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