APPS.GMP_WPS_WRITER dependencies on GME_BATCH_STEP_RESOURCES

Line 358: gme_batch_step_resources gsr,

354: gsr.offset_interval,
355: gsr.plan_start_date,
356: gsr.plan_cmplt_date
357: FROM
358: gme_batch_step_resources gsr,
359: mtl_units_of_measure u1,
360: mtl_units_of_measure u2
361: WHERE
362: gsr.batchstep_activity_id = v_activity_id

Line 434: gme_batch_step_resources

430: END IF;
431: v_trn_start_date := v_start_date + v_offset_interval;
432: v_trn_end_date := v_start_date + v_offset_interval;
433: UPDATE
434: gme_batch_step_resources
435: SET
436: plan_start_date = v_trn_start_date,
437: plan_cmplt_date = v_trn_end_date,
438: last_update_date = SYSDATE,

Line 453: gme_batch_step_resources

449:
450: v_trn_start_date:= v_start_date;
451: v_trn_end_date:= v_end_date;
452: UPDATE
453: gme_batch_step_resources
454: SET
455: plan_start_date = v_trn_start_date,
456: plan_cmplt_date = v_trn_end_date,
457: last_update_date = SYSDATE,

Line 552: v_in_step_res_row gme_batch_step_resources%ROWTYPE; /* Added for NOCOPY */

548: last_update_date DATE;
549: v_res_usage NUMBER ;
550: v_seq_dep_usage NUMBER;
551: v_step_act_id NUMBER;
552: v_in_step_res_row gme_batch_step_resources%ROWTYPE; /* Added for NOCOPY */
553: v_step_res_row gme_batch_step_resources%ROWTYPE;
554:
555: CURSOR validate_step_resource IS
556: SELECT

Line 553: v_step_res_row gme_batch_step_resources%ROWTYPE;

549: v_res_usage NUMBER ;
550: v_seq_dep_usage NUMBER;
551: v_step_act_id NUMBER;
552: v_in_step_res_row gme_batch_step_resources%ROWTYPE; /* Added for NOCOPY */
553: v_step_res_row gme_batch_step_resources%ROWTYPE;
554:
555: CURSOR validate_step_resource IS
556: SELECT
557: gsr.organization_id,

Line 566: gme_batch_step_resources gsr,

562: gsr.usage_um,
563: gsr.batchstep_activity_id
564: FROM
565: gme_batch_steps gbs,
566: gme_batch_step_resources gsr,
567: cr_rsrc_dtl crd
568: WHERE
569: gbs.batchstep_id = v_step_id
570: AND gbs.batchstep_id = gsr.batchstep_id

Line 584: gme_batch_step_resources gsr

580: CURSOR validate_alt_resource IS
581: SELECT
582: gsr.batchstep_resource_id
583: FROM
584: gme_batch_step_resources gsr
585: WHERE
586: gsr.batchstep_activity_id = v_activity_id
587: AND gsr.resources = v_resources
588: AND gsr.organization_id = v_organization_id;

Line 652: gme_batch_step_resources

648: IF v_o_resources = v_n_resources THEN
649: pnew_act_res(i) := pact_res_id(i);
650:
651: UPDATE
652: gme_batch_step_resources
653: SET
654: plan_start_date = v_start_date,
655: plan_cmplt_date = v_end_date,
656: sequence_dependent_usage = v_seq_dep_usage,

Line 678: IF NOT GME_BATCH_STEP_RESOURCES_DBL.fetch_row(v_in_step_res_row,

674: IF validate_alt_resource%FOUND THEN
675: return_status := -8;
676: ELSE
677: v_in_step_res_row.batchstep_resource_id := v_act_resource_id;
678: IF NOT GME_BATCH_STEP_RESOURCES_DBL.fetch_row(v_in_step_res_row,
679: v_step_res_row) THEN
680: return_status := -5;
681: ELSE
682:

Line 684: gme_batch_step_resources

680: return_status := -5;
681: ELSE
682:
683: DELETE
684: gme_batch_step_resources
685: WHERE
686: batchstep_resource_id = v_act_resource_id;
687:
688: IF SQL%NOTFOUND THEN

Line 700: IF NOT GME_BATCH_STEP_RESOURCES_DBL.insert_row

696: v_step_res_row.plan_rsrc_usage :=
697: inv_convert.inv_um_convert(-1,38,v_res_usage,puom_hour,
698: v_uom_code,NULL,NULL);
699:
700: IF NOT GME_BATCH_STEP_RESOURCES_DBL.insert_row
701: (v_step_res_row, v_in_step_res_row) THEN
702: return_status := -7;
703: ELSE
704: pnew_act_res(i) := v_in_step_res_row.batchstep_resource_id;

Line 932: gme_batch_step_resources gsr,

928: gsr.usage_um,
929: gbh.ORGANIZATION_ID
930: FROM
931: cr_rsrc_dtl crd,
932: gme_batch_step_resources gsr,
933: gme_batch_header gbh
934: WHERE
935: crd.resource_id = v_resource_id
936: AND crd.delete_mark = 0

Line 1102: gme_batch_step_resources

1098: CURSOR lock_batch_resources IS
1099: SELECT
1100: batch_id
1101: FROM
1102: gme_batch_step_resources
1103: WHERE
1104: batch_id = v_batch_id
1105: FOR UPDATE NOWAIT;
1106: