212: l_event_name := 'oracle.apps.igs.sv.ni.submit';
213: l_trans_subtype :='SEVISO';
214: END IF;
215:
216: --SELECT FND_GLOBAL.CONC_REQUEST_ID INTO l_con_req_id FROM DUAL;
217:
218: l_con_req_id := FND_GLOBAL.CONC_REQUEST_ID;
219:
220: OPEN c_party_data;
214: END IF;
215:
216: --SELECT FND_GLOBAL.CONC_REQUEST_ID INTO l_con_req_id FROM DUAL;
217:
218: l_con_req_id := FND_GLOBAL.CONC_REQUEST_ID;
219:
220: OPEN c_party_data;
221: FETCH c_party_data INTO l_party_id, l_party_site_id;
222: CLOSE c_party_data;
11698: g_debug_level := 1;
11699:
11700: END IF;
11701:
11702: g_update_login := FND_GLOBAL.LOGIN_ID;
11703: g_update_by := FND_GLOBAL.USER_ID;
11704:
11705: OPEN c_submiter_id;
11706: FETCH c_submiter_id
11699:
11700: END IF;
11701:
11702: g_update_login := FND_GLOBAL.LOGIN_ID;
11703: g_update_by := FND_GLOBAL.USER_ID;
11704:
11705: OPEN c_submiter_id;
11706: FETCH c_submiter_id
11707: INTO l_submiter_id;