APPS.INV_ITEM_CATEGORY_OI dependencies on FND_GLOBAL

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

353: BEGIN
354:
355: --Start 2698140 : Gather stats before running
356: --When called through pub pacs, prog_id will be null or -1.
357: -- IF NVL(fnd_global.conc_program_id,-1) <> -1 THEN Bug:3547401
358: IF NVL(p_prog_id,-1) <> -1 AND p_gather_stats = 1 THEN /* p_gather_stats Added for Bug 8532728 */
359:
360: SELECT count(*) INTO l_records
361: FROM mtl_item_categories_interface

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

410: -- Set global package variables for the current import session
411:
412: g_xset_id := p_rec_set_id;
413:
414: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
415: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
416: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
417: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
418: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );

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

411:
412: g_xset_id := p_rec_set_id;
413:
414: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
415: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
416: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
417: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
418: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
419:

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

412: g_xset_id := p_rec_set_id;
413:
414: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
415: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
416: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
417: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
418: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
419:
420: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';

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

413:
414: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
415: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
416: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
417: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
418: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
419:
420: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';
421:

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

414: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
415: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
416: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
417: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
418: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
419:
420: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';
421:
422: INV_ITEM_MSG.g_User_id := g_User_id;