22: creation_date CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := NULL,
23: object_version_number NUMBER := NULL);
24: G_MISS_contintf_rec ContIntf_Rec_Type;
25: TYPE ContIntf_Val_Rec_Type IS RECORD (
26: contracts_interface_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
27: cp_service_transaction_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
28: cp_service_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
29: contract_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
30: ar_trx_type CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
23: object_version_number NUMBER := NULL);
24: G_MISS_contintf_rec ContIntf_Rec_Type;
25: TYPE ContIntf_Val_Rec_Type IS RECORD (
26: contracts_interface_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
27: cp_service_transaction_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
28: cp_service_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
29: contract_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
30: ar_trx_type CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
31: trx_start_date CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
24: G_MISS_contintf_rec ContIntf_Rec_Type;
25: TYPE ContIntf_Val_Rec_Type IS RECORD (
26: contracts_interface_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
27: cp_service_transaction_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
28: cp_service_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
29: contract_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
30: ar_trx_type CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
31: trx_start_date CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
32: trx_end_date CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
25: TYPE ContIntf_Val_Rec_Type IS RECORD (
26: contracts_interface_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
27: cp_service_transaction_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
28: cp_service_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
29: contract_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
30: ar_trx_type CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
31: trx_start_date CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
32: trx_end_date CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
33: trx_date CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
26: contracts_interface_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
27: cp_service_transaction_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
28: cp_service_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
29: contract_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
30: ar_trx_type CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
31: trx_start_date CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
32: trx_end_date CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
33: trx_date CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
34: trx_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
27: cp_service_transaction_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
28: cp_service_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
29: contract_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
30: ar_trx_type CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
31: trx_start_date CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
32: trx_end_date CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
33: trx_date CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
34: trx_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
35: reason_code CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
28: cp_service_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
29: contract_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
30: ar_trx_type CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
31: trx_start_date CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
32: trx_end_date CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
33: trx_date CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
34: trx_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
35: reason_code CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
36: reason_comments CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
29: contract_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
30: ar_trx_type CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
31: trx_start_date CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
32: trx_end_date CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
33: trx_date CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
34: trx_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
35: reason_code CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
36: reason_comments CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
37: contract_billing_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
30: ar_trx_type CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
31: trx_start_date CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
32: trx_end_date CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
33: trx_date CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
34: trx_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
35: reason_code CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
36: reason_comments CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
37: contract_billing_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
38: cp_quantity NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
31: trx_start_date CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
32: trx_end_date CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
33: trx_date CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
34: trx_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
35: reason_code CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
36: reason_comments CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
37: contract_billing_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
38: cp_quantity NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
39: concurrent_process_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
32: trx_end_date CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
33: trx_date CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
34: trx_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
35: reason_code CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
36: reason_comments CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
37: contract_billing_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
38: cp_quantity NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
39: concurrent_process_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
40: created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
33: trx_date CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
34: trx_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
35: reason_code CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
36: reason_comments CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
37: contract_billing_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
38: cp_quantity NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
39: concurrent_process_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
40: created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
41: creation_date CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
34: trx_amount NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
35: reason_code CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
36: reason_comments CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
37: contract_billing_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
38: cp_quantity NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
39: concurrent_process_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
40: created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
41: creation_date CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
42: object_version_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
35: reason_code CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
36: reason_comments CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
37: contract_billing_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
38: cp_quantity NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
39: concurrent_process_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
40: created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
41: creation_date CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
42: object_version_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
43: G_MISS_contintf_val_rec ContIntf_Val_Rec_Type;
36: reason_comments CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
37: contract_billing_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
38: cp_quantity NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
39: concurrent_process_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
40: created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
41: creation_date CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
42: object_version_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
43: G_MISS_contintf_val_rec ContIntf_Val_Rec_Type;
44: ---------------------------------------------------------------------------
37: contract_billing_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
38: cp_quantity NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
39: concurrent_process_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
40: created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
41: creation_date CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
42: object_version_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
43: G_MISS_contintf_val_rec ContIntf_Val_Rec_Type;
44: ---------------------------------------------------------------------------
45: -- GLOBAL MESSAGE CONSTANTS
38: cp_quantity NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
39: concurrent_process_id NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
40: created_by NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
41: creation_date CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
42: object_version_number NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
43: G_MISS_contintf_val_rec ContIntf_Val_Rec_Type;
44: ---------------------------------------------------------------------------
45: -- GLOBAL MESSAGE CONSTANTS
46: ---------------------------------------------------------------------------
43: G_MISS_contintf_val_rec ContIntf_Val_Rec_Type;
44: ---------------------------------------------------------------------------
45: -- GLOBAL MESSAGE CONSTANTS
46: ---------------------------------------------------------------------------
47: G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
44: ---------------------------------------------------------------------------
45: -- GLOBAL MESSAGE CONSTANTS
46: ---------------------------------------------------------------------------
47: G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
45: -- GLOBAL MESSAGE CONSTANTS
46: ---------------------------------------------------------------------------
47: G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
46: ---------------------------------------------------------------------------
47: G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
47: G_FND_APP CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
57: ---------------------------------------------------------------------------
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
57: ---------------------------------------------------------------------------
58: -- GLOBAL VARIABLES
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
57: ---------------------------------------------------------------------------
58: -- GLOBAL VARIABLES
59: ---------------------------------------------------------------------------
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
57: ---------------------------------------------------------------------------
58: -- GLOBAL VARIABLES
59: ---------------------------------------------------------------------------
60: G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_CONTINTF_PVT';
57: ---------------------------------------------------------------------------
58: -- GLOBAL VARIABLES
59: ---------------------------------------------------------------------------
60: G_PKG_NAME CONSTANT VARCHAR2(200) := 'CS_CONTINTF_PVT';
61: G_APP_NAME CONSTANT VARCHAR2(3) := TAPI_DEV_KIT.G_APP_NAME;
62: ---------------------------------------------------------------------------
63: -- Procedures and Functions
64: ---------------------------------------------------------------------------
65:
65:
66: PROCEDURE insert_row
67: (
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
70: p_validation_level IN NUMBER,
71: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
72: x_return_status OUT VARCHAR2,
73: x_msg_count OUT NUMBER,
67: (
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
70: p_validation_level IN NUMBER,
71: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
72: x_return_status OUT VARCHAR2,
73: x_msg_count OUT NUMBER,
74: x_msg_data OUT VARCHAR2,
75: p_contintf_rec IN ContIntf_Rec_Type := G_MISS_CONTINTF_REC,
77: x_object_version_number OUT NUMBER);
78: PROCEDURE insert_row
79: (
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
82: p_validation_level IN NUMBER,
83: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
84: x_return_status OUT VARCHAR2,
85: x_msg_count OUT NUMBER,
79: (
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
82: p_validation_level IN NUMBER,
83: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
84: x_return_status OUT VARCHAR2,
85: x_msg_count OUT NUMBER,
86: x_msg_data OUT VARCHAR2,
87: p_cp_service_transaction_id IN NUMBER := NULL,
104: x_object_version_number OUT NUMBER);
105: Procedure lock_row
106: (
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
109: p_validation_level IN NUMBER,
110: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
111: x_return_status OUT VARCHAR2,
112: x_msg_count OUT NUMBER,
106: (
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
109: p_validation_level IN NUMBER,
110: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
111: x_return_status OUT VARCHAR2,
112: x_msg_count OUT NUMBER,
113: x_msg_data OUT VARCHAR2,
114: p_contracts_interface_id IN NUMBER,
115: p_object_version_number IN NUMBER);
116: Procedure update_row
117: (
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
120: p_validation_level IN NUMBER,
121: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
122: x_return_status OUT VARCHAR2,
123: x_msg_count OUT NUMBER,
117: (
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
120: p_validation_level IN NUMBER,
121: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
122: x_return_status OUT VARCHAR2,
123: x_msg_count OUT NUMBER,
124: x_msg_data OUT VARCHAR2,
125: p_contintf_val_rec IN ContIntf_Val_Rec_Type := G_MISS_CONTINTF_VAL_REC,
126: x_object_version_number OUT NUMBER);
127: Procedure update_row
128: (
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
131: p_validation_level IN NUMBER,
132: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
133: x_return_status OUT VARCHAR2,
134: x_msg_count OUT NUMBER,
128: (
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
131: p_validation_level IN NUMBER,
132: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
133: x_return_status OUT VARCHAR2,
134: x_msg_count OUT NUMBER,
135: x_msg_data OUT VARCHAR2,
136: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
132: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
133: x_return_status OUT VARCHAR2,
134: x_msg_count OUT NUMBER,
135: x_msg_data OUT VARCHAR2,
136: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
137: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
138: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
139: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
140: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
133: x_return_status OUT VARCHAR2,
134: x_msg_count OUT NUMBER,
135: x_msg_data OUT VARCHAR2,
136: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
137: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
138: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
139: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
140: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
141: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
134: x_msg_count OUT NUMBER,
135: x_msg_data OUT VARCHAR2,
136: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
137: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
138: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
139: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
140: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
141: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
142: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
135: x_msg_data OUT VARCHAR2,
136: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
137: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
138: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
139: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
140: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
141: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
142: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
143: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
136: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
137: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
138: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
139: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
140: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
141: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
142: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
143: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
144: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
137: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
138: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
139: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
140: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
141: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
142: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
143: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
144: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
145: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
138: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
139: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
140: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
141: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
142: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
143: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
144: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
145: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
146: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
139: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
140: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
141: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
142: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
143: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
144: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
145: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
146: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
147: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
140: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
141: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
142: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
143: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
144: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
145: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
146: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
147: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
148: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
141: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
142: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
143: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
144: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
145: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
146: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
147: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
148: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
149: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
142: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
143: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
144: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
145: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
146: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
147: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
148: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
149: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
150: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
143: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
144: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
145: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
146: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
147: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
148: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
149: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
150: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
151: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
144: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
145: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
146: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
147: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
148: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
149: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
150: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
151: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
152: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
145: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
146: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
147: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
148: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
149: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
150: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
151: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
152: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
153: x_object_version_number OUT NUMBER);
146: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
147: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
148: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
149: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
150: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
151: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
152: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
153: x_object_version_number OUT NUMBER);
154: Procedure delete_row
147: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
148: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
149: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
150: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
151: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
152: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
153: x_object_version_number OUT NUMBER);
154: Procedure delete_row
155: (
148: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
149: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
150: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
151: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
152: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
153: x_object_version_number OUT NUMBER);
154: Procedure delete_row
155: (
156: p_api_version IN NUMBER,
153: x_object_version_number OUT NUMBER);
154: Procedure delete_row
155: (
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
158: p_validation_level IN NUMBER,
159: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
160: x_return_status OUT VARCHAR2,
161: x_msg_count OUT NUMBER,
155: (
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
158: p_validation_level IN NUMBER,
159: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
160: x_return_status OUT VARCHAR2,
161: x_msg_count OUT NUMBER,
162: x_msg_data OUT VARCHAR2,
163: p_contracts_interface_id IN NUMBER);
163: p_contracts_interface_id IN NUMBER);
164: PROCEDURE validate_row
165: (
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
168: p_validation_level IN NUMBER,
169: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
170: x_return_status OUT VARCHAR2,
171: x_msg_count OUT NUMBER,
165: (
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
168: p_validation_level IN NUMBER,
169: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
170: x_return_status OUT VARCHAR2,
171: x_msg_count OUT NUMBER,
172: x_msg_data OUT VARCHAR2,
173: p_contintf_val_rec IN ContIntf_Val_Rec_Type := G_MISS_CONTINTF_VAL_REC);
173: p_contintf_val_rec IN ContIntf_Val_Rec_Type := G_MISS_CONTINTF_VAL_REC);
174: PROCEDURE validate_row
175: (
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
178: p_validation_level IN NUMBER,
179: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
180: x_return_status OUT VARCHAR2,
181: x_msg_count OUT NUMBER,
175: (
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
178: p_validation_level IN NUMBER,
179: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
180: x_return_status OUT VARCHAR2,
181: x_msg_count OUT NUMBER,
182: x_msg_data OUT VARCHAR2,
183: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
179: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
180: x_return_status OUT VARCHAR2,
181: x_msg_count OUT NUMBER,
182: x_msg_data OUT VARCHAR2,
183: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
184: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
185: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
186: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
187: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
180: x_return_status OUT VARCHAR2,
181: x_msg_count OUT NUMBER,
182: x_msg_data OUT VARCHAR2,
183: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
184: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
185: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
186: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
187: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
188: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
181: x_msg_count OUT NUMBER,
182: x_msg_data OUT VARCHAR2,
183: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
184: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
185: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
186: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
187: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
188: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
189: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
182: x_msg_data OUT VARCHAR2,
183: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
184: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
185: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
186: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
187: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
188: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
189: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
190: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
183: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
184: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
185: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
186: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
187: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
188: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
189: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
190: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
191: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
184: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
185: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
186: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
187: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
188: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
189: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
190: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
191: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
192: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
185: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
186: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
187: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
188: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
189: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
190: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
191: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
192: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
193: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
186: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
187: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
188: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
189: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
190: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
191: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
192: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
193: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
194: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
187: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
188: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
189: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
190: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
191: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
192: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
193: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
194: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
195: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
188: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
189: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
190: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
191: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
192: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
193: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
194: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
195: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
196: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
189: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
190: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
191: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
192: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
193: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
194: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
195: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
196: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
197: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
190: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
191: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
192: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
193: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
194: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
195: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
196: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
197: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
198: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
191: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
192: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
193: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
194: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
195: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
196: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
197: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
198: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
199: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
192: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
193: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
194: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
195: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
196: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
197: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
198: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
199: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
200: END CS_CONTINTF_PVT;
193: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
194: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
195: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
196: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
197: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
198: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
199: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
200: END CS_CONTINTF_PVT;
194: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
195: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
196: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
197: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
198: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
199: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
200: END CS_CONTINTF_PVT;
195: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
196: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
197: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
198: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
199: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
200: END CS_CONTINTF_PVT;