1: PACKAGE BODY AS_SCORECARD_RULES_PUB AS
2: /* $Header: asxpscob.pls 120.1 2005/06/24 16:56:39 appldev ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SCORECARD_RULES_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(16) := 'asxpscob.pls';
1: PACKAGE BODY AS_SCORECARD_RULES_PUB AS
2: /* $Header: asxpscob.pls 120.1 2005/06/24 16:56:39 appldev ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SCORECARD_RULES_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(16) := 'asxpscob.pls';
6:
7:
8: -- *****************************************************
5: G_FILE_NAME CONSTANT VARCHAR2(16) := 'asxpscob.pls';
6:
7:
8: -- *****************************************************
9: -- FOR AS_SCORECARD_RULES_PUB
10: FUNCTION Init_AS_SCORECARD_Rec RETURN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE IS
11: l_return_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE ;
12: BEGIN
13: l_return_rec := AS_SCORECARD_RULES_PUB.G_MISS_SCORECARD_REC;
6:
7:
8: -- *****************************************************
9: -- FOR AS_SCORECARD_RULES_PUB
10: FUNCTION Init_AS_SCORECARD_Rec RETURN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE IS
11: l_return_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE ;
12: BEGIN
13: l_return_rec := AS_SCORECARD_RULES_PUB.G_MISS_SCORECARD_REC;
14: RETURN l_return_rec ;
7:
8: -- *****************************************************
9: -- FOR AS_SCORECARD_RULES_PUB
10: FUNCTION Init_AS_SCORECARD_Rec RETURN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE IS
11: l_return_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE ;
12: BEGIN
13: l_return_rec := AS_SCORECARD_RULES_PUB.G_MISS_SCORECARD_REC;
14: RETURN l_return_rec ;
15: END;
9: -- FOR AS_SCORECARD_RULES_PUB
10: FUNCTION Init_AS_SCORECARD_Rec RETURN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE IS
11: l_return_rec AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE ;
12: BEGIN
13: l_return_rec := AS_SCORECARD_RULES_PUB.G_MISS_SCORECARD_REC;
14: RETURN l_return_rec ;
15: END;
16:
17:
14: RETURN l_return_rec ;
15: END;
16:
17:
18: FUNCTION Init_AS_CARDRULE_QUAL_Rec RETURN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE IS
19: l_return_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE;
20: BEGIN
21: l_return_rec := AS_SCORECARD_RULES_PUB.G_MISS_CARDRULE_QUAL_REC;
22: RETURN l_return_rec ;
15: END;
16:
17:
18: FUNCTION Init_AS_CARDRULE_QUAL_Rec RETURN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE IS
19: l_return_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE;
20: BEGIN
21: l_return_rec := AS_SCORECARD_RULES_PUB.G_MISS_CARDRULE_QUAL_REC;
22: RETURN l_return_rec ;
23: END;
17:
18: FUNCTION Init_AS_CARDRULE_QUAL_Rec RETURN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE IS
19: l_return_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE;
20: BEGIN
21: l_return_rec := AS_SCORECARD_RULES_PUB.G_MISS_CARDRULE_QUAL_REC;
22: RETURN l_return_rec ;
23: END;
24:
25: FUNCTION Init_AS_CARDRULE_QUAL_Tbl RETURN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_Tbl_TYPE IS
21: l_return_rec := AS_SCORECARD_RULES_PUB.G_MISS_CARDRULE_QUAL_REC;
22: RETURN l_return_rec ;
23: END;
24:
25: FUNCTION Init_AS_CARDRULE_QUAL_Tbl RETURN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_Tbl_TYPE IS
26: l_return_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_Tbl_TYPE;
27: BEGIN
28: l_return_rec := AS_SCORECARD_RULES_PUB.G_MISS_CARDRULE_QUAL_TBL;
29: RETURN l_return_rec ;
22: RETURN l_return_rec ;
23: END;
24:
25: FUNCTION Init_AS_CARDRULE_QUAL_Tbl RETURN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_Tbl_TYPE IS
26: l_return_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_Tbl_TYPE;
27: BEGIN
28: l_return_rec := AS_SCORECARD_RULES_PUB.G_MISS_CARDRULE_QUAL_TBL;
29: RETURN l_return_rec ;
30: END;
24:
25: FUNCTION Init_AS_CARDRULE_QUAL_Tbl RETURN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_Tbl_TYPE IS
26: l_return_rec AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_Tbl_TYPE;
27: BEGIN
28: l_return_rec := AS_SCORECARD_RULES_PUB.G_MISS_CARDRULE_QUAL_TBL;
29: RETURN l_return_rec ;
30: END;
31:
32:
37: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: P_SCORECARD_REC IN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE
42: := G_MISS_SCORECARD_REC,
43: X_SCORECARD_ID OUT NOCOPY NUMBER)
44: IS
45: l_api_name CONSTANT VARCHAR2(30) := 'Create_ScoreCard';
171: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: P_SCORECARD_REC IN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE
176: := G_MISS_SCORECARD_REC)
177: IS
178: l_api_name CONSTANT VARCHAR2(30) := 'Update_ScoreCard';
179: l_api_version_number CONSTANT NUMBER := 2.0;
426: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
427: x_return_status OUT NOCOPY VARCHAR2,
428: x_msg_count OUT NOCOPY NUMBER,
429: x_msg_data OUT NOCOPY VARCHAR2,
430: p_CardRule_Qual_rec IN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE,
431: x_qual_value_id OUT NOCOPY NUMBER)
432: IS
433: l_api_name CONSTANT VARCHAR2(30) := 'Create_CardRule_QUAL';
434: l_api_version_number CONSTANT NUMBER := 2.0;
556: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
557: x_return_status OUT NOCOPY VARCHAR2,
558: x_msg_count OUT NOCOPY NUMBER,
559: x_msg_data OUT NOCOPY VARCHAR2,
560: p_CardRule_Qual_rec IN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE)
561: IS
562: l_api_name CONSTANT VARCHAR2(30) := 'Update_CARDRULE_QUAL';
563: l_api_version_number CONSTANT NUMBER := 2.0;
564: l_return_status VARCHAR2(1);
800: END Delete_CardRule_Qual;
801:
802:
803:
804: END AS_SCORECARD_RULES_PUB;