[Home] [Help]
395: p_icc_ver_id_tab (num_of_records + 1) := p_icc_ver_id;
396: p_icc_name_tab (num_of_records + 1) := p_icc_name;
397:
398: /*In ego_pub_ws_entities, we are reusing the ref10_value column for storing show_error_flag*/
399: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,
400: ODI_SESSION_ID,
401: SEQUENCE_ID,
402: PARENT_SEQUENCE_ID,
403: ENTITY_TYPE,
420: CREATED_BY,
421: USER_ENTERED)
422: VALUES( p_session_id,
423: p_session_id,
424: EGO_PUB_WS_ENTITIES_S.nextval,
425: NULL,
426: G_ENTITY_TYPE_ICC,
427: p_icc_id,
428: p_icc_ver_id,
1533: /* Current AG record does not already exist in ego_pub_ws_entities table.
1534: So, insert a AG record and an AG-ICC association record into ego_pub_ws_entities table.*/
1535:
1536: -- get next value for the sequence_id
1537: SELECT EGO_PUB_WS_ENTITIES_S.nextval
1538: INTO l_seq_id
1539: FROM dual;
1540:
1541: --debug(L_PROC_NAME||'l_seq_id: '||l_seq_id||' ,rec_derived_ags.sequence_id: '||rec_derived_ags.sequence_id);
1539: FROM dual;
1540:
1541: --debug(L_PROC_NAME||'l_seq_id: '||l_seq_id||' ,rec_derived_ags.sequence_id: '||rec_derived_ags.sequence_id);
1542:
1543: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,
1544: ODI_SESSION_ID,
1545: SEQUENCE_ID,
1546: PARENT_SEQUENCE_ID,
1547: ENTITY_TYPE,
1587: G_CURRENT_USER_ID,
1588: G_USER_ENTERED_FLAG_NO
1589: );
1590:
1591: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,
1592: ODI_SESSION_ID,
1593: SEQUENCE_ID,
1594: PARENT_SEQUENCE_ID,
1595: ENTITY_TYPE,
1640:
1641: ELSE /* rec_derived_ags.ag_id l_prev_ag_id */
1642: /* Current AG already exists in ego_pub_ws_entities table,
1643: so insert only the AG-ICC assocation record*/
1644: INSERT INTO EGO_PUB_WS_ENTITIES(SESSION_ID,
1645: ODI_SESSION_ID,
1646: SEQUENCE_ID,
1647: PARENT_SEQUENCE_ID,
1648: ENTITY_TYPE,