5: -- Declare Data Types
6: -- ---------------------------------------------------------
7: TYPE DFF_Rec_Type IS RECORD
8: (
9: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
11: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
6: -- ---------------------------------------------------------
7: TYPE DFF_Rec_Type IS RECORD
8: (
9: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
11: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
7: TYPE DFF_Rec_Type IS RECORD
8: (
9: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
11: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
8: (
9: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
11: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
9: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
10: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
11: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
10: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
11: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
11: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
12: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
13: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
14: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
15: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
16: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
17: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
18: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: );
18: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
19: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: );
26:
19: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
20: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: );
26:
27: -- *******************************************************
20: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: );
26:
27: -- *******************************************************
28: -- Start of Comments
32: -- Pre-Req : None
33: -- Parameters:
34: -- IN
35: -- p_api_version_number IN NUMBER Required
36: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
37: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
38: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
39: -- p_counter_id IN NUMBER Required
40: --
33: -- Parameters:
34: -- IN
35: -- p_api_version_number IN NUMBER Required
36: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
37: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
38: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
39: -- p_counter_id IN NUMBER Required
40: --
41: -- OUT:
34: -- IN
35: -- p_api_version_number IN NUMBER Required
36: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
37: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
38: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
39: -- p_counter_id IN NUMBER Required
40: --
41: -- OUT:
42: -- x_return_status OUT VARCHAR2
52: --
53: PROCEDURE VALIDATE_FORMULA_CTR
54: (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
58: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
53: PROCEDURE VALIDATE_FORMULA_CTR
54: (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
58: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
54: (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
58: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
62: p_counter_id IN NUMBER,
71: -- Pre-Req : None
72: -- Parameters:
73: -- IN
74: -- p_api_version_number IN NUMBER Required
75: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
76: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
77: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
78: -- p_counter_id IN NUMBER Required
79: --
72: -- Parameters:
73: -- IN
74: -- p_api_version_number IN NUMBER Required
75: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
76: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
77: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
78: -- p_counter_id IN NUMBER Required
79: --
80: -- OUT:
73: -- IN
74: -- p_api_version_number IN NUMBER Required
75: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
76: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
77: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
78: -- p_counter_id IN NUMBER Required
79: --
80: -- OUT:
81: -- x_return_status OUT VARCHAR2
92: --
93: PROCEDURE VALIDATE_GRPOP_CTR
94: (
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
97: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
93: PROCEDURE VALIDATE_GRPOP_CTR
94: (
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
97: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
94: (
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
97: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
98: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_counter_id IN NUMBER,
173: -- Application identifier
174: -- p_resp_id IN NUMBER Optional
175: -- Responsibility identifier
176: -- OUT : x_return_status OUT VARCHAR2(1)
177: -- FND_API.G_RET_STS_SUCCESS => values are valid
178: -- FND_API.G_RET_STS_ERROR => values are invalid
179: ------------------------------------------------------------------------------
180:
181: PROCEDURE Validate_Desc_Flex
174: -- p_resp_id IN NUMBER Optional
175: -- Responsibility identifier
176: -- OUT : x_return_status OUT VARCHAR2(1)
177: -- FND_API.G_RET_STS_SUCCESS => values are valid
178: -- FND_API.G_RET_STS_ERROR => values are invalid
179: ------------------------------------------------------------------------------
180:
181: PROCEDURE Validate_Desc_Flex
182: ( p_api_name IN VARCHAR2,