88: -- Set global package variables for the current import session
89:
90: INV_ITEM_MSG.g_Table_Name := 'p_item_desc_element_table';
91:
92: INV_ITEM_MSG.g_User_id := FND_GLOBAL.user_id ;
93: INV_ITEM_MSG.g_Login_id := FND_GLOBAL.login_id ;
94: INV_ITEM_MSG.g_Prog_appid := FND_GLOBAL.prog_appl_id ;
95: INV_ITEM_MSG.g_Prog_id := FND_GLOBAL.conc_program_id;
96: INV_ITEM_MSG.g_Request_id := FND_GLOBAL.conc_request_id;
89:
90: INV_ITEM_MSG.g_Table_Name := 'p_item_desc_element_table';
91:
92: INV_ITEM_MSG.g_User_id := FND_GLOBAL.user_id ;
93: INV_ITEM_MSG.g_Login_id := FND_GLOBAL.login_id ;
94: INV_ITEM_MSG.g_Prog_appid := FND_GLOBAL.prog_appl_id ;
95: INV_ITEM_MSG.g_Prog_id := FND_GLOBAL.conc_program_id;
96: INV_ITEM_MSG.g_Request_id := FND_GLOBAL.conc_request_id;
97:
90: INV_ITEM_MSG.g_Table_Name := 'p_item_desc_element_table';
91:
92: INV_ITEM_MSG.g_User_id := FND_GLOBAL.user_id ;
93: INV_ITEM_MSG.g_Login_id := FND_GLOBAL.login_id ;
94: INV_ITEM_MSG.g_Prog_appid := FND_GLOBAL.prog_appl_id ;
95: INV_ITEM_MSG.g_Prog_id := FND_GLOBAL.conc_program_id;
96: INV_ITEM_MSG.g_Request_id := FND_GLOBAL.conc_request_id;
97:
98: x_return_status := fnd_api.g_RET_STS_SUCCESS;
91:
92: INV_ITEM_MSG.g_User_id := FND_GLOBAL.user_id ;
93: INV_ITEM_MSG.g_Login_id := FND_GLOBAL.login_id ;
94: INV_ITEM_MSG.g_Prog_appid := FND_GLOBAL.prog_appl_id ;
95: INV_ITEM_MSG.g_Prog_id := FND_GLOBAL.conc_program_id;
96: INV_ITEM_MSG.g_Request_id := FND_GLOBAL.conc_request_id;
97:
98: x_return_status := fnd_api.g_RET_STS_SUCCESS;
99: ------------------------------------------------------------------------------------------
92: INV_ITEM_MSG.g_User_id := FND_GLOBAL.user_id ;
93: INV_ITEM_MSG.g_Login_id := FND_GLOBAL.login_id ;
94: INV_ITEM_MSG.g_Prog_appid := FND_GLOBAL.prog_appl_id ;
95: INV_ITEM_MSG.g_Prog_id := FND_GLOBAL.conc_program_id;
96: INV_ITEM_MSG.g_Request_id := FND_GLOBAL.conc_request_id;
97:
98: x_return_status := fnd_api.g_RET_STS_SUCCESS;
99: ------------------------------------------------------------------------------------------
100: -- Process step 1: Loop through item catlog group elements interface records --
347: -- Set global package variables for the current import session
348:
349: g_xset_id := p_rec_set_id;
350:
351: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
352: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
353: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
354: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
355: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
348:
349: g_xset_id := p_rec_set_id;
350:
351: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
352: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
353: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
354: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
355: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
356:
349: g_xset_id := p_rec_set_id;
350:
351: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
352: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
353: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
354: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
355: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
356:
357: INV_ITEM_MSG.g_Table_Name := 'MTL_DESC_ELEM_VAL_INTERFACE';
350:
351: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
352: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
353: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
354: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
355: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
356:
357: INV_ITEM_MSG.g_Table_Name := 'MTL_DESC_ELEM_VAL_INTERFACE';
358:
351: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
352: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
353: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
354: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
355: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
356:
357: INV_ITEM_MSG.g_Table_Name := 'MTL_DESC_ELEM_VAL_INTERFACE';
358:
359: INV_ITEM_MSG.g_User_id := g_User_id;