1 PACKAGE JTA_CAL_APPOINTMENT_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtavcas.pls 120.1 2005/07/02 02:24:32 appldev ship $ */
3
4
5 PROCEDURE create_appointment (
6 p_task_name IN VARCHAR2,
7 p_task_type_id IN NUMBER,
8 p_description IN VARCHAR2 DEFAULT NULL,
9 p_task_priority_id IN NUMBER DEFAULT NULL,
10 p_owner_type_code IN VARCHAR2 DEFAULT NULL,
11 p_owner_id IN NUMBER DEFAULT NULL,
12 p_planned_start_date IN DATE,
13 p_planned_end_date IN DATE DEFAULT NULL,
14 p_timezone_id IN NUMBER,
15 p_private_flag IN VARCHAR2 DEFAULT NULL,
16 p_alarm_start IN NUMBER DEFAULT NULL,
17 p_alarm_on IN VARCHAR2 DEFAULT NULL,
18 p_category_id IN NUMBER DEFAULT NULL,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_task_id OUT NOCOPY NUMBER
21 );
22
23
24 PROCEDURE create_appointment (
25 p_task_name IN VARCHAR2,
26 p_task_type_id IN NUMBER,
27 p_description IN VARCHAR2 DEFAULT NULL,
28 p_task_priority_id IN NUMBER DEFAULT NULL,
29 p_owner_type_code IN VARCHAR2 DEFAULT NULL,
30 p_owner_id IN NUMBER DEFAULT NULL,
31 p_planned_start_date IN DATE,
32 p_planned_end_date IN DATE DEFAULT NULL,
33 p_timezone_id IN NUMBER,
34 p_private_flag IN VARCHAR2 DEFAULT NULL,
35 p_alarm_start IN NUMBER DEFAULT NULL,
36 p_alarm_on IN VARCHAR2 DEFAULT NULL,
37 p_category_id IN NUMBER DEFAULT NULL,
38 p_free_busy_type IN VARCHAR2,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_task_id OUT NOCOPY NUMBER
41 );
42
43 PROCEDURE update_appointment (
44 p_object_version_number IN OUT NOCOPY NUMBER ,
45 p_task_id IN NUMBER,
46 p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
47 p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
48 p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
49 p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
50 p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date,
51 p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date,
52 p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
53 p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
54 p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
55 p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
56 p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number,
57 p_change_mode IN VARCHAR2,
58 x_return_status OUT NOCOPY VARCHAR2
59 );
60
61 PROCEDURE update_appointment (
62 p_object_version_number IN OUT NOCOPY NUMBER ,
63 p_task_id IN NUMBER,
64 p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
65 p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num,
66 p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
67 p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num,
68 p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date,
69 p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date,
70 p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num,
71 p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
72 p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num,
73 p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
74 p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number,
75 p_free_busy_type IN VARCHAR2,
76 p_change_mode IN VARCHAR2,
77 x_return_status OUT NOCOPY VARCHAR2
78
79 );
80 PROCEDURE delete_appointment (
81 p_object_version_number IN NUMBER,
82 p_task_id IN NUMBER,
83 p_delete_future_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false,
84 x_return_status OUT NOCOPY VARCHAR2
85 );
86
87 END;