DBA Data[Home] [Help]

APPS.AMW_PROJECT_EVENT_PVT dependencies on FND_GLOBAL

Line 17: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

13: -- End of Comments
14: -- ===============================================================
15: g_pkg_name CONSTANT VARCHAR2 (30) := 'AMW_PROJECT_EVENT_PVT';
16: g_file_name CONSTANT VARCHAR2 (12) := 'amwvpceb.pls';
17: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
18: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
19:
20: FUNCTION Scope_Update
21: ( p_subscription_guid in raw,

Line 18: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

14: -- ===============================================================
15: g_pkg_name CONSTANT VARCHAR2 (30) := 'AMW_PROJECT_EVENT_PVT';
16: g_file_name CONSTANT VARCHAR2 (12) := 'amwvpceb.pls';
17: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
18: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
19:
20: FUNCTION Scope_Update
21: ( p_subscription_guid in raw,
22: p_event in out NOCOPY wf_event_t

Line 186: last_updated_by = fnd_global.user_id,

182:
183: IF l_obj_name = 'AMW_ORGANIZATION' THEN
184: UPDATE amw_audit_scope_organizations
185: SET last_update_date = sysdate,
186: last_updated_by = fnd_global.user_id,
187: last_update_login = fnd_global.conc_login_id,
188: evaluation_opinion_id = l_opin_id
189: WHERE organization_id = l_pk1
190: AND audit_project_id = l_pk2;

Line 187: last_update_login = fnd_global.conc_login_id,

183: IF l_obj_name = 'AMW_ORGANIZATION' THEN
184: UPDATE amw_audit_scope_organizations
185: SET last_update_date = sysdate,
186: last_updated_by = fnd_global.user_id,
187: last_update_login = fnd_global.conc_login_id,
188: evaluation_opinion_id = l_opin_id
189: WHERE organization_id = l_pk1
190: AND audit_project_id = l_pk2;
191:

Line 194: last_updated_by = fnd_global.user_id,

190: AND audit_project_id = l_pk2;
191:
192: UPDATE amw_audit_scope_organizations
193: SET last_update_date = sysdate,
194: last_updated_by = fnd_global.user_id,
195: last_update_login = fnd_global.conc_login_id,
196: sub_orgs_evaluated = least(sub_orgs_evaluated+l_evaluated_diff,total_sub_orgs),
197: ineffective_sub_orgs =
198: least(greatest(0,ineffective_sub_orgs+l_ineff_diff),sub_orgs_evaluated+l_evaluated_diff,total_sub_orgs)

Line 195: last_update_login = fnd_global.conc_login_id,

191:
192: UPDATE amw_audit_scope_organizations
193: SET last_update_date = sysdate,
194: last_updated_by = fnd_global.user_id,
195: last_update_login = fnd_global.conc_login_id,
196: sub_orgs_evaluated = least(sub_orgs_evaluated+l_evaluated_diff,total_sub_orgs),
197: ineffective_sub_orgs =
198: least(greatest(0,ineffective_sub_orgs+l_ineff_diff),sub_orgs_evaluated+l_evaluated_diff,total_sub_orgs)
199: WHERE organization_id IN (

Line 215: last_updated_by = fnd_global.user_id,

211:
212: ELSIF l_obj_name = 'AMW_ORG_PROCESS' THEN
213: UPDATE amw_audit_scope_processes
214: SET last_update_date = sysdate,
215: last_updated_by = fnd_global.user_id,
216: last_update_login = fnd_global.conc_login_id,
217: evaluation_opinion_id = l_opin_id
218: WHERE process_id = l_pk1
219: AND audit_project_id = l_pk2

Line 216: last_update_login = fnd_global.conc_login_id,

212: ELSIF l_obj_name = 'AMW_ORG_PROCESS' THEN
213: UPDATE amw_audit_scope_processes
214: SET last_update_date = sysdate,
215: last_updated_by = fnd_global.user_id,
216: last_update_login = fnd_global.conc_login_id,
217: evaluation_opinion_id = l_opin_id
218: WHERE process_id = l_pk1
219: AND audit_project_id = l_pk2
220: AND organization_id = l_pk3;

Line 224: last_updated_by = fnd_global.user_id,

220: AND organization_id = l_pk3;
221:
222: UPDATE amw_audit_scope_organizations
223: SET last_update_date = sysdate,
224: last_updated_by = fnd_global.user_id,
225: last_update_login = fnd_global.conc_login_id,
226: processes_evaluated = least(processes_evaluated+l_evaluated_diff,total_processes),
227: ineffective_processes =
228: least(greatest(0,ineffective_processes+l_ineff_diff),processes_evaluated+l_evaluated_diff,total_processes)

Line 225: last_update_login = fnd_global.conc_login_id,

221:
222: UPDATE amw_audit_scope_organizations
223: SET last_update_date = sysdate,
224: last_updated_by = fnd_global.user_id,
225: last_update_login = fnd_global.conc_login_id,
226: processes_evaluated = least(processes_evaluated+l_evaluated_diff,total_processes),
227: ineffective_processes =
228: least(greatest(0,ineffective_processes+l_ineff_diff),processes_evaluated+l_evaluated_diff,total_processes)
229: WHERE audit_project_id = l_pk2

Line 234: last_updated_by = fnd_global.user_id,

230: AND organization_id = l_pk3;
231: ELSIF l_obj_name = 'AMW_ORG_PROCESS_RISK' THEN
232: UPDATE amw_audit_scope_organizations
233: SET last_update_date = sysdate,
234: last_updated_by = fnd_global.user_id,
235: last_update_login = fnd_global.conc_login_id,
236: risks_evaluated =
237: least(risks_evaluated+l_evaluated_diff,total_risks),
238: unmitigated_risks =

Line 235: last_update_login = fnd_global.conc_login_id,

231: ELSIF l_obj_name = 'AMW_ORG_PROCESS_RISK' THEN
232: UPDATE amw_audit_scope_organizations
233: SET last_update_date = sysdate,
234: last_updated_by = fnd_global.user_id,
235: last_update_login = fnd_global.conc_login_id,
236: risks_evaluated =
237: least(risks_evaluated+l_evaluated_diff,total_risks),
238: unmitigated_risks =
239: least(greatest(0,unmitigated_risks+l_ineff_diff),risks_evaluated+l_evaluated_diff,total_risks)

Line 245: last_updated_by = fnd_global.user_id,

241: AND organization_id = l_pk3;
242:
243: UPDATE amw_audit_scope_processes
244: SET last_update_date = sysdate,
245: last_updated_by = fnd_global.user_id,
246: last_update_login = fnd_global.conc_login_id,
247: risks_evaluated =
248: least(risks_evaluated+l_evaluated_diff,total_risks),
249: unmitigated_risks =

Line 246: last_update_login = fnd_global.conc_login_id,

242:
243: UPDATE amw_audit_scope_processes
244: SET last_update_date = sysdate,
245: last_updated_by = fnd_global.user_id,
246: last_update_login = fnd_global.conc_login_id,
247: risks_evaluated =
248: least(risks_evaluated+l_evaluated_diff,total_risks),
249: unmitigated_risks =
250: least(greatest(0,unmitigated_risks+l_ineff_diff),risks_evaluated+l_evaluated_diff,total_risks)

Line 268: last_updated_by = fnd_global.user_id,

264: ELSIF l_obj_name = 'AMW_ORG_CONTROL' THEN
265:
266: UPDATE amw_audit_scope_organizations
267: SET last_update_date = sysdate,
268: last_updated_by = fnd_global.user_id,
269: last_update_login = fnd_global.conc_login_id,
270: controls_evaluated =
271: least(controls_evaluated+l_evaluated_diff,total_controls),
272: ineffective_controls =

Line 269: last_update_login = fnd_global.conc_login_id,

265:
266: UPDATE amw_audit_scope_organizations
267: SET last_update_date = sysdate,
268: last_updated_by = fnd_global.user_id,
269: last_update_login = fnd_global.conc_login_id,
270: controls_evaluated =
271: least(controls_evaluated+l_evaluated_diff,total_controls),
272: ineffective_controls =
273: least(greatest(0,ineffective_controls+l_ineff_diff),controls_evaluated+l_evaluated_diff,total_controls)

Line 279: last_updated_by = fnd_global.user_id,

275: AND organization_id = l_pk3;
276:
277: UPDATE amw_audit_scope_processes
278: SET last_update_date = sysdate,
279: last_updated_by = fnd_global.user_id,
280: last_update_login = fnd_global.conc_login_id,
281: controls_evaluated =
282: least(controls_evaluated+l_evaluated_diff,total_controls),
283: ineffective_controls =

Line 280: last_update_login = fnd_global.conc_login_id,

276:
277: UPDATE amw_audit_scope_processes
278: SET last_update_date = sysdate,
279: last_updated_by = fnd_global.user_id,
280: last_update_login = fnd_global.conc_login_id,
281: controls_evaluated =
282: least(controls_evaluated+l_evaluated_diff,total_controls),
283: ineffective_controls =
284: least(greatest(0,ineffective_controls+l_ineff_diff),controls_evaluated+l_evaluated_diff,total_controls)