41: -- Pre-reqs : None.
42: -- Parameters :
43: -- IN : p_api_version IN NUMBER Required
44: -- p_init_msg_list IN VARCHAR2 Optional
45: -- Default = FND_API.G_FALSE
46: -- p_commit IN VARCHAR2 Optional
47: -- Default = FND_API.G_FALSE
48: -- p_validation_level IN NUMBER Optional
49: -- Default = FND_API.G_VALID_LEVEL_FULL
43: -- IN : p_api_version IN NUMBER Required
44: -- p_init_msg_list IN VARCHAR2 Optional
45: -- Default = FND_API.G_FALSE
46: -- p_commit IN VARCHAR2 Optional
47: -- Default = FND_API.G_FALSE
48: -- p_validation_level IN NUMBER Optional
49: -- Default = FND_API.G_VALID_LEVEL_FULL
50: -- p_attain_tier IN attain_tier_rec_type
51: -- OUT : x_return_status OUT VARCHAR2(1)
45: -- Default = FND_API.G_FALSE
46: -- p_commit IN VARCHAR2 Optional
47: -- Default = FND_API.G_FALSE
48: -- p_validation_level IN NUMBER Optional
49: -- Default = FND_API.G_VALID_LEVEL_FULL
50: -- p_attain_tier IN attain_tier_rec_type
51: -- OUT : x_return_status OUT VARCHAR2(1)
52: -- x_msg_count OUT NUMBER
53: -- x_msg_data OUT VARCHAR2(2000)
56: --
57: -- End of comments
58: PROCEDURE Create_Attain_Tier
59: (p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63: p_attain_tier IN attain_tier_rec_type,
64: x_return_status OUT NOCOPY VARCHAR2,
57: -- End of comments
58: PROCEDURE Create_Attain_Tier
59: (p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63: p_attain_tier IN attain_tier_rec_type,
64: x_return_status OUT NOCOPY VARCHAR2,
65: x_msg_count OUT NOCOPY NUMBER,
58: PROCEDURE Create_Attain_Tier
59: (p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63: p_attain_tier IN attain_tier_rec_type,
64: x_return_status OUT NOCOPY VARCHAR2,
65: x_msg_count OUT NOCOPY NUMBER,
66: x_msg_data OUT NOCOPY VARCHAR2);
72: -- Pre-reqs : None.
73: -- Parameters :
74: -- IN : p_api_version IN NUMBER Required
75: -- p_init_msg_list IN VARCHAR2 Optional
76: -- Default = FND_API.G_FALSE
77: -- p_commit IN VARCHAR2 Optional
78: -- Default = FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Optional
80: -- Default = FND_API.G_VALID_LEVEL_FULL
74: -- IN : p_api_version IN NUMBER Required
75: -- p_init_msg_list IN VARCHAR2 Optional
76: -- Default = FND_API.G_FALSE
77: -- p_commit IN VARCHAR2 Optional
78: -- Default = FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Optional
80: -- Default = FND_API.G_VALID_LEVEL_FULL
81: -- p_attain_tier IN attain_tier_rec_type
82: -- OUT : x_return_status OUT VARCHAR2(1)
76: -- Default = FND_API.G_FALSE
77: -- p_commit IN VARCHAR2 Optional
78: -- Default = FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Optional
80: -- Default = FND_API.G_VALID_LEVEL_FULL
81: -- p_attain_tier IN attain_tier_rec_type
82: -- OUT : x_return_status OUT VARCHAR2(1)
83: -- x_msg_count OUT NUMBER
84: -- x_msg_data OUT VARCHAR2(2000)
87: --
88: -- End of comments
89: PROCEDURE Update_Attain_Tier
90: (p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92: p_commit IN VARCHAR2 := FND_API.G_FALSE,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: p_attain_tier IN attain_tier_rec_type,
95: x_return_status OUT NOCOPY VARCHAR2,
88: -- End of comments
89: PROCEDURE Update_Attain_Tier
90: (p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92: p_commit IN VARCHAR2 := FND_API.G_FALSE,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: p_attain_tier IN attain_tier_rec_type,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
89: PROCEDURE Update_Attain_Tier
90: (p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92: p_commit IN VARCHAR2 := FND_API.G_FALSE,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: p_attain_tier IN attain_tier_rec_type,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2 );
103: -- Pre-reqs : None.
104: -- Parameters :
105: -- IN : p_api_version IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional
107: -- Default = FND_API.G_FALSE
108: -- p_commit IN VARCHAR2 Optional
109: -- Default = FND_API.G_FALSE
110: -- p_validation_level IN NUMBER Optional
111: -- Default = FND_API.G_VALID_LEVEL_FULL
105: -- IN : p_api_version IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional
107: -- Default = FND_API.G_FALSE
108: -- p_commit IN VARCHAR2 Optional
109: -- Default = FND_API.G_FALSE
110: -- p_validation_level IN NUMBER Optional
111: -- Default = FND_API.G_VALID_LEVEL_FULL
112: -- p_attain_tier IN attain_tier_rec_type
113: -- OUT : x_return_status OUT VARCHAR2(1)
107: -- Default = FND_API.G_FALSE
108: -- p_commit IN VARCHAR2 Optional
109: -- Default = FND_API.G_FALSE
110: -- p_validation_level IN NUMBER Optional
111: -- Default = FND_API.G_VALID_LEVEL_FULL
112: -- p_attain_tier IN attain_tier_rec_type
113: -- OUT : x_return_status OUT VARCHAR2(1)
114: -- x_msg_count OUT NUMBER
115: -- x_msg_data OUT VARCHAR2(2000)
118: --
119: -- End of comments
120: PROCEDURE Delete_Attain_Tier
121: (p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: p_attain_tier IN attain_tier_rec_type,
126: x_return_status OUT NOCOPY VARCHAR2,
119: -- End of comments
120: PROCEDURE Delete_Attain_Tier
121: (p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: p_attain_tier IN attain_tier_rec_type,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
120: PROCEDURE Delete_Attain_Tier
121: (p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: p_attain_tier IN attain_tier_rec_type,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2);
134: -- Pre-reqs : None.
135: -- Parameters :
136: -- IN : p_api_version IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional
138: -- Default = FND_API.G_FALSE
139: -- p_commit IN VARCHAR2 Optional
140: -- Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional
142: -- Default = FND_API.G_VALID_LEVEL_FULL
136: -- IN : p_api_version IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional
138: -- Default = FND_API.G_FALSE
139: -- p_commit IN VARCHAR2 Optional
140: -- Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional
142: -- Default = FND_API.G_VALID_LEVEL_FULL
143: -- p_attain_schedule_id IN NUMBER
144: -- OUT : x_return_status OUT VARCHAR2(1)
138: -- Default = FND_API.G_FALSE
139: -- p_commit IN VARCHAR2 Optional
140: -- Default = FND_API.G_FALSE
141: -- p_validation_level IN NUMBER Optional
142: -- Default = FND_API.G_VALID_LEVEL_FULL
143: -- p_attain_schedule_id IN NUMBER
144: -- OUT : x_return_status OUT VARCHAR2(1)
145: -- x_msg_count OUT NUMBER
146: -- x_msg_data OUT VARCHAR2(2000)
150: --
151: -- End of comments
152: PROCEDURE Get_Attain_Tier
153: (p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: p_attain_schedule_id IN NUMBER,
158: x_attain_tier OUT NOCOPY attain_tier_tbl_type,
151: -- End of comments
152: PROCEDURE Get_Attain_Tier
153: (p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: p_attain_schedule_id IN NUMBER,
158: x_attain_tier OUT NOCOPY attain_tier_tbl_type,
159: x_return_status OUT NOCOPY VARCHAR2,
152: PROCEDURE Get_Attain_Tier
153: (p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_commit IN VARCHAR2 := FND_API.G_FALSE,
156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
157: p_attain_schedule_id IN NUMBER,
158: x_attain_tier OUT NOCOPY attain_tier_tbl_type,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,