APPS.CSI_GIS_INSTANCE_LOC_PUB dependencies on CSI_ITEM_INSTANCES

Line 147: FROM CSI_ITEM_INSTANCES

143: SET process_flag = 'E',
144: error_message=l_msg_data,
145: process_date=sysdate
146: WHERE instance_number = (select instance_number
147: FROM CSI_ITEM_INSTANCES
148: WHERE instance_id = p_csi_instance_geoloc_tbl(i).instance_id)
149: AND PROCESS_FLAG = 'R';
150: END IF;
151: l_error_count:=l_error_count+1;

Line 193: FROM CSI_ITEM_INSTANCES

189: SET process_flag = 'E',
190: error_message=l_msg_data,
191: process_date=sysdate
192: WHERE instance_number = (select instance_number
193: FROM CSI_ITEM_INSTANCES
194: WHERE instance_id = p_csi_instance_geoloc_tbl(i).instance_id)
195: AND PROCESS_FLAG = 'R';
196: END IF;
197: -- Continue processing other records

Line 226: FROM CSI_ITEM_INSTANCES

222: SET process_flag = 'E',
223: error_message=l_msg_data,
224: process_date=sysdate
225: WHERE instance_number = (select instance_number
226: FROM CSI_ITEM_INSTANCES
227: WHERE instance_id = p_csi_instance_geoloc_tbl(i).instance_id)
228: AND PROCESS_FLAG = 'R';
229: END IF;
230: l_error_count:=l_error_count+1;

Line 262: FROM CSI_ITEM_INSTANCES

258: SET process_flag = 'E',
259: error_message=l_msg_data,
260: process_date=sysdate
261: WHERE instance_number = (select instance_number
262: FROM CSI_ITEM_INSTANCES
263: WHERE instance_id = p_csi_instance_geoloc_tbl(i).instance_id)
264: AND PROCESS_FLAG = 'R';
265: END IF;
266:

Line 300: FROM CSI_ITEM_INSTANCES

296: SET process_flag = 'E',
297: error_message=l_msg_data,
298: process_date=sysdate
299: WHERE instance_number = (select instance_number
300: FROM CSI_ITEM_INSTANCES
301: WHERE instance_id = p_csi_instance_geoloc_tbl(i).instance_id)
302: AND PROCESS_FLAG = 'R';
303: END IF;
304: l_error_count:=l_error_count+1;

Line 334: FROM CSI_ITEM_INSTANCES

330: SET process_flag = 'E',
331: error_message=l_msg_data,
332: process_date=sysdate
333: WHERE instance_number = (select instance_number
334: FROM CSI_ITEM_INSTANCES
335: WHERE instance_id = p_csi_instance_geoloc_tbl(i).instance_id)
336: AND PROCESS_FLAG = 'R';
337: END IF;
338: l_error_count:=l_error_count+1;

Line 372: FROM CSI_ITEM_INSTANCES

368: SET process_flag = 'E',
369: error_message=l_msg_data,
370: process_date=sysdate
371: WHERE instance_number = (select instance_number
372: FROM CSI_ITEM_INSTANCES
373: WHERE instance_id = p_csi_instance_geoloc_tbl(i).instance_id)
374: AND PROCESS_FLAG = 'R';
375: END IF;
376: l_error_count:=l_error_count+1;

Line 386: FROM CSI_ITEM_INSTANCES

382: UPDATE csi_ii_geoloc_interface
383: SET process_flag = 'P',
384: process_date = sysdate
385: WHERE instance_number = (select instance_number
386: FROM CSI_ITEM_INSTANCES
387: WHERE instance_id = p_csi_instance_geoloc_tbl(i).instance_id)
388: AND PROCESS_FLAG = 'R';
389: COMMIT WORK;
390: csi_t_gen_utility_pvt.add( 'Completed Processing Record#:'||i);

Line 415: FROM CSI_ITEM_INSTANCES

411: SET process_flag = 'E',
412: error_message=l_msg_data,
413: process_date = sysdate
414: WHERE instance_number = (select instance_number
415: FROM CSI_ITEM_INSTANCES
416: WHERE instance_id = p_csi_instance_geoloc_tbl(i).instance_id)
417: AND PROCESS_FLAG = 'R';
418: END IF;
419: l_error_count:=l_error_count + 1;

Line 429: FROM CSI_ITEM_INSTANCES

425: UPDATE csi_ii_geoloc_interface
426: SET process_flag = 'P',
427: process_date = sysdate
428: WHERE instance_number = (select instance_number
429: FROM CSI_ITEM_INSTANCES
430: WHERE instance_id = p_csi_instance_geoloc_tbl(i).instance_id)
431: AND PROCESS_FLAG = 'R' ;
432: COMMIT WORK;
433: csi_t_gen_utility_pvt.add( 'Completed Processing Record#:'||i);

Line 581: FROM csi_item_instances

577:
578: BEGIN
579: SELECT instance_id
580: INTO l_instance_id
581: FROM csi_item_instances
582: WHERE instance_number = import_inst_geo_loc_tbl(i).instance_number;
583: EXCEPTION
584: WHEN NO_DATA_FOUND THEN
585: