[Home] [Help]
88: and nvl(jtt_vl.end_date_active, sysdate + 1)
89: and jtb.task_priority_id = jp_vl.task_priority_id
90: and sysdate between nvl(jp_vl.start_date_active, sysdate)
91: and nvl(jp_vl.end_date_active, sysdate + 1)
92: and jp_vl.importance_level <= fnd_profile.VALUE_SPECIFIC('CSF_ALERT_PRIORITY',
93: getUserId(jta.resource_id, jta.resource_type_code),
94: 21685,
95: 513,
96: null,
125: and nvl(jtt_vl.end_date_active, sysdate + 1)
126: and jtb.task_priority_id = jp_vl.task_priority_id
127: and sysdate between nvl(jp_vl.start_date_active, sysdate)
128: and nvl(jp_vl.end_date_active, sysdate + 1)
129: and jp_vl.importance_level <= fnd_profile.VALUE_SPECIFIC('CSF_ALERT_PRIORITY',
130: getUserId(jta.resource_id, jta.resource_type_code),
131: 21685,
132: 513,
133: null,
178: and nvl(jtt_vl.end_date_active, sysdate + 1)
179: and jtb.task_priority_id = jp_vl.task_priority_id
180: and sysdate between nvl(jp_vl.start_date_active, sysdate)
181: and nvl(jp_vl.end_date_active, sysdate + 1)
182: and jp_vl.importance_level <= fnd_profile.VALUE_SPECIFIC('CSF_ALERT_PRIORITY',
183: getUserId(v_resource_id, v_resource_type_code),
184: 21685,
185: 513,
186: null,
234: where
235: jtab.task_id = v_task_id
236: and jtab.task_audit_id = v_task_audit_id
237: and jp_vl1.task_priority_id = jtab.new_task_priority_id
238: and jp_vl1.importance_level <= fnd_profile.VALUE_SPECIFIC('CSF_ALERT_PRIORITY',
239: getUserId(v_resource_id, v_resource_type),
240: 21685,
241: 513,
242: null,
241: 513,
242: null,
243: null)
244: and jp_vl2.task_priority_id = jtab.old_task_priority_id
245: and jp_vl2.importance_level > fnd_profile.VALUE_SPECIFIC('CSF_ALERT_PRIORITY',
246: getUserId(v_resource_id, v_resource_type),
247: 21685,
248: 513,
249: null,
435: if l_task_id is null then
436: return 'SUCCESS'; -- nothing to do now :)
437: end if;
438:
439: if l_new_asgnmnt_status_id = fnd_profile.VALUE_SPECIFIC('CSF_DEFAULT_TASK_CANCELLED_STATUS',
440: getUserId(l_resource_id, l_resource_type_code),
441: 21685,
442: 513,
443: null,
823: itemkey => itemkey,
824: aname => 'MSG_SUBJECT2',
825: avalue => l_msg_subject2);
826:
827: l_auto_reject := fnd_profile.VALUE_SPECIFIC('CSF_ALERTS_AUTO_REJECT',
828: getUserId(l_resource_id, l_resource_type),
829: 21685,
830: 513,
831: null,
840: itemkey => itemkey,
841: aname => 'AUTO_REJECT_VALUE',
842: avalue => l_auto_reject);
843:
844: l_time_out1 := fnd_profile.VALUE_SPECIFIC('CSF_ALERTS_RESPONSE_TIME_MIN',
845: getUserId(l_resource_id, l_resource_type),
846: 21685,
847: 513,
848: null,
852: itemkey => itemkey,
853: aname => 'TIMEOUT1',
854: avalue => l_time_out1);
855:
856: l_time_out2 := fnd_profile.VALUE_SPECIFIC('CSF_ALERTS_REMINDER_TIME_MIN',
857: getUserId(l_resource_id, l_resource_type),
858: 21685,
859: 513,
860: null,
945: and nvl(jtt_vl.end_date_active, sysdate + 1)
946: and jtb.task_priority_id = jp_vl.task_priority_id
947: and sysdate between nvl(jp_vl.start_date_active, sysdate)
948: and nvl(jp_vl.end_date_active, sysdate + 1)
949: and jp_vl.importance_level <= fnd_profile.VALUE_SPECIFIC('CSF_ALERT_PRIORITY',
950: getUserId(jta.resource_id, jta.resource_type_code),
951: 21685,
952: 513,
953: null,
977: and l_org_assignment_status_id = l_curr_assignment_status_id then
978: -- check for timeout2 profile
979: -- if it is null then do not send reminder
980:
981: l_reminder_timeout := fnd_profile.VALUE_SPECIFIC('CSF_ALERTS_REMINDER_TIME_MIN',
982: getUserId(l_resource_id, l_resource_type),
983: 21685,
984: 513,
985: null,
1093:
1094: csf_task_assignments_pub.update_assignment_status(
1095: p_api_version => 1.0,
1096: p_task_assignment_id => l_task_assgn_id,
1097: p_assignment_status_id => fnd_profile.VALUE_SPECIFIC('CSF_DEFAULT_ACCEPTED_STATUS',
1098: getUserId(l_resource_id, l_resource_type),
1099: 21685,
1100: 513,
1101: null,
1210:
1211: csf_task_assignments_pub.update_assignment_status(
1212: p_api_version => 1.0,
1213: p_task_assignment_id => l_task_assgn_id,
1214: p_assignment_status_id => fnd_profile.VALUE_SPECIFIC('CSF_DEFAULT_REJECTED_STATUS',
1215: getUserId(l_resource_id, l_resource_type),
1216: 21685,
1217: 513,
1218: null,
1287: X_MSG_COUNT NUMBER;
1288: X_MSG_DATA VARCHAR2(200);
1289: begin
1290: l_return_date := null;
1291: l_profile_value := fnd_profile.value_specific('CSF_ALERT_SEND_PREF',
1292: getUserId(p_resource_id, p_resource_type_code),
1293: 21685,
1294: 513,
1295: null,
1331: if (X_RETURN_STATUS = 'S') and (l_shifts is not null) and (l_shifts.count > 0) then
1332: l_return_date := l_shifts(1).start_datetime;
1333:
1334: -- fetch profile value for how many minutes before should we send the notification
1335: l_minutes_before := fnd_profile.VALUE_SPECIFIC('CSF_ALERTS_MIN_BEFORE_SHIFT',
1336: getUserId(p_resource_id, p_resource_type_code),
1337: 21685,
1338: 513,
1339: null,
1368: if (X_RETURN_STATUS = 'S') and (l_shifts is not null) and (l_shifts.count > 0) then
1369: l_return_date := l_shifts(1).start_datetime;
1370:
1371: -- fetch profile value for how many minutes before should we send the notification
1372: l_minutes_before := fnd_profile.VALUE_SPECIFIC('CSF_ALERTS_MIN_BEFORE_SHIFT',
1373: getUserId(p_resource_id, p_resource_type_code),
1374: 21685,
1375: 513,
1376: null,
1457: l_return_value boolean;
1458: begin
1459: l_return_value := false;
1460:
1461: if fnd_profile.VALUE_SPECIFIC('CSF_ALERTS_ENABLE',
1462: getUserId(p_resource_id, p_resource_type_code),
1463: 21685,
1464: 513,
1465: null,
2848: IF (fnd_timezones.timezones_enabled <> 'Y') THEN
2849: return p_server_time;
2850: END IF;
2851:
2852: l_client_tz_id := to_number(fnd_profile.VALUE_SPECIFIC('CLIENT_TIMEZONE_ID',
2853: p_user_id,
2854: 21685,
2855: 513,
2856: null,
2855: 513,
2856: null,
2857: null));
2858:
2859: l_server_tz_id := to_number(fnd_profile.VALUE_SPECIFIC('SERVER_TIMEZONE_ID',
2860: p_user_id,
2861: 21685,
2862: 513,
2863: null,