[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,
1582: /* , 0 */
1583: FROM
1584: ar_receivable_applications ra,
1585: ar_payment_schedules ps,
1586: ar_adjustments adj,
1587: ra_cust_trx_types ctt,
1588: ra_cust_trx_line_gl_dist ctlgd,
1589: ra_customer_trx ct,
1590: fnd_currencies c,
3626: ra_cust_trx_types ctt_com,
3627: ra_cust_trx_line_gl_dist ctlgd_com,
3628: ar_payment_schedules ps,
3629: ar_receivable_applications ra,
3630: ar_adjustments adj,
3631: fnd_currencies c,
3632: ra_terms t,
3633: ra_terms_lines tl,
3634: ra_customer_trx ct_com,
3716: ------------------------------------------------
3717: -- Insert adj sql
3718: ------------------------------------------------
3719: l_insert_adj_sql :=
3720: 'INSERT INTO AR_ADJUSTMENTS
3721: (
3722: created_by,
3723: creation_date,
3724: last_updated_by,
4111: l_commitment_bal NUMBER;
4112: l_amount NUMBER;
4113: /* VAT changes */
4114: l_ae_doc_rec ae_doc_rec_type;
4115: l_adjustment_id ar_adjustments.adjustment_id%type;
4116:
4117: l_total_tax_adj NUMBER;
4118: l_total_frt_adj NUMBER;
4119: l_total_line_adj NUMBER;
4390: END LOOP;
4391:
4392:
4393: -------------------------------------------------------------
4394: -- Insert into ar_adjustments
4395: -------------------------------------------------------------
4396:
4397: FOR i IN 0..p_number_records - 1 LOOP
4398:
4471: 'acctd_adj_amount',
4472: p_acctd_adj_amount_t( i ) );
4473:
4474: /* VAT changes */
4475: SELECT ar_adjustments_s.nextval
4476: INTO l_adjustment_id
4477: FROM dual;
4478:
4479: dbms_sql.bind_variable( p_insert_adj_c,
4525: +-------------------------------------------*/
4526:
4527: ar_mrc_engine.maintain_mrc_data(
4528: p_event_mode => 'INSERT',
4529: p_table_name => 'AR_ADJUSTMENTS',
4530: p_mode => 'SINGLE',
4531: p_key_value => l_adjustment_id);
4532:
4533: EXCEPTION
5203: ra_cust_trx_line_gl_dist ctlgd_com,
5204: ar_payment_schedules ps,
5205: ar_payment_schedules ps_inv,
5206: ar_receivable_applications ra,
5207: ar_adjustments adj,
5208: ar_adjustments adjd,
5209: fnd_currencies c,
5210: fnd_currencies c_ps,
5211: ra_customer_trx ct_com,
5204: ar_payment_schedules ps,
5205: ar_payment_schedules ps_inv,
5206: ar_receivable_applications ra,
5207: ar_adjustments adj,
5208: ar_adjustments adjd,
5209: fnd_currencies c,
5210: fnd_currencies c_ps,
5211: ra_customer_trx ct_com,
5212: ra_customer_trx ct_inv,
5302: --sequence. Bind variable :adjustment_id is expected while
5303: --assigning the bind variable
5304:
5305: l_insert_adj_sql :=
5306: 'INSERT INTO AR_ADJUSTMENTS
5307: (
5308: created_by,
5309: creation_date,
5310: last_updated_by,
5728: l_percent_t number_table_type;
5729:
5730: /* VAT changes */
5731: l_ae_doc_rec ae_doc_rec_type;
5732: l_adjustment_id ar_adjustments.adjustment_id%type;
5733:
5734: /* Bug 3570404 - Guarantees */
5735: l_max_curr_adj NUMBER;
5736: l_bal_sign NUMBER;
5912: so figure the effect of prior CMs here and now */
5913:
5914: select nvl(sum(adj.line_adjusted),0)
5915: into l_cm_adjustment_total
5916: from ar_adjustments adj,
5917: ra_customer_trx ocm
5918: where adj.customer_trx_id = p_select_rec.adjusted_trx_id
5919: and adj.subsequent_trx_id = ocm.customer_trx_id
5920: and ocm.previous_customer_trx_id = p_select_rec.invoice_trx_id;
6220: END LOOP;
6221:
6222:
6223: -------------------------------------------------------------
6224: -- Insert into ar_adjustments
6225: -------------------------------------------------------------
6226:
6227: FOR i IN 0..p_number_records - 1 LOOP
6228:
6301: 'acctd_adj_amount',
6302: p_acctd_adj_amount_t( i ) );
6303:
6304: /* VAT changes */
6305: SELECT ar_adjustments_s.nextval
6306: INTO l_adjustment_id
6307: FROM dual;
6308:
6309: dbms_sql.bind_variable( p_insert_adj_c,
6352: +-------------------------------------------*/
6353:
6354: ar_mrc_engine.maintain_mrc_data(
6355: p_event_mode => 'INSERT',
6356: p_table_name => 'AR_ADJUSTMENTS',
6357: p_mode => 'SINGLE',
6358: p_key_value => l_adjustment_id);
6359:
6360: EXCEPTION