APPS.GME_UPDATE_STEP_QTY_PVT dependencies on GME_BATCH_STEP_ACTIVITIES

Line 1009: l_gme_batchstep_activities gme_batch_step_activities%ROWTYPE;

1005: IS
1006: l_api_name CONSTANT VARCHAR2 (30) := 'update_activities';
1007: /* Collections for details etc */
1008: l_batchstep_activity_ids gme_common_pvt.number_tab;
1009: l_gme_batchstep_activities gme_batch_step_activities%ROWTYPE;
1010: l_gme_calc_int_rsrc_usage_char VARCHAR2 (10);
1011: l_user_profile_option_name VARCHAR2 (100);
1012: /* Local variables */
1013: l_return_status VARCHAR2 (1);

Line 1018: FROM gme_batch_step_activities

1014:
1015: CURSOR cur_step_activity_ids
1016: IS
1017: SELECT batchstep_activity_id
1018: FROM gme_batch_step_activities
1019: WHERE batch_id = p_batch_step_rec.batch_id
1020: AND batchstep_id = p_batch_step_rec.batchstep_id
1021: ORDER BY batchstep_id;
1022:

Line 1049: IF NOT (gme_batch_step_activities_dbl.fetch_row

1045: FOR i IN 1 .. l_batchstep_activity_ids.COUNT LOOP
1046: l_gme_batchstep_activities.batchstep_activity_id :=
1047: l_batchstep_activity_ids (i);
1048:
1049: IF NOT (gme_batch_step_activities_dbl.fetch_row
1050: (l_gme_batchstep_activities
1051: ,l_gme_batchstep_activities) ) THEN
1052: RAISE step_activity_fetch_error;
1053: END IF;

Line 1102: IF NOT (gme_batch_step_activities_dbl.update_row

1098: RAISE step_resource_upd_err;
1099: END IF;
1100:
1101: /* Save the updated batch step activities row to the database */
1102: IF NOT (gme_batch_step_activities_dbl.update_row
1103: (l_gme_batchstep_activities) ) THEN
1104: RAISE step_activity_upd_err;
1105: END IF;
1106: END LOOP; /* FOR i IN 1..l_batchstep_activity_ids.COUNT LOOP */

Line 1170: ,p_batchstep_activities_rec IN gme_batch_step_activities%ROWTYPE

1166: =============================================================================================*/
1167: PROCEDURE update_resources (
1168: p_batch_hdr_rec IN gme_batch_header%ROWTYPE
1169: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1170: ,p_batchstep_activities_rec IN gme_batch_step_activities%ROWTYPE
1171: ,x_return_status OUT NOCOPY VARCHAR2
1172: ,p_routing_scale_factor IN NUMBER DEFAULT NULL
1173: ,p_backflush_factor IN NUMBER DEFAULT NULL
1174: ,p_charge_diff IN NUMBER DEFAULT NULL

Line 1224: FROM gme_batch_step_activities

1220:
1221: CURSOR cur_prev_actv_fact (v_batchstep_activity_id NUMBER)
1222: IS
1223: SELECT plan_activity_factor, actual_activity_factor
1224: FROM gme_batch_step_activities
1225: WHERE batchstep_activity_id = v_batchstep_activity_id;
1226:
1227: CURSOR cur_prev_plan_charge
1228: IS