APPS.GMS_LD_PKG dependencies on GMS_ENCUMBRANCE_ITEMS_ALL

Line 520: FROM gms_encumbrance_items_all gei

516: -- encumbrance Item details.
517:
518: CURSOR c_original_enc_exists IS
519: SELECT net_zero_adjustment_flag,amount
520: FROM gms_encumbrance_items_all gei
521: WHERE gei.transaction_source = P_transaction_source
522: AND gei.encumbrance_item_id = l_orig_enc_item_id ;
523:
524: BEGIN

Line 1289: from gms_encumbrance_items_all gei

1285: begin
1286: x_dummy := 0 ;
1287: select count(*)
1288: into x_dummy
1289: from gms_encumbrance_items_all gei
1290: where orig_transaction_reference = trxRec.orig_transaction_reference
1291: and transaction_source = P_TRANSACTION_SOURCE ;
1292:
1293: if x_dummy > 0 then

Line 1416: UPDATE gms_encumbrance_items_all

1412: AND transaction_source = P_TRANSACTION_SOURCE;*/
1413:
1414: -- Bug 3465939 : Updating the original encumbrance Item to Net zero.
1415:
1416: UPDATE gms_encumbrance_items_all
1417: SET net_zero_adjustment_flag = 'Y'
1418: WHERE encumbrance_item_id = l_orig_enc_item_id;
1419:
1420: ELSE

Line 1530: l_orig_enc_item_id1 IN gms_encumbrance_items_all.encumbrance_item_id%TYPE -- Original Encumbrance Item Id

1526: PROCEDURE Validate_Dates_YN
1527: ( l_award_id1 IN gms_awards_all.award_id%TYPE, -- Original Encumbrance Award Id
1528: l_project_id1 IN pa_projects_all.project_id%TYPE, -- Original Encumbrance Project Id
1529: l_task_id1 IN pa_tasks.task_id%TYPE, -- Original Encumbrance Task Id
1530: l_orig_enc_item_id1 IN gms_encumbrance_items_all.encumbrance_item_id%TYPE -- Original Encumbrance Item Id
1531: ) IS
1532:
1533: -- The following cursor is to get the maximum start date and minimum completion date
1534: -- out of award, project and task's start and end dates.

Line 1563: FROM gms_encumbrance_items_all

1559: -- dates there is no need to do the date validation for the reversal encumbrance item.
1560:
1561: CURSOR Cur_Check_EncItemDate IS
1562: SELECT 1
1563: FROM gms_encumbrance_items_all
1564: WHERE encumbrance_item_id = l_orig_enc_item_id1
1565: AND (encumbrance_item_date < l_max_start_date OR encumbrance_item_date > l_min_end_date);
1566:
1567: l_Check_EncItemDate NUMBER := 0;