eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_PUB_WS_AG dependencies on EGO_PUB_WS_ENTITIES

Line 465: FROM EGO_PUB_WS_ENTITIES

461: -- if ag id exists in input table do not insert ag id
462: BEGIN
463: SELECT pk1_value
464: INTO l_attr_grp_id
465: FROM EGO_PUB_WS_ENTITIES
466: WHERE pk1_value = l_agrp_id
467: AND session_id = p_session_id;
468: EXCEPTION
469: WHEN No_Data_Found THEN

Line 478: SELECT EGO_PUB_WS_ENTITIES_S.nextval

474:
475: IF l_attr_grp_id IS NULL THEN
476:
477: -- get next value for the sequence_id
478: SELECT EGO_PUB_WS_ENTITIES_S.nextval
479: INTO l_seq_id
480: FROM dual;
481:
482: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,

Line 482: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,

478: SELECT EGO_PUB_WS_ENTITIES_S.nextval
479: INTO l_seq_id
480: FROM dual;
481:
482: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,
483: ODI_SESSION_ID,
484: SEQUENCE_ID,
485: PARENT_SEQUENCE_ID,
486: ENTITY_TYPE,

Line 609: FROM EGO_PUB_WS_ENTITIES

605: -- if ag id exists in input table do not insert ag id
606: BEGIN
607: SELECT pk1_value
608: INTO l_attr_grp_id
609: FROM EGO_PUB_WS_ENTITIES
610: WHERE pk1_value = l_ag_id
611: AND session_id = p_session_id;
612: EXCEPTION
613: WHEN No_Data_Found THEN

Line 621: SELECT EGO_PUB_WS_ENTITIES_S.nextval

617: END;
618: IF l_attr_grp_id IS NULL THEN
619:
620: -- get next value for the sequence_id
621: SELECT EGO_PUB_WS_ENTITIES_S.nextval
622: INTO l_seq_id
623: FROM dual;
624:
625: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,

Line 625: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,

621: SELECT EGO_PUB_WS_ENTITIES_S.nextval
622: INTO l_seq_id
623: FROM dual;
624:
625: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,
626: ODI_SESSION_ID,
627: SEQUENCE_ID,
628: PARENT_SEQUENCE_ID,
629: ENTITY_TYPE,

Line 725: l_ref6_value EGO_PUB_WS_ENTITIES.REF6_VALUE%TYPE;

721:
722: --valuesets information
723:
724: l_is_child BOOLEAN := FALSE;
725: l_ref6_value EGO_PUB_WS_ENTITIES.REF6_VALUE%TYPE;
726:
727: l_vs_id NUMBER;
728: l_vs_seq_id NUMBER;
729: l_application_col_name VARCHAR2(150);

Line 752: FROM EGO_PUB_WS_ENTITIES

748: SELECT SESSION_ID,
749: SEQUENCE_ID,
750: PK1_VALUE,
751: REF1_VALUE
752: FROM EGO_PUB_WS_ENTITIES
753: WHERE SESSION_ID = p_session_id
754: AND ENTITY_TYPE = G_ENTITY_TYPE_AG
755: AND PARENT_SEQUENCE_ID IS NULL;
756:

Line 792: --from EGO_PUB_WS_ENTITIES table.

788: EGO_PUB_WS_UTIL.Init_Security(p_session_id, l_web_service_name);
789:
790: --Check on the sync privilege for the end-attributegroup.
791: --If end-attributegroup has no sync privilege, then remove end-attributegroup
792: --from EGO_PUB_WS_ENTITIES table.
793: --trudave - as the SYNC privilege is not yet defined, commenting following call
794: /* check_end_ag_security(p_session_id => p_session_id,
795: p_odi_session_id => p_odi_session_id,
796: p_priv_check => 'EGO_SYNC_AG',

Line 826: -- check whether the valueset exists in EGO_PUB_WS_ENTITIES

822: l_valueset_name := s.flex_value_set_name; -- VS_P2PS_1
823: l_application_col_name := s.application_column_name; -- N_EXT_ATTR2
824: l_attr_id := s.attr_id; -- 3415
825:
826: -- check whether the valueset exists in EGO_PUB_WS_ENTITIES
827: BEGIN
828: SELECT PK1_VALUE, SEQUENCE_ID, REF1_VALUE
829: INTO l_vs_id, l_vs_seq_id, l_vs_name
830: FROM EGO_PUB_WS_ENTITIES

Line 830: FROM EGO_PUB_WS_ENTITIES

826: -- check whether the valueset exists in EGO_PUB_WS_ENTITIES
827: BEGIN
828: SELECT PK1_VALUE, SEQUENCE_ID, REF1_VALUE
829: INTO l_vs_id, l_vs_seq_id, l_vs_name
830: FROM EGO_PUB_WS_ENTITIES
831: WHERE SESSION_ID = p_session_id
832: AND ENTITY_TYPE = G_ENTITY_TYPE_VS
833: AND PK1_VALUE = l_valueset_id
834: AND PARENT_SEQUENCE_ID IS NULL;

Line 857: SELECT EGO_PUB_WS_ENTITIES_S.nextval

853: END IF;
854:
855:
856: -- get next value for the sequence_id
857: SELECT EGO_PUB_WS_ENTITIES_S.nextval
858: INTO l_seq_id
859: FROM dual;
860:
861: -- as value set does not exist in input table, insert value set record and

Line 864: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,

860:
861: -- as value set does not exist in input table, insert value set record and
862: -- insert its association to attribute group
863:
864: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,
865: ODI_SESSION_ID,
866: SEQUENCE_ID,
867: PARENT_SEQUENCE_ID,
868: ENTITY_TYPE,

Line 912: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,

908: 0,
909: 'N'
910: );
911:
912: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,
913: ODI_SESSION_ID,
914: SEQUENCE_ID,
915: PARENT_SEQUENCE_ID,
916: ENTITY_TYPE,

Line 964: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,

960: END IF;
961:
962: IF l_vs_id IS NOT NULL THEN
963:
964: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,
965: ODI_SESSION_ID,
966: SEQUENCE_ID,
967: PARENT_SEQUENCE_ID,
968: ENTITY_TYPE,

Line 1057: FROM EGO_PUB_WS_ENTITIES

1053:
1054: CURSOR c_odi_end_vs(l_session_id NUMBER) IS
1055: SELECT PK1_VALUE,
1056: PK2_VALUE
1057: FROM EGO_PUB_WS_ENTITIES
1058: WHERE SESSION_ID = l_session_id
1059: AND ENTITY_TYPE = G_ENTITY_TYPE_VS
1060: AND NVL(USER_ENTERED, 'N') = 'N'
1061: AND PARENT_SEQUENCE_ID IS NULL;

Line 1159: FROM EGO_PUB_WS_ENTITIES

1155: -- create input entities for the session.
1156:
1157: SELECT COUNT(1)
1158: INTO l_entity_rec_count
1159: FROM EGO_PUB_WS_ENTITIES
1160: WHERE SESSION_ID = p_session_id
1161: AND ENTITY_TYPE = G_ENTITY_TYPE_AG;
1162:
1163: IF l_entity_rec_count = 0 THEN