DBA Data[Home] [Help]

APPS.ARP_REVERSE_RECEIPT dependencies on RA_CUST_TRX_TYPES

Line 82: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

78: --
79: PROCEDURE validate_dm_reversal_args(
80: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
81: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
82: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
83: p_reversal_gl_date IN
84: ar_cash_receipt_history.reversal_gl_date%TYPE,
85: p_reversal_date IN
86: ar_cash_receipts.reversal_date%TYPE,

Line 1564: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

1560:
1561: PROCEDURE debit_memo_reversal(
1562: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,
1563: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
1564: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1565: p_cust_trx_type IN ra_cust_trx_types.name%TYPE,
1566: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1567: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1568: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,

Line 1565: p_cust_trx_type IN ra_cust_trx_types.name%TYPE,

1561: PROCEDURE debit_memo_reversal(
1562: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE,
1563: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
1564: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1565: p_cust_trx_type IN ra_cust_trx_types.name%TYPE,
1566: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE,
1567: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE,
1568: p_reversal_category IN ar_cash_receipts.reversal_category%TYPE,
1569: p_reversal_reason_code IN

Line 1908: ra_customer_trx, ra_cust_trx_types

1904: SELECT decode ( max(dummy), NULL, 'N','Y')
1905: INTO l_does_it_exist
1906: from dual
1907: where exists (select trx_number from
1908: ra_customer_trx, ra_cust_trx_types
1909: where trx_number = l_ct_rec.trx_number
1910: and batch_source_id = l_ct_rec.batch_source_id
1911: and ra_customer_trx.cust_trx_type_id =
1912: ra_cust_trx_types.cust_trx_type_id

Line 1912: ra_cust_trx_types.cust_trx_type_id

1908: ra_customer_trx, ra_cust_trx_types
1909: where trx_number = l_ct_rec.trx_number
1910: and batch_source_id = l_ct_rec.batch_source_id
1911: and ra_customer_trx.cust_trx_type_id =
1912: ra_cust_trx_types.cust_trx_type_id
1913: and ra_cust_trx_types.type = 'DM');
1914:
1915: /* if a DM exists with the same number and the same batch source,
1916: then we use existing functionality and call the EH without a

Line 1913: and ra_cust_trx_types.type = 'DM');

1909: where trx_number = l_ct_rec.trx_number
1910: and batch_source_id = l_ct_rec.batch_source_id
1911: and ra_customer_trx.cust_trx_type_id =
1912: ra_cust_trx_types.cust_trx_type_id
1913: and ra_cust_trx_types.type = 'DM');
1914:
1915: /* if a DM exists with the same number and the same batch source,
1916: then we use existing functionality and call the EH without a
1917: trx_number */

Line 2158: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

2154: +===========================================================================*/
2155: PROCEDURE validate_dm_reversal_args(
2156: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2157: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,
2158: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2159: p_reversal_gl_date IN
2160: ar_cash_receipt_history.reversal_gl_date%TYPE,
2161: p_reversal_date IN
2162: ar_cash_receipts.reversal_date%TYPE,