Procedure: INSERT_ROW_BATCH
Parameter Name | IN /Out | Data Type | Description | |
|
|
|
| |
p_api_version | IN | NUMBER | Version of the API | |
p_bill_summaries | IN | bill_summaries_table | PL/SQL table type | |
|
|
| that contains the | |
|
|
| record type required | |
|
|
| for creating bill | |
|
|
| summaries. | |
x_return_status | OUT | VARCHAR2 | Returns the status of | |
|
|
| the create operation. | |
|
|
| The values returned | |
|
|
| are: |
|
|
|
| • | S: When the |
|
|
|
| operation is a |
|
|
|
| success. |
|
|
| • | E: When the |
|
|
|
| operation is not a |
|
|
|
| success due to a |
|
|
|
| known error. |
x_msg_data | OUT | VARCHAR2 | A concatenated string | |
|
|
| of all the error and | |
|
|
| warning messages | |
|
|
| that are put into the | |
|
|
| message stack. | |
|
|
|
|
|
Procedure: UPDATE_ROW_BATCH
The UPDATE_ROW_BATCH procedure is used to update existing bill summary records from external billing application into Oracle
Syntax: XNB_BILL_SUMMARIES_PKG.Update_Row_Batch(p_api_version, bill_summaries, x_return_status, x_msg_data);
The table below lists the parameters for the UPDATE_ROW_BATCH procedure.
