DBA Data[Home] [Help]

APPS.MSC_MATL_PLAN_PKG dependencies on FND_GLOBAL

Line 84: fnd_global.user_id, sysdate,

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,

Line 85: sysdate, fnd_global.user_id, fnd_global.login_id

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

Line 112: fnd_global.user_id, sysdate,

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:

Line 113: sysdate, fnd_global.user_id, fnd_global.login_id);

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;

Line 206: fnd_global.user_id, sysdate,

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

Line 207: sysdate, fnd_global.user_id, fnd_global.login_id

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

Line 657: last_updated_by = fnd_global.user_id,

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;

Line 658: last_update_login = fnd_global.login_id

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:

Line 694: fnd_global.user_id, sysdate,

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;

Line 695: sysdate, fnd_global.user_id, fnd_global.login_id);

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;

Line 746: last_updated_by = fnd_global.user_id,

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;

Line 747: last_update_login = fnd_global.login_id

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:

Line 791: fnd_global.user_id, sysdate,

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;

Line 792: sysdate, fnd_global.user_id, fnd_global.login_id);

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;

Line 810: last_updated_by = fnd_global.user_id,

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;

Line 811: last_update_login = fnd_global.login_id

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: