1079: SYSDATE,
1080: v_created_by,/* Aiyer for the bug 4565665. Added the columns last_update_date and last_updated_by */
1081: SYSDATE,
1082: v_created_by,
1083: fnd_profile.value('PROG_APPL_ID'),
1084: fnd_profile.value('CONC_PROGRAM_ID'),
1085: fnd_profile.value('CONC_LOGIN_ID'),
1086: fnd_profile.value('CONC_REQUEST_ID')
1087: )returning batch_id into v_batch_id; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1080: v_created_by,/* Aiyer for the bug 4565665. Added the columns last_update_date and last_updated_by */
1081: SYSDATE,
1082: v_created_by,
1083: fnd_profile.value('PROG_APPL_ID'),
1084: fnd_profile.value('CONC_PROGRAM_ID'),
1085: fnd_profile.value('CONC_LOGIN_ID'),
1086: fnd_profile.value('CONC_REQUEST_ID')
1087: )returning batch_id into v_batch_id; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1088:
1081: SYSDATE,
1082: v_created_by,
1083: fnd_profile.value('PROG_APPL_ID'),
1084: fnd_profile.value('CONC_PROGRAM_ID'),
1085: fnd_profile.value('CONC_LOGIN_ID'),
1086: fnd_profile.value('CONC_REQUEST_ID')
1087: )returning batch_id into v_batch_id; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1088:
1089: COMMIT;
1082: v_created_by,
1083: fnd_profile.value('PROG_APPL_ID'),
1084: fnd_profile.value('CONC_PROGRAM_ID'),
1085: fnd_profile.value('CONC_LOGIN_ID'),
1086: fnd_profile.value('CONC_REQUEST_ID')
1087: )returning batch_id into v_batch_id; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1088:
1089: COMMIT;
1090:
1423: shipment_rec.document_no,
1424: shipment_rec.line_num,
1425: shipment_rec.shipment_num,
1426: shipment_rec.tax_category_id,
1427: fnd_profile.value('PROG_APPL_ID'),
1428: fnd_profile.value('CONC_PROGRAM_ID'),
1429: fnd_profile.value('CONC_LOGIN_ID'),
1430: fnd_profile.value('CONC_REQUEST_ID'),
1431: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1424: shipment_rec.line_num,
1425: shipment_rec.shipment_num,
1426: shipment_rec.tax_category_id,
1427: fnd_profile.value('PROG_APPL_ID'),
1428: fnd_profile.value('CONC_PROGRAM_ID'),
1429: fnd_profile.value('CONC_LOGIN_ID'),
1430: fnd_profile.value('CONC_REQUEST_ID'),
1431: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1432: sysdate,
1425: shipment_rec.shipment_num,
1426: shipment_rec.tax_category_id,
1427: fnd_profile.value('PROG_APPL_ID'),
1428: fnd_profile.value('CONC_PROGRAM_ID'),
1429: fnd_profile.value('CONC_LOGIN_ID'),
1430: fnd_profile.value('CONC_REQUEST_ID'),
1431: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1432: sysdate,
1433: v_created_by,
1426: shipment_rec.tax_category_id,
1427: fnd_profile.value('PROG_APPL_ID'),
1428: fnd_profile.value('CONC_PROGRAM_ID'),
1429: fnd_profile.value('CONC_LOGIN_ID'),
1430: fnd_profile.value('CONC_REQUEST_ID'),
1431: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1432: sysdate,
1433: v_created_by,
1434: sysdate
1872: shipment_rec.shipment_num,
1873: shipment_rec.tax_category_id,
1874: v_dflt_tax_category_id,
1875: v_message,
1876: fnd_profile.value('PROG_APPL_ID'),
1877: fnd_profile.value('CONC_PROGRAM_ID'),
1878: fnd_profile.value('CONC_LOGIN_ID'),
1879: fnd_profile.value('CONC_REQUEST_ID'),
1880: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1873: shipment_rec.tax_category_id,
1874: v_dflt_tax_category_id,
1875: v_message,
1876: fnd_profile.value('PROG_APPL_ID'),
1877: fnd_profile.value('CONC_PROGRAM_ID'),
1878: fnd_profile.value('CONC_LOGIN_ID'),
1879: fnd_profile.value('CONC_REQUEST_ID'),
1880: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1881: sysdate,
1874: v_dflt_tax_category_id,
1875: v_message,
1876: fnd_profile.value('PROG_APPL_ID'),
1877: fnd_profile.value('CONC_PROGRAM_ID'),
1878: fnd_profile.value('CONC_LOGIN_ID'),
1879: fnd_profile.value('CONC_REQUEST_ID'),
1880: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1881: sysdate,
1882: v_created_by,
1875: v_message,
1876: fnd_profile.value('PROG_APPL_ID'),
1877: fnd_profile.value('CONC_PROGRAM_ID'),
1878: fnd_profile.value('CONC_LOGIN_ID'),
1879: fnd_profile.value('CONC_REQUEST_ID'),
1880: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1881: sysdate,
1882: v_created_by,
1883: sysdate
1986: releases_rec.release_num,
1987: releases_rec.line_num,
1988: releases_rec.shipment_num,
1989: releases_rec.tax_category_id,
1990: fnd_profile.value('PROG_APPL_ID'),
1991: fnd_profile.value('CONC_PROGRAM_ID'),
1992: fnd_profile.value('CONC_LOGIN_ID'),
1993: fnd_profile.value('CONC_REQUEST_ID'),
1994: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1987: releases_rec.line_num,
1988: releases_rec.shipment_num,
1989: releases_rec.tax_category_id,
1990: fnd_profile.value('PROG_APPL_ID'),
1991: fnd_profile.value('CONC_PROGRAM_ID'),
1992: fnd_profile.value('CONC_LOGIN_ID'),
1993: fnd_profile.value('CONC_REQUEST_ID'),
1994: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1995: sysdate,
1988: releases_rec.shipment_num,
1989: releases_rec.tax_category_id,
1990: fnd_profile.value('PROG_APPL_ID'),
1991: fnd_profile.value('CONC_PROGRAM_ID'),
1992: fnd_profile.value('CONC_LOGIN_ID'),
1993: fnd_profile.value('CONC_REQUEST_ID'),
1994: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1995: sysdate,
1996: v_created_by,
1989: releases_rec.tax_category_id,
1990: fnd_profile.value('PROG_APPL_ID'),
1991: fnd_profile.value('CONC_PROGRAM_ID'),
1992: fnd_profile.value('CONC_LOGIN_ID'),
1993: fnd_profile.value('CONC_REQUEST_ID'),
1994: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
1995: sysdate,
1996: v_created_by,
1997: sysdate
2435: releases_rec.shipment_num,
2436: releases_rec.tax_category_id,
2437: v_dflt_tax_category_id,
2438: v_message,
2439: fnd_profile.value('PROG_APPL_ID'),
2440: fnd_profile.value('CONC_PROGRAM_ID'),
2441: fnd_profile.value('CONC_LOGIN_ID'),
2442: fnd_profile.value('CONC_REQUEST_ID'),
2443: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2436: releases_rec.tax_category_id,
2437: v_dflt_tax_category_id,
2438: v_message,
2439: fnd_profile.value('PROG_APPL_ID'),
2440: fnd_profile.value('CONC_PROGRAM_ID'),
2441: fnd_profile.value('CONC_LOGIN_ID'),
2442: fnd_profile.value('CONC_REQUEST_ID'),
2443: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2444: sysdate,
2437: v_dflt_tax_category_id,
2438: v_message,
2439: fnd_profile.value('PROG_APPL_ID'),
2440: fnd_profile.value('CONC_PROGRAM_ID'),
2441: fnd_profile.value('CONC_LOGIN_ID'),
2442: fnd_profile.value('CONC_REQUEST_ID'),
2443: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2444: sysdate,
2445: v_created_by,
2438: v_message,
2439: fnd_profile.value('PROG_APPL_ID'),
2440: fnd_profile.value('CONC_PROGRAM_ID'),
2441: fnd_profile.value('CONC_LOGIN_ID'),
2442: fnd_profile.value('CONC_REQUEST_ID'),
2443: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2444: sysdate,
2445: v_created_by,
2446: sysdate
2530: reqn_rec.type_lookup_code,
2531: reqn_rec.document_no,
2532: reqn_rec.line_num,
2533: reqn_rec.tax_category_id,
2534: fnd_profile.value('PROG_APPL_ID'),
2535: fnd_profile.value('CONC_PROGRAM_ID'),
2536: fnd_profile.value('CONC_LOGIN_ID'),
2537: fnd_profile.value('CONC_REQUEST_ID'),
2538: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2531: reqn_rec.document_no,
2532: reqn_rec.line_num,
2533: reqn_rec.tax_category_id,
2534: fnd_profile.value('PROG_APPL_ID'),
2535: fnd_profile.value('CONC_PROGRAM_ID'),
2536: fnd_profile.value('CONC_LOGIN_ID'),
2537: fnd_profile.value('CONC_REQUEST_ID'),
2538: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2539: sysdate,
2532: reqn_rec.line_num,
2533: reqn_rec.tax_category_id,
2534: fnd_profile.value('PROG_APPL_ID'),
2535: fnd_profile.value('CONC_PROGRAM_ID'),
2536: fnd_profile.value('CONC_LOGIN_ID'),
2537: fnd_profile.value('CONC_REQUEST_ID'),
2538: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2539: sysdate,
2540: v_created_by,
2533: reqn_rec.tax_category_id,
2534: fnd_profile.value('PROG_APPL_ID'),
2535: fnd_profile.value('CONC_PROGRAM_ID'),
2536: fnd_profile.value('CONC_LOGIN_ID'),
2537: fnd_profile.value('CONC_REQUEST_ID'),
2538: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2539: sysdate,
2540: v_created_by,
2541: sysdate
2993: reqn_rec.line_num,
2994: reqn_rec.tax_category_id,
2995: v_dflt_tax_category_id,
2996: v_message,
2997: fnd_profile.value('PROG_APPL_ID'),
2998: fnd_profile.value('CONC_PROGRAM_ID'),
2999: fnd_profile.value('CONC_LOGIN_ID'),
3000: fnd_profile.value('CONC_REQUEST_ID'),
3001: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
2994: reqn_rec.tax_category_id,
2995: v_dflt_tax_category_id,
2996: v_message,
2997: fnd_profile.value('PROG_APPL_ID'),
2998: fnd_profile.value('CONC_PROGRAM_ID'),
2999: fnd_profile.value('CONC_LOGIN_ID'),
3000: fnd_profile.value('CONC_REQUEST_ID'),
3001: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3002: sysdate,
2995: v_dflt_tax_category_id,
2996: v_message,
2997: fnd_profile.value('PROG_APPL_ID'),
2998: fnd_profile.value('CONC_PROGRAM_ID'),
2999: fnd_profile.value('CONC_LOGIN_ID'),
3000: fnd_profile.value('CONC_REQUEST_ID'),
3001: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3002: sysdate,
3003: v_created_by,
2996: v_message,
2997: fnd_profile.value('PROG_APPL_ID'),
2998: fnd_profile.value('CONC_PROGRAM_ID'),
2999: fnd_profile.value('CONC_LOGIN_ID'),
3000: fnd_profile.value('CONC_REQUEST_ID'),
3001: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3002: sysdate,
3003: v_created_by,
3004: sysdate
3102: 'SO',
3103: so_rec.document_no,
3104: so_rec.line_number,
3105: so_rec.tax_category_id,
3106: fnd_profile.value('PROG_APPL_ID'),
3107: fnd_profile.value('CONC_PROGRAM_ID'),
3108: fnd_profile.value('CONC_LOGIN_ID'),
3109: fnd_profile.value('CONC_REQUEST_ID'),
3110: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3103: so_rec.document_no,
3104: so_rec.line_number,
3105: so_rec.tax_category_id,
3106: fnd_profile.value('PROG_APPL_ID'),
3107: fnd_profile.value('CONC_PROGRAM_ID'),
3108: fnd_profile.value('CONC_LOGIN_ID'),
3109: fnd_profile.value('CONC_REQUEST_ID'),
3110: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3111: sysdate,
3104: so_rec.line_number,
3105: so_rec.tax_category_id,
3106: fnd_profile.value('PROG_APPL_ID'),
3107: fnd_profile.value('CONC_PROGRAM_ID'),
3108: fnd_profile.value('CONC_LOGIN_ID'),
3109: fnd_profile.value('CONC_REQUEST_ID'),
3110: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3111: sysdate,
3112: v_created_by,
3105: so_rec.tax_category_id,
3106: fnd_profile.value('PROG_APPL_ID'),
3107: fnd_profile.value('CONC_PROGRAM_ID'),
3108: fnd_profile.value('CONC_LOGIN_ID'),
3109: fnd_profile.value('CONC_REQUEST_ID'),
3110: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3111: sysdate,
3112: v_created_by,
3113: sysdate
3529: so_rec.line_number,
3530: so_rec.tax_category_id,
3531: v_dflt_tax_category_id,
3532: v_message,
3533: fnd_profile.value('PROG_APPL_ID'),
3534: fnd_profile.value('CONC_PROGRAM_ID'),
3535: fnd_profile.value('CONC_LOGIN_ID'),
3536: fnd_profile.value('CONC_REQUEST_ID'),
3537: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3530: so_rec.tax_category_id,
3531: v_dflt_tax_category_id,
3532: v_message,
3533: fnd_profile.value('PROG_APPL_ID'),
3534: fnd_profile.value('CONC_PROGRAM_ID'),
3535: fnd_profile.value('CONC_LOGIN_ID'),
3536: fnd_profile.value('CONC_REQUEST_ID'),
3537: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3538: sysdate,
3531: v_dflt_tax_category_id,
3532: v_message,
3533: fnd_profile.value('PROG_APPL_ID'),
3534: fnd_profile.value('CONC_PROGRAM_ID'),
3535: fnd_profile.value('CONC_LOGIN_ID'),
3536: fnd_profile.value('CONC_REQUEST_ID'),
3537: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3538: sysdate,
3539: v_created_by,
3532: v_message,
3533: fnd_profile.value('PROG_APPL_ID'),
3534: fnd_profile.value('CONC_PROGRAM_ID'),
3535: fnd_profile.value('CONC_LOGIN_ID'),
3536: fnd_profile.value('CONC_REQUEST_ID'),
3537: v_created_by,/* Aiyer for the bug 4565665. Added the who columns */
3538: sysdate,
3539: v_created_by,
3540: sysdate