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 446: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;

442: AND RT.TRANSACTION_ID = RAE.RCV_TRANSACTION_ID
443: AND RT.TRANSACTION_DATE < CPP.PERIOD_START_DATE
444: AND RAE.EVENT_TYPE_ID in (18,19,20);
445:
446: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
447: l_sql_to_run VARCHAR2(500);
448: l_package_name VARCHAR2(100);
449: l_cursor NUMBER;
450: l_event_type_id VARCHAR2(30);

Line 660: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;

656: po_distributions_all pod
657: where pod.line_location_id = poll.line_location_id and
658: accrue_on_receipt_flag = 'Y'));
659:
660: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
661: l_sql_to_run VARCHAR2(500);
662: l_package_name VARCHAR2(100);
663: l_cursor NUMBER;
664: l_event_type_id VARCHAR2(30);

Line 779: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

775:
776:
777:
778: PROCEDURE insert_ae_lines (
779: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
780: i_ae_line_rec_tbl IN CSTPALTY.cst_ae_line_tbl_type,
781: o_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
782: )
783: IS

Line 780: i_ae_line_rec_tbl IN CSTPALTY.cst_ae_line_tbl_type,

776:
777:
778: PROCEDURE insert_ae_lines (
779: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
780: i_ae_line_rec_tbl IN CSTPALTY.cst_ae_line_tbl_type,
781: o_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
782: )
783: IS
784: l_ae_header_id NUMBER;

Line 781: o_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

777:
778: PROCEDURE insert_ae_lines (
779: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
780: i_ae_line_rec_tbl IN CSTPALTY.cst_ae_line_tbl_type,
781: o_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
782: )
783: IS
784: l_ae_header_id NUMBER;
785: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;

Line 785: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;

781: o_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
782: )
783: IS
784: l_ae_header_id NUMBER;
785: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
786: l_stmt_num NUMBER;
787: l_request_id NUMBER;
788: l_user_id NUMBER;
789: l_login_id NUMBER;