DBA Data[Home] [Help]

APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_ENCUMBRANCE_ITEMS_ALL

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;