DBA Data[Home] [Help]

APPS.JAI_AR_IMPORT_POPU_PKG dependencies on FND_GLOBAL

Line 646: fnd_global.user_id ,

642: lv_appl_src, \*'JA_IN_OE_AR_LINES_INSERT_TRG', Ramananda for removal of SQL LITERALs *\
643: lv_err_msg, \* 'Default Location is not setup for Inventory Organization ' || pr_new.warehouse_id , *\
644: lv_addl_msg, \* 'Please setup the Default Location in Organization Additional Information Screen for Trx id : ' || pr_new.customer_trx_id , *\
645: sysdate,
646: fnd_global.user_id ,
647: fnd_global.user_id,
648: sysdate
649: );
650: end if;*/

Line 647: fnd_global.user_id,

643: lv_err_msg, \* 'Default Location is not setup for Inventory Organization ' || pr_new.warehouse_id , *\
644: lv_addl_msg, \* 'Please setup the Default Location in Organization Additional Information Screen for Trx id : ' || pr_new.customer_trx_id , *\
645: sysdate,
646: fnd_global.user_id ,
647: fnd_global.user_id,
648: sysdate
649: );
650: end if;*/
651:

Line 699: fnd_global.user_id ,

695: 0 ,
696: lr_trx_rec.trx_number ,
697: lr_trx_rec.batch_source_id ,
698: sysdate ,
699: fnd_global.user_id ,
700: sysdate ,
701: fnd_global.user_id ,
702: fnd_global.login_id ,
703: lr_trx_rec.set_of_books_id ,

Line 701: fnd_global.user_id ,

697: lr_trx_rec.batch_source_id ,
698: sysdate ,
699: fnd_global.user_id ,
700: sysdate ,
701: fnd_global.user_id ,
702: fnd_global.login_id ,
703: lr_trx_rec.set_of_books_id ,
704: lr_trx_rec.primary_salesrep_id ,
705: lr_trx_rec.invoice_currency_code ,

Line 702: fnd_global.login_id ,

698: sysdate ,
699: fnd_global.user_id ,
700: sysdate ,
701: fnd_global.user_id ,
702: fnd_global.login_id ,
703: lr_trx_rec.set_of_books_id ,
704: lr_trx_rec.primary_salesrep_id ,
705: lr_trx_rec.invoice_currency_code ,
706: lr_trx_rec.exchange_rate_type ,

Line 846: fnd_global.user_id ,

842: round(tax_rec.tax_amount,2) ,
843: round(tax_rec.func_tax_amount,2) ,
844: round(tax_rec.base_tax_amount,2) ,
845: sysdate ,
846: fnd_global.user_id ,
847: sysdate ,
848: fnd_global.user_id ,
849: fnd_global.login_id
850: );

Line 848: fnd_global.user_id ,

844: round(tax_rec.base_tax_amount,2) ,
845: sysdate ,
846: fnd_global.user_id ,
847: sysdate ,
848: fnd_global.user_id ,
849: fnd_global.login_id
850: );
851: end if; /* end if for tax type not in excise .... */
852: else /* register association is not bond register , so all taxes can flow */

Line 849: fnd_global.login_id

845: sysdate ,
846: fnd_global.user_id ,
847: sysdate ,
848: fnd_global.user_id ,
849: fnd_global.login_id
850: );
851: end if; /* end if for tax type not in excise .... */
852: else /* register association is not bond register , so all taxes can flow */
853:

Line 905: fnd_global.user_id ,

901: round(tax_rec.tax_amount,2) ,
902: round(tax_rec.func_tax_amount,2) ,
903: round(tax_rec.base_tax_amount,2) ,
904: sysdate ,
905: fnd_global.user_id ,
906: sysdate ,
907: fnd_global.user_id ,
908: fnd_global.login_id
909: );

Line 907: fnd_global.user_id ,

903: round(tax_rec.base_tax_amount,2) ,
904: sysdate ,
905: fnd_global.user_id ,
906: sysdate ,
907: fnd_global.user_id ,
908: fnd_global.login_id
909: );
910:
911: end if;

Line 908: fnd_global.login_id

904: sysdate ,
905: fnd_global.user_id ,
906: sysdate ,
907: fnd_global.user_id ,
908: fnd_global.login_id
909: );
910:
911: end if;
912: end loop;

Line 1085: fnd_global.user_id ,

1081: round(nvl(rec_so_lines.line_amount,0) +
1082: nvl(ln_ar_tax_amount,0),2) ,
1083: rec_so_lines.assessable_value ,
1084: sysdate ,
1085: fnd_global.user_id ,
1086: sysdate ,
1087: fnd_global.user_id ,
1088: fnd_global.login_id ,
1089: rec_so_lines.excise_exempt_type ,

Line 1087: fnd_global.user_id ,

1083: rec_so_lines.assessable_value ,
1084: sysdate ,
1085: fnd_global.user_id ,
1086: sysdate ,
1087: fnd_global.user_id ,
1088: fnd_global.login_id ,
1089: rec_so_lines.excise_exempt_type ,
1090: rec_so_lines.excise_exempt_refno ,
1091: rec_so_lines.excise_exempt_date ,

Line 1088: fnd_global.login_id ,

1084: sysdate ,
1085: fnd_global.user_id ,
1086: sysdate ,
1087: fnd_global.user_id ,
1088: fnd_global.login_id ,
1089: rec_so_lines.excise_exempt_type ,
1090: rec_so_lines.excise_exempt_refno ,
1091: rec_so_lines.excise_exempt_date ,
1092: NULL ,

Line 4765: fnd_global.user_id,

