[Home] [Help]
PACKAGE: APPS.JTA_CAL_ATTENDEES_PVT
Source
1 PACKAGE JTA_CAL_ATTENDEES_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtavcats.pls 115.5 2002/12/07 01:24:19 rdespoto ship $ */
3 /*=======================================================================+
4 | Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA|
5 | All rights reserved. |
6 +=======================================================================+
7 | FILENAME |
8 | jtavcats.pls |
9 | |
10 | DESCRIPTION |
11 | - This package contains calendar assignment procedures. |
12 | |
13 | NOTES |
14 | |
15 | Date Developer Change |
16 | ------ --------------- -------------------------------------- |
17 | 12-Apr-2002 arpatel Created. |
18 +======================================================================*/
19
20 TYPE Resource_rec IS RECORD
21 (
22 resource_id NUMBER,
23 resource_type VARCHAR2(30)
24 );
25
26 TYPE Resource_tbl IS TABLE OF Resource_rec
27 INDEX BY BINARY_INTEGER;
28
29 TYPE Task_Assign_rec IS RECORD
30 (
31 task_assignment_id NUMBER
32 );
33
34 TYPE Task_Assign_tbl IS TABLE OF Task_Assign_rec
35 INDEX BY BINARY_INTEGER;
36
37 PROCEDURE create_cal_assignment (
38 p_task_id IN NUMBER,
39 p_resources IN Resource_tbl,
40 p_add_option IN VARCHAR2,
41 p_invitor_res_id IN NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_task_assignment_ids OUT NOCOPY Task_Assign_tbl
44 );
45
46 PROCEDURE delete_cal_assignment
47 (p_object_version_number IN NUMBER,
48 p_task_assignments IN Task_Assign_tbl,
49 p_delete_option IN VARCHAR2,
50 p_no_of_attendies IN NUMBER,
51 x_return_status OUT NOCOPY VARCHAR2
52 );
53
54 PROCEDURE update_cal_assignment (
55 p_object_version_number IN OUT NOCOPY NUMBER,
56 p_task_assignment_id IN NUMBER,
57 p_resource_id IN NUMBER,
58 p_resource_type IN VARCHAR2,
59 p_assignment_status_id IN NUMBER,
60 x_return_status OUT NOCOPY VARCHAR2
61 ) ;
62
63 End ;