APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_ENCUMBRANCE_ITEMS

Line 618: from gms_encumbrance_items gei

614: and gbc.adjusted_document_header_id is NOT NULL
615: and gbc. adjusted_document_header_id <> gbc.document_header_id
616: and exists
617: (select 1
618: from gms_encumbrance_items gei
619: where gei.encumbrance_item_id = gbc.adjusted_document_header_id
620: and nvl(gei.enc_distributed_flag,'N') = 'N'
621: and nvl(request_id,-1) <> gbc.request_id
622: ) ;

Line 786: from gms_encumbrance_items gei,

782: -- Update 2 : For Adjusting (Reversing) transactions whose original transaction
783: -- was funds checked earlier
784: Update gms_bc_packets gbc
785: set gbc.ind_compiled_Set_id = (Select nvl(gei.ind_compiled_set_id, adl.ind_compiled_set_id) --Bug 5122879
786: from gms_encumbrance_items gei,
787: gms_award_distributions adl
788: where adl.expenditure_item_id =gbc.adjusted_document_header_id
789: and adl.adl_status = 'A'
790: and adl.fc_status = 'A'

Line 819: -- GMS_ENCUMBRANCE_ITEMS_ALL ENC_DISTRIBUTED_FLAG

815: -- BUD_TASK_ID(Budgeted Task)
816: -- BUD_RES_LIST_MEMBER_ID(Budgeted rlmi)
817: -- RAW_COST
818: -- IND_COMPILED_SET_ID
819: -- GMS_ENCUMBRANCE_ITEMS_ALL ENC_DISTRIBUTED_FLAG
820: --
821: -- DIFFERENT MODE USED FOR UPDATE
822: -- S - Submit
823: -- B - Baseline

Line 1121: UPDATE gms_encumbrance_items_all

1117: /* Commented for bug 5726575
1118: IF p_mode <> 'B' THEN
1119: g_error_stage := 'UPDATE_ENC_ITEM';
1120: FORALL I in tpacket_id.FIRST..tpacket_id.LAST
1121: UPDATE gms_encumbrance_items_all
1122: SET enc_distributed_flag = DECODE (SUBSTR (tresult_code(i), 1, 1), 'P', 'Y', 'N'),
1123: ind_compiled_set_id = tind_compiled_set_id(i)
1124: WHERE encumbrance_item_id = tdocument_header_id(i)
1125: AND tdocument_type(i) = 'ENC';

Line 1182: UPDATE gms_encumbrance_items_all

1178: LIMIT l_batch_size;
1179: IF tpacket_id.COUNT > 0 THEN
1180: IF p_mode <> 'B' THEN
1181: FORALL I in tpacket_id.FIRST..tpacket_id.LAST
1182: UPDATE gms_encumbrance_items_all
1183: SET enc_distributed_flag = DECODE (SUBSTR (tresult_code(i), 1, 1), 'P', 'Y', 'N'),
1184: ind_compiled_set_id = tind_compiled_set_id(i)
1185: WHERE encumbrance_item_id = tdocument_header_id(i);
1186: END IF;