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;*/
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:
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 ,
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 ,
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 ,
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: );
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 */
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:
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: );
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;
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;
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 ,
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 ,
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 ,
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 ;
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: );
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
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 ,
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 ,
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 ,
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: );
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
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:
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: );
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;
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;
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
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
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);