APPS.IEX_SCORE_PVT dependencies on IEX_SCORE_COMP_TYPES_B

Line 1654: SELECT IEX_SCORE_COMP_TYPES_B_S.nextval

1650: x_SCORE_COMP_TYPE_ID OUT NOCOPY NUMBER)
1651:
1652: IS
1653: CURSOR get_seq_csr is
1654: SELECT IEX_SCORE_COMP_TYPES_B_S.nextval
1655: FROM sys.dual;
1656: --
1657:
1658: l_api_name CONSTANT VARCHAR2(30) := 'Create_Score_Comp_Type';

Line 1827: from iex_score_comp_types_b

1823: LAST_UPDATE_LOGIN,
1824: FUNCTION_FLAG,
1825: METRIC_FLAG,
1826: DISPLAY_ORDER
1827: from iex_score_comp_types_b
1828: where score_comp_type_id = in_score_comp_type_id
1829: FOR UPDATE NOWAIT;
1830: --
1831: CURSOR C_get_Score_Comp_Type_TL_Rec (IN_SCORE_COMP_Type_ID NUMBER) is

Line 1909: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_types_b', FALSE);

1905:
1906: IF ( C_Get_SCORE_COMP_TYPE_B_REC%NOTFOUND) THEN
1907: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1908: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
1909: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_types_b', FALSE);
1910: FND_MSG_PUB.Add;
1911: END IF;
1912: RAISE FND_API.G_EXC_ERROR;
1913: END IF;

Line 2083: FROM IEX_SCORE_COMP_TYPES_B

2079:
2080: IS
2081: CURSOR C_GET_TYPE (IN_SCORE_COMP_TYPE_ID NUMBER) IS
2082: SELECT rowid
2083: FROM IEX_SCORE_COMP_TYPES_B
2084: WHERE SCORE_COMP_TYPE_ID = IN_SCORE_COMP_TYPE_ID;
2085: --
2086: l_score_comp_Type_id NUMBER ;
2087: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Score_Comp_Type';