APPS.GMS_PA_API3 dependencies on GMS_ENCUMBRANCE_ITEMS_ALL

Line 2342: -- in gms_encumbrance_items_all.

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

Line 2380: UPDATE gms_encumbrance_items_all ITEM

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,
2383: 'Y', decode(ITEM.ind_compiled_set_id,
2384: p_ind_compiled_set_id, 'N',

Line 2437: -- in gms_encumbrance_items_all.

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

Line 2470: UPDATE gms_encumbrance_items_all ei

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
2469:
2470: UPDATE gms_encumbrance_items_all ei
2471: SET enc_distributed_flag = 'N',
2472: adjustment_type ='BURDEN_RECOMPILE',
2473: last_update_date = SYSDATE,
2474: last_updated_by = x_last_updated_by,

Line 2495: UPDATE gms_encumbrance_items_all ei

2491:
2492: --update commented for the Bug#5989869
2493: --Bug 9885825: Reverted the changes of bug 5989869
2494:
2495: UPDATE gms_encumbrance_items_all ei
2496: SET enc_distributed_flag = 'N' ,
2497: adjustment_type ='BURDEN_RECOMPILE',
2498: last_update_date = SYSDATE,
2499: last_updated_by = x_last_updated_by,

Line 2516: UPDATE gms_encumbrance_items_all ei

2512: AND gms_pa_api2.is_award_closed(ei.encumbrance_item_id,ei.task_id, 'ENC') = 'N'
2513: AND pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) = 'D';
2514:
2515: elsif p_mode = 'O' then --Update based on enc_item_date
2516: UPDATE gms_encumbrance_items_all ei
2517: SET enc_distributed_flag = 'N' ,
2518: adjustment_type ='BURDEN_RECOMPILE',
2519: last_update_date = SYSDATE,
2520: last_updated_by = x_last_updated_by,

Line 2646: UPDATE gms_encumbrance_items_all ITEM

2642: IF l_award_status <> 'CLOSED' AND l_close_date >= trunc (sysdate ) then /* bug 7225876 */
2643:
2644: l_project_closed := pa_project_stus_utils.Is_Project_Closed(p_project_id);
2645:
2646: UPDATE gms_encumbrance_items_all ITEM
2647: SET ITEM.enc_distributed_flag = 'N',
2648: ITEM.adjustment_type = 'BURDEN_RECALC',
2649: ITEM.ind_compiled_set_id = NULL,
2650: ITEM.last_update_date = SYSDATE,

Line 2707: UPDATE gms_encumbrance_items_all ITEM

2703: END IF;
2704:
2705: IF l_award_status <> 'CLOSED' AND l_close_date >= trunc (sysdate ) then -- bug 7225876
2706:
2707: UPDATE gms_encumbrance_items_all ITEM
2708: SET ITEM.enc_distributed_flag = 'N',
2709: ITEM.adjustment_type = 'BURDEN_RECALC',
2710: ITEM.ind_compiled_set_id = NULL,
2711: ITEM.last_update_date = SYSDATE,

Line 2755: UPDATE gms_encumbrance_items_all ITEM

2751: IF l_award_status <> 'CLOSED' AND l_close_date >= trunc (sysdate ) then -- bug 7225876
2752:
2753: l_project_closed := pa_project_stus_utils.Is_Project_Closed(p_project_id);
2754:
2755: UPDATE gms_encumbrance_items_all ITEM
2756: SET ITEM.enc_distributed_flag = 'N',
2757: ITEM.adjustment_type = 'BURDEN_RECALC',
2758: ITEM.ind_compiled_set_id = NULL,
2759: ITEM.last_update_date = SYSDATE,

Line 2814: UPDATE gms_encumbrance_items_all ITEM

2810: END IF;
2811:
2812: IF l_award_status <> 'CLOSED' AND l_close_date >= trunc (sysdate ) then
2813:
2814: UPDATE gms_encumbrance_items_all ITEM
2815: SET ITEM.enc_distributed_flag = 'N',
2816: ITEM.adjustment_type = 'BURDEN_RECALC',
2817: ITEM.ind_compiled_set_id = NULL,
2818: ITEM.last_update_date = SYSDATE,