APPS.AMW_ORG_CERT_AGGR_PKG dependencies on FND_GLOBAL

Line 61: l_parent_id, 1, sysdate, fnd_global.user_id, sysdate,

57: created_by, last_update_date, last_updated_by, last_update_login,
58: object_version_number, delete_flag)
59: VALUES(amw_full_entity_hier_s.nextval, 'BUSIPROC_CERTIFICATION',
60: p_certification_id, 'SUBSIDIARY', p_child_id, 'SUBSIDIARY',
61: l_parent_id, 1, sysdate, fnd_global.user_id, sysdate,
62: fnd_global.user_id, fnd_global.login_id, 1, 'N');
63:
64: recursive_populate_hier(p_certification_id, l_parent_id);
65: ELSE

Line 62: fnd_global.user_id, fnd_global.login_id, 1, 'N');

58: object_version_number, delete_flag)
59: VALUES(amw_full_entity_hier_s.nextval, 'BUSIPROC_CERTIFICATION',
60: p_certification_id, 'SUBSIDIARY', p_child_id, 'SUBSIDIARY',
61: l_parent_id, 1, sysdate, fnd_global.user_id, sysdate,
62: fnd_global.user_id, fnd_global.login_id, 1, 'N');
63:
64: recursive_populate_hier(p_certification_id, l_parent_id);
65: ELSE
66: CLOSE row_exists_check;

Line 201: last_updated_by = fnd_global.user_id,

197: 0, 0,
198: trunc(100 * sum_query.ineffective_controls /
199: sum_query.total_controls)),
200: last_update_date = sysdate,
201: last_updated_by = fnd_global.user_id,
202: last_update_login = fnd_global.login_id
203: WHEN NOT MATCHED THEN
204: INSERT
205: (cert_org_aggr_sum_id,

Line 202: last_update_login = fnd_global.login_id

198: trunc(100 * sum_query.ineffective_controls /
199: sum_query.total_controls)),
200: last_update_date = sysdate,
201: last_updated_by = fnd_global.user_id,
202: last_update_login = fnd_global.login_id
203: WHEN NOT MATCHED THEN
204: INSERT
205: (cert_org_aggr_sum_id,
206: certification_id,

Line 258: fnd_global.user_id,

254: sum_query.open_findings,
255: sum_query.open_issues,
256: sum_query.top_org_processes,
257: sum_query.top_org_proc_pending_cert,
258: fnd_global.user_id,
259: sysdate,
260: fnd_global.user_id,
261: sysdate,
262: fnd_global.login_id,

Line 260: fnd_global.user_id,

256: sum_query.top_org_processes,
257: sum_query.top_org_proc_pending_cert,
258: fnd_global.user_id,
259: sysdate,
260: fnd_global.user_id,
261: sysdate,
262: fnd_global.login_id,
263: 1,
264: sum_query.sub_org_cert_issues,

Line 262: fnd_global.login_id,

258: fnd_global.user_id,
259: sysdate,
260: fnd_global.user_id,
261: sysdate,
262: fnd_global.login_id,
263: 1,
264: sum_query.sub_org_cert_issues,
265: sum_query.proc_cert_issues,
266: decode(sum_query.total_processes,