19: p_occurs_every IN INTEGER DEFAULT NULL,
20: p_occurs_number IN INTEGER DEFAULT NULL,
21: p_start_date_active IN DATE DEFAULT NULL,
22: p_end_date_active IN DATE DEFAULT NULL,
23: p_template_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER,
26: x_msg_data OUT NOCOPY VARCHAR2,
27: x_recurrence_rule_id OUT NOCOPY NUMBER,
42: p_attribute13 IN VARCHAR2 DEFAULT null ,
43: p_attribute14 IN VARCHAR2 DEFAULT null ,
44: p_attribute15 IN VARCHAR2 DEFAULT null ,
45: p_attribute_category IN VARCHAR2 DEFAULT null ,
46: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
47: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
48: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
49: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
50: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
43: p_attribute14 IN VARCHAR2 DEFAULT null ,
44: p_attribute15 IN VARCHAR2 DEFAULT null ,
45: p_attribute_category IN VARCHAR2 DEFAULT null ,
46: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
47: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
48: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
49: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
50: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
51: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
44: p_attribute15 IN VARCHAR2 DEFAULT null ,
45: p_attribute_category IN VARCHAR2 DEFAULT null ,
46: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
47: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
48: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
49: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
50: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
51: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
52: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
45: p_attribute_category IN VARCHAR2 DEFAULT null ,
46: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
47: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
48: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
49: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
50: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
51: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
52: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
53: );
46: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
47: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
48: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
49: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
50: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
51: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
52: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
53: );
54:
47: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
48: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
49: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
50: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
51: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
52: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
53: );
54:
55: PROCEDURE generate_dates (
48: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
49: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
50: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
51: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
52: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
53: );
54:
55: PROCEDURE generate_dates (
56: p_occurs_which NUMBER DEFAULT NULL,
63: p_start_date DATE DEFAULT NULL,
64: p_end_date DATE DEFAULT SYSDATE,
65: x_output_dates_tbl OUT NOCOPY jtf_task_recurrences_pvt.output_dates_rec,
66: x_output_dates_counter OUT NOCOPY INTEGER,
67: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
68: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
69: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
70: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
71: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
64: p_end_date DATE DEFAULT SYSDATE,
65: x_output_dates_tbl OUT NOCOPY jtf_task_recurrences_pvt.output_dates_rec,
66: x_output_dates_counter OUT NOCOPY INTEGER,
67: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
68: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
69: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
70: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
71: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
72: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
65: x_output_dates_tbl OUT NOCOPY jtf_task_recurrences_pvt.output_dates_rec,
66: x_output_dates_counter OUT NOCOPY INTEGER,
67: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
68: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
69: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
70: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
71: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
72: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
73: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
66: x_output_dates_counter OUT NOCOPY INTEGER,
67: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
68: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
69: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
70: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
71: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
72: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
73: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
74: p_task_id IN NUMBER DEFAULT NULL -- Added by SBARAT on 13/04/2006 for bug# 5119803
67: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
68: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
69: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
70: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
71: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
72: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
73: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
74: p_task_id IN NUMBER DEFAULT NULL -- Added by SBARAT on 13/04/2006 for bug# 5119803
75: );
68: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
69: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
70: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
71: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
72: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
73: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
74: p_task_id IN NUMBER DEFAULT NULL -- Added by SBARAT on 13/04/2006 for bug# 5119803
75: );
76:
69: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
70: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
71: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
72: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
73: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
74: p_task_id IN NUMBER DEFAULT NULL -- Added by SBARAT on 13/04/2006 for bug# 5119803
75: );
76:
77: PROCEDURE recur_main (
85: p_start_date DATE DEFAULT NULL,
86: p_end_date DATE DEFAULT NULL,
87: x_output_dates_tbl OUT NOCOPY jtf_task_recurrences_pvt.output_dates_rec,
88: x_output_dates_counter OUT NOCOPY INTEGER,
89: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
90: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
91: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
92: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
93: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
86: p_end_date DATE DEFAULT NULL,
87: x_output_dates_tbl OUT NOCOPY jtf_task_recurrences_pvt.output_dates_rec,
88: x_output_dates_counter OUT NOCOPY INTEGER,
89: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
90: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
91: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
92: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
93: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
94: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
87: x_output_dates_tbl OUT NOCOPY jtf_task_recurrences_pvt.output_dates_rec,
88: x_output_dates_counter OUT NOCOPY INTEGER,
89: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
90: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
91: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
92: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
93: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
94: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
95: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
88: x_output_dates_counter OUT NOCOPY INTEGER,
89: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
90: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
91: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
92: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
93: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
94: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
95: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
96: p_task_id IN NUMBER DEFAULT NULL -- Added by SBARAT on 13/04/2006 for bug# 5119803
89: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
90: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
91: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
92: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
93: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
94: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
95: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
96: p_task_id IN NUMBER DEFAULT NULL -- Added by SBARAT on 13/04/2006 for bug# 5119803
97: );
90: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
91: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
92: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
93: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
94: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
95: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
96: p_task_id IN NUMBER DEFAULT NULL -- Added by SBARAT on 13/04/2006 for bug# 5119803
97: );
98:
91: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
92: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
93: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
94: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
95: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
96: p_task_id IN NUMBER DEFAULT NULL -- Added by SBARAT on 13/04/2006 for bug# 5119803
97: );
98:
99: PROCEDURE update_task_recurrence (
110: p_occurs_every IN INTEGER DEFAULT NULL,
111: p_occurs_number IN INTEGER DEFAULT NULL,
112: p_start_date_active IN DATE DEFAULT NULL,
113: p_end_date_active IN DATE DEFAULT NULL,
114: p_template_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
115: p_attribute1 IN VARCHAR2 DEFAULT NULL ,
116: p_attribute2 IN VARCHAR2 DEFAULT NULL ,
117: p_attribute3 IN VARCHAR2 DEFAULT NULL ,
118: p_attribute4 IN VARCHAR2 DEFAULT NULL ,
127: p_attribute13 IN VARCHAR2 DEFAULT NULL ,
128: p_attribute14 IN VARCHAR2 DEFAULT NULL ,
129: p_attribute15 IN VARCHAR2 DEFAULT NULL ,
130: p_attribute_category IN VARCHAR2 DEFAULT NULL ,
131: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
132: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
133: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
134: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
135: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
128: p_attribute14 IN VARCHAR2 DEFAULT NULL ,
129: p_attribute15 IN VARCHAR2 DEFAULT NULL ,
130: p_attribute_category IN VARCHAR2 DEFAULT NULL ,
131: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
132: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
133: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
134: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
135: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
136: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
129: p_attribute15 IN VARCHAR2 DEFAULT NULL ,
130: p_attribute_category IN VARCHAR2 DEFAULT NULL ,
131: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
132: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
133: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
134: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
135: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
136: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
137: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
130: p_attribute_category IN VARCHAR2 DEFAULT NULL ,
131: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
132: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
133: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
134: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
135: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
136: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
137: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
138: x_new_recurrence_rule_id OUT NOCOPY NUMBER,
131: p_sunday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
132: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
133: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
134: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
135: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
136: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
137: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
138: x_new_recurrence_rule_id OUT NOCOPY NUMBER,
139: x_return_status OUT NOCOPY VARCHAR2,
132: p_monday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
133: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
134: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
135: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
136: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
137: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
138: x_new_recurrence_rule_id OUT NOCOPY NUMBER,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
133: p_tuesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
134: p_wednesday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
135: p_thursday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
136: p_friday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
137: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char,
138: x_new_recurrence_rule_id OUT NOCOPY NUMBER,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2