APPS.ARP_PROCESS_HEADER_POST_COMMIT dependencies on RA_CUST_TRX_TYPES

Line 94: ra_cust_trx_types.accounting_affect_flag%type,

90: ra_customer_trx.previous_customer_trx_id%type,
91: p_complete_flag IN
92: ra_customer_trx.complete_flag%type,
93: p_trx_open_receivables_flag IN
94: ra_cust_trx_types.accounting_affect_flag%type,
95: p_prev_open_receivables_flag IN
96: ra_cust_trx_types.accounting_affect_flag%type,
97: p_creation_sign IN
98: ra_cust_trx_types.creation_sign%type,

Line 96: ra_cust_trx_types.accounting_affect_flag%type,

92: ra_customer_trx.complete_flag%type,
93: p_trx_open_receivables_flag IN
94: ra_cust_trx_types.accounting_affect_flag%type,
95: p_prev_open_receivables_flag IN
96: ra_cust_trx_types.accounting_affect_flag%type,
97: p_creation_sign IN
98: ra_cust_trx_types.creation_sign%type,
99: p_allow_overapplication_flag IN
100: ra_cust_trx_types.allow_overapplication_flag%type,

Line 98: ra_cust_trx_types.creation_sign%type,

94: ra_cust_trx_types.accounting_affect_flag%type,
95: p_prev_open_receivables_flag IN
96: ra_cust_trx_types.accounting_affect_flag%type,
97: p_creation_sign IN
98: ra_cust_trx_types.creation_sign%type,
99: p_allow_overapplication_flag IN
100: ra_cust_trx_types.allow_overapplication_flag%type,
101: p_natural_application_flag IN
102: ra_cust_trx_types.natural_application_only_flag%type,

Line 100: ra_cust_trx_types.allow_overapplication_flag%type,

96: ra_cust_trx_types.accounting_affect_flag%type,
97: p_creation_sign IN
98: ra_cust_trx_types.creation_sign%type,
99: p_allow_overapplication_flag IN
100: ra_cust_trx_types.allow_overapplication_flag%type,
101: p_natural_application_flag IN
102: ra_cust_trx_types.natural_application_only_flag%type,
103: p_cash_receipt_id IN
104: ar_cash_receipts.cash_receipt_id%type DEFAULT NULL,

Line 102: ra_cust_trx_types.natural_application_only_flag%type,

98: ra_cust_trx_types.creation_sign%type,
99: p_allow_overapplication_flag IN
100: ra_cust_trx_types.allow_overapplication_flag%type,
101: p_natural_application_flag IN
102: ra_cust_trx_types.natural_application_only_flag%type,
103: p_cash_receipt_id IN
104: ar_cash_receipts.cash_receipt_id%type DEFAULT NULL,
105: p_error_mode IN VARCHAR2
106: ) IS

Line 113: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;

109: l_dist_count NUMBER;
110: l_error_count NUMBER;
111: l_error_message VARCHAR2(128);
112:
113: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
114: l_true_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
115: l_old_complete_flag VARCHAR2(1);
116: l_recreate_ps_flag VARCHAR2(1);
117: l_applied_commitment_amt NUMBER;

Line 114: l_true_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;

110: l_error_count NUMBER;
111: l_error_message VARCHAR2(128);
112:
113: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
114: l_true_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
115: l_old_complete_flag VARCHAR2(1);
116: l_recreate_ps_flag VARCHAR2(1);
117: l_applied_commitment_amt NUMBER;
118:

Line 208: ra_cust_trx_types ctt,

204: l_true_open_receivables_flag,
205: l_ps_rev_cash_id,
206: l_ct_rev_cash_id
207: FROM ar_payment_schedules ps,
208: ra_cust_trx_types ctt,
209: ra_cust_trx_line_gl_dist lgd,
210: ra_customer_trx ct
211: WHERE ct.customer_trx_id = ps.customer_trx_id(+)
212: AND ct.cust_trx_type_id = ctt.cust_trx_type_id

Line 305: ra_cust_trx_types ctt

301: l_initial_customer_trx_id,
302: l_previous_customer_trx_id
303: from
304: ra_customer_trx ct,
305: ra_cust_trx_types ctt
306: WHERE
307: ct.customer_trx_id = p_customer_trx_id
308: and
309: ct.cust_trx_type_id = ctt.cust_trx_type_id;

Line 727: ra_cust_trx_types ctt,

723: MAX( ps.term_id ),'N', 'Y'))
724: INTO l_recreate_ps_flag,
725: l_term_changed_flag
726: FROM ar_payment_schedules ps,
727: ra_cust_trx_types ctt,
728: ra_cust_trx_line_gl_dist lgd,
729: ra_customer_trx ct
730: WHERE ct.customer_trx_id = ps.customer_trx_id(+)
731: AND ct.cust_trx_type_id = ctt.cust_trx_type_id

Line 774: ra_cust_trx_types ctt

770: l_initial_customer_trx_id,
771: l_previous_customer_trx_id
772: from
773: ra_customer_trx ct,
774: ra_cust_trx_types ctt
775: WHERE
776: ct.customer_trx_id = p_customer_trx_id
777: and
778: ct.cust_trx_type_id = ctt.cust_trx_type_id;