APPS.MSC_HP_UTIL dependencies on FND_GLOBAL

Line 160: fnd_global.user_id, sysdate,

156: greatest(decode(tw.week_index, 1, m.plan_start_date, t.week_start_date), t.week_last_work_date) week_last_work_date,
157: decode(tp.period_index, 1, m.plan_start_date, t.period_start_date) period_start_date,
158: t.period_end_date,
159: greatest(decode(tp.period_index, 1, m.plan_start_date, t.period_start_date), t.period_last_work_date) period_last_work_date,
160: fnd_global.user_id, sysdate,
161: sysdate, fnd_global.user_id, fnd_global.login_id
162: from t, m,
163: (select rownum week_index, week_start_date from (select distinct week_start_date from t order by 1)) tw,
164: (select rownum period_index, period_start_date from (select distinct period_start_date from t order by 1)) tp

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

157: decode(tp.period_index, 1, m.plan_start_date, t.period_start_date) period_start_date,
158: t.period_end_date,
159: greatest(decode(tp.period_index, 1, m.plan_start_date, t.period_start_date), t.period_last_work_date) period_last_work_date,
160: fnd_global.user_id, sysdate,
161: sysdate, fnd_global.user_id, fnd_global.login_id
162: from t, m,
163: (select rownum week_index, week_start_date from (select distinct week_start_date from t order by 1)) tw,
164: (select rownum period_index, period_start_date from (select distinct period_start_date from t order by 1)) tp
165: where t.week_start_date=tw.week_start_date

Line 181: fnd_global.user_id, sysdate,

177: m.plan_start_date - 1 week_last_work_date,
178: m.plan_start_date - 1 period_start_date,
179: m.plan_start_date - 1 period_end_date,
180: m.plan_start_date - 1 period_last_work_date,
181: fnd_global.user_id, sysdate,
182: sysdate, fnd_global.user_id, fnd_global.login_id
183: from m
184: order by bucket_index;
185: msc_phub_util.log('insert into msc_hp_col_dtls: '||sql%rowcount);

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

178: m.plan_start_date - 1 period_start_date,
179: m.plan_start_date - 1 period_end_date,
180: m.plan_start_date - 1 period_last_work_date,
181: fnd_global.user_id, sysdate,
182: sysdate, fnd_global.user_id, fnd_global.login_id
183: from m
184: order by bucket_index;
185: msc_phub_util.log('insert into msc_hp_col_dtls: '||sql%rowcount);
186: commit;

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

201: if (p_filter_type in (ft_organization, ft_category, ft_department, ft_resource)) then
202: insert into msc_form_query(query_id, number1, char1,
203: created_by, creation_date, last_update_date, last_updated_by, last_update_login)
204: values (p_query_id, p_filter_type, trim(substr(s, 1, i - 1)),
205: fnd_global.user_id, sysdate, sysdate, fnd_global.user_id, fnd_global.login_id);
206: end if;
207:
208: if (p_filter_type in (ft_exception, ft_item)) then
209: insert into msc_form_query(query_id, number1, number2,

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

208: if (p_filter_type in (ft_exception, ft_item)) then
209: insert into msc_form_query(query_id, number1, number2,
210: created_by, creation_date, last_update_date, last_updated_by, last_update_login)
211: values (p_query_id, p_filter_type, trim(substr(s, 1, i - 1)),
212: fnd_global.user_id, sysdate, sysdate, fnd_global.user_id, fnd_global.login_id);
213: end if;
214: end if;
215: s := substr(s, i + 1);
216: i := instr(s, ',');