APPS.MSC_RES_PLAN_PKG dependencies on FND_GLOBAL

Line 79: fnd_global.user_id, sysdate,

75: p_query_id,
76: msc_hp_util.ft_end_pegging,
77: mfp1.sr_instance_id,
78: mfp1.end_pegging_id,
79: fnd_global.user_id, sysdate,
80: sysdate, fnd_global.user_id, fnd_global.login_id
81: from
82: msc_full_pegging mfp1,
83: msc_exception_details med1,

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

76: msc_hp_util.ft_end_pegging,
77: mfp1.sr_instance_id,
78: mfp1.end_pegging_id,
79: fnd_global.user_id, sysdate,
80: sysdate, fnd_global.user_id, fnd_global.login_id
81: from
82: msc_full_pegging mfp1,
83: msc_exception_details med1,
84: msc_form_query q,

Line 129: fnd_global.user_id, sysdate,

125: organization_code,
126: department_code,
127: resource_code,
128: 1 data_flag,
129: fnd_global.user_id, sysdate,
130: sysdate, fnd_global.user_id, fnd_global.login_id
131: from
132: (select distinct
133: r.plan_id,

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

126: department_code,
127: resource_code,
128: 1 data_flag,
129: fnd_global.user_id, sysdate,
130: sysdate, fnd_global.user_id, fnd_global.login_id
131: from
132: (select distinct
133: r.plan_id,
134: r.sr_instance_id,

Line 212: fnd_global.user_id, sysdate,

208: mtp.organization_code,
209: mdp.department_code,
210: mdp.resource_code,
211: 1 data_flag,
212: fnd_global.user_id, sysdate,
213: sysdate, fnd_global.user_id, fnd_global.login_id
214: from
215: msc_department_resources mdp,
216: msc_trading_partners mtp

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

209: mdp.department_code,
210: mdp.resource_code,
211: 1 data_flag,
212: fnd_global.user_id, sysdate,
213: sysdate, fnd_global.user_id, fnd_global.login_id
214: from
215: msc_department_resources mdp,
216: msc_trading_partners mtp
217: where mdp.plan_id = p_plan_id

Line 237: fnd_global.user_id, sysdate,

233: data_flag,
234: created_by, creation_date,
235: last_update_date, last_updated_by, last_update_login)
236: values (p_query_id, -1, p_plan_id, 1,
237: fnd_global.user_id, sysdate,
238: sysdate, fnd_global.user_id, fnd_global.login_id);
239: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
240: commit;
241:

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

234: created_by, creation_date,
235: last_update_date, last_updated_by, last_update_login)
236: values (p_query_id, -1, p_plan_id, 1,
237: fnd_global.user_id, sysdate,
238: sysdate, fnd_global.user_id, fnd_global.login_id);
239: msc_phub_util.log('insert into msc_hp_row_dtls: '||sql%rowcount);
240: commit;
241:
242: g_page_size := p_page_size;

Line 309: fnd_global.user_id, sysdate,

