[Home] [Help]
PACKAGE: APPS.JTF_TASK_REPEAT_APPT_PVT
Source
1 PACKAGE JTF_TASK_REPEAT_APPT_PVT AS
2 /* $Header: jtfvtkos.pls 120.2 2005/08/04 13:32:16 sbarat ship $ */
3 /*======================================================================+
4 | Copyright (c) 1995 Oracle Corporation Redwood Shores, California, USA|
5 | All rights reserved. |
6 +=======================================================================+
7 | FILENAME |
8 | jtfvtkos.pls |
9 | |
10 | DESCRIPTION |
11 | This is used to process the change of repeating appointments |
12 | NOTES |
13 | |
14 | Date Developer Change |
15 |------ --------------- ---------------------------------------|
16 | 26-Mar-2002 cjang Created |
17 | 28-Mar-2002 cjang Modified the code for p_change_mode |
18 | Added is_this_first_task(), |
19 | get_new_first_taskid(), |
20 | exist_syncid() |
21 | 01-Apr-2002 cjang Moved is_this_first_task(), |
22 | get_new_first_taskid(), |
23 | exist_syncid() |
24 | to jtf_task_utl |
25 | Changed G_ONE from 'O' to 'F' |
26 | 03-Aug-2005 Swapan Barat Added location_id field in |
27 | updated_field_rec for Enh# 3691788 |
28 *=======================================================================*/
29 G_FUTURE CONSTANT VARCHAR2(1) := 'T';
30 G_ALL CONSTANT VARCHAR2(1) := 'A';
31 G_ONE CONSTANT VARCHAR2(1) := 'F';
32 G_SKIP CONSTANT VARCHAR2(1) := 'N';
33
34 TYPE updated_field_rec IS RECORD
35 (
36 task_id NUMBER DEFAULT fnd_api.g_miss_num,
37 task_name jtf_tasks_tl.task_name%TYPE DEFAULT fnd_api.g_miss_char,
38 task_type_id NUMBER DEFAULT fnd_api.g_miss_num,
39 description jtf_tasks_tl.description%TYPE DEFAULT fnd_api.g_miss_char,
40 task_status_id NUMBER DEFAULT fnd_api.g_miss_num,
41 task_priority_id NUMBER DEFAULT fnd_api.g_miss_num,
42 owner_type_code jtf_tasks_b.owner_type_code%TYPE DEFAULT fnd_api.g_miss_char,
43 owner_id NUMBER DEFAULT fnd_api.g_miss_num,
44 owner_territory_id NUMBER DEFAULT fnd_api.g_miss_num,
45 assigned_by_id NUMBER DEFAULT fnd_api.g_miss_num,
46 customer_id NUMBER DEFAULT fnd_api.g_miss_num,
47 cust_account_id NUMBER DEFAULT fnd_api.g_miss_num,
48 address_id NUMBER DEFAULT fnd_api.g_miss_num, ---- hz_party_sites
49 planned_start_date DATE DEFAULT fnd_api.g_miss_date,
50 planned_end_date DATE DEFAULT fnd_api.g_miss_date,
51 scheduled_start_date DATE DEFAULT fnd_api.g_miss_date,
52 scheduled_end_date DATE DEFAULT fnd_api.g_miss_date,
53 actual_start_date DATE DEFAULT fnd_api.g_miss_date,
54 actual_end_date DATE DEFAULT fnd_api.g_miss_date,
55 timezone_id NUMBER DEFAULT fnd_api.g_miss_num,
56 source_object_type_code jtf_tasks_b.source_object_type_code%TYPE DEFAULT fnd_api.g_miss_char,
57 source_object_id NUMBER DEFAULT fnd_api.g_miss_num,
58 source_object_name jtf_tasks_b.source_object_name%TYPE DEFAULT fnd_api.g_miss_char,
59 duration NUMBER DEFAULT fnd_api.g_miss_num,
60 duration_uom jtf_tasks_b.duration_uom%TYPE DEFAULT fnd_api.g_miss_char,
61 planned_effort NUMBER DEFAULT fnd_api.g_miss_num,
62 planned_effort_uom jtf_tasks_b.planned_effort_uom%TYPE DEFAULT fnd_api.g_miss_char,
63 actual_effort NUMBER DEFAULT fnd_api.g_miss_num,
64 actual_effort_uom jtf_tasks_b.actual_effort_uom%TYPE DEFAULT fnd_api.g_miss_char,
65 percentage_complete NUMBER DEFAULT fnd_api.g_miss_num,
66 reason_code jtf_tasks_b.reason_code%TYPE DEFAULT fnd_api.g_miss_char,
67 private_flag jtf_tasks_b.private_flag%TYPE DEFAULT fnd_api.g_miss_char,
68 publish_flag jtf_tasks_b.publish_flag%TYPE DEFAULT fnd_api.g_miss_char,
69 restrict_closure_flag jtf_tasks_b.restrict_closure_flag%TYPE DEFAULT fnd_api.g_miss_char,
70 multi_booked_flag jtf_tasks_b.multi_booked_flag%TYPE DEFAULT fnd_api.g_miss_char,
71 milestone_flag jtf_tasks_b.milestone_flag%TYPE DEFAULT fnd_api.g_miss_char,
72 holiday_flag jtf_tasks_b.holiday_flag%TYPE DEFAULT fnd_api.g_miss_char,
73 billable_flag jtf_tasks_b.billable_flag%TYPE DEFAULT fnd_api.g_miss_char,
74 bound_mode_code jtf_tasks_b.bound_mode_code%TYPE DEFAULT fnd_api.g_miss_char,
75 soft_bound_flag jtf_tasks_b.soft_bound_flag%TYPE DEFAULT fnd_api.g_miss_char,
76 workflow_process_id NUMBER DEFAULT fnd_api.g_miss_num,
77 notification_flag jtf_tasks_b.notification_flag%TYPE DEFAULT fnd_api.g_miss_char,
78 notification_period jtf_tasks_b.notification_period%TYPE DEFAULT fnd_api.g_miss_num,
79 notification_period_uom jtf_tasks_b.notification_period_uom%TYPE DEFAULT fnd_api.g_miss_char,
80 parent_task_id NUMBER DEFAULT fnd_api.g_miss_num,
81 alarm_start NUMBER DEFAULT fnd_api.g_miss_num,
82 alarm_start_uom jtf_tasks_b.alarm_start_uom%TYPE DEFAULT fnd_api.g_miss_char,
83 alarm_on jtf_tasks_b.alarm_on%TYPE DEFAULT fnd_api.g_miss_char,
84 alarm_count NUMBER DEFAULT fnd_api.g_miss_num,
85 alarm_fired_count NUMBER DEFAULT fnd_api.g_miss_num,
86 alarm_interval NUMBER DEFAULT fnd_api.g_miss_num,
87 alarm_interval_uom jtf_tasks_b.alarm_interval_uom%TYPE DEFAULT fnd_api.g_miss_char,
88 palm_flag jtf_tasks_b.palm_flag%TYPE DEFAULT fnd_api.g_miss_char,
89 wince_flag jtf_tasks_b.wince_flag%TYPE DEFAULT fnd_api.g_miss_char,
90 laptop_flag jtf_tasks_b.laptop_flag%TYPE DEFAULT fnd_api.g_miss_char,
91 device1_flag jtf_tasks_b.device1_flag%TYPE DEFAULT fnd_api.g_miss_char,
92 device2_flag jtf_tasks_b.device2_flag%TYPE DEFAULT fnd_api.g_miss_char,
93 device3_flag jtf_tasks_b.device3_flag%TYPE DEFAULT fnd_api.g_miss_char,
94 costs NUMBER DEFAULT fnd_api.g_miss_num,
95 currency_code jtf_tasks_b.currency_code%TYPE DEFAULT fnd_api.g_miss_char,
96 escalation_level jtf_tasks_b.escalation_level%TYPE DEFAULT fnd_api.g_miss_char,
97 attribute1 jtf_tasks_b.attribute1%TYPE DEFAULT jtf_task_utl.g_miss_char,
98 attribute2 jtf_tasks_b.attribute2%TYPE DEFAULT jtf_task_utl.g_miss_char,
99 attribute3 jtf_tasks_b.attribute3%TYPE DEFAULT jtf_task_utl.g_miss_char,
100 attribute4 jtf_tasks_b.attribute4%TYPE DEFAULT jtf_task_utl.g_miss_char,
101 attribute5 jtf_tasks_b.attribute5%TYPE DEFAULT jtf_task_utl.g_miss_char,
102 attribute6 jtf_tasks_b.attribute6%TYPE DEFAULT jtf_task_utl.g_miss_char,
103 attribute7 jtf_tasks_b.attribute7%TYPE DEFAULT jtf_task_utl.g_miss_char,
104 attribute8 jtf_tasks_b.attribute8%TYPE DEFAULT jtf_task_utl.g_miss_char,
105 attribute9 jtf_tasks_b.attribute9%TYPE DEFAULT jtf_task_utl.g_miss_char,
106 attribute10 jtf_tasks_b.attribute10%TYPE DEFAULT jtf_task_utl.g_miss_char,
107 attribute11 jtf_tasks_b.attribute11%TYPE DEFAULT jtf_task_utl.g_miss_char,
108 attribute12 jtf_tasks_b.attribute12%TYPE DEFAULT jtf_task_utl.g_miss_char,
109 attribute13 jtf_tasks_b.attribute13%TYPE DEFAULT jtf_task_utl.g_miss_char,
110 attribute14 jtf_tasks_b.attribute14%TYPE DEFAULT jtf_task_utl.g_miss_char,
111 attribute15 jtf_tasks_b.attribute15%TYPE DEFAULT jtf_task_utl.g_miss_char,
112 attribute_category jtf_tasks_b.attribute_category%TYPE DEFAULT jtf_task_utl.g_miss_char,
113 date_selected jtf_tasks_b.date_selected%TYPE DEFAULT jtf_task_utl.g_miss_char,
114 category_id NUMBER DEFAULT jtf_task_utl.g_miss_number,
115 show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE DEFAULT jtf_task_utl.g_miss_char,
116 owner_status_id NUMBER DEFAULT jtf_task_utl.g_miss_number,
117 enable_workflow VARCHAR2(1) DEFAULT fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW'),
118 abort_workflow VARCHAR2(1) DEFAULT fnd_profile.value('JTF_TASK_ABORT_PREV_WF'),
119 change_mode VARCHAR2(1) DEFAULT 'N',
120 recurrence_rule_id NUMBER DEFAULT NULL,
121 old_calendar_start_date DATE DEFAULT NULL,
122 new_calendar_start_date DATE DEFAULT NULL,
123 new_calendar_end_date DATE DEFAULT NULL,
124 free_busy_type jtf_task_all_assignments.free_busy_type%TYPE DEFAULT jtf_task_utl.g_miss_char, -- Bug No 4231616
125 location_id NUMBER DEFAULT NULL
126 );
127
128 PROCEDURE update_repeat_appointment(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
131 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
132 p_object_version_number IN OUT NOCOPY NUMBER,
133 p_updated_field_rec IN updated_field_rec,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2
137 );
138
139
140 END JTF_TASK_REPEAT_APPT_PVT;