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: );

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: );
62:

Line 563: FROM ar_receipt_methods

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

Line 1236: FROM ar_receipt_methods rm,

1232: rma.end_date rma_end_date,
1233: rm.start_date rm_start_date,
1234: rm.end_date rm_end_date,
1235: ba.end_Date bau_end_date
1236: FROM ar_receipt_methods rm,
1237: ce_bank_accounts cba,
1238: ce_bank_acct_uses ba,
1239: ar_receipt_method_accounts rma ,
1240: ar_receipt_classes rc

Line 1339: ar_receipt_methods rm

1335: rc.creation_method_code
1336: INTO p_state,
1337: p_creation_method_code
1338: FROM ar_receipt_classes rc,
1339: ar_receipt_methods rm
1340: WHERE rc.receipt_class_id = rm.receipt_class_id
1341: AND rm.receipt_method_id = p_receipt_method_id;
1342:
1343: --the invalid error message will be raised in the

Line 1433: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;

1429: p_remittance_bank_account_id IN ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,
1430: p_gl_date IN DATE,
1431: p_return_status OUT NOCOPY VARCHAR2
1432: )IS
1433: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
1434: l_remit_bank_account_id ar_receipt_method_accounts.remit_bank_acct_use_id%type;
1435: l_cash_ccid gl_code_combinations.code_combination_id%type;
1436: l_earned_ccid gl_code_combinations.code_combination_id%type;
1437: l_on_account_ccid gl_code_combinations.code_combination_id%type;

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

1752: p_usr_exchange_rate_type IN gl_daily_conversion_types.user_conversion_type%TYPE,
1753: p_customer_name IN hz_parties.party_name%TYPE,
1754: p_customer_number IN hz_cust_accounts.account_number%TYPE,
1755: p_location IN hz_cust_site_uses.location%type,
1756: p_receipt_method_name IN OUT NOCOPY ar_receipt_methods.name%TYPE,
1757: /* 6612301 */
1758: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,
1759: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
1760: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,

Line 1931: FROM ar_receipt_methods

1927: ELSE
1928: BEGIN
1929: SELECT name
1930: INTO p_receipt_method_name
1931: FROM ar_receipt_methods
1932: WHERE receipt_method_id = p_receipt_method_id;
1933:
1934: l_boe_flag := arpt_sql_func_util.check_BOE_Paymeth(p_receipt_method_id);
1935: if l_boe_flag = 'Y' then

Line 6843: FROM ar_receipt_methods

6839: ELSE
6840: BEGIN
6841: SELECT name
6842: INTO p_receipt_method_name
6843: FROM ar_receipt_methods
6844: WHERE receipt_method_id = p_receipt_method_id;
6845: EXCEPTION
6846: WHEN no_data_found THEN
6847: IF PG_DEBUG in ('Y', 'C') THEN