APPS.EGO_PUB_WS_VS dependencies on EGO_PUB_WS_ENTITIES

Line 322: FROM EGO_PUB_WS_ENTITIES

318:
319: CURSOR c_odi_end_vs(l_session_id NUMBER) IS
320: SELECT PK1_VALUE,
321: PK2_VALUE
322: FROM EGO_PUB_WS_ENTITIES
323: WHERE SESSION_ID = l_session_id
324: AND ENTITY_TYPE = 'VS'
325: AND NVL(USER_ENTERED, 'N') = 'N'
326: AND PARENT_SEQUENCE_ID IS NOT NULL

Line 403: FROM EGO_PUB_WS_ENTITIES EPWE

399: ,EPWE.ref1_value vs_name
400: ,EPWE.sequence_id sequence_id
401: ,VS_REL.value_set_id child_vs_id
402: ,FFVS.flex_value_set_name child_vs_name
403: FROM EGO_PUB_WS_ENTITIES EPWE
404: ,EGO_VALUE_SET_EXT VS_REL
405: ,FND_FLEX_VALUE_SETS FFVS
406: WHERE EPWE.session_id = p_session_id
407: AND EPWE.entity_type = G_ENTITY_TYPE_VS

Line 415: FROM EGO_PUB_WS_ENTITIES EPWE

411:
412: CURSOR cur_fetch_vs_frm_entity ( p_vs_id NUMBER)
413: IS
414: SELECT 1
415: FROM EGO_PUB_WS_ENTITIES EPWE
416: WHERE EPWE.session_id = p_session_id
417: AND EPWE.entity_type = G_ENTITY_TYPE_VS
418: AND EPWE.parent_sequence_id IS NULL
419: AND EPWE.pk1_value = p_vs_id

Line 483: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,

479: ELSE 'FALSE' END);
480:
481: IF NOT l_child_exists_in_entities THEN
482:
483: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,
484: ODI_SESSION_ID,
485: SEQUENCE_ID,
486: PARENT_SEQUENCE_ID,
487: ENTITY_TYPE,

Line 508: EGO_PUB_WS_ENTITIES_S.nextval,

504: CREATED_BY,
505: USER_ENTERED)
506: VALUES( p_session_id,
507: p_session_id,
508: EGO_PUB_WS_ENTITIES_S.nextval,
509: rec_get_vs_to_explode.sequence_id,
510: G_ENTITY_TYPE_VS,
511: rec_get_vs_to_explode.child_vs_id,
512: NULL,

Line 853: l_ref6_value ego_pub_ws_entities.ref6_value%TYPE;

849: IS
850: l_proc_name VARCHAR2(50) := 'Insert_Vs_Entity=>';
851: l_derived_vs_id NUMBER := NULL;
852: l_is_child BOOLEAN := FALSE;
853: l_ref6_value ego_pub_ws_entities.ref6_value%TYPE;
854: BEGIN
855:
856: -- if vs id exists in input table do not insert vs id
857: BEGIN

Line 860: FROM EGO_PUB_WS_ENTITIES epwe

856: -- if vs id exists in input table do not insert vs id
857: BEGIN
858: SELECT epwe.pk1_value
859: INTO l_derived_vs_id
860: FROM EGO_PUB_WS_ENTITIES epwe
861: WHERE epwe.pk1_value = p_vs_id
862: AND NVL(epwe.pk2_value, '-999') = NVL(p_vs_version, -999)
863: AND epwe.session_id = p_session_id
864: AND epwe.entity_type = G_ENTITY_TYPE_VS;

Line 884: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,

880: l_ref6_value := NULL;
881: END IF;
882:
883:
884: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,
885: ODI_SESSION_ID,
886: SEQUENCE_ID,
887: PARENT_SEQUENCE_ID,
888: ENTITY_TYPE,

Line 909: EGO_PUB_WS_ENTITIES_S.nextval,

905: CREATED_BY,
906: USER_ENTERED)
907: VALUES( p_session_id,
908: p_session_id,
909: EGO_PUB_WS_ENTITIES_S.nextval,
910: NULL,
911: G_ENTITY_TYPE_VS,
912: p_vs_id,
913: p_vs_version,

Line 1219: from EGO_PUB_WS_ENTITIES

1215:
1216:
1217: SELECT count(1)
1218: INTO l_entity_count
1219: from EGO_PUB_WS_ENTITIES
1220: WHERE session_id = p_session_id
1221: AND ENTITY_TYPE = G_ENTITY_TYPE_VS;
1222:
1223: IF l_entity_count = 0 THEN