105: -- Pre-Req :
106: -- Parameters:
107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
112: -- P_process_setup_tbl IN process_setup_tbl_type Required
113: --
106: -- Parameters:
107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
112: -- P_process_setup_tbl IN process_setup_tbl_type Required
113: --
114: -- OUT:
107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
112: -- P_process_setup_tbl IN process_setup_tbl_type Required
113: --
114: -- OUT:
115: -- x_return_status OUT NOCOPY VARCHAR2
120: -- End of Comments
121: --
122: PROCEDURE create_process_setup(
123: p_api_version_number IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
121: --
122: PROCEDURE create_process_setup(
123: p_api_version_number IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
122: PROCEDURE create_process_setup(
123: p_api_version_number IN NUMBER,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_process_setup_tbl IN process_setup_tbl_type ,
138: -- Pre-Req :
139: -- Parameters:
140: -- IN
141: -- p_api_version_number IN NUMBER Required
142: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
143: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
144: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
145: -- p_process_setup_tbl IN process_setup_tbl_type Required
146: --
139: -- Parameters:
140: -- IN
141: -- p_api_version_number IN NUMBER Required
142: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
143: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
144: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
145: -- p_process_setup_tbl IN process_setup_tbl_type Required
146: --
147: -- OUT:
140: -- IN
141: -- p_api_version_number IN NUMBER Required
142: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
143: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
144: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
145: -- p_process_setup_tbl IN process_setup_tbl_type Required
146: --
147: -- OUT:
148: -- x_return_status OUT NOCOPY VARCHAR2
154: -- End of Comments
155: --
156: PROCEDURE Update_process_setup(
157: P_Api_Version_Number IN NUMBER,
158: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
159: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161: X_Return_Status OUT NOCOPY VARCHAR2,
162: X_Msg_Count OUT NOCOPY NUMBER,
155: --
156: PROCEDURE Update_process_setup(
157: P_Api_Version_Number IN NUMBER,
158: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
159: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161: X_Return_Status OUT NOCOPY VARCHAR2,
162: X_Msg_Count OUT NOCOPY NUMBER,
163: X_Msg_Data OUT NOCOPY VARCHAR2,
156: PROCEDURE Update_process_setup(
157: P_Api_Version_Number IN NUMBER,
158: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
159: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161: X_Return_Status OUT NOCOPY VARCHAR2,
162: X_Msg_Count OUT NOCOPY NUMBER,
163: X_Msg_Data OUT NOCOPY VARCHAR2,
164: p_process_setup_tbl IN process_setup_tbl_type ,
171: -- Pre-Req :
172: -- Parameters:
173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
178: -- p_process_setup_tbl IN process_setup_tbl_type , Required
179: --
172: -- Parameters:
173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
178: -- p_process_setup_tbl IN process_setup_tbl_type , Required
179: --
180: -- OUT:
173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default=FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default=FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default=FND_API.G_VALID_LEVEL_FULL
178: -- p_process_setup_tbl IN process_setup_tbl_type , Required
179: --
180: -- OUT:
181: -- x_return_status OUT NOCOPY VARCHAR2
186: -- End of Comments
187: --
188: PROCEDURE update_process_setup_tbl(
189: P_Api_Version_Number IN NUMBER,
190: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
191: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: X_Return_Status OUT NOCOPY VARCHAR2,
194: X_Msg_Count OUT NOCOPY NUMBER,
187: --
188: PROCEDURE update_process_setup_tbl(
189: P_Api_Version_Number IN NUMBER,
190: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
191: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: X_Return_Status OUT NOCOPY VARCHAR2,
194: X_Msg_Count OUT NOCOPY NUMBER,
195: X_Msg_Data OUT NOCOPY VARCHAR2,
188: PROCEDURE update_process_setup_tbl(
189: P_Api_Version_Number IN NUMBER,
190: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
191: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193: X_Return_Status OUT NOCOPY VARCHAR2,
194: X_Msg_Count OUT NOCOPY NUMBER,
195: X_Msg_Data OUT NOCOPY VARCHAR2,
196: p_process_setup_tbl IN process_setup_tbl_type
230: -- End of Comments
231:
232: PROCEDURE validate_process_setup_Rec(
233: P_Api_Version_Number IN NUMBER,
234: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
235: X_Return_Status OUT NOCOPY VARCHAR2,
236: X_Msg_Count OUT NOCOPY NUMBER,
237: X_Msg_Data OUT NOCOPY VARCHAR2,
238: p_process_setup_tbl IN PROCESS_SETUP_TBL_TYPE
248: -- End of Comments
249:
250: PROCEDURE Validate_process_setup(
251: P_Api_Version_Number IN NUMBER,
252: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
253: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254: P_Validation_mode IN VARCHAR2,
255: p_process_setup_tbl IN process_setup_tbl_type,
256: X_Return_Status OUT NOCOPY VARCHAR2,
249:
250: PROCEDURE Validate_process_setup(
251: P_Api_Version_Number IN NUMBER,
252: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
253: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254: P_Validation_mode IN VARCHAR2,
255: p_process_setup_tbl IN process_setup_tbl_type,
256: X_Return_Status OUT NOCOPY VARCHAR2,
257: X_Msg_Count OUT NOCOPY NUMBER,