DBA Data[Home] [Help]

APPS.EGO_PUB_WS_ICC dependencies on EGO_PUB_BAT_ENT_OBJS_V

Line 1187: In batch mode, icc_name will not be present in Ego_Pub_Bat_Ent_Objs_v, so we are collecting it as null*/

1183:
1184:
1185: IF l_batch_id IS NOT NULL THEN
1186: /*we are using to_char since l_dup_icc_id_tab, l_dup_icc_ver_id_tab are varchar2 tables
1187: In batch mode, icc_name will not be present in Ego_Pub_Bat_Ent_Objs_v, so we are collecting it as null*/
1188: SELECT To_Char(pk1_value) , NULL, To_Char(pk2_value)
1189: BULK COLLECT INTO l_dup_icc_id_tab, l_dup_icc_name_tab, l_dup_icc_ver_id_tab
1190: FROM Ego_Pub_Bat_Ent_Objs_v
1191: WHERE batch_id = l_batch_id

Line 1190: FROM Ego_Pub_Bat_Ent_Objs_v

1186: /*we are using to_char since l_dup_icc_id_tab, l_dup_icc_ver_id_tab are varchar2 tables
1187: In batch mode, icc_name will not be present in Ego_Pub_Bat_Ent_Objs_v, so we are collecting it as null*/
1188: SELECT To_Char(pk1_value) , NULL, To_Char(pk2_value)
1189: BULK COLLECT INTO l_dup_icc_id_tab, l_dup_icc_name_tab, l_dup_icc_ver_id_tab
1190: FROM Ego_Pub_Bat_Ent_Objs_v
1191: WHERE batch_id = l_batch_id
1192: AND user_entered = G_USER_ENTERED_FLAG_YES;
1193: --debug(L_PROC_NAME||'l_dup_icc_id_tab.count: '||l_dup_icc_id_tab.Count||' ,l_dup_icc_name_tab.count: '||l_dup_icc_name_tab.Count||' ,l_dup_icc_ver_id_tab.count: '||l_dup_icc_ver_id_tab.Count);
1194: END IF; /*l_batch_id IS NOT NULL*/