80: o.organization_code,
81: ic.category_name,
82: i.item_name,
83: 1 data_flag,
84: fnd_global.user_id, sysdate,
85: sysdate, fnd_global.user_id, fnd_global.login_id
86: from
87: msc_system_items i,
88: msc_item_categories ic,
81: ic.category_name,
82: i.item_name,
83: 1 data_flag,
84: fnd_global.user_id, sysdate,
85: sysdate, fnd_global.user_id, fnd_global.login_id
86: from
87: msc_system_items i,
88: msc_item_categories ic,
89: msc_trading_partners o
108: data_flag,
109: created_by, creation_date,
110: last_update_date, last_updated_by, last_update_login)
111: values (p_query_id, -1, p_plan_id, 1,
112: fnd_global.user_id, sysdate,
113: sysdate, fnd_global.user_id, fnd_global.login_id);
114: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
115: commit;
116:
109: created_by, creation_date,
110: last_update_date, last_updated_by, last_update_login)
111: values (p_query_id, -1, p_plan_id, 1,
112: fnd_global.user_id, sysdate,
113: sysdate, fnd_global.user_id, fnd_global.login_id);
114: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
115: commit;
116:
117: g_page_size := p_page_size;
202: sum(dependent_demand) dependent_demand,
203: sum(manual_demand) manual_demand,
204: sum(sales_order) sales_order,
205: sum(safety_stock) safety_stock,
206: fnd_global.user_id, sysdate,
207: sysdate, fnd_global.user_id, fnd_global.login_id
208: from
209: (
210: -- supplies:scheduled_receipts
203: sum(manual_demand) manual_demand,
204: sum(sales_order) sales_order,
205: sum(safety_stock) safety_stock,
206: fnd_global.user_id, sysdate,
207: sysdate, fnd_global.user_id, fnd_global.login_id
208: from
209: (
210: -- supplies:scheduled_receipts
211: select
653: nvl(firm_quantity, new_order_quantity)*(ru.new_value-l_fixed)/l_old_value),
654: status = 0,
655: applied = 2,
656: last_update_date = sysdate,
657: last_updated_by = fnd_global.user_id,
658: last_update_login = fnd_global.login_id
659: where current of c1;
660: l_n := l_n + 1;
661: end loop;
654: status = 0,
655: applied = 2,
656: last_update_date = sysdate,
657: last_updated_by = fnd_global.user_id,
658: last_update_login = fnd_global.login_id
659: where current of c1;
660: l_n := l_n + 1;
661: end loop;
662:
690: ru.last_work_date,
691: (ru.new_value-l_fixed),
692: 0,
693: 2,
694: fnd_global.user_id, sysdate,
695: sysdate, fnd_global.user_id, fnd_global.login_id);
696: msc_phub_util.log('insert into msc_supplies: '||sql%rowcount);
697: end if;
698: commit;
691: (ru.new_value-l_fixed),
692: 0,
693: 2,
694: fnd_global.user_id, sysdate,
695: sysdate, fnd_global.user_id, fnd_global.login_id);
696: msc_phub_util.log('insert into msc_supplies: '||sql%rowcount);
697: end if;
698: commit;
699: end if;
742: org_firm_flag = 1,
743: status = 0,
744: applied = 2,
745: last_update_date = sysdate,
746: last_updated_by = fnd_global.user_id,
747: last_update_login = fnd_global.login_id
748: where current of c2;
749: l_n := l_n + 1;
750: end loop;
743: status = 0,
744: applied = 2,
745: last_update_date = sysdate,
746: last_updated_by = fnd_global.user_id,
747: last_update_login = fnd_global.login_id
748: where current of c2;
749: l_n := l_n + 1;
750: end loop;
751:
787: 1,
788: 1,
789: 0,
790: 2,
791: fnd_global.user_id, sysdate,
792: sysdate, fnd_global.user_id, fnd_global.login_id);
793: msc_phub_util.log('insert into msc_demands: '||sql%rowcount);
794: end if;
795: commit;
788: 1,
789: 0,
790: 2,
791: fnd_global.user_id, sysdate,
792: sysdate, fnd_global.user_id, fnd_global.login_id);
793: msc_phub_util.log('insert into msc_demands: '||sql%rowcount);
794: end if;
795: commit;
796: end if;
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
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;
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
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: