APPS.EGO_ODI_PUB dependencies on EGO_PUB_WS_INPUT_IDENTIFIERS

Line 386: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

382:
383: --dbms_output.put_line(' Error : Invalid Organization Details ');
384:
385: SELECT Nvl(Max(INPUT_ID),0) + 1 into l_index
386: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
387: WHERE session_id = p_session_id;
388:
389: IF (l_ag_id IS NOT NULL) THEN
390:

Line 481: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

477:
478: --dbms_output.put_line(' Error : Invalid Revision Details ');
479:
480: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_index
481: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
482: WHERE session_id = p_session_id;
483:
484: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
485: p_odi_session_id => p_odi_session_id,

Line 564: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

560:
561: --dbms_output.put_line(' Error : Invalid Revision Details ');
562:
563: /*SELECT Nvl(Max(INPUT_ID),0) + 1 into p_index
564: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
565: WHERE session_id = p_session_id;*/
566:
567: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
568: p_odi_session_id => p_odi_session_id,

Line 619: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

615: WHEN No_Data_Found THEN
616: --dbms_output.put_line(' Error : Invalid Revision Details ');
617:
618: SELECT Nvl(Max(INPUT_ID),0) + 1 into l_index
619: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
620: WHERE session_id = p_session_id;
621:
622: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
623: p_odi_session_id => p_odi_session_id,

Line 673: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

669: WHEN No_Data_Found THEN
670: --dbms_output.put_line(' Error : Invalid Revision Details ');
671:
672: SELECT Nvl(Max(INPUT_ID),0) + 1 into l_index
673: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
674: WHERE session_id = p_session_id;
675:
676: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
677: p_odi_session_id => p_odi_session_id,

Line 727: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

723: WHEN No_Data_Found THEN
724: --dbms_output.put_line(' Error : Invalid Revision Details ');
725:
726: SELECT Nvl(Max(INPUT_ID),0) + 1 into l_index
727: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
728: WHERE session_id = p_session_id;
729:
730: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
731: p_odi_session_id => p_odi_session_id,

Line 796: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

792: WHEN No_Data_Found THEN
793: --dbms_output.put_line(' Error : Invalid Language Code ');
794:
795: SELECT Nvl(Max(INPUT_ID),0) + 1 into l_index
796: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
797: WHERE session_id = p_session_id;
798:
799:
800: IF l_temp IS NOT NULL THEN

Line 5330: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

5326: cp_odi_session_id NUMBER,
5327: cp_input_id NUMBER)
5328: IS
5329: SELECT session_id, param_name,param_value
5330: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
5331: WHERE session_id=cp_session_id
5332: AND odi_session_id= cp_odi_session_id
5333: AND input_id=cp_input_id;
5334:

Line 7089: INSERT INTO EGO_PUB_WS_INPUT_IDENTIFIERS(session_id,

7085: IS
7086:
7087: BEGIN
7088:
7089: INSERT INTO EGO_PUB_WS_INPUT_IDENTIFIERS(session_id,
7090: odi_session_id,
7091: input_id,
7092: param_name,
7093: param_value,

Line 7212: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

7208: CURSOR cur_input_id(cp_session_id NUMBER,
7209: cp_odi_session_id NUMBER)
7210: IS
7211: SELECT (Nvl(Max(input_id),0)+1) AS input_id
7212: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
7213: WHERE session_id=cp_session_id
7214: AND odi_session_id= cp_odi_session_id;
7215:
7216: BEGIN