305: sum(non_standard_jobs) non_standard_jobs,
306: sum(planned_order) planned_order,
307: sum(work_order) work_order,
308: sum(total_resource_cost) total_resource_cost,
309: fnd_global.user_id, sysdate,
310: sysdate, fnd_global.user_id, fnd_global.login_id
311: from
312: (
313: -- requirements, non-batchable

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

306: sum(planned_order) planned_order,
307: sum(work_order) work_order,
308: sum(total_resource_cost) total_resource_cost,
309: fnd_global.user_id, sysdate,
310: sysdate, fnd_global.user_id, fnd_global.login_id
311: from
312: (
313: -- requirements, non-batchable
314: select

Line 766: fnd_global.user_id, sysdate,

762: mra.shift_date+(mra.from_time/86400) from_time2,
763: mra.shift_date+(decode(sign(mra.to_time-mra.from_time), -1, mra.to_time+86400, mra.to_time))/86400 to_time2,
764: mra.parent_id,
765: mra.capacity_units,
766: fnd_global.user_id, sysdate,
767: sysdate, fnd_global.user_id, fnd_global.login_id
768: from msc_net_resource_avail mra, msc_calendar_dates md
769: where mra.plan_id(+) = ru.plan_id
770: and mra.sr_instance_id(+) = ru.sr_instance_id

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

763: mra.shift_date+(decode(sign(mra.to_time-mra.from_time), -1, mra.to_time+86400, mra.to_time))/86400 to_time2,
764: mra.parent_id,
765: mra.capacity_units,
766: fnd_global.user_id, sysdate,
767: sysdate, fnd_global.user_id, fnd_global.login_id
768: from msc_net_resource_avail mra, msc_calendar_dates md
769: where mra.plan_id(+) = ru.plan_id
770: and mra.sr_instance_id(+) = ru.sr_instance_id
771: and mra.organization_id(+) = ru.organization_id

Line 841: last_updated_by = fnd_global.user_id,

837: to_time = r.to_time,
838: to_time2 = r.to_time2,
839: change_flag = 1,
840: last_update_date = sysdate,
841: last_updated_by = fnd_global.user_id,
842: last_update_login = fnd_global.login_id
843: where current of c;
844: else
845: r.to_time2 := r.to_time2 + (l_difference*r.shift_capacity/l_total_capacity/86400);

Line 842: last_update_login = fnd_global.login_id

838: to_time2 = r.to_time2,
839: change_flag = 1,
840: last_update_date = sysdate,
841: last_updated_by = fnd_global.user_id,
842: last_update_login = fnd_global.login_id
843: where current of c;
844: else
845: r.to_time2 := r.to_time2 + (l_difference*r.shift_capacity/l_total_capacity/86400);
846: r.to_time := (r.to_time2 - trunc(r.to_time2, 'DDD'))*86400;

Line 856: last_updated_by = fnd_global.user_id,

852: set to_time = r.to_time,
853: to_time2 = r.to_time2,
854: change_flag = 1,
855: last_update_date = sysdate,
856: last_updated_by = fnd_global.user_id,
857: last_update_login = fnd_global.login_id
858: where current of c;
859: end if;
860: end if;

Line 857: last_update_login = fnd_global.login_id

853: to_time2 = r.to_time2,
854: change_flag = 1,
855: last_update_date = sysdate,
856: last_updated_by = fnd_global.user_id,
857: last_update_login = fnd_global.login_id
858: where current of c;
859: end if;
860: end if;
861: fetch c into r;

Line 992: last_updated_by = fnd_global.user_id,

988: to_time = r.to_time,
989: to_time2 = r.to_time2,
990: change_flag = 1,
991: last_update_date = sysdate,
992: last_updated_by = fnd_global.user_id,
993: last_update_login = fnd_global.login_id
994: where current of c;
995: end if;
996: fetch c into r;

Line 993: last_update_login = fnd_global.login_id

989: to_time2 = r.to_time2,
990: change_flag = 1,
991: last_update_date = sysdate,
992: last_updated_by = fnd_global.user_id,
993: last_update_login = fnd_global.login_id
994: where current of c;
995: end if;
996: fetch c into r;
997: end loop;

Line 1039: last_updated_by = fnd_global.user_id,

1035: shift_num = r.shift_num,
1036: capacity_units = r.capacity_units,
1037: change_flag = 1,
1038: last_update_date = sysdate,
1039: last_updated_by = fnd_global.user_id,
1040: last_update_login = fnd_global.login_id
1041: where current of c;
1042: end if;
1043: fetch c into r;

Line 1040: last_update_login = fnd_global.login_id

1036: capacity_units = r.capacity_units,
1037: change_flag = 1,
1038: last_update_date = sysdate,
1039: last_updated_by = fnd_global.user_id,
1040: last_update_login = fnd_global.login_id
1041: where current of c;
1042: end if;
1043: fetch c into r;
1044: end loop;

Line 1085: last_updated_by = fnd_global.user_id,

1081: to_time2 = r.to_time2,
1082: capacity_units = r.capacity_units,
1083: change_flag = 1,
1084: last_update_date = sysdate,
1085: last_updated_by = fnd_global.user_id,
1086: last_update_login = fnd_global.login_id
1087: where current of c;
1088: fetch c into r;
1089: end loop;

Line 1086: last_update_login = fnd_global.login_id

1082: capacity_units = r.capacity_units,
1083: change_flag = 1,
1084: last_update_date = sysdate,
1085: last_updated_by = fnd_global.user_id,
1086: last_update_login = fnd_global.login_id
1087: where current of c;
1088: fetch c into r;
1089: end loop;
1090: close c;

Line 1108: last_updated_by = fnd_global.user_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
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;

Line 1109: last_update_login = fnd_global.login_id

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
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:

Line 1246: fnd_global.user_id, sysdate,

1242: r3.shift_date,
1243: r3.capacity_units * decode(r3.from_time, null, 0,
1244: (decode(sign(r3.to_time-r3.from_time),
1245: -1, r3.to_time+86400, r3.to_time) - r3.from_time)/3600),
1246: fnd_global.user_id, sysdate,
1247: sysdate, fnd_global.user_id, fnd_global.login_id);
1248: msc_phub_util.log('insert into msc_net_resource_avail (summary): '||sql%rowcount||', '||r3.parent_id);
1249: end;
1250: end if;

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

1243: r3.capacity_units * decode(r3.from_time, null, 0,
1244: (decode(sign(r3.to_time-r3.from_time),
1245: -1, r3.to_time+86400, r3.to_time) - r3.from_time)/3600),
1246: fnd_global.user_id, sysdate,
1247: sysdate, fnd_global.user_id, fnd_global.login_id);
1248: msc_phub_util.log('insert into msc_net_resource_avail (summary): '||sql%rowcount||', '||r3.parent_id);
1249: end;
1250: end if;
1251:

