[Home] [Help]
PACKAGE: APPS.JTF_TASK_RECURRENCES_PVT
Source
1 PACKAGE jtf_task_recurrences_pvt AS
2 /* $Header: jtfvtkus.pls 120.2 2006/04/13 03:53:01 sbarat ship $ */
3 g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_TASK_RECURRENCE';
4
5
6 TYPE output_dates_rec IS TABLE OF DATE
7 INDEX BY BINARY_INTEGER;
8
9 PROCEDURE create_task_recurrence (
10 p_api_version IN NUMBER,
11 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
12 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
13 p_task_id IN NUMBER,
14 p_occurs_which IN INTEGER DEFAULT NULL,
15 p_day_of_week IN INTEGER DEFAULT NULL,
16 p_date_of_month IN INTEGER DEFAULT NULL,
17 p_occurs_month IN INTEGER DEFAULT NULL,
18 p_occurs_uom IN VARCHAR2 DEFAULT NULL,
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,
28 x_task_rec OUT NOCOPY jtf_task_recurrences_pub.task_details_rec,
29 x_output_dates_counter OUT NOCOPY INTEGER,
30 p_attribute1 IN VARCHAR2 DEFAULT null ,
31 p_attribute2 IN VARCHAR2 DEFAULT null ,
32 p_attribute3 IN VARCHAR2 DEFAULT null ,
33 p_attribute4 IN VARCHAR2 DEFAULT null ,
34 p_attribute5 IN VARCHAR2 DEFAULT null ,
35 p_attribute6 IN VARCHAR2 DEFAULT null ,
36 p_attribute7 IN VARCHAR2 DEFAULT null ,
37 p_attribute8 IN VARCHAR2 DEFAULT null ,
38 p_attribute9 IN VARCHAR2 DEFAULT null ,
39 p_attribute10 IN VARCHAR2 DEFAULT null ,
40 p_attribute11 IN VARCHAR2 DEFAULT null ,
41 p_attribute12 IN VARCHAR2 DEFAULT null ,
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,
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,
57 p_day_of_week NUMBER DEFAULT NULL,
58 p_date_of_month NUMBER DEFAULT NULL,
59 p_occurs_month NUMBER DEFAULT NULL,
60 p_occurs_uom VARCHAR2 DEFAULT NULL,
61 p_occurs_every NUMBER DEFAULT NULL,
62 p_occurs_number NUMBER DEFAULT 0,
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,
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 (
78 p_occurs_which VARCHAR2 DEFAULT NULL,
79 p_day_of_week VARCHAR2 DEFAULT NULL,
80 p_date_of_month NUMBER DEFAULT NULL,
81 p_occurs_month NUMBER DEFAULT NULL,
82 p_occurs_uom VARCHAR2 DEFAULT NULL,
83 p_occurs_every NUMBER DEFAULT NULL,
84 p_occurs_number NUMBER DEFAULT 0,
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,
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 (
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
102 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
103 p_task_id IN NUMBER,
104 p_recurrence_rule_id IN NUMBER,
105 p_occurs_which IN INTEGER DEFAULT NULL,
106 p_day_of_week IN INTEGER DEFAULT NULL,
107 p_date_of_month IN INTEGER DEFAULT NULL,
108 p_occurs_month IN INTEGER DEFAULT NULL,
109 p_occurs_uom IN VARCHAR2 DEFAULT NULL,
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 ,
119 p_attribute5 IN VARCHAR2 DEFAULT NULL ,
120 p_attribute6 IN VARCHAR2 DEFAULT NULL ,
121 p_attribute7 IN VARCHAR2 DEFAULT NULL ,
122 p_attribute8 IN VARCHAR2 DEFAULT NULL ,
123 p_attribute9 IN VARCHAR2 DEFAULT NULL ,
124 p_attribute10 IN VARCHAR2 DEFAULT NULL ,
125 p_attribute11 IN VARCHAR2 DEFAULT NULL ,
126 p_attribute12 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,
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
142 );
143
144 END;