[Home] [Help]
160: line_remaining NUMBER,
161: amount_adjusted NUMBER,
162: percent NUMBER,
163: allocate_tax_freight ra_cust_trx_types_all.allocate_tax_freight%type,
164: adjustment_type ar_adjustments_all.type%type,
165: tax_remaining NUMBER,
166: freight_remaining NUMBER,
167: total_tax_amount NUMBER,
168: total_freight_amount NUMBER
201: ps_freight_original NUMBER,
202: ps_freight_remaining NUMBER,
203: ps_amount_adjusted NUMBER,
204: allocate_tax_freight ra_cust_trx_types.allocate_tax_freight%type,
205: adjustment_type ar_adjustments.type%type,
206: total_cm_tax_amount NUMBER,
207: total_cm_frt_amount NUMBER,
208: -- total_inv_line_adj NUMBER,
209: -- total_inv_tax_adj NUMBER,
1574: /* , 0 */
1575: FROM
1576: ar_receivable_applications ra,
1577: ar_payment_schedules ps,
1578: ar_adjustments adj,
1579: ra_cust_trx_types ctt,
1580: ra_cust_trx_line_gl_dist ctlgd,
1581: ra_customer_trx ct,
1582: fnd_currencies c,
3618: ra_cust_trx_types ctt_com,
3619: ra_cust_trx_line_gl_dist ctlgd_com,
3620: ar_payment_schedules ps,
3621: ar_receivable_applications ra,
3622: ar_adjustments adj,
3623: fnd_currencies c,
3624: ra_terms t,
3625: ra_terms_lines tl,
3626: ra_customer_trx ct_com,
3707: ------------------------------------------------
3708: -- Insert adj sql
3709: ------------------------------------------------
3710: l_insert_adj_sql :=
3711: 'INSERT INTO AR_ADJUSTMENTS
3712: (
3713: created_by,
3714: creation_date,
3715: last_updated_by,
4102: l_commitment_bal NUMBER;
4103: l_amount NUMBER;
4104: /* VAT changes */
4105: l_ae_doc_rec ae_doc_rec_type;
4106: l_adjustment_id ar_adjustments.adjustment_id%type;
4107:
4108: l_total_tax_adj NUMBER;
4109: l_total_frt_adj NUMBER;
4110: l_total_line_adj NUMBER;
4381: END LOOP;
4382:
4383:
4384: -------------------------------------------------------------
4385: -- Insert into ar_adjustments
4386: -------------------------------------------------------------
4387:
4388: FOR i IN 0..p_number_records - 1 LOOP
4389:
4462: 'acctd_adj_amount',
4463: p_acctd_adj_amount_t( i ) );
4464:
4465: /* VAT changes */
4466: SELECT ar_adjustments_s.nextval
4467: INTO l_adjustment_id
4468: FROM dual;
4469:
4470: dbms_sql.bind_variable( p_insert_adj_c,
4516: +-------------------------------------------*/
4517:
4518: ar_mrc_engine.maintain_mrc_data(
4519: p_event_mode => 'INSERT',
4520: p_table_name => 'AR_ADJUSTMENTS',
4521: p_mode => 'SINGLE',
4522: p_key_value => l_adjustment_id);
4523:
4524: EXCEPTION
5194: ra_cust_trx_line_gl_dist ctlgd_com,
5195: ar_payment_schedules ps,
5196: ar_payment_schedules ps_inv,
5197: ar_receivable_applications ra,
5198: ar_adjustments adj,
5199: ar_adjustments adjd,
5200: fnd_currencies c,
5201: fnd_currencies c_ps,
5202: ra_customer_trx ct_com,
5195: ar_payment_schedules ps,
5196: ar_payment_schedules ps_inv,
5197: ar_receivable_applications ra,
5198: ar_adjustments adj,
5199: ar_adjustments adjd,
5200: fnd_currencies c,
5201: fnd_currencies c_ps,
5202: ra_customer_trx ct_com,
5203: ra_customer_trx ct_inv,
5293: --sequence. Bind variable :adjustment_id is expected while
5294: --assigning the bind variable
5295:
5296: l_insert_adj_sql :=
5297: 'INSERT INTO AR_ADJUSTMENTS
5298: (
5299: created_by,
5300: creation_date,
5301: last_updated_by,
5719: l_percent_t number_table_type;
5720:
5721: /* VAT changes */
5722: l_ae_doc_rec ae_doc_rec_type;
5723: l_adjustment_id ar_adjustments.adjustment_id%type;
5724:
5725: /* Bug 3570404 - Guarantees */
5726: l_max_curr_adj NUMBER;
5727: l_bal_sign NUMBER;
5903: so figure the effect of prior CMs here and now */
5904:
5905: select nvl(sum(adj.line_adjusted),0)
5906: into l_cm_adjustment_total
5907: from ar_adjustments adj,
5908: ra_customer_trx ocm
5909: where adj.customer_trx_id = p_select_rec.adjusted_trx_id
5910: and adj.subsequent_trx_id = ocm.customer_trx_id
5911: and ocm.previous_customer_trx_id = p_select_rec.invoice_trx_id;
6211: END LOOP;
6212:
6213:
6214: -------------------------------------------------------------
6215: -- Insert into ar_adjustments
6216: -------------------------------------------------------------
6217:
6218: FOR i IN 0..p_number_records - 1 LOOP
6219:
6292: 'acctd_adj_amount',
6293: p_acctd_adj_amount_t( i ) );
6294:
6295: /* VAT changes */
6296: SELECT ar_adjustments_s.nextval
6297: INTO l_adjustment_id
6298: FROM dual;
6299:
6300: dbms_sql.bind_variable( p_insert_adj_c,
6343: +-------------------------------------------*/
6344:
6345: ar_mrc_engine.maintain_mrc_data(
6346: p_event_mode => 'INSERT',
6347: p_table_name => 'AR_ADJUSTMENTS',
6348: p_mode => 'SINGLE',
6349: p_key_value => l_adjustment_id);
6350:
6351: EXCEPTION