1 PACKAGE JTF_TASK_TEMP_GROUP_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfvtkgs.pls 120.1 2005/07/02 01:45:48 appldev ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TASK_TEMP_GROUP_PVT';
5
6 procedure create_task_template_group
7 (
8 P_COMMIT IN VARCHAR2,
9 P_TEMPLATE_GROUP_NAME IN VARCHAR2,
10 P_SOURCE_OBJECT_TYPE_CODE IN VARCHAR2,
11 P_START_DATE_ACTIVE IN DATE,
12 P_END_DATE_ACTIVE IN DATE,
13 P_DESCRIPTION IN VARCHAR2,
14 P_ATTRIBUTE1 IN VARCHAR2,
15 P_ATTRIBUTE2 IN VARCHAR2,
16 P_ATTRIBUTE3 IN VARCHAR2,
17 P_ATTRIBUTE4 IN VARCHAR2,
18 P_ATTRIBUTE5 IN VARCHAR2,
19 P_ATTRIBUTE6 IN VARCHAR2,
20 P_ATTRIBUTE7 IN VARCHAR2,
21 P_ATTRIBUTE8 IN VARCHAR2,
22 P_ATTRIBUTE9 IN VARCHAR2,
23 P_ATTRIBUTE10 IN VARCHAR2,
24 P_ATTRIBUTE11 IN VARCHAR2,
25 P_ATTRIBUTE12 IN VARCHAR2,
26 P_ATTRIBUTE13 IN VARCHAR2,
27 P_ATTRIBUTE14 IN VARCHAR2,
28 P_ATTRIBUTE15 IN VARCHAR2,
29 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
30 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
31 X_MSG_COUNT OUT NOCOPY NUMBER,
32 X_MSG_DATA OUT NOCOPY VARCHAR2,
33 X_TASK_TEMPLATE_GROUP_ID OUT NOCOPY NUMBER,
34 p_application_id in NUMBER default null
35 );
36
37 procedure update_task_template_group
38 (
39 P_COMMIT IN VARCHAR2,
40 P_TASK_TEMPLATE_GROUP_ID IN NUMBER,
41 P_TEMPLATE_GROUP_NAME IN VARCHAR2,
42 P_SOURCE_OBJECT_TYPE_CODE IN VARCHAR2,
43 P_START_DATE_ACTIVE IN DATE,
44 P_END_DATE_ACTIVE IN DATE,
45 P_DESCRIPTION IN VARCHAR2,
46 P_ATTRIBUTE1 IN VARCHAR2,
47 P_ATTRIBUTE2 IN VARCHAR2,
48 P_ATTRIBUTE3 IN VARCHAR2,
49 P_ATTRIBUTE4 IN VARCHAR2,
50 P_ATTRIBUTE5 IN VARCHAR2,
51 P_ATTRIBUTE6 IN VARCHAR2,
52 P_ATTRIBUTE7 IN VARCHAR2,
53 P_ATTRIBUTE8 IN VARCHAR2,
54 P_ATTRIBUTE9 IN VARCHAR2,
55 P_ATTRIBUTE10 IN VARCHAR2,
56 P_ATTRIBUTE11 IN VARCHAR2,
57 P_ATTRIBUTE12 IN VARCHAR2,
58 P_ATTRIBUTE13 IN VARCHAR2,
59 P_ATTRIBUTE14 IN VARCHAR2,
60 P_ATTRIBUTE15 IN VARCHAR2,
61 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
62 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
63 X_MSG_COUNT OUT NOCOPY NUMBER,
64 X_MSG_DATA OUT NOCOPY VARCHAR2,
65 X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
66 p_application_id in NUMBER default null
67 );
68
69 procedure delete_task_template_group
70 (
71 P_COMMIT IN VARCHAR2,
72 P_TASK_TEMPLATE_GROUP_ID IN NUMBER,
73 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
74 X_MSG_COUNT OUT NOCOPY NUMBER,
75 X_MSG_DATA OUT NOCOPY VARCHAR2
76 );
77
78 Procedure GET_TASK_TEMPLATE_GROUP
79 (
80 P_COMMIT IN VARCHAR2 default fnd_api.g_false,
81 P_TASK_TEMPLATE_GROUP_ID IN NUMBER,
82 P_TEMPLATE_GROUP_NAME IN VARCHAR2,
83 P_SOURCE_OBJECT_TYPE_CODE IN VARCHAR2,
84 P_START_DATE_ACTIVE IN DATE,
85 P_END_DATE_ACTIVE IN DATE,
86 P_SORT_DATA IN jtf_task_temp_group_pub.SORT_DATA,
87 P_QUERY_OR_NEXT_CODE IN VARCHAR2 default 'Q',
88 P_START_POINTER IN NUMBER,
89 P_REC_WANTED IN NUMBER,
90 P_SHOW_ALL IN VARCHAR2 default 'Y',
91 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
92 X_MSG_COUNT OUT NOCOPY NUMBER,
93 X_MSG_DATA OUT NOCOPY VARCHAR2,
94 X_TASK_TEMPLATE_GROUP OUT NOCOPY jtf_task_temp_group_pub.TASK_TEMP_GROUP_TBL,
95 X_TOTAL_RETRIEVED OUT NOCOPY NUMBER,
96 X_TOTAL_RETURNED OUT NOCOPY NUMBER,
97 p_application_id IN NUMBER default null
98 );
99
100
101 END;