DBA Data[Home] [Help]

APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_ENCUMBRANCE_ITEMS_ALL

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;