1 PACKAGE jtf_task_mass_pvt AUTHID CURRENT_USER AS
2 /* $Header: jtfvtkbs.pls 115.4 2002/12/04 02:19:16 cjang ship $ */
3
4
5 G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TASK_MASS_PVT';
6 G_USER CONSTANT VARCHAR2(30):=FND_GLOBAL.USER_ID;
7 G_FALSE CONSTANT VARCHAR2(30):=FND_API.G_FALSE;
8 G_TRUE CONSTANT VARCHAR2(30):=FND_API.G_TRUE;
9
10 ----------------------------------------------------------------------------------------------------
11 -- Start of comments
12 -- Procedure Name : create_mass_tasks
13 -- Type : Private
14 -- Function : Create tasks for all the members of a group or a team.
15 -- Pre reqs : None
16 -- Parameters :
17 -- name direction type required
18 -- ------ --------- ---- --------
19 -- p_api_version IN NUMBER required
20 -- p_init_msg_list IN VARCHAR2 optional
21 -- p_commit IN VARCHAR2 optional
22 -- x_msg_count OUT NOCOPY NUMBER required
23 -- x_msg_data OUT NOCOPY VARCHAR2 required
24 -- x_return_status OUT NOCOPY VARCHAR2 required
25 -- p_resource_type IN VARCHAR2 required
26 -- p_resource_id IN NUMBER required
27 -- p_task_id IN NUMBER required
28 -- p_task_number IN VARCHAR2 required
29 -- p_keep_record IN VARCHAR2 optional
30 -- p_keep_resource_id IN NUMBER optional
31 -- p_copy_notes IN VARCHAR2 optional
32 -- p_copy_task_assignments IN VARCHAR2 optional
33 -- p_copy_task_rsc_reqs IN VARCHAR2 optional
34 -- p_copy_task_depends IN VARCHAR2 optional
35 -- p_create_recurrences IN VARCHAR2 optional
36 -- p_copy_task_references IN VARCHAR2 optional
37 -- p_copy_task_dates IN VARCHAR2 optional
38
39 -----------------------------------------------------------------------------------------------------
40
41 PROCEDURE create_mass_tasks( p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
43 p_commit IN VARCHAR2 DEFAULT fnd_api.g_true,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2,
47 p_resource_type IN VARCHAR2,
48 p_resource_id IN NUMBER,
49 p_task_id IN NUMBER,
50 p_task_number IN VARCHAR2,
51 p_keep_record IN VARCHAR2 DEFAULT NULL,
52 p_keep_resource_id IN NUMBER DEFAULT NULL,
53 p_copy_notes IN VARCHAR2 DEFAULT fnd_api.g_false,
54 p_copy_task_assignments IN VARCHAR2 DEFAULT fnd_api.g_false,
55 p_copy_task_rsc_reqs IN VARCHAR2 DEFAULT fnd_api.g_false,
56 p_copy_task_depends IN VARCHAR2 DEFAULT fnd_api.g_false,
57 p_create_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false,
58 p_copy_task_references IN VARCHAR2 DEFAULT fnd_api.g_false,
59 p_copy_task_dates IN VARCHAR2 DEFAULT fnd_api.g_false);
60
61 ----------------------------------------------------------------------------------------------------
62 -- Start of comments
63 -- Procedure Name : validate_resource
64 -- Type : private
65 -- Function : Validate a given resource.
66 -- Pre reqs : None
67 -- Parameters :
68 -- name direction type required
69 -- ------ --------- ---- --------
70 -- p_api_version IN NUMBER required
71 -- p_init_msg_list IN VARCHAR2 optional
72 -- p_resource_type IN VARCHAR2 required
73 -- p_resource_type_id IN NUMBER required
74 -- x_msg_count OUT NOCOPY NUMBER required
75 -- x_msg_data OUT NOCOPY VARCHAR2 required
76 -- x_return_status OUT NOCOPY VARCHAR2 required
77
78 -----------------------------------------------------------------------------------------------------
79
80 PROCEDURE validate_resource(p_api_version in number,
81 p_init_msg_list in varchar2,
82 p_resource_type in varchar2,
83 p_resource_type_id in number,
84 x_msg_count OUT NOCOPY number,
85 x_msg_data OUT NOCOPY varchar2,
86 x_return_status OUT NOCOPY varchar2);
87 END jtf_task_mass_pvt;