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 --
345: -- Set global package variables for the current import session
346:
347: g_xset_id := p_rec_set_id;
348:
349: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
350: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
351: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
352: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
353: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
346:
347: g_xset_id := p_rec_set_id;
348:
349: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
350: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
351: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
352: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
353: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
354:
347: g_xset_id := p_rec_set_id;
348:
349: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
350: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
351: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
352: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
353: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
354:
355: INV_ITEM_MSG.g_Table_Name := 'MTL_DESC_ELEM_VAL_INTERFACE';
348:
349: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
350: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
351: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
352: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
353: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
354:
355: INV_ITEM_MSG.g_Table_Name := 'MTL_DESC_ELEM_VAL_INTERFACE';
356:
349: g_User_id := NVL(p_user_id, FND_GLOBAL.user_id );
350: g_Login_id := NVL(p_login_id, FND_GLOBAL.login_id );
351: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
352: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
353: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
354:
355: INV_ITEM_MSG.g_Table_Name := 'MTL_DESC_ELEM_VAL_INTERFACE';
356:
357: INV_ITEM_MSG.g_User_id := g_User_id;