4761: lv_err_msg ,
4762: substr(vsqlerrm,1,200) ,
4763: sysdate ,
4764: user ,
4765: fnd_global.user_id,
4766: sysdate
4767: );*/
4768:
4769: END pop_jai_inv_and_suppl ;

Line 5225: fnd_global.user_id ,

5221: lv_appl_src, \*'JA_IN_OE_AR_LINES_INSERT_TRG', Ramananda for removal of SQL LITERALs *\
5222: lv_err_msg, \* 'Default Location is not setup for Inventory Organization ' || pr_new.warehouse_id , *\
5223: lv_addl_msg, \* 'Please setup the Default Location in Organization Additional Information Screen for Trx id : ' || pr_new.customer_trx_id , *\
5224: sysdate,
5225: fnd_global.user_id ,
5226: -- added, Harshita for Bug 4866533
5227: fnd_global.user_id,
5228: sysdate
5229: );

Line 5227: fnd_global.user_id,

5223: lv_addl_msg, \* 'Please setup the Default Location in Organization Additional Information Screen for Trx id : ' || pr_new.customer_trx_id , *\
5224: sysdate,
5225: fnd_global.user_id ,
5226: -- added, Harshita for Bug 4866533
5227: fnd_global.user_id,
5228: sysdate
5229: );
5230: end if;*/
5231: insert into JAI_AR_TRXS -- bill only invoice

Line 5272: fnd_global.user_id ,

5268: 0 ,
5269: lr_trx_rec.trx_number ,
5270: lr_trx_rec.batch_source_id ,
5271: sysdate ,
5272: fnd_global.user_id ,
5273: sysdate ,
5274: fnd_global.user_id ,
5275: fnd_global.login_id ,
5276: lr_trx_rec.set_of_books_id ,

Line 5274: fnd_global.user_id ,

5270: lr_trx_rec.batch_source_id ,
5271: sysdate ,
5272: fnd_global.user_id ,
5273: sysdate ,
5274: fnd_global.user_id ,
5275: fnd_global.login_id ,
5276: lr_trx_rec.set_of_books_id ,
5277: lr_trx_rec.primary_salesrep_id ,
5278: lr_trx_rec.invoice_currency_code ,

Line 5275: fnd_global.login_id ,

5271: sysdate ,
5272: fnd_global.user_id ,
5273: sysdate ,
5274: fnd_global.user_id ,
5275: fnd_global.login_id ,
5276: lr_trx_rec.set_of_books_id ,
5277: lr_trx_rec.primary_salesrep_id ,
5278: lr_trx_rec.invoice_currency_code ,
5279: lr_trx_rec.exchange_rate_type ,

Line 5413: fnd_global.user_id ,

5409: -round(tax_rec.tax_amount,2) ,
5410: -round(tax_rec.func_tax_amount,2) ,
5411: -round(tax_rec.base_tax_amount,2) ,
5412: sysdate ,
5413: fnd_global.user_id ,
5414: sysdate ,
5415: fnd_global.user_id ,
5416: fnd_global.login_id
5417: );

Line 5415: fnd_global.user_id ,

5411: -round(tax_rec.base_tax_amount,2) ,
5412: sysdate ,
5413: fnd_global.user_id ,
5414: sysdate ,
5415: fnd_global.user_id ,
5416: fnd_global.login_id
5417: );
5418: end if;
5419: else

Line 5416: fnd_global.login_id

5412: sysdate ,
5413: fnd_global.user_id ,
5414: sysdate ,
5415: fnd_global.user_id ,
5416: fnd_global.login_id
5417: );
5418: end if;
5419: else
5420:

Line 5472: fnd_global.user_id ,

5468: -round(tax_rec.tax_amount,2) ,
5469: -round(tax_rec.func_tax_amount,2) ,
5470: -round(tax_rec.base_tax_amount,2) ,
5471: sysdate ,
5472: fnd_global.user_id ,
5473: sysdate ,
5474: fnd_global.user_id ,
5475: fnd_global.login_id
5476: );

Line 5474: fnd_global.user_id ,

5470: -round(tax_rec.base_tax_amount,2) ,
5471: sysdate ,
5472: fnd_global.user_id ,
5473: sysdate ,
5474: fnd_global.user_id ,
5475: fnd_global.login_id
5476: );
5477:
5478: end if;

Line 5475: fnd_global.login_id

5471: sysdate ,
5472: fnd_global.user_id ,
5473: sysdate ,
5474: fnd_global.user_id ,
5475: fnd_global.login_id
5476: );
5477:
5478: end if;
5479: end loop;

Line 5637: fnd_global.user_id ,

5633: nvl(ln_ar_tax_amount,0),
5634: NVL(pr_new.quantity_credited * pr_new.unit_selling_price, nvl(pr_new.extended_amount,0)) + nvl(ln_ar_tax_amount,0) ,
5635: rec_so_lines.assessable_value ,
5636: sysdate ,
5637: fnd_global.user_id ,
5638: sysdate ,
5639: fnd_global.user_id ,
5640: fnd_global.login_id ,
5641: rec_so_lines.service_type_code

Line 5639: fnd_global.user_id ,

5635: rec_so_lines.assessable_value ,
5636: sysdate ,
5637: fnd_global.user_id ,
5638: sysdate ,
5639: fnd_global.user_id ,
5640: fnd_global.login_id ,
5641: rec_so_lines.service_type_code
5642: );
5643: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin

Line 5640: fnd_global.login_id ,

5636: sysdate ,
5637: fnd_global.user_id ,
5638: sysdate ,
5639: fnd_global.user_id ,
5640: fnd_global.login_id ,
5641: rec_so_lines.service_type_code
5642: );
5643: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 begin
5644: OPEN c_jai_ar_trx_lines(pr_new.customer_trx_id,pr_new.customer_trx_line_id);