APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on JAI_RCV_TP_INVOICES

Line 36: 2. jai_rcv_tp_invoices

32: This clean up also has introduced two tables which help in tracking
33: third party invoices.
34:
35: 1. jai_rcv_tp_batches
36: 2. jai_rcv_tp_invoices
37:
38:
39: 14-mar-2005 bug#4284505 ssumaith - version 115.1
40:

Line 203: from jai_rcv_tp_invoices

199: select jai_rcv_tp_batches_s.nextval from dual;
200:
201: cursor c_no_of_invoice_generated(cp_batch_id number) is
202: select count(batch_invoice_id)
203: from jai_rcv_tp_invoices
204: where batch_id = cp_batch_id;
205:
206:
207: r_pending_tp_receipts c_pending_tp_receipts%rowtype;

Line 620: select jai_rcv_tp_invoices_s1.nextval /* renamed the sequence to point to the correct sequence name - ssumaith - sequence change process */

616: where vendor_id = p_vendor_id
617: and vendor_site_id = p_vendor_site_id;
618:
619: cursor c_get_inv_run_no is
620: select jai_rcv_tp_invoices_s1.nextval /* renamed the sequence to point to the correct sequence name - ssumaith - sequence change process */
621: from dual;
622:
623: cursor c_check_if_already_processed(p_shipment_header_id number) is
624: select count(transaction_id)

Line 1081: SELECT jai_rcv_tp_invoices_s.nextval

1077: open c_get_goods_received_date(c_thirdparty_tax_rec.vendor_id , c_thirdparty_tax_rec.vendor_site_id);
1078: fetch c_get_goods_received_date into ld_goods_received_date;
1079: close c_get_goods_received_date;
1080:
1081: SELECT jai_rcv_tp_invoices_s.nextval
1082: INTO ln_batch_invoice_id
1083: FROM DUAL;
1084:
1085: --Tax table need to be inserted once only

Line 1094: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 1. Before insert into jai_rcv_tp_invoices ' );

1090: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 : jai_rcv_tp_invoice stable insert beign:');
1091: -----------------------------------------------------------------------
1092: --added by eric for inclusive tax on 20-dec,2007, end
1093: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 ,jai_rcv_tp_invoice table insert : i =1 Branch :');
1094: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 1. Before insert into jai_rcv_tp_invoices ' );
1095:
1096:
1097: -- start for bug 13528285 by anupgupt
1098: /* Code changes done to calculate third party invoice header amount as per the correction done on receipt */

Line 1169: insert into jai_rcv_tp_invoices

1165: END LOOP;
1166: END;
1167: -- end for bug 13528285 by anupgupt
1168:
1169: insert into jai_rcv_tp_invoices
1170: (
1171: batch_invoice_id ,
1172: batch_id ,
1173: shipment_header_id ,

Line 1210: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 2. After insert into jai_rcv_tp_invoices ' );

1206: fnd_profile.value('CONC_LOGIN_ID'),
1207: fnd_profile.value('CONC_REQUEST_ID')
1208: );
1209:
1210: Fnd_File.put_line(Fnd_File.LOG, ' DEBUG : 2. After insert into jai_rcv_tp_invoices ' );
1211: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 2 :jai_rcv_tp_invoice table insert end:');
1212: Fnd_File.put_line(Fnd_File.LOG, ' ');
1213: --added by eric for inclusive tax on 20-dec,2007, Begin
1214: -----------------------------------------------------------------------

Line 1653: || This procedure is added by ssumaith - bug# 4284505 for updating the invoice_id in the jai_Rcv_tp_invoices table

1649: )
1650: IS
1651:
1652: /*
1653: || This procedure is added by ssumaith - bug# 4284505 for updating the invoice_id in the jai_Rcv_tp_invoices table
1654: || This procedure will be called from the trigger - ja_in_ap_aia_before_trg on ap_invoices_all
1655: */
1656: BEGIN
1657:

Line 1658: UPDATE jai_rcv_tp_invoices

1654: || This procedure will be called from the trigger - ja_in_ap_aia_before_trg on ap_invoices_all
1655: */
1656: BEGIN
1657:
1658: UPDATE jai_rcv_tp_invoices
1659: SET invoice_id = p_invoice_id ,
1660: last_update_date = sysdate ,
1661: last_updated_by = fnd_global.user_id
1662: WHERE invoice_num = p_invoice_num