[Home] [Help]
1806:
1807: /*changing the below select statement to use the base table instead of view.
1808: Using an NVL on pk2_value since it can be null for AG and VS but not ICC
1809: kkq- do we really need below select stmt, since
1810: ego_pub_ws_entities will initially have the same records as ego_pub_bat_ent_objs_b (user_entered=Y)
1811: and as we derive new entity records (user_entered=N), we do not insert them into ego_pub_ws_entities
1812: if they are already present. We can safely assume that all records fetched by cursor c_derived_entities
1813: will not be present in ego_pub_bat_ent_objs_b.*/
1814:
1809: kkq- do we really need below select stmt, since
1810: ego_pub_ws_entities will initially have the same records as ego_pub_bat_ent_objs_b (user_entered=Y)
1811: and as we derive new entity records (user_entered=N), we do not insert them into ego_pub_ws_entities
1812: if they are already present. We can safely assume that all records fetched by cursor c_derived_entities
1813: will not be present in ego_pub_bat_ent_objs_b.*/
1814:
1815: SELECT COUNT(*) INTO v_count
1816: FROM EGO_PUB_BAT_ENT_OBJS_B
1817: WHERE BATCH_ID = l_batch_id
1812: if they are already present. We can safely assume that all records fetched by cursor c_derived_entities
1813: will not be present in ego_pub_bat_ent_objs_b.*/
1814:
1815: SELECT COUNT(*) INTO v_count
1816: FROM EGO_PUB_BAT_ENT_OBJS_B
1817: WHERE BATCH_ID = l_batch_id
1818: AND entity_type_id = l_entity_type_id
1819: AND PK1_VALUE = k.pk1_value
1820: AND NVL(PK2_VALUE,-999) = NVL(k.pk2_value,-999);
1865: -- 2. Calls Create_Entities_ICC procedure, to populate ODI input table EGO_PUB_WS_ENTITIES
1866: -- for entity ICC, based on the invokation type (e.g. batch, list)
1867: -- 3. Calls Explode_ICC procedure to explode the ICCs and populate AGs into EGO_PUB_WS_ENTITIES
1868: -- 4. In Batch Mode flow, calls Write_Derived_Entites_ToBatFwk procedure to
1869: -- add the derived entities (ICCs,AGs) to Batch Fwk Entities table - EGO_PUB_BAT_ENT_OBJS_B
1870: -- This procedure gets called from ODI project EGO_SYNCICCDETAILS.
1871: --
1872: -- Scope : Public
1873: --
1973: END IF;
1974:
1975: END IF; /* end of if on l_entity_rec_count = 0 */
1976:
1977: -- For BATCH Mode, write derived entities to EGO_PUB_BAT_ENT_OBJS_B table
1978: IF l_mode = 'BATCH' THEN
1979: --debug(L_PROC_NAME||'Calling Write_Derived_Entites_ToBatFwk procedure');
1980: Write_Derived_Entites_ToBatFwk(p_session_id,l_batch_id);
1981: --debug(L_PROC_NAME||'Returned from Write_Derived_Entites_ToBatFwk procedure');