DBA Data[Home] [Help]

APPS.CSTPALPC dependencies on CSTPALTY

Line 93: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;

89: o_err_num OUT NOCOPY NUMBER,
90: o_err_code OUT NOCOPY VARCHAR2,
91: o_err_msg OUT NOCOPY VARCHAR2
92: ) IS
93: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
94: l_stmt_num NUMBER;
95: BEGIN
96: IF l_debug_flag = 'Y' THEN
97: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create_Acct_Entry <<< ');

Line 421: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;

417: AND RT.TRANSACTION_ID = RAE.RCV_TRANSACTION_ID
418: AND RT.TRANSACTION_DATE < CPP.PERIOD_START_DATE
419: AND RAE.EVENT_TYPE_ID in (18,19,20);
420:
421: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
422: l_sql_to_run VARCHAR2(500);
423: l_package_name VARCHAR2(100);
424: l_cursor NUMBER;
425: l_event_type_id VARCHAR2(30);

Line 635: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;

631: po_distributions_all pod
632: where pod.line_location_id = poll.line_location_id and
633: accrue_on_receipt_flag = 'Y'));
634:
635: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
636: l_sql_to_run VARCHAR2(500);
637: l_package_name VARCHAR2(100);
638: l_cursor NUMBER;
639: l_event_type_id VARCHAR2(30);

Line 754: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

750:
751:
752:
753: PROCEDURE insert_ae_lines (
754: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
755: i_ae_line_rec_tbl IN CSTPALTY.cst_ae_line_tbl_type,
756: o_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
757: )
758: IS

Line 755: i_ae_line_rec_tbl IN CSTPALTY.cst_ae_line_tbl_type,

751:
752:
753: PROCEDURE insert_ae_lines (
754: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
755: i_ae_line_rec_tbl IN CSTPALTY.cst_ae_line_tbl_type,
756: o_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
757: )
758: IS
759: l_ae_header_id NUMBER;

Line 756: o_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

752:
753: PROCEDURE insert_ae_lines (
754: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
755: i_ae_line_rec_tbl IN CSTPALTY.cst_ae_line_tbl_type,
756: o_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
757: )
758: IS
759: l_ae_header_id NUMBER;
760: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;

Line 760: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;

756: o_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
757: )
758: IS
759: l_ae_header_id NUMBER;
760: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
761: l_stmt_num NUMBER;
762: l_request_id NUMBER;
763: l_user_id NUMBER;
764: l_login_id NUMBER;