APPS.INV_ITEM_CATEGORY_OI dependencies on FND_GLOBAL

Line 352: -- IF NVL(fnd_global.conc_program_id,-1) <> -1 THEN Bug:3547401

348: BEGIN
349:
350: --Start 2698140 : Gather stats before running
351: --When called through pub pacs, prog_id will be null or -1.
352: -- IF NVL(fnd_global.conc_program_id,-1) <> -1 THEN Bug:3547401
353: IF NVL(p_prog_id,-1) <> -1 THEN
354:
355: SELECT count(*) INTO l_records
356: FROM mtl_item_categories_interface

Line 407: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );

403: -- Set global package variables for the current import session
404:
405: g_xset_id := p_rec_set_id;
406:
407: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
408: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
409: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
410: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
411: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );

Line 408: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );

404:
405: g_xset_id := p_rec_set_id;
406:
407: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
408: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
409: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
410: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
411: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
412:

Line 409: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );

405: g_xset_id := p_rec_set_id;
406:
407: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
408: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
409: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
410: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
411: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
412:
413: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';

Line 410: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );

406:
407: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
408: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
409: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
410: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
411: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
412:
413: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';
414:

Line 411: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );

407: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
408: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
409: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
410: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
411: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
412:
413: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';
414:
415: INV_ITEM_MSG.g_User_id := g_User_id;