DBA Data[Home] [Help]

APPS.IEX_SCORE_PVT dependencies on IEX_SCORE_COMP_TYPES_VL

Line 217: FROM iex_score_comp_types_vl

213: X_Msg_Data OUT NOCOPY VARCHAR2)
214: IS
215: CURSOR C_GET_SCORE_COMP_NAME (IN_SCORE_COMP_NAME VARCHAR2) IS
216: SELECT score_comp_Name
217: FROM iex_score_comp_types_vl
218: WHERE SCORE_comp_name = IN_SCORE_comp_Name;
219: --
220: l_score_comp_name VARCHAR2(30);
221:

Line 280: FROM iex_score_comp_types_vl

276: X_Msg_Data OUT NOCOPY VARCHAR2)
277: IS
278: CURSOR C_GET_SCORE_COMP_ID_NAME (IN_SCORE_COMP_NAME VARCHAR2, IN_SCORE_COMP_TYPE_ID NUMBER) IS
279: SELECT score_comp_Name
280: FROM iex_score_comp_types_vl
281: WHERE SCORE_comp_name = IN_SCORE_comp_Name
282: AND SCORE_COMP_TYPE_ID <> IN_SCORE_COMP_TYPE_ID;
283: --
284: l_score_comp_name VARCHAR2(30);

Line 1144: P_TABLE_NAME => 'IEX_SCORE_COMP_TYPES_VL',

1140: WriteLog(l_msg || 'type_id='||l_score_comp_rec.score_comp_type_id);
1141:
1142: IEX_UTILITIES.VALIDATE_ANY_ID(P_COL_ID => l_score_comp_rec.score_comp_type_id,
1143: P_COL_NAME => 'SCORE_COMP_TYPE_ID',
1144: P_TABLE_NAME => 'IEX_SCORE_COMP_TYPES_VL',
1145: X_Return_Status => x_return_status,
1146: X_Msg_Count => x_msg_count,
1147: X_Msg_Data => x_msg_data,
1148: P_Init_Msg_List => FND_API.G_FALSE);

Line 1332: P_TABLE_NAME => 'IEX_SCORE_COMP_TYPES_VL',

1328: WriteLog('iexvscrb:UpdScrComp: Validate Score_Comp_Type_ID');
1329:
1330: IEX_UTILITIES.VALIDATE_ANY_ID(P_COL_ID => l_score_comp_rec.score_comp_type_id,
1331: P_COL_NAME => 'SCORE_COMP_TYPE_ID',
1332: P_TABLE_NAME => 'IEX_SCORE_COMP_TYPES_VL',
1333: X_Return_Status => x_return_status,
1334: X_Msg_Count => x_msg_count,
1335: X_Msg_Data => x_msg_data,
1336: P_Init_Msg_List => FND_API.G_FALSE);