APPS.MSC_RES_PLAN_PKG dependencies on MSC_HP_UPDATES

Line 635: msc_hp_updates u,

631: decode(u.time_level, 2, b.week_end_date, 3, period_end_date, bkt_end_date) end_date,
632: decode(u.time_level, 2, b.week_last_work_date, 3, period_last_work_date, bkt_end_date) last_work_date,
633: u.new_value
634: from
635: msc_hp_updates u,
636: msc_hp_row_dtls h,
637: msc_hp_col_dtls b
638: where h.query_id = p_query_id
639: and h.query_id = u.query_id

Line 1105: update msc_hp_updates set

1101:
1102: populate_data(p_query_id, 2);
1103: summarize_data(p_query_id);
1104:
1105: update msc_hp_updates set
1106: process_status = 2,
1107: last_update_date = sysdate,
1108: last_updated_by = fnd_global.user_id,
1109: last_update_login = fnd_global.login_id

Line 1111: msc_phub_util.log('update msc_hp_updates: '||sql%rowcount);

1107: last_update_date = sysdate,
1108: last_updated_by = fnd_global.user_id,
1109: last_update_login = fnd_global.login_id
1110: where query_id = p_query_id and nvl(process_status, 1) = 1;
1111: msc_phub_util.log('update msc_hp_updates: '||sql%rowcount);
1112: commit;
1113:
1114: end recalculate;
1115:

Line 1129: delete from msc_hp_updates where query_id = p_query_id;

1125: delete from msc_res_plan_data where query_id = p_query_id;
1126: msc_phub_util.log('delete from msc_res_plan_data: '||sql%rowcount);
1127: commit;
1128:
1129: delete from msc_hp_updates where query_id = p_query_id;
1130: msc_phub_util.log('delete from msc_hp_updates: '||sql%rowcount);
1131: commit;
1132:
1133: delete from msc_res_plan_updates where query_id = p_query_id;

Line 1130: msc_phub_util.log('delete from msc_hp_updates: '||sql%rowcount);

1126: msc_phub_util.log('delete from msc_res_plan_data: '||sql%rowcount);
1127: commit;
1128:
1129: delete from msc_hp_updates where query_id = p_query_id;
1130: msc_phub_util.log('delete from msc_hp_updates: '||sql%rowcount);
1131: commit;
1132:
1133: delete from msc_res_plan_updates where query_id = p_query_id;
1134: msc_phub_util.log('delete from msc_res_plan_updates: '||sql%rowcount);