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 1091: FROM ar_system_parameters;

1087:
1088: --fetch org id,need to set it for child requests
1089: SELECT org_id
1090: INTO l_org_id
1091: FROM ar_system_parameters;
1092:
1093: l_master_request_id := arp_standard.profile.request_id;
1094:
1095: IF (p_clr_remitted_receipts = 'Y') THEN

Line 1256: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;

1252: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1253: v_mod_name varchar2(30);
1254: v_mod_vers varchar2(5);
1255: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1256: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;
1257: p_cr_rec ar_cash_receipts%ROWTYPE;
1258: p_crh_rec ar_cash_receipt_history%ROWTYPE;
1259: locked BOOLEAN;
1260:

Line 1271: select set_of_books_id INTO v_set_of_bks_id from ar_system_parameters;

1267: --
1268: BEGIN
1269: --
1270: fnd_file.put_line( FND_FILE.LOG, 'populate_interim_table()+');
1271: select set_of_books_id INTO v_set_of_bks_id from ar_system_parameters;
1272: --
1273: IF ( remitted_or_factored_or_risk = 1) THEN
1274: statement := 'INSERT INTO ar_autoclear_interim
1275: ( cash_receipt_id,

Line 1586: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;

1582: v_fac_disc_amount ar_cash_receipt_history.factor_discount_amount%TYPE;
1583: v_mod_name varchar2(30);
1584: v_mod_vers varchar2(5);
1585: p_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1586: v_set_of_bks_id ar_system_parameters.set_of_books_id%TYPE;
1587: p_cr_rec ar_cash_receipts%ROWTYPE;
1588: p_crh_rec ar_cash_receipt_history%ROWTYPE;
1589: locked BOOLEAN;
1590:

Line 1601: select set_of_books_id INTO v_set_of_bks_id from ar_system_parameters;

1597: --
1598: BEGIN
1599: --
1600: fnd_file.put_line(fnd_file.log, 'clr_remit_disc_risk_rcpts_pa()+');
1601: select set_of_books_id INTO v_set_of_bks_id from ar_system_parameters;
1602: --
1603: IF ( remitted_or_factored_or_risk = 1) THEN
1604: main_select_remitted_parallel(
1605: statement );