[Home] [Help]
87: and nvl(jtt_vl.end_date_active, sysdate + 1)
88: and jtb.task_priority_id = jp_vl.task_priority_id
89: and sysdate between nvl(jp_vl.start_date_active, sysdate)
90: and nvl(jp_vl.end_date_active, sysdate + 1)
91: and jp_vl.importance_level <= fnd_profile.VALUE_SPECIFIC('CSF_ALERT_PRIORITY',
92: getUserId(jta.resource_id, jta.resource_type_code),
93: 21685,
94: 513,
95: null,
123: and nvl(jtt_vl.end_date_active, sysdate + 1)
124: and jtb.task_priority_id = jp_vl.task_priority_id
125: and sysdate between nvl(jp_vl.start_date_active, sysdate)
126: and nvl(jp_vl.end_date_active, sysdate + 1)
127: and jp_vl.importance_level <= fnd_profile.VALUE_SPECIFIC('CSF_ALERT_PRIORITY',
128: getUserId(jta.resource_id, jta.resource_type_code),
129: 21685,
130: 513,
131: null,
175: and nvl(jtt_vl.end_date_active, sysdate + 1)
176: and jtb.task_priority_id = jp_vl.task_priority_id
177: and sysdate between nvl(jp_vl.start_date_active, sysdate)
178: and nvl(jp_vl.end_date_active, sysdate + 1)
179: and jp_vl.importance_level <= fnd_profile.VALUE_SPECIFIC('CSF_ALERT_PRIORITY',
180: getUserId(v_resource_id, v_resource_type_code),
181: 21685,
182: 513,
183: null,
225: where
226: jtab.task_id = v_task_id
227: and jtab.task_audit_id = v_task_audit_id
228: and jp_vl1.task_priority_id = jtab.new_task_priority_id
229: and jp_vl1.importance_level <= fnd_profile.VALUE_SPECIFIC('CSF_ALERT_PRIORITY',
230: getUserId(v_resource_id, v_resource_type),
231: 21685,
232: 513,
233: null,
232: 513,
233: null,
234: null)
235: and jp_vl2.task_priority_id = jtab.old_task_priority_id
236: and jp_vl2.importance_level > fnd_profile.VALUE_SPECIFIC('CSF_ALERT_PRIORITY',
237: getUserId(v_resource_id, v_resource_type),
238: 21685,
239: 513,
240: null,
426: if l_task_id is null then
427: return 'SUCCESS'; -- nothing to do now :)
428: end if;
429:
430: if l_new_asgnmnt_status_id = fnd_profile.VALUE_SPECIFIC('CSF_DEFAULT_TASK_CANCELLED_STATUS',
431: getUserId(l_resource_id, l_resource_type_code),
432: 21685,
433: 513,
434: null,
813: itemkey => itemkey,
814: aname => 'MSG_SUBJECT2',
815: avalue => l_msg_subject2);
816:
817: l_auto_reject := fnd_profile.VALUE_SPECIFIC('CSF_ALERTS_AUTO_REJECT',
818: getUserId(l_resource_id, l_resource_type),
819: 21685,
820: 513,
821: null,
830: itemkey => itemkey,
831: aname => 'AUTO_REJECT_VALUE',
832: avalue => l_auto_reject);
833:
834: l_time_out1 := fnd_profile.VALUE_SPECIFIC('CSF_ALERTS_RESPONSE_TIME_MIN',
835: getUserId(l_resource_id, l_resource_type),
836: 21685,
837: 513,
838: null,
842: itemkey => itemkey,
843: aname => 'TIMEOUT1',
844: avalue => l_time_out1);
845:
846: l_time_out2 := fnd_profile.VALUE_SPECIFIC('CSF_ALERTS_REMINDER_TIME_MIN',
847: getUserId(l_resource_id, l_resource_type),
848: 21685,
849: 513,
850: null,
935: and nvl(jtt_vl.end_date_active, sysdate + 1)
936: and jtb.task_priority_id = jp_vl.task_priority_id
937: and sysdate between nvl(jp_vl.start_date_active, sysdate)
938: and nvl(jp_vl.end_date_active, sysdate + 1)
939: and jp_vl.importance_level <= fnd_profile.VALUE_SPECIFIC('CSF_ALERT_PRIORITY',
940: getUserId(jta.resource_id, jta.resource_type_code),
941: 21685,
942: 513,
943: null,
967: and l_org_assignment_status_id = l_curr_assignment_status_id then
968: -- check for timeout2 profile
969: -- if it is null then do not send reminder
970:
971: l_reminder_timeout := fnd_profile.VALUE_SPECIFIC('CSF_ALERTS_REMINDER_TIME_MIN',
972: getUserId(l_resource_id, l_resource_type),
973: 21685,
974: 513,
975: null,
1083:
1084: csf_task_assignments_pub.update_assignment_status(
1085: p_api_version => 1.0,
1086: p_task_assignment_id => l_task_assgn_id,
1087: p_assignment_status_id => fnd_profile.VALUE_SPECIFIC('CSF_DEFAULT_ACCEPTED_STATUS',
1088: getUserId(l_resource_id, l_resource_type),
1089: 21685,
1090: 513,
1091: null,
1200:
1201: csf_task_assignments_pub.update_assignment_status(
1202: p_api_version => 1.0,
1203: p_task_assignment_id => l_task_assgn_id,
1204: p_assignment_status_id => fnd_profile.VALUE_SPECIFIC('CSF_DEFAULT_REJECTED_STATUS',
1205: getUserId(l_resource_id, l_resource_type),
1206: 21685,
1207: 513,
1208: null,
1277: X_MSG_COUNT NUMBER;
1278: X_MSG_DATA VARCHAR2(200);
1279: begin
1280: l_return_date := null;
1281: l_profile_value := fnd_profile.value_specific('CSF_ALERT_SEND_PREF',
1282: getUserId(p_resource_id, p_resource_type_code),
1283: 21685,
1284: 513,
1285: null,
1321: if (X_RETURN_STATUS = 'S') and (l_shifts is not null) and (l_shifts.count > 0) then
1322: l_return_date := l_shifts(1).start_datetime;
1323:
1324: -- fetch profile value for how many minutes before should we send the notification
1325: l_minutes_before := fnd_profile.VALUE_SPECIFIC('CSF_ALERTS_MIN_BEFORE_SHIFT',
1326: getUserId(p_resource_id, p_resource_type_code),
1327: 21685,
1328: 513,
1329: null,
1358: if (X_RETURN_STATUS = 'S') and (l_shifts is not null) and (l_shifts.count > 0) then
1359: l_return_date := l_shifts(1).start_datetime;
1360:
1361: -- fetch profile value for how many minutes before should we send the notification
1362: l_minutes_before := fnd_profile.VALUE_SPECIFIC('CSF_ALERTS_MIN_BEFORE_SHIFT',
1363: getUserId(p_resource_id, p_resource_type_code),
1364: 21685,
1365: 513,
1366: null,
1447: l_return_value boolean;
1448: begin
1449: l_return_value := false;
1450:
1451: if fnd_profile.VALUE_SPECIFIC('CSF_ALERTS_ENABLE',
1452: getUserId(p_resource_id, p_resource_type_code),
1453: 21685,
1454: 513,
1455: null,
2838: IF (fnd_timezones.timezones_enabled <> 'Y') THEN
2839: return p_server_time;
2840: END IF;
2841:
2842: l_client_tz_id := to_number(fnd_profile.VALUE_SPECIFIC('CLIENT_TIMEZONE_ID',
2843: p_user_id,
2844: 21685,
2845: 513,
2846: null,
2845: 513,
2846: null,
2847: null));
2848:
2849: l_server_tz_id := to_number(fnd_profile.VALUE_SPECIFIC('SERVER_TIMEZONE_ID',
2850: p_user_id,
2851: 21685,
2852: 513,
2853: null,