APPS.IEX_SCORE_PVT dependencies on IEX_SCORE_COMPONENTS

Line 876: FROM IEX_SCORE_COMPONENTS

872: WHERE SCORE_ID = IN_SCORE_ID;
873: --
874: CURSOR C_GET_SCORE_COMPS (IN_SCORE_ID NUMBER) IS
875: SELECT SCORE_COMPONENT_ID
876: FROM IEX_SCORE_COMPONENTS
877: WHERE SCORE_ID = IN_SCORE_ID;
878: --
879: CURSOR C_GET_SCORE_FILTER (IN_SCORE_ID NUMBER) IS
880: SELECT OBJECT_FILTER_ID

Line 1075: SELECT IEX_SCORE_COMPONENTS_S.nextval

1071: x_SCORE_COMP_ID OUT NOCOPY NUMBER)
1072:
1073: IS
1074: CURSOR get_seq_csr is
1075: SELECT IEX_SCORE_COMPONENTS_S.nextval
1076: FROM sys.dual;
1077: --
1078:
1079: l_api_name CONSTANT VARCHAR2(30) := 'Create_Score_Comp';

Line 1179: IEX_SCORE_COMPONENTS_PKG.insert_row(

1175: WriteLog(l_msg || 'enabled='|| l_score_comp_rec.enabled_flag);
1176: WriteLog(l_msg || 'typeid='|| l_score_comp_rec.score_comp_type_id);
1177:
1178: -- Create Score Comp
1179: IEX_SCORE_COMPONENTS_PKG.insert_row(
1180: x_rowid => l_rowid
1181: , p_score_component_id => x_score_comp_id
1182: , p_last_update_date => sysdate
1183: , p_last_updated_by => FND_GLOBAL.USER_ID

Line 1264: from iex_score_components

1260: LAST_UPDATED_BY,
1261: CREATION_DATE,
1262: CREATED_BY ,
1263: LAST_UPDATE_LOGIN
1264: from iex_score_components
1265: where score_component_id = in_score_comp_id
1266: FOR UPDATE NOWAIT;
1267: --
1268: l_api_name CONSTANT VARCHAR2(30) := 'Update_Score_Comp';

Line 1364: FND_MESSAGE.Set_Token ('INFO', 'iex_score_components', FALSE);

1360: IF ( C_Get_SCORE_COMP_REC%NOTFOUND) THEN
1361: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1362: THEN
1363: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
1364: FND_MESSAGE.Set_Token ('INFO', 'iex_score_components', FALSE);
1365: FND_MSG_PUB.Add;
1366: END IF;
1367: RAISE FND_API.G_EXC_ERROR;
1368: END IF;

Line 1415: IEX_SCORE_COMPONENTS_PKG.update_row(

1411: -- cannot update score_id ???
1412:
1413: WriteLog('iexvscrb:UpdScrComp: Update Row');
1414:
1415: IEX_SCORE_COMPONENTS_PKG.update_row(
1416: x_rowid => l_rowid
1417: , p_score_component_id => l_score_comp_rec.score_component_id
1418: , p_score_comp_weight => l_score_comp_rec.score_comp_weight
1419: , p_score_id => l_score_comp_rec.score_id

Line 1491: FROM IEX_SCORE_COMPONENTS

1487:
1488: IS
1489: CURSOR C_GET_SCORE_COMP (IN_SCORE_COMP_ID NUMBER) IS
1490: SELECT rowid
1491: FROM IEX_SCORE_COMPONENTS
1492: WHERE SCORE_COMPONENT_ID = IN_SCORE_COMP_ID;
1493: --
1494: CURSOR C_GET_SCORE_COMP_DET (IN_SCORE_COMP_ID NUMBER) IS
1495: SELECT Score_Comp_Det_id

Line 1547: FND_MESSAGE.Set_Token ('INFO', 'iex_score_components', FALSE);

1543: IF ( C_Get_Score_Comp%NOTFOUND) THEN
1544: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1545: THEN
1546: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
1547: FND_MESSAGE.Set_Token ('INFO', 'iex_score_components', FALSE);
1548: FND_MSG_PUB.Add;
1549: END IF;
1550: RAISE FND_API.G_EXC_ERROR;
1551: END IF;

Line 1559: IEX_SCORE_COMPONENTS_PKG.Delete_Row(

1555:
1556: WriteLog('iexvscrb:Delete_Score_Comp=>Delete Row');
1557:
1558: -- Invoke table handler
1559: IEX_SCORE_COMPONENTS_PKG.Delete_Row(
1560: x_rowid => l_rowid);
1561:
1562: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1563: RAISE FND_API.G_EXC_ERROR;

Line 2266: P_TABLE_NAME => 'IEX_SCORE_COMPONENTS',

2262:
2263: -- Validate Data
2264: IEX_UTILITIES.VALIDATE_ANY_ID(P_COL_ID => l_score_comp_det_rec.score_component_id,
2265: P_COL_NAME => 'SCORE_COMPONENT_ID',
2266: P_TABLE_NAME => 'IEX_SCORE_COMPONENTS',
2267: X_Return_Status => x_return_status,
2268: X_Msg_Count => x_msg_count,
2269: X_Msg_Data => x_msg_data,
2270: P_Init_Msg_List => FND_API.G_FALSE);

Line 2754: FROM IEX_SCORE_COMPONENTS

2750: WHERE SCORE_ID = IN_SCORE_ID;
2751: --
2752: CURSOR C_GET_SCORE_COMPS (IN_SCORE_ID NUMBER) IS
2753: SELECT SCORE_COMPONENT_ID
2754: FROM IEX_SCORE_COMPONENTS
2755: WHERE SCORE_ID = IN_SCORE_ID;
2756: --
2757: CURSOR C_get_Score_Comp_Rec (IN_SCORE_COMP_ID NUMBER) is
2758: select SCORE_COMP_WEIGHT,

Line 2762: from iex_score_components

2758: select SCORE_COMP_WEIGHT,
2759: SCORE_ID,
2760: ENABLED_FLAG,
2761: SCORE_COMP_TYPE_ID
2762: from iex_score_components
2763: where score_component_id = in_score_comp_id;
2764: --
2765: CURSOR C_GET_SCORE_COMP_DET (IN_SCORE_COMP_ID NUMBER) IS
2766: SELECT Score_Comp_Det_id