APPS.GMD_OPRN_MIGRATION dependencies on GMD_OPERATION_RESOURCES

Line 255: INSERT INTO gmd_operation_resources (

251: AND v_activity_rec.scale_type in (1,2) THEN
252: RAISE invalid_err;
253: END IF;
254: --END BUG#3316385
255: INSERT INTO gmd_operation_resources (
256: oprn_line_id
257: ,resources
258: ,resource_usage
259: ,resource_count

Line 374: FROM gmd_operation_resources

370: ,NULL /* Process parameter 4 */
371: ,NULL /* Process parameter 5 */
372: FROM dual
373: WHERE NOT EXISTS (SELECT 1
374: FROM gmd_operation_resources
375: WHERE oprn_line_id = p_oprn_line_id AND
376: resources = v_activity_rec.resources);
377:
378: EXCEPTION

Line 383: ,p_target_table => 'GMD_OPERATION_RESOURCES'

379: --BEGIN BUG#3316385
380: WHEN invalid_err THEN
381: error_msg := 'Invalid Combination of Process Quantity,Usage and Scale Type';
382: GMD_RECIPE_MIGRATION.insert_message (p_source_table => 'FM_OPRN_DTL'
383: ,p_target_table => 'GMD_OPERATION_RESOURCES'
384: ,p_source_id => v_activity_rec.resources
385: ,p_target_id => v_activity_rec.resources
386: ,p_message => error_msg
387: ,p_error_type => 'U');

Line 392: ,p_target_table => 'GMD_OPERATION_RESOURCES'

388: --END BUG#3316385
389: WHEN OTHERS THEN
390: error_msg := SQLERRM;
391: GMD_RECIPE_MIGRATION.insert_message (p_source_table => 'FM_OPRN_DTL'
392: ,p_target_table => 'GMD_OPERATION_RESOURCES'
393: ,p_source_id => v_activity_rec.resources
394: ,p_target_id => v_activity_rec.resources
395: ,p_message => error_msg
396: ,p_error_type => 'U');