APPS.ARP_REVERSE_RECEIPT dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 81: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,

77: p_status IN VARCHAR2 );
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

Line 1175: ra_cust_trx_line_gl_dist ctlg

1171: --
1172: SELECT COUNT(*)
1173: INTO l_count
1174: FROM ar_payment_schedules ps,
1175: ra_cust_trx_line_gl_dist ctlg
1176: WHERE ps.associated_cash_receipt_id = p_cr_id
1177: AND ps.class = 'CB'
1178: AND ps.customer_trx_id = ctlg.customer_trx_id
1179: AND ( NVL( ps.amount_applied, 0 ) <> 0

Line 1563: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,

1559: +===========================================================================*/
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,

Line 1625: l_gl_date_dummy ra_cust_trx_line_gl_dist.gl_date%type;

1621: l_count NUMBER := 0;
1622:
1623: l_rule_start_date ra_customer_trx_lines.rule_start_date%type;
1624: l_accounting_rule_duration ra_customer_trx_lines.accounting_rule_duration%type;
1625: l_gl_date_dummy ra_cust_trx_line_gl_dist.gl_date%type;
1626: l_trx_date_dummy ra_customer_trx.trx_date%type;
1627: l_status_dummy varchar2(100);
1628:
1629: l_commit_cust_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;

Line 2157: p_cc_id IN ra_cust_trx_line_gl_dist.code_combination_id%TYPE,

2153: | |
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