eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_SCORE_PVT dependencies on IEX_SCORES

Line 33: P_TABLE_NAME => 'IEX_SCORES',

29: FND_MSG_PUB.initialize;
30: END IF;
31: IEX_UTILITIES.VALIDATE_ANY_ID(P_COL_ID => l_score_rec.score_id,
32: P_COL_NAME => 'SCORE_ID',
33: P_TABLE_NAME => 'IEX_SCORES',
34: X_Return_Status => x_return_status,
35: X_Msg_Count => x_msg_count,
36: X_Msg_Data => x_msg_data,
37: P_Init_Msg_List => FND_API.G_FALSE);

Line 76: FROM iex_scores

72: X_Msg_Data OUT NOCOPY VARCHAR2)
73: IS
74: CURSOR C_GET_SCORE_name (IN_SCORE_Name VARCHAR2, IN_SCORE_ID NUMBER) IS
75: SELECT score_Name
76: FROM iex_scores
77: WHERE SCORE_Name = IN_SCORE_Name
78: AND SCORE_ID <> IN_SCORE_ID;
79: --
80: l_score_Name VARCHAR2(256);

Line 155: FROM iex_scores

151: X_Msg_Data OUT NOCOPY VARCHAR2)
152: IS
153: CURSOR C_GET_SCORE_ID_name (IN_SCORE_Name VARCHAR2, IN_SCORE_ID NUMBER) IS
154: SELECT score_Name
155: FROM iex_scores
156: WHERE SCORE_Name = IN_SCORE_Name and score_id <> IN_Score_ID;
157: --
158: l_score_Name VARCHAR2(256);
159:

Line 345: SELECT IEX_SCORES_S.nextval

341: x_msg_data OUT NOCOPY VARCHAR2,
342: X_SCORE_ID OUT NOCOPY NUMBER)
343: IS
344: CURSOR get_seq_csr is
345: SELECT IEX_SCORES_S.nextval
346: FROM sys.dual;
347: --
348: l_api_name CONSTANT VARCHAR2(30) := 'Create_Score';
349: l_api_version_number CONSTANT NUMBER := 1.0;

Line 484: IEX_SCORES_PKG.insert_row(

480:
481: WriteLog(l_msg || 'insert row');
482:
483: -- Create Score
484: IEX_SCORES_PKG.insert_row(
485: x_rowid => l_rowid
486: , p_score_id => x_score_id
487: , p_security_group_id => l_score_rec.security_group_id
488: , p_score_name => l_score_rec.score_name

Line 596: from iex_scores

592: WEIGHT_REQUIRED,
593: SCORE_RANGE_LOW,
594: SCORE_RANGE_HIGH,
595: OUT_OF_RANGE_RULE
596: from iex_scores
597: where score_id = in_score_id
598: FOR UPDATE NOWAIT;
599: --
600: l_api_name CONSTANT VARCHAR2(30) := 'Update_Score';

Line 696: FND_MESSAGE.Set_Token ('INFO', 'iex_scores', FALSE);

692: IF ( C_Get_SCORE_REC%NOTFOUND) THEN
693: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
694: THEN
695: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
696: FND_MESSAGE.Set_Token ('INFO', 'iex_scores', FALSE);
697: FND_MSG_PUB.Add;
698: END IF;
699: RAISE FND_API.G_EXC_ERROR;
700: END IF;

Line 780: IEX_SCORES_PKG.update_row(

776: END IF;
777:
778: WriteLog('iexvscrb:UpdScr: update row');
779:
780: IEX_SCORES_PKG.update_row(
781: x_rowid => l_rowid
782: , p_score_id => l_score_rec.score_id
783: , p_security_group_id => l_score_rec.security_group_id
784: , p_score_name => l_score_rec.score_name

Line 871: FROM IEX_SCORES

867:
868: IS
869: CURSOR C_GET_SCORE (IN_SCORE_ID NUMBER) IS
870: SELECT rowid
871: FROM IEX_SCORES
872: WHERE SCORE_ID = IN_SCORE_ID;
873: --
874: CURSOR C_GET_SCORE_COMPS (IN_SCORE_ID NUMBER) IS
875: SELECT SCORE_COMPONENT_ID

Line 938: FND_MESSAGE.Set_Token ('INFO', 'iex_scores', FALSE);

934: l_rowid;
935:
936: IF ( C_Get_Score%NOTFOUND) THEN
937: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
938: FND_MESSAGE.Set_Token ('INFO', 'iex_scores', FALSE);
939: FND_MSG_PUB.Add;
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;

Line 951: IEX_SCORES_PKG.Delete_Row(

947: WriteLog( 'iexvscrb: DelScr: Delete Row');
948:
949:
950: -- Invoke table handler
951: IEX_SCORES_PKG.Delete_Row(
952: x_rowid => l_rowid);
953:
954: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
955: RAISE FND_API.G_EXC_ERROR;

Line 1129: P_TABLE_NAME => 'IEX_SCORES',

1125: WriteLog(l_msg || 'score_id='||l_score_comp_rec.score_id);
1126:
1127: IEX_UTILITIES.VALIDATE_ANY_ID(P_COL_ID => l_score_comp_rec.score_id,
1128: P_COL_NAME => 'SCORE_ID',
1129: P_TABLE_NAME => 'IEX_SCORES',
1130: X_Return_Status => x_return_status,
1131: X_Msg_Count => x_msg_count,
1132: X_Msg_Data => x_msg_data,
1133: P_Init_Msg_List => FND_API.G_FALSE);

Line 1318: P_TABLE_NAME => 'IEX_SCORES',

1314: WriteLog('iexvscrb:UpdScrComp: Validate Score_ID');
1315:
1316: IEX_UTILITIES.VALIDATE_ANY_ID(P_COL_ID => l_score_comp_rec.score_id,
1317: P_COL_NAME => 'SCORE_ID',
1318: P_TABLE_NAME => 'IEX_SCORES',
1319: X_Return_Status => x_return_status,
1320: X_Msg_Count => x_msg_count,
1321: X_Msg_Data => x_msg_data,
1322: P_Init_Msg_List => FND_API.G_FALSE);

Line 2749: FROM IEX_SCORES

2745: WEIGHT_REQUIRED,
2746: SCORE_RANGE_LOW,
2747: SCORE_RANGE_HIGH,
2748: OUT_OF_RANGE_RULE
2749: FROM IEX_SCORES
2750: WHERE SCORE_ID = IN_SCORE_ID;
2751: --
2752: CURSOR C_GET_SCORE_COMPS (IN_SCORE_ID NUMBER) IS
2753: SELECT SCORE_COMPONENT_ID

Line 3575: FROM IEX_SCORES

3571:
3572: -- use this to get the valid active score_card_id
3573: CURSOR c_score_name (p_score_name VARCHAR2) IS
3574: SELECT SCORE_ID
3575: FROM IEX_SCORES
3576: WHERE SCORE_NAME = p_score_name AND
3577: ENABLED_FLAG = 'Y' AND
3578: VALID_FROM_DT < sysdate AND
3579: VALID_TO_DT >= sysdate;

Line 3583: FROM IEX_SCORES

3579: VALID_TO_DT >= sysdate;
3580:
3581: CURSOR c_score_id (p_score_id VARCHAR2) IS
3582: SELECT SCORE_ID
3583: FROM IEX_SCORES
3584: WHERE SCORE_ID = p_score_id AND
3585: ENABLED_FLAG = 'Y' AND
3586: VALID_FROM_DT < sysdate AND
3587: VALID_TO_DT >= sysdate;