Line 1289: fnd_global.user_id, sysdate,

1285: r3.capacity_units,
1286: 0,
1287: 2,
1288: 2,
1289: fnd_global.user_id, sysdate,
1290: sysdate, fnd_global.user_id, fnd_global.login_id);
1291: msc_phub_util.log('insert into msc_net_resource_avail (detail): '||sql%rowcount||', '||r3.transaction_id);
1292:
1293: update msc_res_plan_updates

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

1286: 0,
1287: 2,
1288: 2,
1289: fnd_global.user_id, sysdate,
1290: sysdate, fnd_global.user_id, fnd_global.login_id);
1291: msc_phub_util.log('insert into msc_net_resource_avail (detail): '||sql%rowcount||', '||r3.transaction_id);
1292:
1293: update msc_res_plan_updates
1294: set transaction_id=r3.transaction_id

Line 1308: last_updated_by = fnd_global.user_id,

1304: status = 0,
1305: applied = 2,
1306: updated = 2,
1307: last_update_date = sysdate,
1308: last_updated_by = fnd_global.user_id,
1309: last_update_login = fnd_global.login_id
1310: where current of c4;
1311: msc_phub_util.log('update msc_net_resource_avail (detail): '||sql%rowcount||', '||r3.transaction_id);
1312: exit;

Line 1309: last_update_login = fnd_global.login_id

1305: applied = 2,
1306: updated = 2,
1307: last_update_date = sysdate,
1308: last_updated_by = fnd_global.user_id,
1309: last_update_login = fnd_global.login_id
1310: where current of c4;
1311: msc_phub_util.log('update msc_net_resource_avail (detail): '||sql%rowcount||', '||r3.transaction_id);
1312: exit;
1313: end loop;