[Home] [Help]
PACKAGE: APPS.AS_SCORECARD_RULES_PVT
Source
1 PACKAGE AS_SCORECARD_RULES_PVT AUTHID CURRENT_USER AS
2 /* $Header: asxvscos.pls 120.1 2005/06/24 17:15:18 appldev ship $ */
3
4 Procedure Create_ScoreCard (
5 p_api_version IN NUMBER := 2.0,
6 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7 p_commit IN VARCHAR2 := FND_API.G_FALSE,
8 p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
9 x_return_status OUT NOCOPY VARCHAR2,
10 x_msg_count OUT NOCOPY NUMBER,
11 x_msg_data OUT NOCOPY VARCHAR2,
12 P_SCORECARD_REC IN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE
13 := AS_SCORECARD_RULES_PUB.G_MISS_SCORECARD_REC,
14 X_SCORECARD_ID OUT NOCOPY NUMBER);
15
16 Procedure Update_ScoreCard (
17 p_api_version IN NUMBER := 2.0,
18 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19 p_commit IN VARCHAR2 := FND_API.G_FALSE,
20 p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2,
24 P_SCORECARD_REC IN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE
25 := AS_SCORECARD_RULES_PUB.G_MISS_SCORECARD_REC);
26
27 Procedure Delete_ScoreCard (
28 p_api_version IN NUMBER := 2.0,
29 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30 p_commit IN VARCHAR2 := FND_API.G_FALSE,
31 p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2,
35 P_SCORECARD_ID IN NUMBER);
36
37
38 Procedure Create_CardRule_QUAL (
39 p_api_version IN NUMBER := 2.0,
40 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41 p_commit IN VARCHAR2 := FND_API.G_FALSE,
42 p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_CardRule_Qual_rec IN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE,
47 x_qual_value_id OUT NOCOPY NUMBER);
48
49 Procedure Update_CardRule_QUAL (
50 p_api_version IN NUMBER := 2.0,
51 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52 p_commit IN VARCHAR2 := FND_API.G_FALSE,
53 p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 p_CardRule_Qual_rec IN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE);
58
59 -- pass in the qual value Id
60 Procedure Delete_CardRule_QUAL (
61 p_api_version IN NUMBER := 2.0,
62 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63 p_commit IN VARCHAR2 := FND_API.G_FALSE,
64 p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_qual_value_id IN NUMBER);
69
70
71 -- Validation
72 Procedure Validate_Seed_Qual_ID(
73 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
74 P_Validation_mode IN VARCHAR2,
75 P_SEED_QUAL_ID IN NUMBER,
76 X_Return_Status OUT NOCOPY VARCHAR2,
77 X_Msg_Count OUT NOCOPY NUMBER,
78 X_Msg_Data OUT NOCOPY VARCHAR2
79 );
80
81 Procedure Validate_Seed_Qual_Value_Num(
82 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
83 P_Validation_mode IN VARCHAR2,
84 P_SEED_QUAL_ID IN NUMBER,
85 P_High_Value_Number IN NUMBER,
86 P_Low_Value_Number IN NUMBER,
87 X_Return_Status OUT NOCOPY VARCHAR2,
88 X_Msg_Count OUT NOCOPY NUMBER,
89 X_Msg_Data OUT NOCOPY VARCHAR2
90 );
91
92 Procedure Validate_Seed_Qual_Value_Char(
93 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
94 P_Validation_mode IN VARCHAR2,
95 P_SEED_QUAL_ID IN NUMBER,
96 P_High_Value_Char IN VARCHAR2,
97 P_Low_Value_Char IN VARCHAR2,
98 X_Return_Status OUT NOCOPY VARCHAR2,
99 X_Msg_Count OUT NOCOPY NUMBER,
100 X_Msg_Data OUT NOCOPY VARCHAR2
101 );
102
103 Procedure Validate_Seed_Qual_Value_Date(
104 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
105 P_Validation_mode IN VARCHAR2,
106 P_SEED_QUAL_ID IN NUMBER,
107 P_High_Value_Date IN DATE,
108 P_Low_Value_Date IN DATE,
109 X_Return_Status OUT NOCOPY VARCHAR2,
110 X_Msg_Count OUT NOCOPY NUMBER,
111 X_Msg_Data OUT NOCOPY VARCHAR2
112 );
113
114 Procedure Validate_Seed_Qual(
115 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116 P_Validation_mode IN VARCHAR2,
117 P_CARDRULE_QUAL_rec IN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE,
118 X_Return_Status OUT NOCOPY VARCHAR2,
119 X_Msg_Count OUT NOCOPY NUMBER,
120 X_Msg_Data OUT NOCOPY VARCHAR2
121 );
122
123 END AS_SCORECARD_RULES_PVT;
124