[Home] [Help]
36: IS
37:
38: CURSOR C IS
39: SELECT rowid
40: FROM psb_flex_mapping_set_values
41: WHERE flex_mapping_value_id = p_flex_mapping_value_id ;
42:
43: --
44: P_LAST_UPDATE_DATE DATE;
88: raise FND_API.G_EXC_ERROR;
89: end if;
90: --
91:
92: INSERT INTO psb_flex_mapping_set_values
93: ( flex_mapping_set_id,
94: flex_mapping_value_id,
95: budget_year_type_id,
96: application_column_name,
209: Application_Column_Name,
210: Flex_Value_Set_ID,
211: Flex_Value_ID,
212: From_Flex_Value_ID
213: FROM psb_flex_mapping_set_values
214: WHERE Flex_Mapping_Value_ID = p_Flex_Mapping_Value_ID
215: FOR UPDATE of Flex_Mapping_Value_ID NOWAIT;
216: Recinfo C%ROWTYPE;
217:
394: FND_MSG_PUB.Add ;
395: raise FND_API.G_EXC_ERROR ;
396: end if;
397: --
398: UPDATE psb_flex_mapping_set_values
399: SET
400: Flex_Mapping_Set_ID = p_Flex_Mapping_Set_ID,
401: Flex_Mapping_Value_ID = p_Flex_Mapping_Value_ID ,
402: Budget_Year_Type_ID = p_Budget_Year_Type_ID ,
501: p_return_status := FND_API.G_RET_STS_SUCCESS ;
502: --
503:
504: --
505: -- Deleting the record in psb_flex_mapping_set_values.
506: --
507: DELETE psb_flex_mapping_set_values
508: WHERE Flex_Mapping_Value_ID = p_Flex_Mapping_Value_ID;
509:
503:
504: --
505: -- Deleting the record in psb_flex_mapping_set_values.
506: --
507: DELETE psb_flex_mapping_set_values
508: WHERE Flex_Mapping_Value_ID = p_Flex_Mapping_Value_ID;
509:
510: IF (SQL%NOTFOUND) THEN
511: RAISE NO_DATA_FOUND ;
742: END IF;
743: --
744: p_return_status := FND_API.G_RET_STS_SUCCESS ;
745: --
746: DELETE psb_flex_mapping_set_values
747: WHERE flex_mapping_set_id = p_flex_mapping_set_id ;
748:
749: DELETE psb_flex_mapping_sets
750: WHERE flex_mapping_set_id = p_flex_mapping_set_id;
1052: --
1053: END Sets_Update_Row;
1054:
1055: -- +++++++++++++++++++++++++++++++++
1056: -- This function maps segment values from psb_flex_mapping_set_values to the segment values
1057: -- of the input ccid. If no mapping record found, input ccid segment is unchanged
1058: -- p_mapping_mode of Worksheet,Report,GL_Posting
1059: -- return mapped ccid value if a valid ccid or 0 if invalid ccid
1060: -- +++++++++++++++++++++++++++++++++
1103: select fval.flex_value to_val ,
1104: fromval.flex_value from_val
1105: from fnd_flex_values_vl fval,
1106: fnd_flex_values_vl fromval,
1107: psb_flex_mapping_set_values map,
1108: fnd_id_flex_segments seg
1109: where flex_mapping_set_id = p_flexfield_mapping_set_id
1110: and budget_year_type_id = p_budget_year_type_id
1111: and map.flex_value_id = fval.flex_value_id(+)
1131: -- cursor for worksheet mapping_mode - uses from value
1132: cursor c_seginfo_ws is
1133: select fval.flex_value from_val , seg.application_column_name
1134: from fnd_flex_values_vl fval,
1135: psb_flex_mapping_set_values map,
1136: fnd_id_flex_segments seg
1137: where flex_mapping_set_id = p_flexfield_mapping_set_id
1138: and budget_year_type_id = l_cy_budget_year_type_id
1139: and map.from_flex_value_id = fval.flex_value_id
1145:
1146: cursor c_cy is
1147: select fval.flex_value curr_val
1148: from fnd_flex_values_vl fval,
1149: psb_flex_mapping_set_values map,
1150: fnd_id_flex_segments seg
1151: where flex_mapping_set_id = p_flexfield_mapping_set_id
1152: and budget_year_type_id = l_cy_budget_year_type_id
1153: and map.from_flex_value_id = fval.flex_value_id
1161:
1162: cursor c_py is
1163: select fval.flex_value curr_val
1164: from fnd_flex_values_vl fval,
1165: psb_flex_mapping_set_values map,
1166: fnd_id_flex_segments seg
1167: where flex_mapping_set_id = p_flexfield_mapping_set_id
1168: and budget_year_type_id = l_py_budget_year_type_id
1169: and map.from_flex_value_id = fval.flex_value_id
1447: select fval.flex_value to_val ,
1448: fromval.flex_value from_val
1449: from fnd_flex_values_vl fval,
1450: fnd_flex_values_vl fromval,
1451: psb_flex_mapping_set_values map,
1452: fnd_id_flex_segments seg
1453: where flex_mapping_set_id = p_flexfield_mapping_set_id
1454: and budget_year_type_id = p_budget_year_type_id
1455: and map.flex_value_id = fval.flex_value_id(+)
1474:
1475: cursor c_cy is
1476: select fval.flex_value curr_val
1477: from fnd_flex_values_vl fval,
1478: psb_flex_mapping_set_values map,
1479: fnd_id_flex_segments seg
1480: where flex_mapping_set_id = p_flexfield_mapping_set_id
1481: and budget_year_type_id = l_cy_budget_year_type_id
1482: and map.from_flex_value_id = fval.flex_value_id