APPS.AR_RECEIPT_LIB_PVT dependencies on AR_RECEIPT_METHODS

Line 57: rm_start_date ar_receipt_methods.start_date%TYPE,

53: called_from VARCHAR2(200),
54: state ar_receipt_classes.creation_status%TYPE,
55: creation_method_code ar_receipt_classes.creation_method_code%TYPE,
56: bau_end_date ce_bank_acct_uses.end_date%TYPE,
57: rm_start_date ar_receipt_methods.start_date%TYPE,
58: rm_end_date ar_receipt_methods.end_date%TYPE,
59: rma_start_date ar_receipt_method_accounts.start_date%TYPE,
60: rma_end_date ar_receipt_method_accounts.end_date%TYPE,
61: org_id ar_receipt_method_accounts.org_id%TYPE

Line 58: rm_end_date ar_receipt_methods.end_date%TYPE,

54: state ar_receipt_classes.creation_status%TYPE,
55: creation_method_code ar_receipt_classes.creation_method_code%TYPE,
56: bau_end_date ce_bank_acct_uses.end_date%TYPE,
57: rm_start_date ar_receipt_methods.start_date%TYPE,
58: rm_end_date ar_receipt_methods.end_date%TYPE,
59: rma_start_date ar_receipt_method_accounts.start_date%TYPE,
60: rma_end_date ar_receipt_method_accounts.end_date%TYPE,
61: org_id ar_receipt_method_accounts.org_id%TYPE
62: );

Line 564: FROM ar_receipt_methods

560: THEN
561:
562: SELECT receipt_method_id
563: INTO l_selected_id
564: FROM ar_receipt_methods
565: WHERE name = p_value;
566: /* PAYMENT UPTAKE removed the following
567: a) getting the bank_account_id from CUST_BANK_ACCOUNT_NUMBER.
568: b) getting the bank_account_id from CUST_BANK_ACCOUNT_NAME.

Line 1241: FROM ar_receipt_methods rm,

1237: rm.start_date rm_start_date,
1238: rm.end_date rm_end_date,
1239: ba.end_Date bau_end_date,
1240: rma.org_id rma_org_id
1241: FROM ar_receipt_methods rm,
1242: ce_bank_accounts cba,
1243: ce_bank_acct_uses ba,
1244: ar_receipt_method_accounts rma ,
1245: ar_receipt_classes rc

Line 1346: ar_receipt_methods rm

1342: rc.creation_method_code
1343: INTO p_state,
1344: p_creation_method_code
1345: FROM ar_receipt_classes rc,
1346: ar_receipt_methods rm
1347: WHERE rc.receipt_class_id = rm.receipt_class_id
1348: AND rm.receipt_method_id = p_receipt_method_id;
1349:
1350: --the invalid error message will be raised in the

Line 1440: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;

1436: p_remittance_bank_account_id IN ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,
1437: p_gl_date IN DATE,
1438: p_return_status OUT NOCOPY VARCHAR2
1439: )IS
1440: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
1441: l_remit_bank_account_id ar_receipt_method_accounts.remit_bank_acct_use_id%type;
1442: l_cash_ccid gl_code_combinations.code_combination_id%type;
1443: l_earned_ccid gl_code_combinations.code_combination_id%type;
1444: l_on_account_ccid gl_code_combinations.code_combination_id%type;

Line 1763: p_receipt_method_name IN OUT NOCOPY ar_receipt_methods.name%TYPE,

1759: p_usr_exchange_rate_type IN gl_daily_conversion_types.user_conversion_type%TYPE,
1760: p_customer_name IN hz_parties.party_name%TYPE,
1761: p_customer_number IN hz_cust_accounts.account_number%TYPE,
1762: p_location IN hz_cust_site_uses.location%type,
1763: p_receipt_method_name IN OUT NOCOPY ar_receipt_methods.name%TYPE,
1764: /* 6612301 */
1765: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,
1766: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
1767: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,

Line 1938: FROM ar_receipt_methods

1934: ELSE
1935: BEGIN
1936: SELECT name
1937: INTO p_receipt_method_name
1938: FROM ar_receipt_methods
1939: WHERE receipt_method_id = p_receipt_method_id;
1940:
1941: l_boe_flag := arpt_sql_func_util.check_BOE_Paymeth(p_receipt_method_id);
1942: if l_boe_flag = 'Y' then

Line 7131: FROM ar_receipt_methods

7127: ELSE
7128: BEGIN
7129: SELECT name
7130: INTO p_receipt_method_name
7131: FROM ar_receipt_methods
7132: WHERE receipt_method_id = p_receipt_method_id;
7133: EXCEPTION
7134: WHEN no_data_found THEN
7135: IF PG_DEBUG in ('Y', 'C') THEN