DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on FND_GLOBAL

Line 283: v_created_by NUMBER; -- := nvl(FND_GLOBAL.USER_ID,-1);

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 ***********

Line 284: v_login_id NUMBER; -- := nvl(FND_GLOBAL.LOGIN_ID,-1);

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;

Line 285: v_user_id NUMBER; -- := nvl(FND_GLOBAL.USER_ID,-1);

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:

Line 1258: v_created_by := nvl(FND_GLOBAL.USER_ID,-1);

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;

Line 1259: v_login_id := nvl(FND_GLOBAL.LOGIN_ID,-1);

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';

Line 1260: v_user_id := nvl(FND_GLOBAL.USER_ID,-1);

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';

Line 1433: FND_GLOBAL.PROG_APPL_ID,

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'),

Line 1434: FND_GLOBAL.CONC_PROGRAM_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'),

Line 1435: FND_GLOBAL.CONC_LOGIN_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'),

Line 1436: FND_GLOBAL.CONC_REQUEST_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 */

Line 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:

Line 1826: FND_GLOBAL.PROG_APPL_ID,

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'),

Line 1827: FND_GLOBAL.CONC_PROGRAM_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'),

Line 1828: FND_GLOBAL.CONC_LOGIN_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'),

Line 1829: FND_GLOBAL.CONC_REQUEST_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 */

Line 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

Line 2295: FND_GLOBAL.PROG_APPL_ID,

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'),

Line 2296: FND_GLOBAL.CONC_PROGRAM_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'),

Line 2297: FND_GLOBAL.CONC_LOGIN_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'),

Line 2298: FND_GLOBAL.CONC_REQUEST_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 */

Line 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

Line 2414: FND_GLOBAL.PROG_APPL_ID,

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'),

Line 2415: FND_GLOBAL.CONC_PROGRAM_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'),

Line 2416: FND_GLOBAL.CONC_LOGIN_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'),

Line 2417: FND_GLOBAL.CONC_REQUEST_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 */

Line 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

Line 2884: FND_GLOBAL.PROG_APPL_ID,

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'),

Line 2885: FND_GLOBAL.CONC_PROGRAM_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'),

Line 2886: FND_GLOBAL.CONC_LOGIN_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'),

Line 2887: FND_GLOBAL.CONC_REQUEST_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 */

Line 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

Line 2984: FND_GLOBAL.PROG_APPL_ID,

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'),

Line 2985: FND_GLOBAL.CONC_PROGRAM_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'),

Line 2986: FND_GLOBAL.CONC_LOGIN_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'),

Line 2987: FND_GLOBAL.CONC_REQUEST_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 */

Line 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

Line 3466: FND_GLOBAL.PROG_APPL_ID,

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'),

Line 3467: FND_GLOBAL.CONC_PROGRAM_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'),

Line 3468: FND_GLOBAL.CONC_LOGIN_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'),

Line 3469: FND_GLOBAL.CONC_REQUEST_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 */

Line 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

Line 3580: FND_GLOBAL.PROG_APPL_ID,

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'),

Line 3581: FND_GLOBAL.CONC_PROGRAM_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'),

Line 3582: FND_GLOBAL.CONC_LOGIN_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'),

Line 3583: FND_GLOBAL.CONC_REQUEST_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 */

Line 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

Line 4122: FND_GLOBAL.PROG_APPL_ID,

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'),

Line 4123: FND_GLOBAL.CONC_PROGRAM_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'),

Line 4124: FND_GLOBAL.CONC_LOGIN_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'),

Line 4125: FND_GLOBAL.CONC_REQUEST_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 */

Line 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

Line 4232: FND_GLOBAL.PROG_APPL_ID,

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,

Line 4233: FND_GLOBAL.CONC_PROGRAM_ID,

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,

Line 4234: FND_GLOBAL.CONC_LOGIN_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,
4238: v_created_by,

Line 4235: FND_GLOBAL.CONC_REQUEST_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,
4239: sysdate

Line 4675: FND_GLOBAL.PROG_APPL_ID,

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,

Line 4676: FND_GLOBAL.CONC_PROGRAM_ID,

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,

Line 4677: FND_GLOBAL.CONC_LOGIN_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,
4681: v_created_by,

Line 4678: FND_GLOBAL.CONC_REQUEST_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,
4682: sysdate