40: -- Pre-reqs : None.
41: -- Parameters :
42: -- IN : p_api_version IN NUMBER Required
43: -- p_init_msg_list IN VARCHAR2 Optional
44: -- Default = FND_API.G_FALSE
45: -- p_commit IN VARCHAR2 Optional
46: -- Default = FND_API.G_FALSE
47: -- p_validation_level IN NUMBER Optional
48: -- Default = FND_API.G_VALID_LEVEL_FULL
42: -- IN : p_api_version IN NUMBER Required
43: -- p_init_msg_list IN VARCHAR2 Optional
44: -- Default = FND_API.G_FALSE
45: -- p_commit IN VARCHAR2 Optional
46: -- Default = FND_API.G_FALSE
47: -- p_validation_level IN NUMBER Optional
48: -- Default = FND_API.G_VALID_LEVEL_FULL
49: -- p_attain_schedule IN attain_schedule_rec_type
50: -- OUT : x_return_status OUT VARCHAR2(1)
44: -- Default = FND_API.G_FALSE
45: -- p_commit IN VARCHAR2 Optional
46: -- Default = FND_API.G_FALSE
47: -- p_validation_level IN NUMBER Optional
48: -- Default = FND_API.G_VALID_LEVEL_FULL
49: -- p_attain_schedule IN attain_schedule_rec_type
50: -- OUT : x_return_status OUT VARCHAR2(1)
51: -- x_msg_count OUT NUMBER
52: -- x_msg_data OUT VARCHAR2(2000)
55: --
56: -- End of comments
57: PROCEDURE Create_Attain_Schedule
58: (p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60: p_commit IN VARCHAR2 := FND_API.G_FALSE,
61: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62: p_attain_schedule IN attain_schedule_rec_type,
63: x_return_status OUT NOCOPY VARCHAR2,
56: -- End of comments
57: PROCEDURE Create_Attain_Schedule
58: (p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60: p_commit IN VARCHAR2 := FND_API.G_FALSE,
61: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62: p_attain_schedule IN attain_schedule_rec_type,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
57: PROCEDURE Create_Attain_Schedule
58: (p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60: p_commit IN VARCHAR2 := FND_API.G_FALSE,
61: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62: p_attain_schedule IN attain_schedule_rec_type,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2);
71: -- Pre-reqs : None.
72: -- Parameters :
73: -- IN : p_api_version IN NUMBER Required
74: -- p_init_msg_list IN VARCHAR2 Optional
75: -- Default = FND_API.G_FALSE
76: -- p_commit IN VARCHAR2 Optional
77: -- Default = FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional
79: -- Default = FND_API.G_VALID_LEVEL_FULL
73: -- IN : p_api_version IN NUMBER Required
74: -- p_init_msg_list IN VARCHAR2 Optional
75: -- Default = FND_API.G_FALSE
76: -- p_commit IN VARCHAR2 Optional
77: -- Default = FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional
79: -- Default = FND_API.G_VALID_LEVEL_FULL
80: -- p_attain_schedule IN attain_schedule_rec_type
81: -- OUT : x_return_status OUT VARCHAR2(1)
75: -- Default = FND_API.G_FALSE
76: -- p_commit IN VARCHAR2 Optional
77: -- Default = FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional
79: -- Default = FND_API.G_VALID_LEVEL_FULL
80: -- p_attain_schedule IN attain_schedule_rec_type
81: -- OUT : x_return_status OUT VARCHAR2(1)
82: -- x_msg_count OUT NUMBER
83: -- x_msg_data OUT VARCHAR2(2000)
86: --
87: -- End of comments
88: PROCEDURE Update_Attain_Schedule
89: (p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91: p_commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: p_attain_schedule IN attain_schedule_rec_type,
94: x_return_status OUT NOCOPY VARCHAR2,
87: -- End of comments
88: PROCEDURE Update_Attain_Schedule
89: (p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91: p_commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: p_attain_schedule IN attain_schedule_rec_type,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,
88: PROCEDURE Update_Attain_Schedule
89: (p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91: p_commit IN VARCHAR2 := FND_API.G_FALSE,
92: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93: p_attain_schedule IN attain_schedule_rec_type,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,
96: x_msg_data OUT NOCOPY VARCHAR2 );
102: -- Pre-reqs : None.
103: -- Parameters :
104: -- IN : p_api_version IN NUMBER Required
105: -- p_init_msg_list IN VARCHAR2 Optional
106: -- Default = FND_API.G_FALSE
107: -- p_commit IN VARCHAR2 Optional
108: -- Default = FND_API.G_FALSE
109: -- p_validation_level IN NUMBER Optional
110: -- Default = FND_API.G_VALID_LEVEL_FULL
104: -- IN : p_api_version IN NUMBER Required
105: -- p_init_msg_list IN VARCHAR2 Optional
106: -- Default = FND_API.G_FALSE
107: -- p_commit IN VARCHAR2 Optional
108: -- Default = FND_API.G_FALSE
109: -- p_validation_level IN NUMBER Optional
110: -- Default = FND_API.G_VALID_LEVEL_FULL
111: -- p_attain_schedule IN attain_schedule_rec_type
112: -- OUT : x_return_status OUT VARCHAR2(1)
106: -- Default = FND_API.G_FALSE
107: -- p_commit IN VARCHAR2 Optional
108: -- Default = FND_API.G_FALSE
109: -- p_validation_level IN NUMBER Optional
110: -- Default = FND_API.G_VALID_LEVEL_FULL
111: -- p_attain_schedule IN attain_schedule_rec_type
112: -- OUT : x_return_status OUT VARCHAR2(1)
113: -- x_msg_count OUT NUMBER
114: -- x_msg_data OUT VARCHAR2(2000)
117: --
118: -- End of comments
119: PROCEDURE Delete_Attain_Schedule
120: (p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_attain_schedule IN attain_schedule_rec_type,
125: x_return_status OUT NOCOPY VARCHAR2,
118: -- End of comments
119: PROCEDURE Delete_Attain_Schedule
120: (p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_attain_schedule IN attain_schedule_rec_type,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
119: PROCEDURE Delete_Attain_Schedule
120: (p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_attain_schedule IN attain_schedule_rec_type,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2);
133: -- Pre-reqs : None.
134: -- Parameters :
135: -- IN : p_api_version IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Optional
137: -- Default = FND_API.G_FALSE
138: -- p_commit IN VARCHAR2 Optional
139: -- Default = FND_API.G_FALSE
140: -- p_validation_level IN NUMBER Optional
141: -- Default = FND_API.G_VALID_LEVEL_FULL
135: -- IN : p_api_version IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Optional
137: -- Default = FND_API.G_FALSE
138: -- p_commit IN VARCHAR2 Optional
139: -- Default = FND_API.G_FALSE
140: -- p_validation_level IN NUMBER Optional
141: -- Default = FND_API.G_VALID_LEVEL_FULL
142: -- OUT : x_return_status OUT VARCHAR2(1)
143: -- x_msg_count OUT NUMBER
137: -- Default = FND_API.G_FALSE
138: -- p_commit IN VARCHAR2 Optional
139: -- Default = FND_API.G_FALSE
140: -- p_validation_level IN NUMBER Optional
141: -- Default = FND_API.G_VALID_LEVEL_FULL
142: -- OUT : x_return_status OUT VARCHAR2(1)
143: -- x_msg_count OUT NUMBER
144: -- x_msg_data OUT VARCHAR2(2000)
145: -- x_attain_schedule OUT attain_schedule_tbl_type
148: --
149: -- End of comments
150: PROCEDURE Get_Attain_Schedule
151: (p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155: x_attain_schedule OUT NOCOPY attain_schedule_tbl_type,
156: x_return_status OUT NOCOPY VARCHAR2,
149: -- End of comments
150: PROCEDURE Get_Attain_Schedule
151: (p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155: x_attain_schedule OUT NOCOPY attain_schedule_tbl_type,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
150: PROCEDURE Get_Attain_Schedule
151: (p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155: x_attain_schedule OUT NOCOPY attain_schedule_tbl_type,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2);