[Home] [Help]
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,
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,
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,
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,
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
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,
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,
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,