DBA Data[Home] [Help]

APPS.GMD_OPRN_MIGRATION dependencies on GMD_OPERATION_ACTIVITIES

Line 119: INSERT INTO gmd_operation_activities

115:
116: PROCEDURE INSERT_OPERATION_ACTIVITY IS
117: error_msg VARCHAR2(240);
118: BEGIN
119: INSERT INTO gmd_operation_activities
120: (oprn_line_id
121: ,oprn_id
122: ,activity
123: ,offset_interval

Line 208: FROM gmd_operation_activities

204: ,v_activity_rec.attribute30
205: ,v_activity_rec.attribute_category
206: FROM dual
207: WHERE NOT EXISTS (SELECT 1
208: FROM gmd_operation_activities
209: WHERE oprn_line_id = v_activity_rec.oprn_line_id);
210: EXCEPTION
211: WHEN OTHERS THEN
212: error_msg := SQLERRM;

Line 214: ,p_target_table => 'GMD_OPERATION_ACTIVITIES'

210: EXCEPTION
211: WHEN OTHERS THEN
212: error_msg := SQLERRM;
213: GMD_RECIPE_MIGRATION.insert_message (p_source_table => 'FM_OPRN_DTL'
214: ,p_target_table => 'GMD_OPERATION_ACTIVITIES'
215: ,p_source_id => v_activity_rec.activity
216: ,p_target_id => v_activity_rec.activity
217: ,p_message => error_msg
218: ,p_error_type => 'U');