DBA Data[Home] [Help]

APPS.ARP_TRX_DEFAULTS_3 dependencies on RA_CUSTOMER_TRX

Line 471: ra_customer_trx.trx_date%type,

467:
468:
469: FUNCTION check_payment_method(
470: p_trx_date IN
471: ra_customer_trx.trx_date%type,
472: p_customer_id IN
473: ra_customer_trx.customer_trx_id%type,
474: p_site_use_id IN
475: hz_cust_site_uses.site_use_id%type,

Line 473: ra_customer_trx.customer_trx_id%type,

469: FUNCTION check_payment_method(
470: p_trx_date IN
471: ra_customer_trx.trx_date%type,
472: p_customer_id IN
473: ra_customer_trx.customer_trx_id%type,
474: p_site_use_id IN
475: hz_cust_site_uses.site_use_id%type,
476: p_currency_code IN
477: fnd_currencies.currency_code%type,

Line 707: ra_customer_trx.trx_date%type,

703: +===========================================================================*/
704:
705: FUNCTION check_bank_default(
706: p_trx_date IN
707: ra_customer_trx.trx_date%type,
708: p_customer_id IN
709: ra_customer_trx.customer_trx_id%type,
710: p_site_use_id IN
711: hz_cust_site_uses.site_use_id%type,

Line 709: ra_customer_trx.customer_trx_id%type,

705: FUNCTION check_bank_default(
706: p_trx_date IN
707: ra_customer_trx.trx_date%type,
708: p_customer_id IN
709: ra_customer_trx.customer_trx_id%type,
710: p_site_use_id IN
711: hz_cust_site_uses.site_use_id%type,
712: p_currency_code IN
713: fnd_currencies.currency_code%type,

Line 784: ra_customer_trx.trx_date%type,

780: +===========================================================================*/
781:
782: PROCEDURE get_payment_method_default(
783: p_trx_date IN
784: ra_customer_trx.trx_date%type,
785: p_currency_code IN
786: fnd_currencies.currency_code%type,
787: p_paying_customer_id IN
788: hz_cust_accounts.cust_account_id%type,

Line 992: ra_customer_trx.trx_date%type,

988: +===========================================================================*/
989:
990: PROCEDURE get_bank_defaults(
991: p_trx_date IN
992: ra_customer_trx.trx_date%type,
993: p_currency_code IN
994: fnd_currencies.currency_code%type,
995: p_paying_customer_id IN
996: hz_cust_accounts.cust_account_id%type,

Line 1239: ra_customer_trx.trx_date%type,

1235: +===========================================================================*/
1236:
1237: PROCEDURE get_pay_method_and_bank_deflts(
1238: p_trx_date IN
1239: ra_customer_trx.trx_date%type,
1240: p_currency_code IN
1241: fnd_currencies.currency_code%type,
1242: p_paying_customer_id IN
1243: hz_cust_accounts.cust_account_id%type,

Line 1513: p_trx_date IN ra_customer_trx.trx_date%type,

1509: p_type_term_id IN ra_terms.term_id%type,
1510: p_type_term_name IN ra_terms.name%type,
1511: p_customer_id IN hz_cust_accounts.cust_account_id%type,
1512: p_site_use_id IN hz_cust_site_uses.site_use_id%type,
1513: p_trx_date IN ra_customer_trx.trx_date%type,
1514: p_class IN ra_cust_trx_types.type%type,
1515: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
1516: p_default_term_id OUT NOCOPY ra_terms.term_id%type,
1517: p_default_term_name OUT NOCOPY ra_terms.name%type,

Line 1520: ra_customer_trx.term_due_date%type

1516: p_default_term_id OUT NOCOPY ra_terms.term_id%type,
1517: p_default_term_name OUT NOCOPY ra_terms.name%type,
1518: p_number_of_due_dates OUT NOCOPY number,
1519: p_term_due_date OUT NOCOPY
1520: ra_customer_trx.term_due_date%type
1521: ) IS
1522:
1523: l_number_of_due_dates number;
1524: l_term_due_date ra_customer_trx.term_due_date%type;

Line 1524: l_term_due_date ra_customer_trx.term_due_date%type;

1520: ra_customer_trx.term_due_date%type
1521: ) IS
1522:
1523: l_number_of_due_dates number;
1524: l_term_due_date ra_customer_trx.term_due_date%type;
1525: l_cust_term_id ra_terms.term_id%type;
1526: l_cust_term_name ra_terms.name%type;
1527: l_org_id ra_customer_trx.org_id%type;
1528: l_billing_cycle_id ra_terms.billing_cycle_id%type; -- Bug 7582592

Line 1527: l_org_id ra_customer_trx.org_id%type;

1523: l_number_of_due_dates number;
1524: l_term_due_date ra_customer_trx.term_due_date%type;
1525: l_cust_term_id ra_terms.term_id%type;
1526: l_cust_term_name ra_terms.name%type;
1527: l_org_id ra_customer_trx.org_id%type;
1528: l_billing_cycle_id ra_terms.billing_cycle_id%type; -- Bug 7582592
1529:
1530: BEGIN
1531:

Line 2035: ra_customer_trx.payment_trxn_extension_id%type,

2031: +===========================================================================*/
2032:
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_trxn_extensions_v.card_number%type;

Line 2144: ra_customer_trx.payment_trxn_extension_id%type,

2140: +===========================================================================*/
2141:
2142:
2143: PROCEDURE get_br_bank_defaults( p_payment_trxn_extension_id IN
2144: ra_customer_trx.payment_trxn_extension_id%type,
2145: p_payment_channel_code IN
2146: ar_receipt_methods.payment_channel_code%type,
2147: p_bank_name OUT NOCOPY
2148: iby_trxn_extensions_v.bank_name%type,

Line 2174: PROCEDURE get_instr_defaults(p_org_id IN ra_customer_trx.org_id%type,

2170:
2171:
2172: --Bug 5507178 To Default the Instrument Details for a transaction
2173:
2174: PROCEDURE get_instr_defaults(p_org_id IN ra_customer_trx.org_id%type,
2175: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
2176: p_paying_site_use_id IN iby_fndcpt_payer_assgn_instr_v.acct_site_use_id%type,
2177: p_instrument_type IN iby_fndcpt_payer_assgn_instr_v.instrument_type%type,
2178: p_currency_code IN iby_fndcpt_payer_assgn_instr_v.currency_code%type ,

Line 2175: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,

2171:
2172: --Bug 5507178 To Default the Instrument Details for a transaction
2173:
2174: PROCEDURE get_instr_defaults(p_org_id IN ra_customer_trx.org_id%type,
2175: p_paying_customer_id IN ra_customer_trx.paying_customer_id%type,
2176: p_paying_site_use_id IN iby_fndcpt_payer_assgn_instr_v.acct_site_use_id%type,
2177: p_instrument_type IN iby_fndcpt_payer_assgn_instr_v.instrument_type%type,
2178: p_currency_code IN iby_fndcpt_payer_assgn_instr_v.currency_code%type ,
2179: p_instrument_assignment_id OUT NOCOPY iby_trxn_extensions_v.instr_assignment_id%type