APPS.ARP_AUTOMATIC_CLEARING_PKG dependencies on AR_SYSTEM_PARAMETERS

Line 531: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;

527: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
528: v_mod_name varchar2(30);
529: v_mod_vers varchar2(5);
530: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
531: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;
532: p_cr_rec ar_cash_receipts%ROWTYPE;
533: p_crh_rec ar_cash_receipt_history%ROWTYPE;
534: locked BOOLEAN;
535:

Line 545: select set_of_books_id INTO v_set_of_bks_id from ar_system_parameters;

541:
542: --
543: BEGIN
544: --
545: select set_of_books_id INTO v_set_of_bks_id from ar_system_parameters;
546: --
547: IF ( remitted_or_factored_or_risk = 1) THEN
548: main_select_remitted(
549: statement,

Line 1063: FROM ar_system_parameters;

1059:
1060: --fetch org id,need to set it for child requests
1061: SELECT org_id
1062: INTO l_org_id
1063: FROM ar_system_parameters;
1064:
1065: l_master_request_id := arp_standard.profile.request_id;
1066:
1067: IF (p_clr_remitted_receipts = 'Y') THEN

Line 1228: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;

1224: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1225: v_mod_name varchar2(30);
1226: v_mod_vers varchar2(5);
1227: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1228: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;
1229: p_cr_rec ar_cash_receipts%ROWTYPE;
1230: p_crh_rec ar_cash_receipt_history%ROWTYPE;
1231: locked BOOLEAN;
1232:

Line 1243: select set_of_books_id INTO v_set_of_bks_id from ar_system_parameters;

1239: --
1240: BEGIN
1241: --
1242: fnd_file.put_line( FND_FILE.LOG, 'populate_interim_table()+');
1243: select set_of_books_id INTO v_set_of_bks_id from ar_system_parameters;
1244: --
1245: IF ( remitted_or_factored_or_risk = 1) THEN
1246: statement := 'INSERT INTO ar_autoclear_interim
1247: ( cash_receipt_id,

Line 1558: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;

1554: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1555: v_mod_name varchar2(30);
1556: v_mod_vers varchar2(5);
1557: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1558: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;
1559: p_cr_rec ar_cash_receipts%ROWTYPE;
1560: p_crh_rec ar_cash_receipt_history%ROWTYPE;
1561: locked BOOLEAN;
1562:

Line 1573: select set_of_books_id INTO v_set_of_bks_id from ar_system_parameters;

1569: --
1570: BEGIN
1571: --
1572: fnd_file.put_line(fnd_file.log, 'clr_remit_disc_risk_rcpts_pa()+');
1573: select set_of_books_id INTO v_set_of_bks_id from ar_system_parameters;
1574: --
1575: IF ( remitted_or_factored_or_risk = 1) THEN
1576: main_select_remitted_parallel(
1577: statement );