APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on JAI_RCV_TP_INV_DETAILS

Line 42: new table created for this bug. The table is jai_rcv_tp_inv_details.

38:
39: 14-mar-2005 bug#4284505 ssumaith - version 115.1
40:
41: Code has been added in the package body to insert third party taxes in the
42: new table created for this bug. The table is jai_rcv_tp_inv_details.
43:
44: A new procedure populate_tp_invoice_id has been created which does the actual
45: invoice id update in the jai_Rcv_Tp_inv_Details table.
46:

Line 45: invoice id update in the jai_Rcv_Tp_inv_Details table.

41: Code has been added in the package body to insert third party taxes in the
42: new table created for this bug. The table is jai_rcv_tp_inv_details.
43:
44: A new procedure populate_tp_invoice_id has been created which does the actual
45: invoice id update in the jai_Rcv_Tp_inv_Details table.
46:
47:
48: This table maintains tax level details of third party taxes, and it will be
49: used by the service tax processing concurrent.

Line 1421: --SELECT jai_rcv_tp_inv_details_s.nextval INTO ln_batch_line_id FROM DUAL;

1417: LOOP
1418:
1419: Fnd_File.put_line(Fnd_File.LOG, ' ');
1420: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 3 : Loop Begin');
1421: --SELECT jai_rcv_tp_inv_details_s.nextval INTO ln_batch_line_id FROM DUAL;
1422:
1423: --tax table need to be populated once only
1424: --added by eric for inclusive tax on 20-dec,2007, Begin
1425: -----------------------------------------------------------------------

Line 1430: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 3 ,jai_rcv_tp_inv_details table : i =1 Branch :');

1426: IF (i =1 )
1427: THEN
1428: -----------------------------------------------------------------------
1429: --added by eric for inclusive tax on 20-dec,2007, end
1430: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 3 ,jai_rcv_tp_inv_details table : i =1 Branch :');
1431: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 7. Before insert into jai_rcv_tp_inv_details' );
1432:
1433: -- start for bug 13528285 by anupgupt
1434: /* code added to apportioning of third party invoice lines amounts based on correction of quantity in receipt*/

Line 1431: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 7. Before insert into jai_rcv_tp_inv_details' );

1427: THEN
1428: -----------------------------------------------------------------------
1429: --added by eric for inclusive tax on 20-dec,2007, end
1430: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 3 ,jai_rcv_tp_inv_details table : i =1 Branch :');
1431: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 7. Before insert into jai_rcv_tp_inv_details' );
1432:
1433: -- start for bug 13528285 by anupgupt
1434: /* code added to apportioning of third party invoice lines amounts based on correction of quantity in receipt*/
1435: DECLARE

Line 1476: INSERT INTO jai_rcv_tp_inv_details

1472: ||tax_rec.tax_type ||' > tax_Rec.tax_amount > '||tax_Rec.tax_amount);
1473: END;
1474: -- end for bug 13528285 by anupgupt
1475:
1476: INSERT INTO jai_rcv_tp_inv_details
1477: (
1478: BATCH_LINE_ID ,
1479: BATCH_INVOICE_ID ,
1480: RCV_TRANSACTION_ID ,

Line 1495: jai_rcv_tp_inv_details_s.nextval,

1491: )
1492: VALUES
1493: (
1494: --ln_batch_line_id ,
1495: jai_rcv_tp_inv_details_s.nextval,
1496: ln_batch_invoice_id ,
1497: tax_rec.transaction_id,
1498: ln_line_number ,
1499: Tax_rec.tax_id ,

Line 1509: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 8. After insert into jai_rcv_tp_inv_details' );

1505: sysdate ,
1506: fnd_global.user_id ,
1507: fnd_global.login_id
1508: ) returning BATCH_LINE_ID into ln_BATCH_LINE_ID;
1509: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 8. After insert into jai_rcv_tp_inv_details' );
1510: --added by eric for inclusive tax on 20-dec,2007, Begin
1511: -----------------------------------------------------------------------
1512: END IF; --(i =1 )
1513: -----------------------------------------------------------------------