APPS.GME_UPDATE_STEP_QTY_PVT dependencies on GME_BATCH_STEP_ACTIVITIES

Line 910: l_gme_batchstep_activities gme_batch_step_activities%ROWTYPE;

906: IS
907: l_api_name CONSTANT VARCHAR2 (30) := 'update_activities';
908: /* Collections for details etc */
909: l_batchstep_activity_ids gme_common_pvt.number_tab;
910: l_gme_batchstep_activities gme_batch_step_activities%ROWTYPE;
911: l_gme_calc_int_rsrc_usage_char VARCHAR2 (10);
912: l_user_profile_option_name VARCHAR2 (100);
913: /* Local variables */
914: l_return_status VARCHAR2 (1);

Line 919: FROM gme_batch_step_activities

915:
916: CURSOR cur_step_activity_ids
917: IS
918: SELECT batchstep_activity_id
919: FROM gme_batch_step_activities
920: WHERE batch_id = p_batch_step_rec.batch_id
921: AND batchstep_id = p_batch_step_rec.batchstep_id
922: ORDER BY batchstep_id;
923:

Line 950: IF NOT (gme_batch_step_activities_dbl.fetch_row

946: FOR i IN 1 .. l_batchstep_activity_ids.COUNT LOOP
947: l_gme_batchstep_activities.batchstep_activity_id :=
948: l_batchstep_activity_ids (i);
949:
950: IF NOT (gme_batch_step_activities_dbl.fetch_row
951: (l_gme_batchstep_activities
952: ,l_gme_batchstep_activities) ) THEN
953: RAISE step_activity_fetch_error;
954: END IF;

Line 1003: IF NOT (gme_batch_step_activities_dbl.update_row

999: RAISE step_resource_upd_err;
1000: END IF;
1001:
1002: /* Save the updated batch step activities row to the database */
1003: IF NOT (gme_batch_step_activities_dbl.update_row
1004: (l_gme_batchstep_activities) ) THEN
1005: RAISE step_activity_upd_err;
1006: END IF;
1007: END LOOP; /* FOR i IN 1..l_batchstep_activity_ids.COUNT LOOP */

Line 1071: ,p_batchstep_activities_rec IN gme_batch_step_activities%ROWTYPE

1067: =============================================================================================*/
1068: PROCEDURE update_resources (
1069: p_batch_hdr_rec IN gme_batch_header%ROWTYPE
1070: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1071: ,p_batchstep_activities_rec IN gme_batch_step_activities%ROWTYPE
1072: ,x_return_status OUT NOCOPY VARCHAR2
1073: ,p_routing_scale_factor IN NUMBER DEFAULT NULL
1074: ,p_backflush_factor IN NUMBER DEFAULT NULL
1075: ,p_charge_diff IN NUMBER DEFAULT NULL

Line 1125: FROM gme_batch_step_activities

1121:
1122: CURSOR cur_prev_actv_fact (v_batchstep_activity_id NUMBER)
1123: IS
1124: SELECT plan_activity_factor, actual_activity_factor
1125: FROM gme_batch_step_activities
1126: WHERE batchstep_activity_id = v_batchstep_activity_id;
1127:
1128: CURSOR cur_prev_plan_charge
1129: IS