APPS.EGO_ITEM_WS_PVT dependencies on EGO_PUB_WS_INPUT_IDENTIFIERS

Line 2286: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

2282: EXCEPTION
2283:
2284: WHEN e_invalid_invocation_mode THEN
2285: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_input_id
2286: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
2287: WHERE session_id = p_session_id;
2288:
2289: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
2290: p_odi_session_id => p_odi_session_id,

Line 2297: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

2293: p_err_message => 'Invalid Invocation Mode, No valid details of Items to be published are given');
2294:
2295: WHEN e_no_org_details THEN
2296: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_input_id
2297: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
2298: WHERE session_id = p_session_id;
2299:
2300: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
2301: p_odi_session_id => p_odi_session_id,

Line 2308: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

2304: p_err_message => 'Organization details are not provided');
2305:
2306: WHEN e_no_rev_details THEN
2307: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_input_id
2308: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
2309: WHERE session_id = p_session_id;
2310:
2311: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
2312: p_odi_session_id => p_odi_session_id,

Line 2319: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

2315: p_err_message => 'Revision details are not provided');
2316:
2317: WHEN e_invalid_batch_id THEN
2318: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_input_id
2319: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
2320: WHERE session_id = p_session_id;
2321:
2322: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
2323: p_odi_session_id => p_odi_session_id,

Line 2456: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

2452: EXCEPTION
2453: WHEN No_Data_Found THEN
2454:
2455: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_index
2456: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
2457: WHERE session_id = p_session_id;
2458:
2459: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
2460: p_odi_session_id => p_odi_session_id,

Line 2483: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

2479: VALUES (p_session_id,p_odi_session_id,'LANGUAGE_CODE',2,NULL,l_lang_code_tab(i),NULL,SYSDATE,G_CURRENT_USER_ID);
2480: EXCEPTION
2481: WHEN NO_DATA_FOUND THEN
2482: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_index
2483: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
2484: WHERE session_id = p_session_id;
2485:
2486: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
2487: p_odi_session_id => p_odi_session_id,

Line 3217: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

3213:
3214: EXCEPTION
3215: WHEN No_Data_Found THEN
3216: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_index
3217: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
3218: WHERE session_id = p_session_id;
3219:
3220: -- Throw error : Attribute Id given is wrong.????? or will ignore the attribute
3221: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

Line 3248: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

3244:
3245: EXCEPTION
3246: WHEN No_Data_Found THEN
3247: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_index
3248: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
3249: WHERE session_id = p_session_id;
3250:
3251: -- Throw error : Attribute Id given is wrong.????? or will ignore the attribute
3252: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

Line 3358: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

3354:
3355: EXCEPTION
3356: WHEN No_Data_Found THEN
3357: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_index
3358: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
3359: WHERE session_id = p_session_id;
3360:
3361: -- Throw error : Attribute Id given is wrong.????? or will ignore the attribute
3362: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

Line 3405: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

3401:
3402: EXCEPTION
3403: WHEN No_Data_Found THEN
3404: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_index
3405: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
3406: WHERE session_id = p_session_id;
3407:
3408: -- Throw error : Attribute Id given is wrong.????? or will ignore the attribute
3409: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

Line 4637: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

4633:
4634: EXCEPTION
4635: WHEN No_Data_Found THEN
4636: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_index
4637: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
4638: WHERE session_id = p_session_id;
4639:
4640: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
4641: p_odi_session_id => p_odi_session_id,

Line 4650: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

4646:
4647: BEGIN
4648:
4649: SELECT PARAM_VALUE into v_org_code
4650: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
4651: WHERE SESSION_ID = p_session_id
4652: AND INPUT_ID = p_input_id
4653: AND PARAM_NAME = 'OrganizationCode';
4654:

Line 5086: DELETE EGO_PUB_WS_INPUT_IDENTIFIERS

5082: -- Bug 8776414: End
5083: exception
5084: when no_data_found then
5085: -- Bug 8776414 : Start
5086: DELETE EGO_PUB_WS_INPUT_IDENTIFIERS
5087: WHERE session_id = p_session_id;
5088:
5089: DELETE EGO_PUB_WS_ERRORS
5090: WHERE session_id = p_session_id;