APPS.MSC_MATL_PLAN_PKG dependencies on MSC_HP_UPDATES

Line 537: msc_hp_updates u,

533: b.bucket_type,
534: u.column_name,
535: u.new_value
536: from
537: msc_hp_updates u,
538: msc_hp_row_dtls h,
539: msc_hp_col_dtls b
540: where h.query_id = p_query_id
541: and h.query_id = u.query_id

Line 802: and row_index in (select row_index from msc_hp_updates where query_id = p_query_id);

798:
799: update msc_hp_row_dtls
800: set data_flag = 3
801: where query_id = p_query_id
802: and row_index in (select row_index from msc_hp_updates where query_id = p_query_id);
803: commit;
804:
805: populate_data(p_query_id, 2);
806:

Line 807: update msc_hp_updates set

803: commit;
804:
805: populate_data(p_query_id, 2);
806:
807: update msc_hp_updates set
808: process_status = 2,
809: last_update_date = sysdate,
810: last_updated_by = fnd_global.user_id,
811: last_update_login = fnd_global.login_id

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

809: last_update_date = sysdate,
810: last_updated_by = fnd_global.user_id,
811: last_update_login = fnd_global.login_id
812: where query_id = p_query_id and nvl(process_status, 1) = 1;
813: msc_phub_util.log('update msc_hp_updates: '||sql%rowcount);
814: commit;
815:
816: end save_changes;
817:

Line 831: delete from msc_hp_updates where query_id = p_query_id;

827: delete from msc_matl_plan_data where query_id = p_query_id;
828: msc_phub_util.log('delete from msc_matl_plan_data: '||sql%rowcount);
829: commit;
830:
831: delete from msc_hp_updates where query_id = p_query_id;
832: msc_phub_util.log('delete from msc_hp_updates: '||sql%rowcount);
833: commit;
834:
835: end close_data;

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

828: msc_phub_util.log('delete from msc_matl_plan_data: '||sql%rowcount);
829: commit;
830:
831: delete from msc_hp_updates where query_id = p_query_id;
832: msc_phub_util.log('delete from msc_hp_updates: '||sql%rowcount);
833: commit;
834:
835: end close_data;
836: