DBA Data[Home] [Help]

APPS.JTF_TASK_REPEAT_APPT_PVT dependencies on JTF_TASK_UTL

Line 24: | to jtf_task_utl |

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: *=======================================================================*/

Line 97: attribute1 jtf_tasks_b.attribute1%TYPE DEFAULT jtf_task_utl.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,

Line 98: attribute2 jtf_tasks_b.attribute2%TYPE DEFAULT jtf_task_utl.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,

Line 99: attribute3 jtf_tasks_b.attribute3%TYPE DEFAULT jtf_task_utl.g_miss_char,

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,

Line 100: attribute4 jtf_tasks_b.attribute4%TYPE DEFAULT jtf_task_utl.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,

Line 101: attribute5 jtf_tasks_b.attribute5%TYPE DEFAULT jtf_task_utl.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,

Line 102: attribute6 jtf_tasks_b.attribute6%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,

Line 103: attribute7 jtf_tasks_b.attribute7%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,

Line 104: attribute8 jtf_tasks_b.attribute8%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,

Line 105: attribute9 jtf_tasks_b.attribute9%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,

Line 106: attribute10 jtf_tasks_b.attribute10%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,

Line 107: attribute11 jtf_tasks_b.attribute11%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,

Line 108: attribute12 jtf_tasks_b.attribute12%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,

Line 109: attribute13 jtf_tasks_b.attribute13%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,

Line 110: attribute14 jtf_tasks_b.attribute14%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,

Line 111: attribute15 jtf_tasks_b.attribute15%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,

Line 112: attribute_category jtf_tasks_b.attribute_category%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,

Line 113: date_selected jtf_tasks_b.date_selected%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'),

Line 114: category_id NUMBER DEFAULT jtf_task_utl.g_miss_number,

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'),

Line 115: show_on_calendar jtf_task_all_assignments.show_on_calendar%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',

Line 116: owner_status_id NUMBER DEFAULT jtf_task_utl.g_miss_number,

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,

Line 124: free_busy_type jtf_task_all_assignments.free_busy_type%TYPE DEFAULT jtf_task_utl.g_miss_char, -- Bug No 4231616

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(