DBA Data[Home] [Help]

APPS.ARP_TRX_DEFAULTS_3 dependencies on AR_RECEIPT_METHODS

Line 18: pg_payment_type_code ar_receipt_methods.payment_type_code%type; --ajay bug 1081390

14: pg_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
15: pg_set_of_books_id ar_system_parameters.set_of_books_id%type;
16:
17: pg_remit_to_address_rec address_rec_type := NULL;
18: pg_payment_type_code ar_receipt_methods.payment_type_code%type; --ajay bug 1081390
19:
20: /*===========================================================================+
21: | PROCEDURE |
22: | get_default_remit_to |

Line 479: ar_receipt_methods.name%type,

475: hz_cust_site_uses.site_use_id%type,
476: p_currency_code IN
477: fnd_currencies.currency_code%type,
478: p_payment_method_name OUT NOCOPY
479: ar_receipt_methods.name%type,
480: p_receipt_method_id OUT NOCOPY
481: ar_receipt_methods.receipt_method_id%type,
482: p_creation_method_code OUT NOCOPY
483: ar_receipt_classes.creation_method_code%type

Line 481: ar_receipt_methods.receipt_method_id%type,

477: fnd_currencies.currency_code%type,
478: p_payment_method_name OUT NOCOPY
479: ar_receipt_methods.name%type,
480: p_receipt_method_id OUT NOCOPY
481: ar_receipt_methods.receipt_method_id%type,
482: p_creation_method_code OUT NOCOPY
483: ar_receipt_classes.creation_method_code%type
484: ) RETURN BOOLEAN IS
485:

Line 491: FROM ar_receipt_methods arm,

487: SELECT arm.name payment_method_name,
488: arm.receipt_method_id,
489: arm.payment_channel_code, --ajay bug 1081390
490: arc.creation_method_code
491: FROM ar_receipt_methods arm,
492: ra_cust_receipt_methods rcrm,
493: ar_receipt_method_accounts arma,
494: ce_bank_acct_uses_all aba,
495: ce_bank_accounts cba,

Line 569: FROM ar_receipt_methods arm,

565: SELECT arm.name payment_method_name,
566: arm.receipt_method_id,
567: arm.payment_channel_code,
568: arc.creation_method_code
569: FROM ar_receipt_methods arm,
570: ra_cust_receipt_methods rcrm,
571: ar_receipt_classes arc,
572: ar_system_parameters sys
573: WHERE arm.receipt_method_id = rcrm.receipt_method_id

Line 604: l_payment_method_name ar_receipt_methods.name%type;

600: and TRUNC(nvl(
601: rcrm.end_date,
602: p_trx_date));
603:
604: l_payment_method_name ar_receipt_methods.name%type;
605: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
606: l_creation_method_code ar_receipt_classes.creation_method_code%type;
607: payment_method_rec payment_method_cur%ROWTYPE;
608:

Line 605: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;

601: rcrm.end_date,
602: p_trx_date));
603:
604: l_payment_method_name ar_receipt_methods.name%type;
605: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
606: l_creation_method_code ar_receipt_classes.creation_method_code%type;
607: payment_method_rec payment_method_cur%ROWTYPE;
608:
609: BEGIN

Line 796: ar_receipt_methods.name%type,

792: hz_cust_accounts.cust_account_id%type,
793: p_bill_to_site_use_id IN
794: hz_cust_site_uses.site_use_id%type,
795: p_payment_method_name OUT NOCOPY
796: ar_receipt_methods.name%type,
797: p_receipt_method_id OUT NOCOPY
798: ar_receipt_methods.receipt_method_id%type,
799: p_creation_method_code OUT NOCOPY
800: ar_receipt_classes.creation_method_code%type,

Line 798: ar_receipt_methods.receipt_method_id%type,

794: hz_cust_site_uses.site_use_id%type,
795: p_payment_method_name OUT NOCOPY
796: ar_receipt_methods.name%type,
797: p_receipt_method_id OUT NOCOPY
798: ar_receipt_methods.receipt_method_id%type,
799: p_creation_method_code OUT NOCOPY
800: ar_receipt_classes.creation_method_code%type,
801: p_trx_manual_flag IN VARCHAR2 DEFAULT 'N'
802: ) IS

Line 1004: ar_receipt_methods.payment_type_code%type,

1000: hz_cust_accounts.cust_account_id%type,
1001: p_bill_to_site_use_id IN
1002: hz_cust_site_uses.site_use_id%type,
1003: p_payment_type_code IN
1004: ar_receipt_methods.payment_type_code%type,
1005: p_customer_bank_account_id OUT NOCOPY
1006: ce_bank_accounts.bank_account_id%type,
1007: p_bank_account_num OUT NOCOPY
1008: ce_bank_accounts.bank_account_num%type,

Line 1251: ar_receipt_methods.payment_type_code%type,

1247: hz_cust_accounts.cust_account_id%type,
1248: p_bill_to_site_use_id IN
1249: hz_cust_site_uses.site_use_id%type,
1250: p_payment_type_code IN
1251: ar_receipt_methods.payment_type_code%type,
1252: p_payment_method_name OUT NOCOPY
1253: ar_receipt_methods.name%type,
1254: p_receipt_method_id OUT NOCOPY
1255: ar_receipt_methods.receipt_method_id%type,

Line 1253: ar_receipt_methods.name%type,

1249: hz_cust_site_uses.site_use_id%type,
1250: p_payment_type_code IN
1251: ar_receipt_methods.payment_type_code%type,
1252: p_payment_method_name OUT NOCOPY
1253: ar_receipt_methods.name%type,
1254: p_receipt_method_id OUT NOCOPY
1255: ar_receipt_methods.receipt_method_id%type,
1256: p_creation_method_code OUT NOCOPY
1257: ar_receipt_classes.creation_method_code%type,

Line 1255: ar_receipt_methods.receipt_method_id%type,

1251: ar_receipt_methods.payment_type_code%type,
1252: p_payment_method_name OUT NOCOPY
1253: ar_receipt_methods.name%type,
1254: p_receipt_method_id OUT NOCOPY
1255: ar_receipt_methods.receipt_method_id%type,
1256: p_creation_method_code OUT NOCOPY
1257: ar_receipt_classes.creation_method_code%type,
1258: p_customer_bank_account_id OUT NOCOPY
1259: ce_bank_accounts.bank_account_id%type,

Line 1911: ar_receipt_methods.payment_channel_code%type

1907: +===========================================================================*/
1908:
1909: FUNCTION get_payment_channel_name(
1910: p_payment_channel_code IN
1911: ar_receipt_methods.payment_channel_code%type
1912: ) RETURN VARCHAR2 IS
1913:
1914: l_payment_channel_name iby_fndcpt_all_pmt_channels_v.payment_channel_name%type; --corrected the field name Bug5367658
1915: BEGIN

Line 2037: ar_receipt_methods.payment_channel_code%type

2033: FUNCTION get_payment_instrument(
2034: p_payment_trxn_extension_id IN
2035: ra_customer_trx.payment_trxn_extension_id%type,
2036: p_payment_channel_code IN
2037: ar_receipt_methods.payment_channel_code%type
2038: ) RETURN VARCHAR2 IS
2039: l_instrument iby_ext_bank_accounts.MASKED_BANK_ACCOUNT_NUM%type;
2040: l_instrument_type iby_trxn_extensions_v.instrument_type%type;
2041: BEGIN

Line 2145: ar_receipt_methods.payment_channel_code%type,

2141:
2142: PROCEDURE get_br_bank_defaults( p_payment_trxn_extension_id IN
2143: ra_customer_trx.payment_trxn_extension_id%type,
2144: p_payment_channel_code IN
2145: ar_receipt_methods.payment_channel_code%type,
2146: p_bank_name OUT NOCOPY
2147: iby_trxn_extensions_v.bank_name%type,
2148: p_branch_name OUT NOCOPY
2149: iby_trxn_extensions_v.bank_branch_name%type,