DBA Data[Home] [Help]

APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on FND_GLOBAL

Line 215: ln_uid NUMBER; --File.Sql.35 Cbabu := fnd_global.user_id;

211: ln_batch_id NUMBER;
212: ln_no_of_invoice_generated NUMBER;
213:
214: ln_req_id NUMBER;
215: ln_uid NUMBER; --File.Sql.35 Cbabu := fnd_global.user_id;
216: lv_temp VARCHAR2(100);
217: ln_org_id NUMBER; /*Added by aiyer for the bug 5490479 */
218:
219: begin

Line 221: ln_uid := fnd_global.user_id;

217: ln_org_id NUMBER; /*Added by aiyer for the bug 5490479 */
218:
219: begin
220:
221: ln_uid := fnd_global.user_id;
222: /*
223: || Start of bug 5490479
224: || Added by aiyer for the bug 5490479
225: || Get the operating unit (org_id)

Line 359: ln_uid := fnd_global.user_id;

355: 'Debug Level 1 : Invoking APXIIMPT as no of invoices created is :'
356: || to_char(ln_no_of_invoice_generated) );
357: end if;
358:
359: ln_uid := fnd_global.user_id;
360: ln_req_id :=
361: Fnd_Request.submit_request
362: (
363: 'SQLAP',

Line 665: ln_uid number; --File.Sql.35 Cbabu := fnd_global.user_id;

661: ln_tax_amount number;
662: lv_currency_conversion_type rcv_transactions.currency_conversion_type%type;
663: lv_currency_conversion_rate rcv_transactions.currency_conversion_rate%type;
664: lv_currency_conversion_date date;
665: ln_uid number; --File.Sql.35 Cbabu := fnd_global.user_id;
666: ln_inv_run_no number;
667: lv_invoice_num ap_invoices_all.invoice_num%type;
668: lv_func_currency gl_sets_of_books.currency_code%type;
669: ln_gl_set_of_books_id gl_sets_of_books.set_of_books_id%type;

Line 742: ln_uid := fnd_global.user_id;

738:
739:
740: begin
741:
742: ln_uid := fnd_global.user_id;
743: ln_vendor_id := -999;
744: ln_vendor_site := -999;
745: lv_currency := '$$$';
746: lv_vendor_has_changed := 'TRUE';

Line 1503: fnd_global.user_id ,

1499: Tax_rec.tax_id ,
1500: tax_Rec.tax_amount ,
1501: tax_rec.tax_rate ,
1502: tax_rec.tax_type ,
1503: fnd_global.user_id ,
1504: sysdate ,
1505: sysdate ,
1506: fnd_global.user_id ,
1507: fnd_global.login_id

Line 1506: fnd_global.user_id ,

1502: tax_rec.tax_type ,
1503: fnd_global.user_id ,
1504: sysdate ,
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

Line 1507: fnd_global.login_id

1503: fnd_global.user_id ,
1504: sysdate ,
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: -----------------------------------------------------------------------

Line 1661: last_updated_by = fnd_global.user_id

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
1663: AND vendor_id = p_vendor_id
1664: AND vendor_site_id = p_vendor_site_id;
1665: