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.AS_SCORECARD_RULES_PVT dependencies on AS_SCORECARD_RULES_PUB

Line 10: P_CARDRULE_QUAL_rec IN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE,

6:
7: Procedure Validate_Seed_Qual(
8: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9: P_Validation_mode IN VARCHAR2,
10: P_CARDRULE_QUAL_rec IN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE,
11: X_Return_Status OUT NOCOPY VARCHAR2,
12: X_Msg_Count OUT NOCOPY NUMBER,
13: X_Msg_Data OUT NOCOPY VARCHAR2
14: )

Line 16: l_cardrule_qual_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE

12: X_Msg_Count OUT NOCOPY NUMBER,
13: X_Msg_Data OUT NOCOPY VARCHAR2
14: )
15: IS
16: l_cardrule_qual_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE
17: := p_cardrule_qual_rec;
18:
19: BEGIN
20: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 427: P_SCORECARD_REC IN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE

423: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
424: x_return_status OUT NOCOPY VARCHAR2,
425: x_msg_count OUT NOCOPY NUMBER,
426: x_msg_data OUT NOCOPY VARCHAR2,
427: P_SCORECARD_REC IN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE
428: := AS_SCORECARD_RULES_PUB.G_MISS_SCORECARD_REC,
429: X_SCORECARD_ID OUT NOCOPY NUMBER)
430: IS
431: CURSOR C_GET_SCORECARD_ID IS

Line 428: := AS_SCORECARD_RULES_PUB.G_MISS_SCORECARD_REC,

424: x_return_status OUT NOCOPY VARCHAR2,
425: x_msg_count OUT NOCOPY NUMBER,
426: x_msg_data OUT NOCOPY VARCHAR2,
427: P_SCORECARD_REC IN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE
428: := AS_SCORECARD_RULES_PUB.G_MISS_SCORECARD_REC,
429: X_SCORECARD_ID OUT NOCOPY NUMBER)
430: IS
431: CURSOR C_GET_SCORECARD_ID IS
432: SELECT AS_SALES_LEAD_SCORECARDS_S.NEXTVAL

Line 440: l_SALES_LEAD_SCORECARD_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE;

436: l_api_version_number CONSTANT NUMBER := 2.0;
437: l_scorecard_id NUMBER;
438: l_qual_value_id NUMBER;
439: l_rowid VARCHAR2(50);
440: l_SALES_LEAD_SCORECARD_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE;
441: /*l_CardRule_Qual_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE;*/
442:
443:
444: BEGIN

Line 441: /l_CardRule_Qual_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE;/

437: l_scorecard_id NUMBER;
438: l_qual_value_id NUMBER;
439: l_rowid VARCHAR2(50);
440: l_SALES_LEAD_SCORECARD_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE;
441: /*l_CardRule_Qual_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE;*/
442:
443:
444: BEGIN
445: -- Standard Start of API savepoint

Line 598: P_SCORECARD_REC IN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE

594: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
595: x_return_status OUT NOCOPY VARCHAR2,
596: x_msg_count OUT NOCOPY NUMBER,
597: x_msg_data OUT NOCOPY VARCHAR2,
598: P_SCORECARD_REC IN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE
599: := AS_SCORECARD_RULES_PUB.G_MISS_SCORECARD_REC)
600:
601: IS
602: CURSOR C_GET_LEAD_SCORECARD (IN_SCORECARD_ID NUMBER) IS

Line 599: := AS_SCORECARD_RULES_PUB.G_MISS_SCORECARD_REC)

595: x_return_status OUT NOCOPY VARCHAR2,
596: x_msg_count OUT NOCOPY NUMBER,
597: x_msg_data OUT NOCOPY VARCHAR2,
598: P_SCORECARD_REC IN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE
599: := AS_SCORECARD_RULES_PUB.G_MISS_SCORECARD_REC)
600:
601: IS
602: CURSOR C_GET_LEAD_SCORECARD (IN_SCORECARD_ID NUMBER) IS
603: SELECT

Line 635: l_SALES_LEAD_SCORECARD_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE

631: l_api_version_number CONSTANT NUMBER := 2.0;
632: l_scorecard_id NUMBER;
633: l_qual_value_id NUMBER;
634: l_rowid VARCHAR2(50);
635: l_SALES_LEAD_SCORECARD_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE
636: := p_scorecard_rec;
637: l_REF_SALES_LEAD_SCORECARD_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE;
638: /*
639: l_CardRule_Qual_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE;

Line 637: l_REF_SALES_LEAD_SCORECARD_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE;

633: l_qual_value_id NUMBER;
634: l_rowid VARCHAR2(50);
635: l_SALES_LEAD_SCORECARD_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE
636: := p_scorecard_rec;
637: l_REF_SALES_LEAD_SCORECARD_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE;
638: /*
639: l_CardRule_Qual_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE;
640: */
641: l_profile_option_id NUMBER;

Line 639: l_CardRule_Qual_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE;

635: l_SALES_LEAD_SCORECARD_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE
636: := p_scorecard_rec;
637: l_REF_SALES_LEAD_SCORECARD_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE;
638: /*
639: l_CardRule_Qual_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE;
640: */
641: l_profile_option_id NUMBER;
642: l_profile_option_nm VARCHAR2(80);
643: l_user_profile_option_nm VARCHAR2(240);

Line 917: l_REF_SALES_LEAD_SCORECARD_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE;

913: l_api_name CONSTANT VARCHAR2(30) := 'Delete_ScoreCard';
914: l_api_version_number CONSTANT NUMBER := 2.0;
915: l_scorecard_id NUMBER := p_scorecard_id;
916: l_rowid VARCHAR2(50);
917: l_REF_SALES_LEAD_SCORECARD_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE;
918:
919: BEGIN
920: -- Standard Start of API savepoint
921: SAVEPOINT DELETE_SCORECARD_PVT;

Line 1050: p_CardRule_Qual_rec IN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE,

1046: AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
1047: x_return_status OUT NOCOPY VARCHAR2,
1048: x_msg_count OUT NOCOPY NUMBER,
1049: x_msg_data OUT NOCOPY VARCHAR2,
1050: p_CardRule_Qual_rec IN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE,
1051: x_qual_value_id OUT NOCOPY NUMBER)
1052: IS
1053: CURSOR C_GET_QUAL_VALUE_ID IS
1054: SELECT AS_CARD_RULE_QUAL_VALUES_S.NEXTVAL

Line 1062: l_CardRule_QUAL_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE :=

1058: l_api_version_number CONSTANT NUMBER := 2.0;
1059: l_scorecard_id NUMBER;
1060: l_qual_value_id NUMBER;
1061: l_rowid VARCHAR2(50);
1062: l_CardRule_QUAL_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE :=
1063: p_cardrule_qual_rec;
1064:
1065: BEGIN
1066: -- Standard Start of API savepoint

Line 1235: p_CardRule_Qual_rec IN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE)

1231: AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
1232: x_return_status OUT NOCOPY VARCHAR2,
1233: x_msg_count OUT NOCOPY NUMBER,
1234: x_msg_data OUT NOCOPY VARCHAR2,
1235: p_CardRule_Qual_rec IN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE)
1236: IS
1237: CURSOR C_GET_CARDRULE_QUAL (IN_QUAL_VALUE_ID NUMBER) IS
1238: SELECT
1239: rowid,

Line 1249: l_CARDRULE_QUAL_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE

1245: l_api_name CONSTANT VARCHAR2(30) := 'Update_CARDRULE_QUAL';
1246: l_api_version_number CONSTANT NUMBER := 2.0;
1247: l_scorecard_id NUMBER;
1248: l_rowid VARCHAR2(50);
1249: l_CARDRULE_QUAL_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE
1250: := p_cardrule_qual_rec;
1251: l_ref_CARDRULE_QUAL_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE;
1252:
1253: BEGIN

Line 1251: l_ref_CARDRULE_QUAL_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE;

1247: l_scorecard_id NUMBER;
1248: l_rowid VARCHAR2(50);
1249: l_CARDRULE_QUAL_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE
1250: := p_cardrule_qual_rec;
1251: l_ref_CARDRULE_QUAL_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE;
1252:
1253: BEGIN
1254:
1255: -- dbms_output.put_line('in update_CardRule_Qual');

Line 1511: l_ref_CARDRULE_QUAL_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE;

1507: --
1508: l_api_name CONSTANT VARCHAR2(30) := 'Delete_CARDRULE_QUAL';
1509: l_api_version_number CONSTANT NUMBER := 2.0;
1510: l_qual_value_id NUMBER := p_qual_value_id;
1511: l_ref_CARDRULE_QUAL_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE;
1512:
1513: BEGIN
1514: -- Standard Start of API savepoint
1515: SAVEPOINT DELETE_CARD_RULE_PVT;