APPS.GMS_PA_API3 dependencies on GMS_ENCUMBRANCE_ITEMS_ALL

Line 2340: -- in gms_encumbrance_items_all.

2336: -- Pre_reqs : None
2337: -- Description : This procedure is called from
2338: -- pa_cost_plus.mark_impacted_exp_items (PAXCCPEB.pls).
2339: -- This procedure will mark all the burden impacted lines
2340: -- in gms_encumbrance_items_all.
2341: --
2342: -- Called from : pa_cost_plus.mark_impacted_exp_items
2343: -- Return Value : None
2344: --

Line 2378: UPDATE gms_encumbrance_items_all ITEM

2374: x_last_updated_by := FND_GLOBAL.USER_ID;
2375: x_last_update_login := FND_GLOBAL.LOGIN_ID;
2376: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2377:
2378: UPDATE gms_encumbrance_items_all ITEM
2379: SET ITEM.enc_distributed_flag =
2380: DECODE(ITEM.enc_distributed_flag,
2381: 'Y', decode(ITEM.ind_compiled_set_id,
2382: p_ind_compiled_set_id, 'N',

Line 2435: -- in gms_encumbrance_items_all.

2431: -- Pre_reqs : None
2432: -- Description : This procedure is called from
2433: -- pa_cost_plus.mark_prev_rev_exp_items (PAXCCPEB.pls).
2434: -- This procedure will mark all the burden impacted lines
2435: -- in gms_encumbrance_items_all.
2436: --
2437: -- Called from : pa_cost_plus.mark_prev_rev_exp_items
2438: -- Return Value : None
2439: --

Line 2467: /*UPDATE gms_encumbrance_items_all ei

2463:
2464: if p_mode = 'T' then --Update when task.cost_ind_sch_fixed_date is populated.
2465: NULL;
2466: --update commented for the Bug#5989869
2467: /*UPDATE gms_encumbrance_items_all ei
2468: SET enc_distributed_flag = 'N',
2469: adjustment_type ='BURDEN_RECOMPILE',
2470: last_update_date = SYSDATE,
2471: last_updated_by = x_last_updated_by,

Line 2488: /*UPDATE gms_encumbrance_items_all ei

2484: AND gms_pa_api2.is_award_closed(ei.encumbrance_item_id,ei.task_id, 'ENC') = 'N';*/
2485: elsif p_mode = 'N' then --Update based on task.cost_ind_sch_fixed_date IS NULL then go by enc_item_date
2486: NULL;
2487: --update commented for the Bug#5989869
2488: /*UPDATE gms_encumbrance_items_all ei
2489: SET enc_distributed_flag = 'N' ,
2490: adjustment_type ='BURDEN_RECOMPILE',
2491: last_update_date = SYSDATE,
2492: last_updated_by = x_last_updated_by,

Line 2508: UPDATE gms_encumbrance_items_all ei

2504: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y'
2505: AND gms_pa_api2.is_award_closed(ei.encumbrance_item_id,ei.task_id, 'ENC') = 'N'
2506: AND pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) = 'D';*/
2507: elsif p_mode = 'O' then --Update based on enc_item_date
2508: UPDATE gms_encumbrance_items_all ei
2509: SET enc_distributed_flag = 'N' ,
2510: adjustment_type ='BURDEN_RECOMPILE',
2511: last_update_date = SYSDATE,
2512: last_updated_by = x_last_updated_by,

Line 2619: UPDATE gms_encumbrance_items_all ITEM

2615: IF L_DEBUG = 'Y' THEN
2616: gms_error_pkg.gms_debug('Call is from OVERRIDE SCHEDULES SCREEN', 'C');
2617: END IF;
2618:
2619: UPDATE gms_encumbrance_items_all ITEM
2620: SET ITEM.enc_distributed_flag = 'N',
2621: ITEM.adjustment_type = 'BURDEN_RECALC',
2622: ITEM.ind_compiled_set_id = NULL,
2623: ITEM.last_update_date = SYSDATE,

Line 2674: UPDATE gms_encumbrance_items_all ITEM

2670: IF L_DEBUG = 'Y' THEN
2671: gms_error_pkg.gms_debug('Call is from AWARD MANAGEMENT SCREEN', 'C');
2672: END IF;
2673:
2674: UPDATE gms_encumbrance_items_all ITEM
2675: SET ITEM.enc_distributed_flag = 'N',
2676: ITEM.adjustment_type = 'BURDEN_RECALC',
2677: ITEM.ind_compiled_set_id = NULL,
2678: ITEM.last_update_date = SYSDATE,

Line 2715: UPDATE gms_encumbrance_items_all ITEM

2711: IF L_DEBUG = 'Y' THEN
2712: gms_error_pkg.gms_debug('call is from override schedule screen', 'C');
2713: END IF;
2714:
2715: UPDATE gms_encumbrance_items_all ITEM
2716: SET ITEM.enc_distributed_flag = 'N',
2717: ITEM.adjustment_type = 'BURDEN_RECALC',
2718: ITEM.ind_compiled_set_id = NULL,
2719: ITEM.last_update_date = SYSDATE,

Line 2768: UPDATE gms_encumbrance_items_all ITEM

2764: IF L_DEBUG = 'Y' THEN
2765: gms_error_pkg.gms_debug('Call is from award management screen', 'C');
2766: END IF;
2767:
2768: UPDATE gms_encumbrance_items_all ITEM
2769: SET ITEM.enc_distributed_flag = 'N',
2770: ITEM.adjustment_type = 'BURDEN_RECALC',
2771: ITEM.ind_compiled_set_id = NULL,
2772: ITEM.last_update_date = SYSDATE,