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 207: ra_cust_trx_types ctt,

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

Line 303: ra_cust_trx_types ctt

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

Line 725: ra_cust_trx_types ctt,

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

Line 772: ra_cust_trx_types ctt

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