APPS.PA_ROLE_PROFILES_PKG dependencies on FND_GLOBAL

Line 61: FND_GLOBAL.USER_ID,

57: p_job_id,
58: p_position_id,
59: p_resource_id,
60: SYSDATE,
61: FND_GLOBAL.USER_ID,
62: SYSDATE,
63: FND_GLOBAL.USER_ID)
64: RETURNING
65: profile_id INTO x_profile_id;

Line 63: FND_GLOBAL.USER_ID)

59: p_resource_id,
60: SYSDATE,
61: FND_GLOBAL.USER_ID,
62: SYSDATE,
63: FND_GLOBAL.USER_ID)
64: RETURNING
65: profile_id INTO x_profile_id;
66:
67: EXCEPTION

Line 108: FND_GLOBAL.USER_ID,

104: (p_profile_id,
105: p_project_role_id,
106: p_role_weighting,
107: SYSDATE,
108: FND_GLOBAL.USER_ID,
109: SYSDATE,
110: FND_GLOBAL.USER_ID);
111:
112: EXCEPTION

Line 110: FND_GLOBAL.USER_ID);

106: p_role_weighting,
107: SYSDATE,
108: FND_GLOBAL.USER_ID,
109: SYSDATE,
110: FND_GLOBAL.USER_ID);
111:
112: EXCEPTION
113: WHEN OTHERS THEN -- catch the exceptins here
114: -- Set the exception Message and the stack

Line 161: last_updated_by = FND_GLOBAL.USER_ID

157: job_id = p_job_id,
158: position_id = p_position_id,
159: resource_id = p_resource_id,
160: last_update_date = SYSDATE,
161: last_updated_by = FND_GLOBAL.USER_ID
162: WHERE profile_id = p_profile_id;
163:
164: EXCEPTION
165: WHEN OTHERS THEN -- catch the exceptins here

Line 300: FND_GLOBAL.USER_ID,

296: p_effective_start_date,
297: p_effective_end_date,
298: 'ASGMT_APPRVL_APPROVED', -- should be changed
299: SYSDATE,
300: FND_GLOBAL.USER_ID,
301: SYSDATE,
302: FND_GLOBAL.USER_ID)
303: RETURNING
304: profile_id INTO l_profile_id;

Line 302: FND_GLOBAL.USER_ID)

298: 'ASGMT_APPRVL_APPROVED', -- should be changed
299: SYSDATE,
300: FND_GLOBAL.USER_ID,
301: SYSDATE,
302: FND_GLOBAL.USER_ID)
303: RETURNING
304: profile_id INTO l_profile_id;
305: dbms_output.put_line('after inserting pa_role_profiles, l_profile_id:'||l_profile_id);
306:

Line 324: FND_GLOBAL.USER_ID,

320: (l_profile_id,
321: l_role_id_tbl(i),
322: p_weighting_tbl(i),
323: SYSDATE,
324: FND_GLOBAL.USER_ID,
325: SYSDATE,
326: FND_GLOBAL.USER_ID);
327: END LOOP;
328:

Line 326: FND_GLOBAL.USER_ID);

322: p_weighting_tbl(i),
323: SYSDATE,
324: FND_GLOBAL.USER_ID,
325: SYSDATE,
326: FND_GLOBAL.USER_ID);
327: END LOOP;
328:
329: -------------------------------------------------------------------
330: -- Exceptions

Line 459: last_updated_by = FND_GLOBAL.USER_ID

455: effective_start_date = p_effective_start_date,
456: effective_end_date = p_effective_end_date,
457: approval_status_code = 'ASGMT_APPRVL_APPROVED', -- should be changed
458: last_update_date = SYSDATE,
459: last_updated_by = FND_GLOBAL.USER_ID
460: WHERE profile_id = p_profile_id;
461:
462: -------------------------------------------------------------------
463: -- Insert Resource Profile Lines to 'PA_ROLE_PROFILE_LINES'

Line 483: FND_GLOBAL.USER_ID,

479: (p_profile_id,
480: l_role_id_tbl(i),
481: p_weighting_tbl(i),
482: SYSDATE,
483: FND_GLOBAL.USER_ID,
484: SYSDATE,
485: FND_GLOBAL.USER_ID);
486: END LOOP;
487:

Line 485: FND_GLOBAL.USER_ID);

481: p_weighting_tbl(i),
482: SYSDATE,
483: FND_GLOBAL.USER_ID,
484: SYSDATE,
485: FND_GLOBAL.USER_ID);
486: END LOOP;
487:
488: -------------------------------------------------------------------
489: -- Exceptions