DBA Data[Home] [Help]

APPS.GMS_PA_API3 dependencies on FND_GLOBAL

Line 281: l_last_updated_by := FND_GLOBAL.USER_ID;

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;

Line 282: l_last_update_date := FND_GLOBAL.USER_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;

Line 283: l_created_by := FND_GLOBAL.USER_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;

Line 284: l_last_update_login := FND_GLOBAL.LOGIN_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:

Line 285: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

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

Line 286: l_program_application_id := FND_GLOBAL.PROG_APPL_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
290: return ;

Line 287: l_program_id := FND_GLOBAL.CONC_PROGRAM_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 ;
291: END IF ;

Line 2376: x_last_updated_by := FND_GLOBAL.USER_ID;

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

Line 2377: x_last_update_login := FND_GLOBAL.LOGIN_ID;

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 =

Line 2378: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;

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,

Line 2462: x_last_updated_by := FND_GLOBAL.USER_ID;

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.

Line 2463: x_last_update_login := FND_GLOBAL.LOGIN_ID;

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

Line 2464: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;

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

Line 2593: x_last_updated_by := FND_GLOBAL.USER_ID;

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 */

Line 2594: x_last_update_login := FND_GLOBAL.LOGIN_ID;

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

Line 2595: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;

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