13: -- Pre-reqs : None.
14: -- Purpose : Creates a lifecycle for the given name and short name
15: -- Parameters :
16: -- p_api_version IN NUMBER Optional Default 1.0
17: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
18: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
19: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
20: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
21: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
14: -- Purpose : Creates a lifecycle for the given name and short name
15: -- Parameters :
16: -- p_api_version IN NUMBER Optional Default 1.0
17: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
18: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
19: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
20: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
21: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
22: -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
15: -- Parameters :
16: -- p_api_version IN NUMBER Optional Default 1.0
17: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
18: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
19: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
20: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
21: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
22: -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
23: -- P_lifecycle_short_name IN VARCHAR2 Required
35: -- End of comments
36:
37: PROCEDURE create_lifecycle (
38: P_api_version IN NUMBER :=1.0 ,
39: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
40: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
41: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
42: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
43: p_debug_mode IN VARCHAR2 :='N' ,
36:
37: PROCEDURE create_lifecycle (
38: P_api_version IN NUMBER :=1.0 ,
39: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
40: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
41: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
42: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
43: p_debug_mode IN VARCHAR2 :='N' ,
44: p_max_msg_count IN NUMBER :=G_MISS_NUM ,
37: PROCEDURE create_lifecycle (
38: P_api_version IN NUMBER :=1.0 ,
39: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
40: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
41: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
42: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
43: p_debug_mode IN VARCHAR2 :='N' ,
44: p_max_msg_count IN NUMBER :=G_MISS_NUM ,
45: P_lifecycle_short_name IN VARCHAR2 ,
60: -- Pre-reqs : None.
61: -- Purpose : Creates a lifecycle phase the given name and short name
62: -- Parameters :
63: -- p_api_version IN NUMBER Optional Default a1.0
64: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
65: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
66: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
67: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
68: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
61: -- Purpose : Creates a lifecycle phase the given name and short name
62: -- Parameters :
63: -- p_api_version IN NUMBER Optional Default a1.0
64: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
65: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
66: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
67: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
68: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
69: -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
62: -- Parameters :
63: -- p_api_version IN NUMBER Optional Default a1.0
64: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
65: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
66: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
67: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
68: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
69: -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
70: -- P_lifecycle_id IN NUMBER Required
84:
85:
86: Procedure create_lifecycle_phase (
87: P_api_version IN NUMBER :=1.0 ,
88: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
89: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
90: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
91: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
92: p_debug_mode IN VARCHAR2 :='N' ,
85:
86: Procedure create_lifecycle_phase (
87: P_api_version IN NUMBER :=1.0 ,
88: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
89: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
90: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
91: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
92: p_debug_mode IN VARCHAR2 :='N' ,
93: P_max_msg_count IN NUMBER :=G_MISS_NUM ,
86: Procedure create_lifecycle_phase (
87: P_api_version IN NUMBER :=1.0 ,
88: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
89: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
90: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
91: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
92: p_debug_mode IN VARCHAR2 :='N' ,
93: P_max_msg_count IN NUMBER :=G_MISS_NUM ,
94: P_lifecycle_id IN NUMBER ,
109: -- Pre-reqs : None.
110: -- Purpose : Updates a lifecycle for the given name and short name
111: -- Parameters :
112: -- p_api_version IN NUMBER Optional Default a1.0
113: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
114: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
115: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
116: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
117: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
110: -- Purpose : Updates a lifecycle for the given name and short name
111: -- Parameters :
112: -- p_api_version IN NUMBER Optional Default a1.0
113: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
114: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
115: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
116: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
117: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
118: -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
111: -- Parameters :
112: -- p_api_version IN NUMBER Optional Default a1.0
113: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
114: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
115: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
116: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
117: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
118: -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
119: -- P_lifecycle_id IN NUMBER Required
132: -- End of comments
133:
134: PROCEDURE update_lifecycle (
135: p_api_version IN NUMBER :=1.0 ,
136: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
137: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
138: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
139: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
140: p_debug_mode IN VARCHAR2 :='N' ,
133:
134: PROCEDURE update_lifecycle (
135: p_api_version IN NUMBER :=1.0 ,
136: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
137: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
138: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
139: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
140: p_debug_mode IN VARCHAR2 :='N' ,
141: p_max_msg_count IN NUMBER :=G_MISS_NUM ,
134: PROCEDURE update_lifecycle (
135: p_api_version IN NUMBER :=1.0 ,
136: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
137: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
138: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
139: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
140: p_debug_mode IN VARCHAR2 :='N' ,
141: p_max_msg_count IN NUMBER :=G_MISS_NUM ,
142: P_lifecycle_id IN NUMBER ,
157: -- Pre-reqs : None.
158: -- Purpose : Updates a lifecycle phase after checking the constraints.
159: -- Parameters :
160: -- p_api_version IN NUMBER Optional Default a1.0
161: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
162: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
163: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
164: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
165: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
158: -- Purpose : Updates a lifecycle phase after checking the constraints.
159: -- Parameters :
160: -- p_api_version IN NUMBER Optional Default a1.0
161: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
162: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
163: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
164: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
165: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
166: -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
159: -- Parameters :
160: -- p_api_version IN NUMBER Optional Default a1.0
161: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
162: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
163: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
164: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
165: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
166: -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
167: -- P_lifecycle_id IN NUMBER Required
182:
183:
184: PROCEDURE update_lifecycle_phase (
185: P_api_version IN NUMBER :=1.0 ,
186: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
187: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
188: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
189: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
190: p_debug_mode IN VARCHAR2 :='N' ,
183:
184: PROCEDURE update_lifecycle_phase (
185: P_api_version IN NUMBER :=1.0 ,
186: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
187: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
188: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
189: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
190: p_debug_mode IN VARCHAR2 :='N' ,
191: P_max_msg_count IN NUMBER :=G_MISS_NUM ,
184: PROCEDURE update_lifecycle_phase (
185: P_api_version IN NUMBER :=1.0 ,
186: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
187: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
188: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
189: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
190: p_debug_mode IN VARCHAR2 :='N' ,
191: P_max_msg_count IN NUMBER :=G_MISS_NUM ,
192: P_lifecycle_id IN NUMBER ,
209: -- Pre-reqs : None.
210: -- Purpose : deletes a given lifecycle
211: -- Parameters :
212: -- p_api_version IN NUMBER Optional Default 1.0
213: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
214: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
215: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
216: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
217: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
210: -- Purpose : deletes a given lifecycle
211: -- Parameters :
212: -- p_api_version IN NUMBER Optional Default 1.0
213: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
214: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
215: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
216: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
217: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
218: -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
211: -- Parameters :
212: -- p_api_version IN NUMBER Optional Default 1.0
213: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
214: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
215: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
216: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
217: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
218: -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
219: -- P_lifecycle_id IN NUMBER Required
227: -- End of comments
228:
229: PROCEDURE delete_lifecycle (
230: P_api_version IN NUMBER := 1.0 ,
231: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
232: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
233: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
234: P_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
235: P_debug_mode IN VARCHAR2 := 'N' ,
228:
229: PROCEDURE delete_lifecycle (
230: P_api_version IN NUMBER := 1.0 ,
231: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
232: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
233: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
234: P_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
235: P_debug_mode IN VARCHAR2 := 'N' ,
236: P_max_msg_count IN NUMBER := G_MISS_NUM ,
229: PROCEDURE delete_lifecycle (
230: P_api_version IN NUMBER := 1.0 ,
231: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
232: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
233: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
234: P_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
235: P_debug_mode IN VARCHAR2 := 'N' ,
236: P_max_msg_count IN NUMBER := G_MISS_NUM ,
237: P_lifecycle_id IN NUMBER ,
248: -- Pre-reqs : None.
249: -- Purpose : deletes a given lifecycle phase
250: -- Parameters :
251: -- p_api_version IN NUMBER Optional Default 1.0
252: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
253: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
254: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
255: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
256: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
249: -- Purpose : deletes a given lifecycle phase
250: -- Parameters :
251: -- p_api_version IN NUMBER Optional Default 1.0
252: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
253: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
254: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
255: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
256: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
257: -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
250: -- Parameters :
251: -- p_api_version IN NUMBER Optional Default 1.0
252: -- P_commit IN VARCHAR2 Optional Default FND_API.G_FALSE
253: -- P_validate_only IN VARCHAR2 Optional Default FND_API.G_TRUE
254: -- P_validation_level IN VARCHAR2 Optional Default FND_API.G_VALID_LEVEL_FULL
255: -- P_calling_module IN VARCHAR2 Optional Default 'SELF_SERVICE'
256: -- P_debug_mode IN VARCHAR2 Optional Default 'N'
257: -- P_max_msg_count IN NUMBER Optional Default G_MISS_NUM
258: -- P_phase_id IN NUMBER Required
267:
268:
269: PROCEDURE delete_lifecycle_phase (
270: P_api_version IN NUMBER := 1.0 ,
271: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
272: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
273: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
274: P_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
275: P_debug_mode IN VARCHAR2 := 'N' ,
268:
269: PROCEDURE delete_lifecycle_phase (
270: P_api_version IN NUMBER := 1.0 ,
271: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
272: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
273: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
274: P_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
275: P_debug_mode IN VARCHAR2 := 'N' ,
276: P_max_msg_count IN NUMBER := G_MISS_NUM ,
269: PROCEDURE delete_lifecycle_phase (
270: P_api_version IN NUMBER := 1.0 ,
271: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
272: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
273: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
274: P_calling_module IN VARCHAR2 := 'SELF_SERVICE' ,
275: P_debug_mode IN VARCHAR2 := 'N' ,
276: P_max_msg_count IN NUMBER := G_MISS_NUM ,
277: P_phase_id IN NUMBER ,