APPS.EGO_PUB_FWK_PK dependencies on EGO_PUB_BAT_ENT_OBJS_B

Line 314: INSERT INTO Ego_Pub_Bat_Ent_Objs_B

310:
311: -- Adding column for entity_type_id . Added for Metadata Sync
312:
313: l_stmt_num := 10;
314: INSERT INTO Ego_Pub_Bat_Ent_Objs_B
315: ( Batch_Entity_Object_id
316: ,Batch_id
317: ,PK1_value
318: ,PK2_value

Line 352: ||' ' || sql%rowcount || ' rows are inserted into EGO_PUB_BAT_ENT_OBJS_B.');

348: WHERE Batch_Id = p_batch_id;
349: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
350: ,p_module => 'EGO_PUB_FWK_PK.process_entities'
351: ,p_message => 'lStmtNum=' || to_char(l_stmt_num)
352: ||' ' || sql%rowcount || ' rows are inserted into EGO_PUB_BAT_ENT_OBJS_B.');
353:
354:
355: l_stmt_num := 20;
356: SELECT Batch_Entity_Object_id

Line 361: FROM Ego_Pub_Bat_Ent_Objs_B EO,

357: ,System_Code
358: BULK COLLECT INTO
359: t_batch_ent_obj_id
360: ,t_system_code
361: FROM Ego_Pub_Bat_Ent_Objs_B EO,
362: EGO_PUB_BAT_SYSTEMS_B SYS
363: WHERE EO.Batch_Id = p_batch_id
364: AND EO.User_Entered = C_NO
365: AND SYS.Batch_Id = EO.Batch_Id;

Line 947: FROM ego_pub_bat_ent_objs_b eo

943:
944: UPDATE ego_publication_batch_gt gt
945: SET batch_entity_object_id =
946: (SELECT eo.batch_entity_object_id
947: FROM ego_pub_bat_ent_objs_b eo
948: WHERE batch_id = gt.batch_id
949: AND eo.pk1_value = nvl(gt.pk1_value, -99)
950: AND nvl(eo.pk2_value, -99) = nvl(gt.pk2_value, -99)
951: AND nvl(eo.pk3_value, -99) = nvl(gt.pk3_value, -99)

Line 2577: from EGO_PUB_BAT_ENT_OBJS_B where BATCH_ID = p_batch_id and USER_ENTERED = 'Y';

2573: begin
2574: -- build entities
2575: select PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE
2576: BULK COLLECT INTO l_pk1_vals, l_pk2_vals, l_pk3_vals, l_pk4_vals, l_pk5_vals
2577: from EGO_PUB_BAT_ENT_OBJS_B where BATCH_ID = p_batch_id and USER_ENTERED = 'Y';
2578: l_counter := 1;
2579: for i in 1..l_pk1_vals.COUNT loop
2580: l_batch_entities(l_counter).pk1_value := l_pk1_vals(i);
2581: l_batch_entities(l_counter).pk2_value := l_pk2_vals(i);

Line 3168: insert into EGO_PUB_BAT_ENT_OBJS_B (

3164: || ', pk5:' || nvl(l_batch_entities(i).pk5_value, 'null')
3165: || ', user_entered:' || nvl(l_batch_entities(i).user_entered, 'null')
3166: );
3167: select EGO_PUB_BAT_ENT_OBJS_S1.NEXTVAL into l_ent_obj_id from dual;
3168: insert into EGO_PUB_BAT_ENT_OBJS_B (
3169: batch_entity_object_id,
3170: batch_id,
3171: entity_type_id,
3172: pk1_value,