APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_ENCUMBRANCE_ITEMS

Line 635: from gms_encumbrance_items gei

631: and gbc.adjusted_document_header_id is NOT NULL
632: and gbc. adjusted_document_header_id <> gbc.document_header_id
633: and exists
634: (select 1
635: from gms_encumbrance_items gei
636: where gei.encumbrance_item_id = gbc.adjusted_document_header_id
637: and nvl(gei.enc_distributed_flag,'N') = 'N'
638: and nvl(request_id,-1) <> gbc.request_id
639: ) ;

Line 804: from gms_encumbrance_items gei,

800: -- Update 2 : For Adjusting (Reversing) transactions whose original transaction
801: -- was funds checked earlier
802: Update gms_bc_packets gbc
803: set gbc.ind_compiled_Set_id = (Select nvl(gei.ind_compiled_set_id, adl.ind_compiled_set_id) --Bug 5122879
804: from gms_encumbrance_items gei,
805: gms_award_distributions adl
806: where adl.expenditure_item_id =gbc.adjusted_document_header_id
807: and adl.adl_status = 'A'
808: and adl.fc_status = 'A'

Line 837: -- GMS_ENCUMBRANCE_ITEMS_ALL ENC_DISTRIBUTED_FLAG

833: -- BUD_TASK_ID(Budgeted Task)
834: -- BUD_RES_LIST_MEMBER_ID(Budgeted rlmi)
835: -- RAW_COST
836: -- IND_COMPILED_SET_ID
837: -- GMS_ENCUMBRANCE_ITEMS_ALL ENC_DISTRIBUTED_FLAG
838: --
839: -- DIFFERENT MODE USED FOR UPDATE
840: -- S - Submit
841: -- B - Baseline

Line 1139: UPDATE gms_encumbrance_items_all

1135: /* Commented for bug 5726575
1136: IF p_mode <> 'B' THEN
1137: g_error_stage := 'UPDATE_ENC_ITEM';
1138: FORALL I in tpacket_id.FIRST..tpacket_id.LAST
1139: UPDATE gms_encumbrance_items_all
1140: SET enc_distributed_flag = DECODE (SUBSTR (tresult_code(i), 1, 1), 'P', 'Y', 'N'),
1141: ind_compiled_set_id = tind_compiled_set_id(i)
1142: WHERE encumbrance_item_id = tdocument_header_id(i)
1143: AND tdocument_type(i) = 'ENC';

Line 1200: UPDATE gms_encumbrance_items_all

1196: LIMIT l_batch_size;
1197: IF tpacket_id.COUNT > 0 THEN
1198: IF p_mode <> 'B' THEN
1199: FORALL I in tpacket_id.FIRST..tpacket_id.LAST
1200: UPDATE gms_encumbrance_items_all
1201: SET enc_distributed_flag = DECODE (SUBSTR (tresult_code(i), 1, 1), 'P', 'Y', 'N'),
1202: ind_compiled_set_id = tind_compiled_set_id(i)
1203: WHERE encumbrance_item_id = tdocument_header_id(i);
1204: END IF;