277: l_cmt_rejection_code t_vc80_tab ;
278: l_cmt_header_id t_num_tab ;
279: BEGIN
280:
281: l_last_updated_by := FND_GLOBAL.USER_ID;
282: l_last_update_date := FND_GLOBAL.USER_ID;
283: l_created_by := FND_GLOBAL.USER_ID;
284: l_last_update_login := FND_GLOBAL.LOGIN_ID;
285: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
278: l_cmt_header_id t_num_tab ;
279: BEGIN
280:
281: l_last_updated_by := FND_GLOBAL.USER_ID;
282: l_last_update_date := FND_GLOBAL.USER_ID;
283: l_created_by := FND_GLOBAL.USER_ID;
284: l_last_update_login := FND_GLOBAL.LOGIN_ID;
285: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
286: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
279: BEGIN
280:
281: l_last_updated_by := FND_GLOBAL.USER_ID;
282: l_last_update_date := FND_GLOBAL.USER_ID;
283: l_created_by := FND_GLOBAL.USER_ID;
284: l_last_update_login := FND_GLOBAL.LOGIN_ID;
285: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
286: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
287: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
280:
281: l_last_updated_by := FND_GLOBAL.USER_ID;
282: l_last_update_date := FND_GLOBAL.USER_ID;
283: l_created_by := FND_GLOBAL.USER_ID;
284: l_last_update_login := FND_GLOBAL.LOGIN_ID;
285: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
286: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
287: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
288:
281: l_last_updated_by := FND_GLOBAL.USER_ID;
282: l_last_update_date := FND_GLOBAL.USER_ID;
283: l_created_by := FND_GLOBAL.USER_ID;
284: l_last_update_login := FND_GLOBAL.LOGIN_ID;
285: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
286: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
287: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
288:
289: IF p_start_project_id is NULL then
282: l_last_update_date := FND_GLOBAL.USER_ID;
283: l_created_by := FND_GLOBAL.USER_ID;
284: l_last_update_login := FND_GLOBAL.LOGIN_ID;
285: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
286: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
287: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
288:
289: IF p_start_project_id is NULL then
290: return ;
283: l_created_by := FND_GLOBAL.USER_ID;
284: l_last_update_login := FND_GLOBAL.LOGIN_ID;
285: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
286: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
287: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
288:
289: IF p_start_project_id is NULL then
290: return ;
291: END IF ;
2372: x_last_update_login number(15);
2373: x_request_id number(15);
2374: begin
2375:
2376: x_last_updated_by := FND_GLOBAL.USER_ID;
2377: x_last_update_login := FND_GLOBAL.LOGIN_ID;
2378: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2379:
2380: UPDATE gms_encumbrance_items_all ITEM
2373: x_request_id number(15);
2374: begin
2375:
2376: x_last_updated_by := FND_GLOBAL.USER_ID;
2377: x_last_update_login := FND_GLOBAL.LOGIN_ID;
2378: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2379:
2380: UPDATE gms_encumbrance_items_all ITEM
2381: SET ITEM.enc_distributed_flag =
2374: begin
2375:
2376: x_last_updated_by := FND_GLOBAL.USER_ID;
2377: x_last_update_login := FND_GLOBAL.LOGIN_ID;
2378: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2379:
2380: UPDATE gms_encumbrance_items_all ITEM
2381: SET ITEM.enc_distributed_flag =
2382: DECODE(ITEM.enc_distributed_flag,
2458: x_last_updated_by number(15);
2459: x_last_update_login number(15);
2460: x_request_id number(15);
2461: begin
2462: x_last_updated_by := FND_GLOBAL.USER_ID;
2463: x_last_update_login := FND_GLOBAL.LOGIN_ID;
2464: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2465:
2466: if p_mode = 'T' then --Update when task.cost_ind_sch_fixed_date is populated.
2459: x_last_update_login number(15);
2460: x_request_id number(15);
2461: begin
2462: x_last_updated_by := FND_GLOBAL.USER_ID;
2463: x_last_update_login := FND_GLOBAL.LOGIN_ID;
2464: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2465:
2466: if p_mode = 'T' then --Update when task.cost_ind_sch_fixed_date is populated.
2467: --update commented for the Bug#5989869
2460: x_request_id number(15);
2461: begin
2462: x_last_updated_by := FND_GLOBAL.USER_ID;
2463: x_last_update_login := FND_GLOBAL.LOGIN_ID;
2464: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2465:
2466: if p_mode = 'T' then --Update when task.cost_ind_sch_fixed_date is populated.
2467: --update commented for the Bug#5989869
2468: --Bug 9885825: Reverted the changes of bug 5989869
2589: gms_error_pkg.gms_debug(',p_project_id:' || p_project_id || ',p_task_id:' || p_task_id || ',p_idc_schedule_fixed_date:' || p_idc_schedule_fixed_date, 'C');
2590: gms_error_pkg.gms_debug(',p_calling_form:' || p_calling_form || ',p_event:' || p_event, 'C');
2591: END IF;
2592:
2593: x_last_updated_by := FND_GLOBAL.USER_ID;
2594: x_last_update_login := FND_GLOBAL.LOGIN_ID;
2595: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2596:
2597: begin /* added for bug 7225876 */
2590: gms_error_pkg.gms_debug(',p_calling_form:' || p_calling_form || ',p_event:' || p_event, 'C');
2591: END IF;
2592:
2593: x_last_updated_by := FND_GLOBAL.USER_ID;
2594: x_last_update_login := FND_GLOBAL.LOGIN_ID;
2595: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2596:
2597: begin /* added for bug 7225876 */
2598: select aw.status, aw.close_date
2591: END IF;
2592:
2593: x_last_updated_by := FND_GLOBAL.USER_ID;
2594: x_last_update_login := FND_GLOBAL.LOGIN_ID;
2595: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2596:
2597: begin /* added for bug 7225876 */
2598: select aw.status, aw.close_date
2599: into l_award_status,l_close_date