80: FUNCTION Init_AS_CARDRULE_QUAL_Tbl RETURN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_Tbl_TYPE;
81:
82: Procedure Create_ScoreCard (
83: p_api_version IN NUMBER := 2.0,
84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
81:
82: Procedure Create_ScoreCard (
83: p_api_version IN NUMBER := 2.0,
84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2,
92: X_SCORECARD_ID OUT NOCOPY NUMBER);
93:
94: Procedure Update_ScoreCard (
95: p_api_version IN NUMBER := 2.0,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
93:
94: Procedure Update_ScoreCard (
95: p_api_version IN NUMBER := 2.0,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
103: := G_MISS_SCORECARD_REC);
104:
105: Procedure Delete_ScoreCard (
106: p_api_version IN NUMBER := 2.0,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
104:
105: Procedure Delete_ScoreCard (
106: p_api_version IN NUMBER := 2.0,
107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108: p_commit IN VARCHAR2 := FND_API.G_FALSE,
109: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113: P_SCORECARD_ID IN NUMBER);
114:
115: Procedure Create_CardRule_QUAL (
116: p_api_version IN NUMBER := 2.0,
117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
114:
115: Procedure Create_CardRule_QUAL (
116: p_api_version IN NUMBER := 2.0,
117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
124: x_qual_value_id OUT NOCOPY NUMBER);
125:
126: Procedure Update_CardRule_QUAL (
127: p_api_version IN NUMBER := 2.0,
128: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
129: p_commit IN VARCHAR2 := FND_API.G_FALSE,
130: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
125:
126: Procedure Update_CardRule_QUAL (
127: p_api_version IN NUMBER := 2.0,
128: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
129: p_commit IN VARCHAR2 := FND_API.G_FALSE,
130: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2,
135:
136: -- pass in the qual value Id
137: Procedure Delete_CardRule_QUAL (
138: p_api_version IN NUMBER := 2.0,
139: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140: p_commit IN VARCHAR2 := FND_API.G_FALSE,
141: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
136: -- pass in the qual value Id
137: Procedure Delete_CardRule_QUAL (
138: p_api_version IN NUMBER := 2.0,
139: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140: p_commit IN VARCHAR2 := FND_API.G_FALSE,
141: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,