6: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
7: p_task_id IN NUMBER DEFAULT NULL,
8: p_task_number IN VARCHAR2 DEFAULT NULL,
9: p_occurs_which IN INTEGER DEFAULT NULL,
10: p_template_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
11: p_day_of_week IN INTEGER DEFAULT NULL,
12: p_date_of_month IN INTEGER DEFAULT NULL,
13: p_occurs_month IN INTEGER DEFAULT NULL,
14: p_occurs_uom IN VARCHAR2 DEFAULT NULL,
37: p_attribute13 IN VARCHAR2 DEFAULT null ,
38: p_attribute14 IN VARCHAR2 DEFAULT null ,
39: p_attribute15 IN VARCHAR2 DEFAULT null ,
40: p_attribute_category IN VARCHAR2 DEFAULT null ,
41: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
42: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
43: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
44: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
45: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
38: p_attribute14 IN VARCHAR2 DEFAULT null ,
39: p_attribute15 IN VARCHAR2 DEFAULT null ,
40: p_attribute_category IN VARCHAR2 DEFAULT null ,
41: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
42: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
43: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
44: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
45: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
46: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
39: p_attribute15 IN VARCHAR2 DEFAULT null ,
40: p_attribute_category IN VARCHAR2 DEFAULT null ,
41: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
42: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
43: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
44: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
45: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
46: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
47: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
40: p_attribute_category IN VARCHAR2 DEFAULT null ,
41: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
42: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
43: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
44: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
45: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
46: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
47: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
48: )
41: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
42: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
43: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
44: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
45: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
46: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
47: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
48: )
49: IS
42: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
43: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
44: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
45: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
46: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
47: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
48: )
49: IS
50: l_api_version CONSTANT NUMBER := 1.0;
43: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
44: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
45: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
46: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
47: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
48: )
49: IS
50: l_api_version CONSTANT NUMBER := 1.0;
51: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK_RECURRENCE';
79: END IF;
80:
81:
82:
83: IF jtf_task_utl.to_boolean (l_template_flag)
84: THEN
85: jtf_task_utl.validate_task_template (
86: x_return_status => x_return_status,
87: p_task_id => p_task_id,
81:
82:
83: IF jtf_task_utl.to_boolean (l_template_flag)
84: THEN
85: jtf_task_utl.validate_task_template (
86: x_return_status => x_return_status,
87: p_task_id => p_task_id,
88: p_task_number => p_task_number,
89: x_task_id => l_task_id
97:
98:
99:
100: ELSE
101: jtf_task_utl.validate_task (
102: x_return_status => x_return_status,
103: p_task_id => p_task_id,
104: p_task_number => p_task_number,
105: x_task_id => l_task_id
210: p_occurs_every IN INTEGER DEFAULT NULL,
211: p_occurs_number IN INTEGER DEFAULT NULL,
212: p_start_date_active IN DATE DEFAULT NULL,
213: p_end_date_active IN DATE DEFAULT NULL,
214: p_template_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
215: p_attribute1 IN VARCHAR2 DEFAULT NULL ,
216: p_attribute2 IN VARCHAR2 DEFAULT NULL ,
217: p_attribute3 IN VARCHAR2 DEFAULT NULL ,
218: p_attribute4 IN VARCHAR2 DEFAULT NULL ,
227: p_attribute13 IN VARCHAR2 DEFAULT NULL ,
228: p_attribute14 IN VARCHAR2 DEFAULT NULL ,
229: p_attribute15 IN VARCHAR2 DEFAULT NULL ,
230: p_attribute_category IN VARCHAR2 DEFAULT NULL ,
231: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
232: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
233: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
234: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
235: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
228: p_attribute14 IN VARCHAR2 DEFAULT NULL ,
229: p_attribute15 IN VARCHAR2 DEFAULT NULL ,
230: p_attribute_category IN VARCHAR2 DEFAULT NULL ,
231: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
232: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
233: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
234: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
235: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
236: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
229: p_attribute15 IN VARCHAR2 DEFAULT NULL ,
230: p_attribute_category IN VARCHAR2 DEFAULT NULL ,
231: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
232: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
233: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
234: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
235: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
236: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
237: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
230: p_attribute_category IN VARCHAR2 DEFAULT NULL ,
231: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
232: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
233: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
234: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
235: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
236: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
237: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
238: x_new_recurrence_rule_id OUT NOCOPY NUMBER,
231: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
232: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
233: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
234: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
235: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
236: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
237: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
238: x_new_recurrence_rule_id OUT NOCOPY NUMBER,
239: x_return_status OUT NOCOPY VARCHAR2,
232: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
233: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
234: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
235: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
236: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
237: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
238: x_new_recurrence_rule_id OUT NOCOPY NUMBER,
239: x_return_status OUT NOCOPY VARCHAR2,
240: x_msg_count OUT NOCOPY NUMBER,
233: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
234: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
235: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
236: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
237: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
238: x_new_recurrence_rule_id OUT NOCOPY NUMBER,
239: x_return_status OUT NOCOPY VARCHAR2,
240: x_msg_count OUT NOCOPY NUMBER,
241: x_msg_data OUT NOCOPY VARCHAR2