279: v_batch_id NUMBER; -- used as unique key in JAI_CMN_MTAX_HDRS_ALL table
280:
281: /* --Ramananda for File.Sql.35*/
282: v_today DATE; -- := trunc(sysdate);
283: v_created_by NUMBER; -- := nvl(FND_GLOBAL.USER_ID,-1);
284: v_login_id NUMBER; -- := nvl(FND_GLOBAL.LOGIN_ID,-1);
285: v_user_id NUMBER; -- := nvl(FND_GLOBAL.USER_ID,-1);
286:
287: --********* Modified Input Variables ***********
280:
281: /* --Ramananda for File.Sql.35*/
282: v_today DATE; -- := trunc(sysdate);
283: v_created_by NUMBER; -- := nvl(FND_GLOBAL.USER_ID,-1);
284: v_login_id NUMBER; -- := nvl(FND_GLOBAL.LOGIN_ID,-1);
285: v_user_id NUMBER; -- := nvl(FND_GLOBAL.USER_ID,-1);
286:
287: --********* Modified Input Variables ***********
288: v_org_id NUMBER;
281: /* --Ramananda for File.Sql.35*/
282: v_today DATE; -- := trunc(sysdate);
283: v_created_by NUMBER; -- := nvl(FND_GLOBAL.USER_ID,-1);
284: v_login_id NUMBER; -- := nvl(FND_GLOBAL.LOGIN_ID,-1);
285: v_user_id NUMBER; -- := nvl(FND_GLOBAL.USER_ID,-1);
286:
287: --********* Modified Input Variables ***********
288: v_org_id NUMBER;
289:
1254: p_process_partial := nvl(pv_process_partial, jai_constants.no);
1255: p_debug := nvl(pv_debug,jai_constants.no);
1256: p_trace :=nvl(pv_trace, jai_constants.no) ;
1257: v_today := trunc(sysdate);
1258: v_created_by := nvl(FND_GLOBAL.USER_ID,-1);
1259: v_login_id := nvl(FND_GLOBAL.LOGIN_ID,-1);
1260: v_user_id := nvl(FND_GLOBAL.USER_ID,-1);
1261: v_message_01 := 'There is no defaulting tax category in the set up';
1262: v_debug := FALSE;
1255: p_debug := nvl(pv_debug,jai_constants.no);
1256: p_trace :=nvl(pv_trace, jai_constants.no) ;
1257: v_today := trunc(sysdate);
1258: v_created_by := nvl(FND_GLOBAL.USER_ID,-1);
1259: v_login_id := nvl(FND_GLOBAL.LOGIN_ID,-1);
1260: v_user_id := nvl(FND_GLOBAL.USER_ID,-1);
1261: v_message_01 := 'There is no defaulting tax category in the set up';
1262: v_debug := FALSE;
1263: v_document_find_failed := 'N';
1256: p_trace :=nvl(pv_trace, jai_constants.no) ;
1257: v_today := trunc(sysdate);
1258: v_created_by := nvl(FND_GLOBAL.USER_ID,-1);
1259: v_login_id := nvl(FND_GLOBAL.LOGIN_ID,-1);
1260: v_user_id := nvl(FND_GLOBAL.USER_ID,-1);
1261: v_message_01 := 'There is no defaulting tax category in the set up';
1262: v_debug := FALSE;
1263: v_document_find_failed := 'N';
1264: v_failed := 'N';
1429: SYSDATE,
1430: v_created_by,/* Aiyer for the bug 4565665. Added the columns last_update_date and last_updated_by */
1431: SYSDATE,
1432: v_created_by,
1433: FND_GLOBAL.PROG_APPL_ID,
1434: FND_GLOBAL.CONC_PROGRAM_ID,
1435: FND_GLOBAL.CONC_LOGIN_ID,
1436: FND_GLOBAL.CONC_REQUEST_ID
1437: /*fnd_profile.value('PROG_APPL_ID'),
1430: v_created_by,/* Aiyer for the bug 4565665. Added the columns last_update_date and last_updated_by */
1431: SYSDATE,
1432: v_created_by,
1433: FND_GLOBAL.PROG_APPL_ID,
1434: FND_GLOBAL.CONC_PROGRAM_ID,
1435: FND_GLOBAL.CONC_LOGIN_ID,
1436: FND_GLOBAL.CONC_REQUEST_ID
1437: /*fnd_profile.value('PROG_APPL_ID'),
1438: fnd_profile.value('CONC_PROGRAM_ID'),
1431: SYSDATE,
1432: v_created_by,
1433: FND_GLOBAL.PROG_APPL_ID,
1434: FND_GLOBAL.CONC_PROGRAM_ID,
1435: FND_GLOBAL.CONC_LOGIN_ID,
1436: FND_GLOBAL.CONC_REQUEST_ID
1437: /*fnd_profile.value('PROG_APPL_ID'),
1438: fnd_profile.value('CONC_PROGRAM_ID'),
1439: fnd_profile.value('CONC_LOGIN_ID'),
1432: v_created_by,
1433: FND_GLOBAL.PROG_APPL_ID,
1434: FND_GLOBAL.CONC_PROGRAM_ID,
1435: FND_GLOBAL.CONC_LOGIN_ID,
1436: FND_GLOBAL.CONC_REQUEST_ID
1437: /*fnd_profile.value('PROG_APPL_ID'),
1438: fnd_profile.value('CONC_PROGRAM_ID'),
1439: fnd_profile.value('CONC_LOGIN_ID'),
1440: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
1436: FND_GLOBAL.CONC_REQUEST_ID
1437: /*fnd_profile.value('PROG_APPL_ID'),
1438: fnd_profile.value('CONC_PROGRAM_ID'),
1439: fnd_profile.value('CONC_LOGIN_ID'),
1440: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
1441: )returning batch_id into v_batch_id; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1442:
1443: COMMIT;
1444:
1822: shipment_rec.document_no,
1823: shipment_rec.line_num,
1824: shipment_rec.shipment_num,
1825: shipment_rec.tax_category_id,
1826: FND_GLOBAL.PROG_APPL_ID,
1827: FND_GLOBAL.CONC_PROGRAM_ID,
1828: FND_GLOBAL.CONC_LOGIN_ID,
1829: FND_GLOBAL.CONC_REQUEST_ID,
1830: /*fnd_profile.value('PROG_APPL_ID'),
1823: shipment_rec.line_num,
1824: shipment_rec.shipment_num,
1825: shipment_rec.tax_category_id,
1826: FND_GLOBAL.PROG_APPL_ID,
1827: FND_GLOBAL.CONC_PROGRAM_ID,
1828: FND_GLOBAL.CONC_LOGIN_ID,
1829: FND_GLOBAL.CONC_REQUEST_ID,
1830: /*fnd_profile.value('PROG_APPL_ID'),
1831: fnd_profile.value('CONC_PROGRAM_ID'),
1824: shipment_rec.shipment_num,
1825: shipment_rec.tax_category_id,
1826: FND_GLOBAL.PROG_APPL_ID,
1827: FND_GLOBAL.CONC_PROGRAM_ID,
1828: FND_GLOBAL.CONC_LOGIN_ID,
1829: FND_GLOBAL.CONC_REQUEST_ID,
1830: /*fnd_profile.value('PROG_APPL_ID'),
1831: fnd_profile.value('CONC_PROGRAM_ID'),
1832: fnd_profile.value('CONC_LOGIN_ID'),
1825: shipment_rec.tax_category_id,
1826: FND_GLOBAL.PROG_APPL_ID,
1827: FND_GLOBAL.CONC_PROGRAM_ID,
1828: FND_GLOBAL.CONC_LOGIN_ID,
1829: FND_GLOBAL.CONC_REQUEST_ID,
1830: /*fnd_profile.value('PROG_APPL_ID'),
1831: fnd_profile.value('CONC_PROGRAM_ID'),
1832: fnd_profile.value('CONC_LOGIN_ID'),
1833: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
1829: FND_GLOBAL.CONC_REQUEST_ID,
1830: /*fnd_profile.value('PROG_APPL_ID'),
1831: fnd_profile.value('CONC_PROGRAM_ID'),
1832: fnd_profile.value('CONC_LOGIN_ID'),
1833: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
1834: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1835: sysdate,
1836: v_created_by,
1837: sysdate
2291: shipment_rec.shipment_num,
2292: shipment_rec.tax_category_id,
2293: v_dflt_tax_category_id,
2294: v_message,
2295: FND_GLOBAL.PROG_APPL_ID,
2296: FND_GLOBAL.CONC_PROGRAM_ID,
2297: FND_GLOBAL.CONC_LOGIN_ID,
2298: FND_GLOBAL.CONC_REQUEST_ID,
2299: /*fnd_profile.value('PROG_APPL_ID'),
2292: shipment_rec.tax_category_id,
2293: v_dflt_tax_category_id,
2294: v_message,
2295: FND_GLOBAL.PROG_APPL_ID,
2296: FND_GLOBAL.CONC_PROGRAM_ID,
2297: FND_GLOBAL.CONC_LOGIN_ID,
2298: FND_GLOBAL.CONC_REQUEST_ID,
2299: /*fnd_profile.value('PROG_APPL_ID'),
2300: fnd_profile.value('CONC_PROGRAM_ID'),
2293: v_dflt_tax_category_id,
2294: v_message,
2295: FND_GLOBAL.PROG_APPL_ID,
2296: FND_GLOBAL.CONC_PROGRAM_ID,
2297: FND_GLOBAL.CONC_LOGIN_ID,
2298: FND_GLOBAL.CONC_REQUEST_ID,
2299: /*fnd_profile.value('PROG_APPL_ID'),
2300: fnd_profile.value('CONC_PROGRAM_ID'),
2301: fnd_profile.value('CONC_LOGIN_ID'),
2294: v_message,
2295: FND_GLOBAL.PROG_APPL_ID,
2296: FND_GLOBAL.CONC_PROGRAM_ID,
2297: FND_GLOBAL.CONC_LOGIN_ID,
2298: FND_GLOBAL.CONC_REQUEST_ID,
2299: /*fnd_profile.value('PROG_APPL_ID'),
2300: fnd_profile.value('CONC_PROGRAM_ID'),
2301: fnd_profile.value('CONC_LOGIN_ID'),
2302: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
2298: FND_GLOBAL.CONC_REQUEST_ID,
2299: /*fnd_profile.value('PROG_APPL_ID'),
2300: fnd_profile.value('CONC_PROGRAM_ID'),
2301: fnd_profile.value('CONC_LOGIN_ID'),
2302: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
2303: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2304: sysdate,
2305: v_created_by,
2306: sysdate
2410: releases_rec.release_num,
2411: releases_rec.line_num,
2412: releases_rec.shipment_num,
2413: releases_rec.tax_category_id,
2414: FND_GLOBAL.PROG_APPL_ID,
2415: FND_GLOBAL.CONC_PROGRAM_ID,
2416: FND_GLOBAL.CONC_LOGIN_ID,
2417: FND_GLOBAL.CONC_REQUEST_ID,
2418: /*fnd_profile.value('PROG_APPL_ID'),
2411: releases_rec.line_num,
2412: releases_rec.shipment_num,
2413: releases_rec.tax_category_id,
2414: FND_GLOBAL.PROG_APPL_ID,
2415: FND_GLOBAL.CONC_PROGRAM_ID,
2416: FND_GLOBAL.CONC_LOGIN_ID,
2417: FND_GLOBAL.CONC_REQUEST_ID,
2418: /*fnd_profile.value('PROG_APPL_ID'),
2419: fnd_profile.value('CONC_PROGRAM_ID'),
2412: releases_rec.shipment_num,
2413: releases_rec.tax_category_id,
2414: FND_GLOBAL.PROG_APPL_ID,
2415: FND_GLOBAL.CONC_PROGRAM_ID,
2416: FND_GLOBAL.CONC_LOGIN_ID,
2417: FND_GLOBAL.CONC_REQUEST_ID,
2418: /*fnd_profile.value('PROG_APPL_ID'),
2419: fnd_profile.value('CONC_PROGRAM_ID'),
2420: fnd_profile.value('CONC_LOGIN_ID'),
2413: releases_rec.tax_category_id,
2414: FND_GLOBAL.PROG_APPL_ID,
2415: FND_GLOBAL.CONC_PROGRAM_ID,
2416: FND_GLOBAL.CONC_LOGIN_ID,
2417: FND_GLOBAL.CONC_REQUEST_ID,
2418: /*fnd_profile.value('PROG_APPL_ID'),
2419: fnd_profile.value('CONC_PROGRAM_ID'),
2420: fnd_profile.value('CONC_LOGIN_ID'),
2421: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
2417: FND_GLOBAL.CONC_REQUEST_ID,
2418: /*fnd_profile.value('PROG_APPL_ID'),
2419: fnd_profile.value('CONC_PROGRAM_ID'),
2420: fnd_profile.value('CONC_LOGIN_ID'),
2421: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
2422: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2423: sysdate,
2424: v_created_by,
2425: sysdate
2880: releases_rec.shipment_num,
2881: releases_rec.tax_category_id,
2882: v_dflt_tax_category_id,
2883: v_message,
2884: FND_GLOBAL.PROG_APPL_ID,
2885: FND_GLOBAL.CONC_PROGRAM_ID,
2886: FND_GLOBAL.CONC_LOGIN_ID,
2887: FND_GLOBAL.CONC_REQUEST_ID,
2888: /*fnd_profile.value('PROG_APPL_ID'),
2881: releases_rec.tax_category_id,
2882: v_dflt_tax_category_id,
2883: v_message,
2884: FND_GLOBAL.PROG_APPL_ID,
2885: FND_GLOBAL.CONC_PROGRAM_ID,
2886: FND_GLOBAL.CONC_LOGIN_ID,
2887: FND_GLOBAL.CONC_REQUEST_ID,
2888: /*fnd_profile.value('PROG_APPL_ID'),
2889: fnd_profile.value('CONC_PROGRAM_ID'),
2882: v_dflt_tax_category_id,
2883: v_message,
2884: FND_GLOBAL.PROG_APPL_ID,
2885: FND_GLOBAL.CONC_PROGRAM_ID,
2886: FND_GLOBAL.CONC_LOGIN_ID,
2887: FND_GLOBAL.CONC_REQUEST_ID,
2888: /*fnd_profile.value('PROG_APPL_ID'),
2889: fnd_profile.value('CONC_PROGRAM_ID'),
2890: fnd_profile.value('CONC_LOGIN_ID'),
2883: v_message,
2884: FND_GLOBAL.PROG_APPL_ID,
2885: FND_GLOBAL.CONC_PROGRAM_ID,
2886: FND_GLOBAL.CONC_LOGIN_ID,
2887: FND_GLOBAL.CONC_REQUEST_ID,
2888: /*fnd_profile.value('PROG_APPL_ID'),
2889: fnd_profile.value('CONC_PROGRAM_ID'),
2890: fnd_profile.value('CONC_LOGIN_ID'),
2891: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
2887: FND_GLOBAL.CONC_REQUEST_ID,
2888: /*fnd_profile.value('PROG_APPL_ID'),
2889: fnd_profile.value('CONC_PROGRAM_ID'),
2890: fnd_profile.value('CONC_LOGIN_ID'),
2891: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
2892: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2893: sysdate,
2894: v_created_by,
2895: sysdate
2980: reqn_rec.type_lookup_code,
2981: reqn_rec.document_no,
2982: reqn_rec.line_num,
2983: reqn_rec.tax_category_id,
2984: FND_GLOBAL.PROG_APPL_ID,
2985: FND_GLOBAL.CONC_PROGRAM_ID,
2986: FND_GLOBAL.CONC_LOGIN_ID,
2987: FND_GLOBAL.CONC_REQUEST_ID,
2988: /*fnd_profile.value('PROG_APPL_ID'),
2981: reqn_rec.document_no,
2982: reqn_rec.line_num,
2983: reqn_rec.tax_category_id,
2984: FND_GLOBAL.PROG_APPL_ID,
2985: FND_GLOBAL.CONC_PROGRAM_ID,
2986: FND_GLOBAL.CONC_LOGIN_ID,
2987: FND_GLOBAL.CONC_REQUEST_ID,
2988: /*fnd_profile.value('PROG_APPL_ID'),
2989: fnd_profile.value('CONC_PROGRAM_ID'),
2982: reqn_rec.line_num,
2983: reqn_rec.tax_category_id,
2984: FND_GLOBAL.PROG_APPL_ID,
2985: FND_GLOBAL.CONC_PROGRAM_ID,
2986: FND_GLOBAL.CONC_LOGIN_ID,
2987: FND_GLOBAL.CONC_REQUEST_ID,
2988: /*fnd_profile.value('PROG_APPL_ID'),
2989: fnd_profile.value('CONC_PROGRAM_ID'),
2990: fnd_profile.value('CONC_LOGIN_ID'),
2983: reqn_rec.tax_category_id,
2984: FND_GLOBAL.PROG_APPL_ID,
2985: FND_GLOBAL.CONC_PROGRAM_ID,
2986: FND_GLOBAL.CONC_LOGIN_ID,
2987: FND_GLOBAL.CONC_REQUEST_ID,
2988: /*fnd_profile.value('PROG_APPL_ID'),
2989: fnd_profile.value('CONC_PROGRAM_ID'),
2990: fnd_profile.value('CONC_LOGIN_ID'),
2991: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
2987: FND_GLOBAL.CONC_REQUEST_ID,
2988: /*fnd_profile.value('PROG_APPL_ID'),
2989: fnd_profile.value('CONC_PROGRAM_ID'),
2990: fnd_profile.value('CONC_LOGIN_ID'),
2991: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
2992: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2993: sysdate,
2994: v_created_by,
2995: sysdate
3462: reqn_rec.line_num,
3463: reqn_rec.tax_category_id,
3464: v_dflt_tax_category_id,
3465: v_message,
3466: FND_GLOBAL.PROG_APPL_ID,
3467: FND_GLOBAL.CONC_PROGRAM_ID,
3468: FND_GLOBAL.CONC_LOGIN_ID,
3469: FND_GLOBAL.CONC_REQUEST_ID,
3470: /*fnd_profile.value('PROG_APPL_ID'),
3463: reqn_rec.tax_category_id,
3464: v_dflt_tax_category_id,
3465: v_message,
3466: FND_GLOBAL.PROG_APPL_ID,
3467: FND_GLOBAL.CONC_PROGRAM_ID,
3468: FND_GLOBAL.CONC_LOGIN_ID,
3469: FND_GLOBAL.CONC_REQUEST_ID,
3470: /*fnd_profile.value('PROG_APPL_ID'),
3471: fnd_profile.value('CONC_PROGRAM_ID'),
3464: v_dflt_tax_category_id,
3465: v_message,
3466: FND_GLOBAL.PROG_APPL_ID,
3467: FND_GLOBAL.CONC_PROGRAM_ID,
3468: FND_GLOBAL.CONC_LOGIN_ID,
3469: FND_GLOBAL.CONC_REQUEST_ID,
3470: /*fnd_profile.value('PROG_APPL_ID'),
3471: fnd_profile.value('CONC_PROGRAM_ID'),
3472: fnd_profile.value('CONC_LOGIN_ID'),
3465: v_message,
3466: FND_GLOBAL.PROG_APPL_ID,
3467: FND_GLOBAL.CONC_PROGRAM_ID,
3468: FND_GLOBAL.CONC_LOGIN_ID,
3469: FND_GLOBAL.CONC_REQUEST_ID,
3470: /*fnd_profile.value('PROG_APPL_ID'),
3471: fnd_profile.value('CONC_PROGRAM_ID'),
3472: fnd_profile.value('CONC_LOGIN_ID'),
3473: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
3469: FND_GLOBAL.CONC_REQUEST_ID,
3470: /*fnd_profile.value('PROG_APPL_ID'),
3471: fnd_profile.value('CONC_PROGRAM_ID'),
3472: fnd_profile.value('CONC_LOGIN_ID'),
3473: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
3474: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3475: sysdate,
3476: v_created_by,
3477: sysdate
3576: 'SO',
3577: so_rec.document_no,
3578: so_rec.line_number,
3579: so_rec.tax_category_id,
3580: FND_GLOBAL.PROG_APPL_ID,
3581: FND_GLOBAL.CONC_PROGRAM_ID,
3582: FND_GLOBAL.CONC_LOGIN_ID,
3583: FND_GLOBAL.CONC_REQUEST_ID,
3584: /*fnd_profile.value('PROG_APPL_ID'),
3577: so_rec.document_no,
3578: so_rec.line_number,
3579: so_rec.tax_category_id,
3580: FND_GLOBAL.PROG_APPL_ID,
3581: FND_GLOBAL.CONC_PROGRAM_ID,
3582: FND_GLOBAL.CONC_LOGIN_ID,
3583: FND_GLOBAL.CONC_REQUEST_ID,
3584: /*fnd_profile.value('PROG_APPL_ID'),
3585: fnd_profile.value('CONC_PROGRAM_ID'),
3578: so_rec.line_number,
3579: so_rec.tax_category_id,
3580: FND_GLOBAL.PROG_APPL_ID,
3581: FND_GLOBAL.CONC_PROGRAM_ID,
3582: FND_GLOBAL.CONC_LOGIN_ID,
3583: FND_GLOBAL.CONC_REQUEST_ID,
3584: /*fnd_profile.value('PROG_APPL_ID'),
3585: fnd_profile.value('CONC_PROGRAM_ID'),
3586: fnd_profile.value('CONC_LOGIN_ID'),
3579: so_rec.tax_category_id,
3580: FND_GLOBAL.PROG_APPL_ID,
3581: FND_GLOBAL.CONC_PROGRAM_ID,
3582: FND_GLOBAL.CONC_LOGIN_ID,
3583: FND_GLOBAL.CONC_REQUEST_ID,
3584: /*fnd_profile.value('PROG_APPL_ID'),
3585: fnd_profile.value('CONC_PROGRAM_ID'),
3586: fnd_profile.value('CONC_LOGIN_ID'),
3587: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
3583: FND_GLOBAL.CONC_REQUEST_ID,
3584: /*fnd_profile.value('PROG_APPL_ID'),
3585: fnd_profile.value('CONC_PROGRAM_ID'),
3586: fnd_profile.value('CONC_LOGIN_ID'),
3587: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
3588: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3589: sysdate,
3590: v_created_by,
3591: sysdate
4118: so_rec.line_number,
4119: so_rec.tax_category_id,
4120: v_dflt_tax_category_id,
4121: v_message,
4122: FND_GLOBAL.PROG_APPL_ID,
4123: FND_GLOBAL.CONC_PROGRAM_ID,
4124: FND_GLOBAL.CONC_LOGIN_ID,
4125: FND_GLOBAL.CONC_REQUEST_ID,
4126: /*fnd_profile.value('PROG_APPL_ID'),
4119: so_rec.tax_category_id,
4120: v_dflt_tax_category_id,
4121: v_message,
4122: FND_GLOBAL.PROG_APPL_ID,
4123: FND_GLOBAL.CONC_PROGRAM_ID,
4124: FND_GLOBAL.CONC_LOGIN_ID,
4125: FND_GLOBAL.CONC_REQUEST_ID,
4126: /*fnd_profile.value('PROG_APPL_ID'),
4127: fnd_profile.value('CONC_PROGRAM_ID'),
4120: v_dflt_tax_category_id,
4121: v_message,
4122: FND_GLOBAL.PROG_APPL_ID,
4123: FND_GLOBAL.CONC_PROGRAM_ID,
4124: FND_GLOBAL.CONC_LOGIN_ID,
4125: FND_GLOBAL.CONC_REQUEST_ID,
4126: /*fnd_profile.value('PROG_APPL_ID'),
4127: fnd_profile.value('CONC_PROGRAM_ID'),
4128: fnd_profile.value('CONC_LOGIN_ID'),
4121: v_message,
4122: FND_GLOBAL.PROG_APPL_ID,
4123: FND_GLOBAL.CONC_PROGRAM_ID,
4124: FND_GLOBAL.CONC_LOGIN_ID,
4125: FND_GLOBAL.CONC_REQUEST_ID,
4126: /*fnd_profile.value('PROG_APPL_ID'),
4127: fnd_profile.value('CONC_PROGRAM_ID'),
4128: fnd_profile.value('CONC_LOGIN_ID'),
4129: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
4125: FND_GLOBAL.CONC_REQUEST_ID,
4126: /*fnd_profile.value('PROG_APPL_ID'),
4127: fnd_profile.value('CONC_PROGRAM_ID'),
4128: fnd_profile.value('CONC_LOGIN_ID'),
4129: fnd_profile.value('CONC_REQUEST_ID') Replaced the call by fnd_global for bug # 9478377 */
4130: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
4131: sysdate,
4132: v_created_by,
4133: sysdate
4228: 'BOE',
4229: boe_rec.boe_id,
4230: boe_rec.boe_detail_id,
4231: boe_rec.tax_category_id,
4232: FND_GLOBAL.PROG_APPL_ID,
4233: FND_GLOBAL.CONC_PROGRAM_ID,
4234: FND_GLOBAL.CONC_LOGIN_ID,
4235: FND_GLOBAL.CONC_REQUEST_ID,
4236: v_created_by,
4229: boe_rec.boe_id,
4230: boe_rec.boe_detail_id,
4231: boe_rec.tax_category_id,
4232: FND_GLOBAL.PROG_APPL_ID,
4233: FND_GLOBAL.CONC_PROGRAM_ID,
4234: FND_GLOBAL.CONC_LOGIN_ID,
4235: FND_GLOBAL.CONC_REQUEST_ID,
4236: v_created_by,
4237: sysdate,
4230: boe_rec.boe_detail_id,
4231: boe_rec.tax_category_id,
4232: FND_GLOBAL.PROG_APPL_ID,
4233: FND_GLOBAL.CONC_PROGRAM_ID,
4234: FND_GLOBAL.CONC_LOGIN_ID,
4235: FND_GLOBAL.CONC_REQUEST_ID,
4236: v_created_by,
4237: sysdate,
4238: v_created_by,
4231: boe_rec.tax_category_id,
4232: FND_GLOBAL.PROG_APPL_ID,
4233: FND_GLOBAL.CONC_PROGRAM_ID,
4234: FND_GLOBAL.CONC_LOGIN_ID,
4235: FND_GLOBAL.CONC_REQUEST_ID,
4236: v_created_by,
4237: sysdate,
4238: v_created_by,
4239: sysdate
4671: boe_rec.line_number,
4672: boe_rec.tax_category_id,
4673: v_dflt_tax_category_id,
4674: v_message,
4675: FND_GLOBAL.PROG_APPL_ID,
4676: FND_GLOBAL.CONC_PROGRAM_ID,
4677: FND_GLOBAL.CONC_LOGIN_ID,
4678: FND_GLOBAL.CONC_REQUEST_ID,
4679: v_created_by,
4672: boe_rec.tax_category_id,
4673: v_dflt_tax_category_id,
4674: v_message,
4675: FND_GLOBAL.PROG_APPL_ID,
4676: FND_GLOBAL.CONC_PROGRAM_ID,
4677: FND_GLOBAL.CONC_LOGIN_ID,
4678: FND_GLOBAL.CONC_REQUEST_ID,
4679: v_created_by,
4680: sysdate,
4673: v_dflt_tax_category_id,
4674: v_message,
4675: FND_GLOBAL.PROG_APPL_ID,
4676: FND_GLOBAL.CONC_PROGRAM_ID,
4677: FND_GLOBAL.CONC_LOGIN_ID,
4678: FND_GLOBAL.CONC_REQUEST_ID,
4679: v_created_by,
4680: sysdate,
4681: v_created_by,
4674: v_message,
4675: FND_GLOBAL.PROG_APPL_ID,
4676: FND_GLOBAL.CONC_PROGRAM_ID,
4677: FND_GLOBAL.CONC_LOGIN_ID,
4678: FND_GLOBAL.CONC_REQUEST_ID,
4679: v_created_by,
4680: sysdate,
4681: v_created_by,
4682: sysdate