eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_CONTINTF_PVT dependencies on CS_CONT_BILL_IFACE

Line 5: SELECT CS_CONT_BILL_IFACE_S.nextval FROM SYS.DUAL;

1: PACKAGE BODY CS_CONTINTF_PVT AS
2: /* $Header: csctcbib.pls 115.1 99/07/16 08:49:03 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_CONT_BILL_IFACE_S.nextval FROM SYS.DUAL;
6: l_seq_id NUMBER := 0;
7: BEGIN
8: OPEN get_seq_id_csr;
9: FETCH get_seq_id_csr INTO l_seq_id;

Line 217: INSERT INTO CS_CONT_BILL_IFACE(

213: END IF;
214: END IF;
215: -- Set primary key value
216: l_def_contintf_rec.contracts_interface_id := get_seq_id;
217: INSERT INTO CS_CONT_BILL_IFACE(
218: contracts_interface_id,
219: cp_service_transaction_id,
220: cp_service_id,
221: contract_id,

Line 304: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := NULL,

300: x_msg_data OUT VARCHAR2,
301: p_cp_service_transaction_id IN NUMBER := NULL,
302: p_cp_service_id IN NUMBER := NULL,
303: p_contract_id IN NUMBER := NULL,
304: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := NULL,
305: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := NULL,
306: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := NULL,
307: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := NULL,
308: p_trx_amount IN NUMBER := NULL,

Line 305: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := NULL,

301: p_cp_service_transaction_id IN NUMBER := NULL,
302: p_cp_service_id IN NUMBER := NULL,
303: p_contract_id IN NUMBER := NULL,
304: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := NULL,
305: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := NULL,
306: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := NULL,
307: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := NULL,
308: p_trx_amount IN NUMBER := NULL,
309: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := NULL,

Line 306: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := NULL,

302: p_cp_service_id IN NUMBER := NULL,
303: p_contract_id IN NUMBER := NULL,
304: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := NULL,
305: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := NULL,
306: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := NULL,
307: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := NULL,
308: p_trx_amount IN NUMBER := NULL,
309: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := NULL,
310: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := NULL,

Line 307: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := NULL,

303: p_contract_id IN NUMBER := NULL,
304: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := NULL,
305: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := NULL,
306: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := NULL,
307: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := NULL,
308: p_trx_amount IN NUMBER := NULL,
309: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := NULL,
310: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := NULL,
311: p_contract_billing_id IN NUMBER := NULL,

Line 309: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := NULL,

305: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := NULL,
306: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := NULL,
307: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := NULL,
308: p_trx_amount IN NUMBER := NULL,
309: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := NULL,
310: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := NULL,
311: p_contract_billing_id IN NUMBER := NULL,
312: p_cp_quantity IN NUMBER := NULL,
313: p_concurrent_process_id IN NUMBER := NULL,

Line 310: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := NULL,

306: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := NULL,
307: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := NULL,
308: p_trx_amount IN NUMBER := NULL,
309: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := NULL,
310: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := NULL,
311: p_contract_billing_id IN NUMBER := NULL,
312: p_cp_quantity IN NUMBER := NULL,
313: p_concurrent_process_id IN NUMBER := NULL,
314: p_created_by IN NUMBER := NULL,

Line 315: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := NULL,

311: p_contract_billing_id IN NUMBER := NULL,
312: p_cp_quantity IN NUMBER := NULL,
313: p_concurrent_process_id IN NUMBER := NULL,
314: p_created_by IN NUMBER := NULL,
315: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := NULL,
316: p_object_version_number IN NUMBER := NULL,
317: x_contracts_interface_id OUT NUMBER,
318: x_object_version_number OUT NUMBER) IS
319: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 415: FROM CS_CONT_BILL_IFACE

411: E_Resource_Busy EXCEPTION;
412: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
413: CURSOR lock_csr IS
414: SELECT OBJECT_VERSION_NUMBER
415: FROM CS_CONT_BILL_IFACE
416: WHERE
417: CONTRACTS_INTERFACE_ID = p_contracts_interface_id AND
418: OBJECT_VERSION_NUMBER = p_object_version_number
419: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 423: FROM CS_CONT_BILL_IFACE

419: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
420:
421: CURSOR lchk_csr IS
422: SELECT OBJECT_VERSION_NUMBER
423: FROM CS_CONT_BILL_IFACE
424: WHERE
425: CONTRACTS_INTERFACE_ID = p_contracts_interface_id
426: ;
427: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';

Line 430: l_object_version_number CS_CONT_BILL_IFACE.OBJECT_VERSION_NUMBER%TYPE;

426: ;
427: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
428: l_api_version CONSTANT NUMBER := 1;
429: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
430: l_object_version_number CS_CONT_BILL_IFACE.OBJECT_VERSION_NUMBER%TYPE;
431: lc_object_version_number CS_CONT_BILL_IFACE.OBJECT_VERSION_NUMBER%TYPE;
432: l_row_notfound BOOLEAN := FALSE;
433: lc_row_notfound BOOLEAN := FALSE;
434: BEGIN

Line 431: lc_object_version_number CS_CONT_BILL_IFACE.OBJECT_VERSION_NUMBER%TYPE;

427: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
428: l_api_version CONSTANT NUMBER := 1;
429: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
430: l_object_version_number CS_CONT_BILL_IFACE.OBJECT_VERSION_NUMBER%TYPE;
431: lc_object_version_number CS_CONT_BILL_IFACE.OBJECT_VERSION_NUMBER%TYPE;
432: l_row_notfound BOOLEAN := FALSE;
433: lc_row_notfound BOOLEAN := FALSE;
434: BEGIN
435: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

Line 538: FROM Cs_Cont_Bill_Iface

534: x_contintf_rec OUT ContIntf_Rec_Type
535: ) RETURN VARCHAR2 IS
536: CURSOR oco_26638_csr (p_contracts_interface_id IN NUMBER) IS
537: SELECT *
538: FROM Cs_Cont_Bill_Iface
539: WHERE cs_cont_bill_iface.contracts_interface_id = p_contracts_interface_id;
540: l_oco_26638 oco_26638_csr%ROWTYPE;
541: l_row_notfound BOOLEAN := TRUE;
542: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 539: WHERE cs_cont_bill_iface.contracts_interface_id = p_contracts_interface_id;

535: ) RETURN VARCHAR2 IS
536: CURSOR oco_26638_csr (p_contracts_interface_id IN NUMBER) IS
537: SELECT *
538: FROM Cs_Cont_Bill_Iface
539: WHERE cs_cont_bill_iface.contracts_interface_id = p_contracts_interface_id;
540: l_oco_26638 oco_26638_csr%ROWTYPE;
541: l_row_notfound BOOLEAN := TRUE;
542: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
543: BEGIN

Line 676: UPDATE CS_CONT_BILL_IFACE

672: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
673: RAISE FND_API.G_EXC_ERROR;
674: END IF;
675: END IF;
676: UPDATE CS_CONT_BILL_IFACE
677: SET
678: CONTRACTS_INTERFACE_ID = l_def_contintf_rec.contracts_interface_id ,
679: CP_SERVICE_TRANSACTION_ID = l_def_contintf_rec.cp_service_transaction_id ,
680: CP_SERVICE_ID = l_def_contintf_rec.cp_service_id ,

Line 748: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

744: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
745: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
746: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
747: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
748: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
749: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
752: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 749: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

745: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
746: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
747: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
748: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
749: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
752: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
753: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

746: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
747: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
748: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
749: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
752: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
753: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
754: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

747: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
748: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
749: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
752: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
753: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
754: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
755: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 753: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

749: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
752: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
753: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
754: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
755: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
756: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
757: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 754: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

750: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
751: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
752: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
753: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
754: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
755: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
756: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
757: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
758: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 759: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

755: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
756: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
757: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
758: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
759: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
760: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
761: x_object_version_number OUT NUMBER) IS
762: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
763: l_api_version CONSTANT NUMBER := 1;

Line 869: DELETE FROM CS_CONT_BILL_IFACE

865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
866: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
867: RAISE FND_API.G_EXC_ERROR;
868: END IF;
869: DELETE FROM CS_CONT_BILL_IFACE
870: WHERE
871: CONTRACTS_INTERFACE_ID = p_contracts_interface_id
872: ;
873: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1008: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1004: p_contracts_interface_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1006: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1012: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1009: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1005: p_cp_service_transaction_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1006: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1012: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1013: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1006: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1012: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1013: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1007: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_ar_trx_type IN CS_CONT_BILL_IFACE.AR_TRX_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1012: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1013: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1013: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1009: p_trx_start_date IN CS_CONT_BILL_IFACE.TRX_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1012: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1013: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1016: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1017: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1014: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1010: p_trx_end_date IN CS_CONT_BILL_IFACE.TRX_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1011: p_trx_date IN CS_CONT_BILL_IFACE.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1012: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1013: p_reason_code IN CS_CONT_BILL_IFACE.REASON_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_reason_comments IN CS_CONT_BILL_IFACE.REASON_COMMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1016: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1017: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1018: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1019: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1015: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1016: p_cp_quantity IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1017: p_concurrent_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1018: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1019: p_creation_date IN CS_CONT_BILL_IFACE.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1020: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1021: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1022: l_api_version CONSTANT NUMBER := 1;
1023: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;