[Home] [Help]
PACKAGE: APPS.JTF_TASK_TEMP_GROUP_PUB
Source
1 PACKAGE JTF_TASK_TEMP_GROUP_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfptkgs.pls 115.24 2002/12/06 01:35:46 sachoudh ship $ */
3
4 ---------------------------------------------------------------------------
5 --Define Global Variables--
6 ---------------------------------------------------------------------------
7
8 G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TASK_TEMP_GROUP_PUB';
9 G_USER CONSTANT VARCHAR2(30):=FND_GLOBAL.USER_ID;
10 G_FALSE CONSTANT VARCHAR2(30):=FND_API.G_FALSE;
11 G_TRUE CONSTANT VARCHAR2(30):=FND_API.G_TRUE;
12 ---------------------------------------------------------------------------
13
14 Type TASK_TEMPLATE_GROUP_REC is RECORD
15 (
16 TASK_TEMPLATE_GROUP_ID jtf_task_temp_groups_vl.task_template_group_id%type,
17 TEMPLATE_GROUP_NAME jtf_task_temp_groups_vl.template_group_name%type,
18 SOURCE_OBJECT_TYPE_CODE jtf_task_temp_groups_vl.source_object_type_code%type,
19 START_DATE_ACTIVE jtf_task_temp_groups_vl.start_date_active%type,
20 END_DATE_ACTIVE jtf_task_temp_groups_vl.end_date_active%type,
21 DESCRIPTION jtf_task_temp_groups_vl.description%type,
22 ATTRIBUTE1 jtf_task_temp_groups_vl.attribute1%type,
23 ATTRIBUTE2 jtf_task_temp_groups_vl.attribute2%type,
24 ATTRIBUTE3 jtf_task_temp_groups_vl.attribute3%type,
25 ATTRIBUTE4 jtf_task_temp_groups_vl.attribute4%type,
26 ATTRIBUTE5 jtf_task_temp_groups_vl.attribute5%type,
27 ATTRIBUTE6 jtf_task_temp_groups_vl.attribute6%type,
28 ATTRIBUTE7 jtf_task_temp_groups_vl.attribute7%type,
29 ATTRIBUTE8 jtf_task_temp_groups_vl.attribute8%type,
30 ATTRIBUTE9 jtf_task_temp_groups_vl.attribute9%type,
31 ATTRIBUTE10 jtf_task_temp_groups_vl.attribute10%type,
32 ATTRIBUTE11 jtf_task_temp_groups_vl.attribute11%type,
33 ATTRIBUTE12 jtf_task_temp_groups_vl.attribute12%type,
34 ATTRIBUTE13 jtf_task_temp_groups_vl.attribute13%type,
35 ATTRIBUTE14 jtf_task_temp_groups_vl.attribute14%type,
36 ATTRIBUTE15 jtf_task_temp_groups_vl.attribute15%type,
37 ATTRIBUTE_CATEGORY jtf_task_temp_groups_vl.attribute_category%type,
38 object_version_number jtf_task_temp_groups_vl.object_version_number%type,
39 application_id jtf_task_temp_groups_vl.application_id%type
40 );
41
42
43 Type task_temp_group_tbl is table of task_template_group_rec
44 index by binary_integer;
45
46 type sort_rec is record
47 (
48 field_name varchar2(30),
49 asc_dsc_flag char(1) default 'A'
50 );
51
52 type sort_data is table of sort_rec
53 index by binary_integer;
54
55 --Procedure to Create Task Template Group
56
57 Procedure CREATE_TASK_TEMPLATE_GROUP
58 (
59 P_API_VERSION IN NUMBER,
60 P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
61 P_COMMIT IN VARCHAR2 default fnd_api.g_false,
62 P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
63 P_TEMPLATE_GROUP_NAME IN VARCHAR2,
64 P_SOURCE_OBJECT_TYPE_CODE IN VARCHAR2,
65 P_START_DATE_ACTIVE IN DATE,
66 P_END_DATE_ACTIVE IN DATE,
67 P_DESCRIPTION IN VARCHAR2,
68 P_ATTRIBUTE1 IN VARCHAR2,
69 P_ATTRIBUTE2 IN VARCHAR2,
70 P_ATTRIBUTE3 IN VARCHAR2,
71 P_ATTRIBUTE4 IN VARCHAR2,
72 P_ATTRIBUTE5 IN VARCHAR2,
73 P_ATTRIBUTE6 IN VARCHAR2,
74 P_ATTRIBUTE7 IN VARCHAR2,
75 P_ATTRIBUTE8 IN VARCHAR2,
76 P_ATTRIBUTE9 IN VARCHAR2,
77 P_ATTRIBUTE10 IN VARCHAR2,
78 P_ATTRIBUTE11 IN VARCHAR2,
79 P_ATTRIBUTE12 IN VARCHAR2,
80 P_ATTRIBUTE13 IN VARCHAR2,
81 P_ATTRIBUTE14 IN VARCHAR2,
82 P_ATTRIBUTE15 IN VARCHAR2,
83 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
84 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
85 X_MSG_COUNT OUT NOCOPY NUMBER,
86 X_MSG_DATA OUT NOCOPY VARCHAR2,
87 X_TASK_TEMPLATE_GROUP_ID OUT NOCOPY NUMBER,
88 p_APPLICATION_ID IN NUMBER default null
89 );
90
91 --Procedure to Upate Task Template Group
92
93 Procedure UPDATE_TASK_TEMPLATE_GROUP
94 (
95 P_API_VERSION IN NUMBER,
96 P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
97 P_COMMIT IN VARCHAR2 default fnd_api.g_false,
98 P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
99 P_TASK_TEMPLATE_GROUP_ID IN NUMBER,
100 P_TEMPLATE_GROUP_NAME IN VARCHAR2,
101 P_SOURCE_OBJECT_TYPE_CODE IN VARCHAR2,
102 P_START_DATE_ACTIVE IN DATE,
103 P_END_DATE_ACTIVE IN DATE,
104 P_DESCRIPTION IN VARCHAR2,
105 P_ATTRIBUTE1 IN VARCHAR2,
106 P_ATTRIBUTE2 IN VARCHAR2,
107 P_ATTRIBUTE3 IN VARCHAR2,
108 P_ATTRIBUTE4 IN VARCHAR2,
109 P_ATTRIBUTE5 IN VARCHAR2,
110 P_ATTRIBUTE6 IN VARCHAR2,
111 P_ATTRIBUTE7 IN VARCHAR2,
112 P_ATTRIBUTE8 IN VARCHAR2,
113 P_ATTRIBUTE9 IN VARCHAR2,
114 P_ATTRIBUTE10 IN VARCHAR2,
115 P_ATTRIBUTE11 IN VARCHAR2,
116 P_ATTRIBUTE12 IN VARCHAR2,
117 P_ATTRIBUTE13 IN VARCHAR2,
118 P_ATTRIBUTE14 IN VARCHAR2,
119 P_ATTRIBUTE15 IN VARCHAR2,
120 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
121 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
122 X_MSG_COUNT OUT NOCOPY NUMBER,
123 X_MSG_DATA OUT NOCOPY VARCHAR2,
124 X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
125 p_application_id IN NUMBER default null
126 );
127
128
129 --Procedure to Delete Task Template Group
130
131 Procedure DELETE_TASK_TEMPLATE_GROUP
132 (
133 P_API_VERSION IN NUMBER,
134 P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
135 P_COMMIT IN VARCHAR2 default fnd_api.g_false,
136 P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
137 P_TASK_TEMPLATE_GROUP_ID IN NUMBER,
138 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
139 X_MSG_COUNT OUT NOCOPY NUMBER,
140 X_MSG_DATA OUT NOCOPY VARCHAR2,
141 X_OBJECT_VERSION_NUMBER IN NUMBER
142 );
143
144 PROCEDURE LOCK_TASK_TEMPLATE_GROUP (
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
147 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
148 P_TASK_TEMPLATE_GROUP_ID IN NUMBER,
149 p_object_version_number IN NUMBER ,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER
153 );
154
155 Procedure GET_TASK_TEMPLATE_GROUP
156 (
157 P_API_VERSION IN NUMBER,
158 P_INIT_MSG_LIST IN VARCHAR2 default fnd_api.g_false,
159 P_COMMIT IN VARCHAR2 default fnd_api.g_false,
160 P_VALIDATE_LEVEL IN VARCHAR2 default fnd_api.g_valid_level_full,
161 P_TASK_TEMPLATE_GROUP_ID IN NUMBER,
162 P_TEMPLATE_GROUP_NAME IN VARCHAR2,
163 P_SOURCE_OBJECT_TYPE_CODE IN VARCHAR2,
164 P_START_DATE_ACTIVE IN DATE,
165 P_END_DATE_ACTIVE IN DATE,
166 P_SORT_DATA IN SORT_DATA,
167 P_QUERY_OR_NEXT_CODE IN VARCHAR2 default 'Q',
168 P_START_POINTER IN NUMBER,
169 P_REC_WANTED IN NUMBER,
170 P_SHOW_ALL IN VARCHAR2,
171 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
172 X_MSG_COUNT OUT NOCOPY NUMBER,
173 X_MSG_DATA OUT NOCOPY VARCHAR2,
174 X_TASK_TEMPLATE_GROUP OUT NOCOPY TASK_TEMP_GROUP_TBL,
175 X_TOTAL_RETRIEVED OUT NOCOPY NUMBER,
176 X_TOTAL_RETURNED OUT NOCOPY NUMBER,
177 p_APPLICATION_ID IN NUMBER default null
178 );
179
180 END JTF_TASK_TEMP_GROUP_PUB;