APPS.CSI_ML_PROGRAM_PUB dependencies on CSI_I_ASSET_INTERFACE

Line 33: AND EXISTS ( SELECT 1 FROM csi_i_asset_interface csiai

29: csii.location_type_code
30: FROM csi_instance_interface csii
31: WHERE process_status = 'R'
32: AND source_system_name = nvl(p_source_system_name,source_system_name)
33: AND EXISTS ( SELECT 1 FROM csi_i_asset_interface csiai
34: WHERE csiai.inst_interface_id = csii.inst_interface_id )
35: AND syncup_family IS NULL;
36:
37: l_syncup_instance_rec syncup_instance_cur%ROWTYPE;

Line 121: UPDATE csi_i_asset_interface

117:
118: IF l_syncup_vld_flag = 'E' THEN
119: FOR i_asst IN l_inst_intr_tbl.first .. l_inst_intr_tbl.last
120: LOOP
121: UPDATE csi_i_asset_interface
122: SET fa_sync_flag = 'N'
123: WHERE inst_interface_id = l_inst_intr_tbl(i_asst)
124: AND fa_sync_flag = 'Y' ;
125:

Line 224: DELETE FROM CSI_I_ASSET_INTERFACE

220: WHERE inst_interface_id=inst_intf_id_del(i1);
221:
222: /* bnarayan Added to purge processed asset interface records */
223: FORALL i1 IN 1 .. inst_intf_id_del.COUNT
224: DELETE FROM CSI_I_ASSET_INTERFACE
225: WHERE inst_interface_id=inst_intf_id_del(i1);
226:
227:
228: FORALL i1 IN 1 .. inst_intf_id_del.COUNT

Line 440: DELETE FROM CSI_I_ASSET_INTERFACE

436: WHERE inst_interface_id=inst_intf_id_del(i1);
437:
438: /* bnarayan Added to purge processed asset interface records */
439: FORALL i1 IN 1 .. inst_intf_id_del.COUNT
440: DELETE FROM CSI_I_ASSET_INTERFACE
441: WHERE inst_interface_id=inst_intf_id_del(i1);
442:
443:
444: FORALL i1 IN 1 .. inst_intf_id_del.COUNT