eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_EAM_WORKREQUEST_PVT dependencies on FND_GLOBAL

Line 111: l_request_log := replace(p_request_log,fnd_global.local_chr(13)||fnd_global.local_chr(10),fnd_global.local_chr(10));

107: -- API body
108:
109: -- remove the carriage return character i.e remove chr(13)
110: -- fix for bug 2104571
111: l_request_log := replace(p_request_log,fnd_global.local_chr(13)||fnd_global.local_chr(10),fnd_global.local_chr(10));
112:
113: SELECT wip_eam_work_requests_s.nextval
114: INTO l_work_request_id FROM DUAL;
115: x_request_id := l_work_request_id;

Line 272: NVL(p_user_id,FND_GLOBAL.user_id),

268: VALUES(
269: l_work_request_id,
270: to_char(l_work_request_id),
271: sysdate,
272: NVL(p_user_id,FND_GLOBAL.user_id),
273: sysdate,
274: NVL(p_user_id,FND_GLOBAL.user_id),
275: NVL(p_user_id,FND_GLOBAL.login_id),
276: p_asset_number,

Line 274: NVL(p_user_id,FND_GLOBAL.user_id),

270: to_char(l_work_request_id),
271: sysdate,
272: NVL(p_user_id,FND_GLOBAL.user_id),
273: sysdate,
274: NVL(p_user_id,FND_GLOBAL.user_id),
275: NVL(p_user_id,FND_GLOBAL.login_id),
276: p_asset_number,
277: p_asset_group_id,
278: p_org_id,

Line 275: NVL(p_user_id,FND_GLOBAL.login_id),

271: sysdate,
272: NVL(p_user_id,FND_GLOBAL.user_id),
273: sysdate,
274: NVL(p_user_id,FND_GLOBAL.user_id),
275: NVL(p_user_id,FND_GLOBAL.login_id),
276: p_asset_number,
277: p_asset_group_id,
278: p_org_id,
279: l_status_id,

Line 288: NVL(p_user_id,FND_GLOBAL.user_id),

284: p_request_by_date,
285: substrb(l_request_log, 1, 240), --changed for the bug 9088315
286: p_work_request_type_id,
287: l_auto_approve_flag,
288: NVL(p_user_id,FND_GLOBAL.user_id),
289: l_maintenance_object_type,
290: l_maintenance_object_id,
291: nvl(p_created_for,FND_GLOBAL.user_id),
292: p_phone_number,

Line 291: nvl(p_created_for,FND_GLOBAL.user_id),

287: l_auto_approve_flag,
288: NVL(p_user_id,FND_GLOBAL.user_id),
289: l_maintenance_object_type,
290: l_maintenance_object_id,
291: nvl(p_created_for,FND_GLOBAL.user_id),
292: p_phone_number,
293: p_email,
294: p_contact_preference,
295: p_notify_originator,

Line 322: l_user_name := FND_GLOBAL.USER_NAME ;

318: FROM fnd_user
319: WHERE user_id = p_user_id;
320: EXCEPTION
321: When NO_DATA_FOUND then
322: l_user_name := FND_GLOBAL.USER_NAME ;
323: END;
324:
325: SELECT '*** '||l_user_name||' ('
326: ||to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS')||') *** '

Line 349: NVL(p_user_id,FND_GLOBAL.user_id),

345: )
346: VALUES(
347: l_work_request_note_id,
348: sysdate,
349: NVL(p_user_id,FND_GLOBAL.user_id),
350: sysdate,
351: NVL(p_user_id,FND_GLOBAL.user_id),
352: NVL(p_user_id,FND_GLOBAL.login_id),
353: l_work_request_id,

Line 351: NVL(p_user_id,FND_GLOBAL.user_id),

347: l_work_request_note_id,
348: sysdate,
349: NVL(p_user_id,FND_GLOBAL.user_id),
350: sysdate,
351: NVL(p_user_id,FND_GLOBAL.user_id),
352: NVL(p_user_id,FND_GLOBAL.login_id),
353: l_work_request_id,
354: l_standard_log,
355: 1, -- 1 for request log, 2 for approver log

Line 352: NVL(p_user_id,FND_GLOBAL.login_id),

348: sysdate,
349: NVL(p_user_id,FND_GLOBAL.user_id),
350: sysdate,
351: NVL(p_user_id,FND_GLOBAL.user_id),
352: NVL(p_user_id,FND_GLOBAL.login_id),
353: l_work_request_id,
354: l_standard_log,
355: 1, -- 1 for request log, 2 for approver log
356: null

Line 379: NVL(p_user_id,FND_GLOBAL.user_id),

375: )
376: VALUES(
377: l_work_request_note_id,
378: sysdate,
379: NVL(p_user_id,FND_GLOBAL.user_id),
380: sysdate,
381: NVL(p_user_id,FND_GLOBAL.user_id),
382: NVL(p_user_id,FND_GLOBAL.login_id),
383: l_work_request_id,

Line 381: NVL(p_user_id,FND_GLOBAL.user_id),

377: l_work_request_note_id,
378: sysdate,
379: NVL(p_user_id,FND_GLOBAL.user_id),
380: sysdate,
381: NVL(p_user_id,FND_GLOBAL.user_id),
382: NVL(p_user_id,FND_GLOBAL.login_id),
383: l_work_request_id,
384: l_request_log,
385: 1, -- 1 for request log, 2 for approver log

Line 382: NVL(p_user_id,FND_GLOBAL.login_id),

378: sysdate,
379: NVL(p_user_id,FND_GLOBAL.user_id),
380: sysdate,
381: NVL(p_user_id,FND_GLOBAL.user_id),
382: NVL(p_user_id,FND_GLOBAL.login_id),
383: l_work_request_id,
384: l_request_log,
385: 1, -- 1 for request log, 2 for approver log
386: null

Line 405: p_employee_id => nvl(p_created_for,FND_GLOBAL.user_id),

401: p_comments => l_request_log,
402: p_reference => l_work_request_id,
403: p_ref_id => l_work_request_id,
404: p_instance_number => null,
405: p_employee_id => nvl(p_created_for,FND_GLOBAL.user_id),
406: x_return_status => x_return_status,
407: x_msg_count => x_msg_count,
408: x_msg_data => x_msg_data
409: );

Line 879: l_user_name := FND_GLOBAL.USER_NAME ;

875: FROM fnd_user
876: WHERE user_id = p_user_id;
877: EXCEPTION
878: When NO_DATA_FOUND then
879: l_user_name := FND_GLOBAL.USER_NAME ;
880: END;
881:
882: SELECT '*** '||l_user_name||' ('
883: ||to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS')||') *** '

Line 908: NVL(p_user_id,FND_GLOBAL.user_id),

904: )
905: values(
906: l_work_request_note_id,
907: sysdate,
908: NVL(p_user_id,FND_GLOBAL.user_id),
909: sysdate,
910: NVL(p_user_id,FND_GLOBAL.user_id),
911: NVL(p_user_id,FND_GLOBAL.login_id),
912: p_request_id,

Line 910: NVL(p_user_id,FND_GLOBAL.user_id),

906: l_work_request_note_id,
907: sysdate,
908: NVL(p_user_id,FND_GLOBAL.user_id),
909: sysdate,
910: NVL(p_user_id,FND_GLOBAL.user_id),
911: NVL(p_user_id,FND_GLOBAL.login_id),
912: p_request_id,
913: l_standard_log,
914: 1, -- 1 for request log, 2 for approver log

Line 911: NVL(p_user_id,FND_GLOBAL.login_id),

907: sysdate,
908: NVL(p_user_id,FND_GLOBAL.user_id),
909: sysdate,
910: NVL(p_user_id,FND_GLOBAL.user_id),
911: NVL(p_user_id,FND_GLOBAL.login_id),
912: p_request_id,
913: l_standard_log,
914: 1, -- 1 for request log, 2 for approver log
915: null -- Don't know what will be put here for notification_id

Line 954: last_updated_by = NVL(p_user_id,FND_GLOBAL.user_id),

950: END IF;
951:
952: UPDATE wip_eam_work_requests SET
953: last_update_date = sysdate,
954: last_updated_by = NVL(p_user_id,FND_GLOBAL.user_id),
955: last_update_login = NVL(p_user_id,FND_GLOBAL.login_id),
956: work_request_priority_id = l_new_priority_id,
957: work_request_owning_dept = l_new_owning_dept_id,
958: work_request_status_id = l_new_status_id,

Line 955: last_update_login = NVL(p_user_id,FND_GLOBAL.login_id),

951:
952: UPDATE wip_eam_work_requests SET
953: last_update_date = sysdate,
954: last_updated_by = NVL(p_user_id,FND_GLOBAL.user_id),
955: last_update_login = NVL(p_user_id,FND_GLOBAL.login_id),
956: work_request_priority_id = l_new_priority_id,
957: work_request_owning_dept = l_new_owning_dept_id,
958: work_request_status_id = l_new_status_id,
959: expected_resolution_date = l_new_request_by_date,

Line 1060: NVL(p_user_id,FND_GLOBAL.user_id),

1056: )
1057: VALUES(
1058: l_work_request_note_id,
1059: sysdate,
1060: NVL(p_user_id,FND_GLOBAL.user_id),
1061: sysdate,
1062: NVL(p_user_id,FND_GLOBAL.user_id),
1063: NVL(p_user_id,FND_GLOBAL.login_id),
1064: p_request_id,

Line 1062: NVL(p_user_id,FND_GLOBAL.user_id),

1058: l_work_request_note_id,
1059: sysdate,
1060: NVL(p_user_id,FND_GLOBAL.user_id),
1061: sysdate,
1062: NVL(p_user_id,FND_GLOBAL.user_id),
1063: NVL(p_user_id,FND_GLOBAL.login_id),
1064: p_request_id,
1065: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1066: 1, -- 1 for request log, 2 for approver log

Line 1063: NVL(p_user_id,FND_GLOBAL.login_id),

1059: sysdate,
1060: NVL(p_user_id,FND_GLOBAL.user_id),
1061: sysdate,
1062: NVL(p_user_id,FND_GLOBAL.user_id),
1063: NVL(p_user_id,FND_GLOBAL.login_id),
1064: p_request_id,
1065: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1066: 1, -- 1 for request log, 2 for approver log
1067: null

Line 1090: NVL(p_user_id,FND_GLOBAL.user_id),

1086: )
1087: VALUES(
1088: l_work_request_note_id,
1089: sysdate,
1090: NVL(p_user_id,FND_GLOBAL.user_id),
1091: sysdate,
1092: NVL(p_user_id,FND_GLOBAL.user_id),
1093: NVL(p_user_id,FND_GLOBAL.login_id),
1094: p_request_id,

Line 1092: NVL(p_user_id,FND_GLOBAL.user_id),

1088: l_work_request_note_id,
1089: sysdate,
1090: NVL(p_user_id,FND_GLOBAL.user_id),
1091: sysdate,
1092: NVL(p_user_id,FND_GLOBAL.user_id),
1093: NVL(p_user_id,FND_GLOBAL.login_id),
1094: p_request_id,
1095: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_asset_number,l_null)||' -> '||nvl(l_new_asset_number,l_null),
1096: 1, -- 1 for request log, 2 for approver log

Line 1093: NVL(p_user_id,FND_GLOBAL.login_id),

1089: sysdate,
1090: NVL(p_user_id,FND_GLOBAL.user_id),
1091: sysdate,
1092: NVL(p_user_id,FND_GLOBAL.user_id),
1093: NVL(p_user_id,FND_GLOBAL.login_id),
1094: p_request_id,
1095: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_asset_number,l_null)||' -> '||nvl(l_new_asset_number,l_null),
1096: 1, -- 1 for request log, 2 for approver log
1097: null

Line 1146: NVL(p_user_id,FND_GLOBAL.user_id),

1142: )
1143: VALUES(
1144: l_work_request_note_id,
1145: sysdate,
1146: NVL(p_user_id,FND_GLOBAL.user_id),
1147: sysdate,
1148: NVL(p_user_id,FND_GLOBAL.user_id),
1149: NVL(p_user_id,FND_GLOBAL.login_id),
1150: p_request_id,

Line 1148: NVL(p_user_id,FND_GLOBAL.user_id),

1144: l_work_request_note_id,
1145: sysdate,
1146: NVL(p_user_id,FND_GLOBAL.user_id),
1147: sysdate,
1148: NVL(p_user_id,FND_GLOBAL.user_id),
1149: NVL(p_user_id,FND_GLOBAL.login_id),
1150: p_request_id,
1151: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1152: 1, -- 1 for request log, 2 for approver log

Line 1149: NVL(p_user_id,FND_GLOBAL.login_id),

1145: sysdate,
1146: NVL(p_user_id,FND_GLOBAL.user_id),
1147: sysdate,
1148: NVL(p_user_id,FND_GLOBAL.user_id),
1149: NVL(p_user_id,FND_GLOBAL.login_id),
1150: p_request_id,
1151: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1152: 1, -- 1 for request log, 2 for approver log
1153: null

Line 1203: NVL(p_user_id,FND_GLOBAL.user_id),

1199: )
1200: VALUES(
1201: l_work_request_note_id,
1202: sysdate,
1203: NVL(p_user_id,FND_GLOBAL.user_id),
1204: sysdate,
1205: NVL(p_user_id,FND_GLOBAL.user_id),
1206: NVL(p_user_id,FND_GLOBAL.login_id),
1207: p_request_id,

Line 1205: NVL(p_user_id,FND_GLOBAL.user_id),

1201: l_work_request_note_id,
1202: sysdate,
1203: NVL(p_user_id,FND_GLOBAL.user_id),
1204: sysdate,
1205: NVL(p_user_id,FND_GLOBAL.user_id),
1206: NVL(p_user_id,FND_GLOBAL.login_id),
1207: p_request_id,
1208: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1209: 1, -- 1 for request log, 2 for approver log

Line 1206: NVL(p_user_id,FND_GLOBAL.login_id),

1202: sysdate,
1203: NVL(p_user_id,FND_GLOBAL.user_id),
1204: sysdate,
1205: NVL(p_user_id,FND_GLOBAL.user_id),
1206: NVL(p_user_id,FND_GLOBAL.login_id),
1207: p_request_id,
1208: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1209: 1, -- 1 for request log, 2 for approver log
1210: null

Line 1259: NVL(p_user_id,FND_GLOBAL.user_id),

1255: )
1256: VALUES(
1257: l_work_request_note_id,
1258: sysdate,
1259: NVL(p_user_id,FND_GLOBAL.user_id),
1260: sysdate,
1261: NVL(p_user_id,FND_GLOBAL.user_id),
1262: NVL(p_user_id,FND_GLOBAL.login_id),
1263: p_request_id,

Line 1261: NVL(p_user_id,FND_GLOBAL.user_id),

1257: l_work_request_note_id,
1258: sysdate,
1259: NVL(p_user_id,FND_GLOBAL.user_id),
1260: sysdate,
1261: NVL(p_user_id,FND_GLOBAL.user_id),
1262: NVL(p_user_id,FND_GLOBAL.login_id),
1263: p_request_id,
1264: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1265: 1, -- 1 for request log, 2 for approver log

Line 1262: NVL(p_user_id,FND_GLOBAL.login_id),

1258: sysdate,
1259: NVL(p_user_id,FND_GLOBAL.user_id),
1260: sysdate,
1261: NVL(p_user_id,FND_GLOBAL.user_id),
1262: NVL(p_user_id,FND_GLOBAL.login_id),
1263: p_request_id,
1264: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1265: 1, -- 1 for request log, 2 for approver log
1266: null

Line 1315: NVL(p_user_id,FND_GLOBAL.user_id),

1311: )
1312: VALUES(
1313: l_work_request_note_id,
1314: sysdate,
1315: NVL(p_user_id,FND_GLOBAL.user_id),
1316: sysdate,
1317: NVL(p_user_id,FND_GLOBAL.user_id),
1318: NVL(p_user_id,FND_GLOBAL.login_id),
1319: p_request_id,

Line 1317: NVL(p_user_id,FND_GLOBAL.user_id),

1313: l_work_request_note_id,
1314: sysdate,
1315: NVL(p_user_id,FND_GLOBAL.user_id),
1316: sysdate,
1317: NVL(p_user_id,FND_GLOBAL.user_id),
1318: NVL(p_user_id,FND_GLOBAL.login_id),
1319: p_request_id,
1320: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1321: 1, -- 1 for request log, 2 for approver log

Line 1318: NVL(p_user_id,FND_GLOBAL.login_id),

1314: sysdate,
1315: NVL(p_user_id,FND_GLOBAL.user_id),
1316: sysdate,
1317: NVL(p_user_id,FND_GLOBAL.user_id),
1318: NVL(p_user_id,FND_GLOBAL.login_id),
1319: p_request_id,
1320: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1321: 1, -- 1 for request log, 2 for approver log
1322: null

Line 1357: NVL(p_user_id,FND_GLOBAL.user_id),

1353: )
1354: VALUES(
1355: l_work_request_note_id,
1356: sysdate,
1357: NVL(p_user_id,FND_GLOBAL.user_id),
1358: sysdate,
1359: NVL(p_user_id,FND_GLOBAL.user_id),
1360: NVL(p_user_id,FND_GLOBAL.login_id),
1361: p_request_id,

Line 1359: NVL(p_user_id,FND_GLOBAL.user_id),

1355: l_work_request_note_id,
1356: sysdate,
1357: NVL(p_user_id,FND_GLOBAL.user_id),
1358: sysdate,
1359: NVL(p_user_id,FND_GLOBAL.user_id),
1360: NVL(p_user_id,FND_GLOBAL.login_id),
1361: p_request_id,
1362: '@@@ '||FND_MESSAGE.GET||l_timezone_code ||' : '||to_char(l_old_request_by_date, 'dd-MON-yyyy hh24:mi:ss')||' -> '
1363: ||to_char(l_new_request_by_date, 'dd-MON-yyyy hh24:mi:ss') ,

Line 1360: NVL(p_user_id,FND_GLOBAL.login_id),

1356: sysdate,
1357: NVL(p_user_id,FND_GLOBAL.user_id),
1358: sysdate,
1359: NVL(p_user_id,FND_GLOBAL.user_id),
1360: NVL(p_user_id,FND_GLOBAL.login_id),
1361: p_request_id,
1362: '@@@ '||FND_MESSAGE.GET||l_timezone_code ||' : '||to_char(l_old_request_by_date, 'dd-MON-yyyy hh24:mi:ss')||' -> '
1363: ||to_char(l_new_request_by_date, 'dd-MON-yyyy hh24:mi:ss') ,
1364: 1, -- 1 for request log, 2 for approver log

Line 1411: NVL(p_user_id,FND_GLOBAL.user_id),

1407: )
1408: VALUES(
1409: l_work_request_note_id,
1410: sysdate,
1411: NVL(p_user_id,FND_GLOBAL.user_id),
1412: sysdate,
1413: NVL(p_user_id,FND_GLOBAL.user_id),
1414: NVL(p_user_id,FND_GLOBAL.login_id),
1415: p_request_id,

Line 1413: NVL(p_user_id,FND_GLOBAL.user_id),

1409: l_work_request_note_id,
1410: sysdate,
1411: NVL(p_user_id,FND_GLOBAL.user_id),
1412: sysdate,
1413: NVL(p_user_id,FND_GLOBAL.user_id),
1414: NVL(p_user_id,FND_GLOBAL.login_id),
1415: p_request_id,
1416: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1417: 1, -- 1 for request log, 2 for approver log

Line 1414: NVL(p_user_id,FND_GLOBAL.login_id),

1410: sysdate,
1411: NVL(p_user_id,FND_GLOBAL.user_id),
1412: sysdate,
1413: NVL(p_user_id,FND_GLOBAL.user_id),
1414: NVL(p_user_id,FND_GLOBAL.login_id),
1415: p_request_id,
1416: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1417: 1, -- 1 for request log, 2 for approver log
1418: null

Line 1442: NVL(p_user_id,FND_GLOBAL.user_id),

1438: )
1439: VALUES(
1440: l_work_request_note_id,
1441: sysdate,
1442: NVL(p_user_id,FND_GLOBAL.user_id),
1443: sysdate,
1444: NVL(p_user_id,FND_GLOBAL.user_id),
1445: NVL(p_user_id,FND_GLOBAL.login_id),
1446: p_request_id,

Line 1444: NVL(p_user_id,FND_GLOBAL.user_id),

1440: l_work_request_note_id,
1441: sysdate,
1442: NVL(p_user_id,FND_GLOBAL.user_id),
1443: sysdate,
1444: NVL(p_user_id,FND_GLOBAL.user_id),
1445: NVL(p_user_id,FND_GLOBAL.login_id),
1446: p_request_id,
1447: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_email,l_null)||' -> '||nvl(l_new_email,l_null),
1448: 1, -- 1 for request log, 2 for approver log

Line 1445: NVL(p_user_id,FND_GLOBAL.login_id),

1441: sysdate,
1442: NVL(p_user_id,FND_GLOBAL.user_id),
1443: sysdate,
1444: NVL(p_user_id,FND_GLOBAL.user_id),
1445: NVL(p_user_id,FND_GLOBAL.login_id),
1446: p_request_id,
1447: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_email,l_null)||' -> '||nvl(l_new_email,l_null),
1448: 1, -- 1 for request log, 2 for approver log
1449: null

Line 1473: NVL(p_user_id,FND_GLOBAL.user_id),

1469: )
1470: VALUES(
1471: l_work_request_note_id,
1472: sysdate,
1473: NVL(p_user_id,FND_GLOBAL.user_id),
1474: sysdate,
1475: NVL(p_user_id,FND_GLOBAL.user_id),
1476: NVL(p_user_id,FND_GLOBAL.login_id),
1477: p_request_id,

Line 1475: NVL(p_user_id,FND_GLOBAL.user_id),

1471: l_work_request_note_id,
1472: sysdate,
1473: NVL(p_user_id,FND_GLOBAL.user_id),
1474: sysdate,
1475: NVL(p_user_id,FND_GLOBAL.user_id),
1476: NVL(p_user_id,FND_GLOBAL.login_id),
1477: p_request_id,
1478: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_phone_number,l_null)||' -> '||nvl(l_new_phone_number,l_null),
1479: 1, /* 1 for request log, 2 for approver log*/

Line 1476: NVL(p_user_id,FND_GLOBAL.login_id),

1472: sysdate,
1473: NVL(p_user_id,FND_GLOBAL.user_id),
1474: sysdate,
1475: NVL(p_user_id,FND_GLOBAL.user_id),
1476: NVL(p_user_id,FND_GLOBAL.login_id),
1477: p_request_id,
1478: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_phone_number,l_null)||' -> '||nvl(l_new_phone_number,l_null),
1479: 1, /* 1 for request log, 2 for approver log*/
1480: null

Line 1524: NVL(p_user_id,FND_GLOBAL.user_id),

1520: )
1521: VALUES(
1522: l_work_request_note_id,
1523: sysdate,
1524: NVL(p_user_id,FND_GLOBAL.user_id),
1525: sysdate,
1526: NVL(p_user_id,FND_GLOBAL.user_id),
1527: NVL(p_user_id,FND_GLOBAL.login_id),
1528: p_request_id,

Line 1526: NVL(p_user_id,FND_GLOBAL.user_id),

1522: l_work_request_note_id,
1523: sysdate,
1524: NVL(p_user_id,FND_GLOBAL.user_id),
1525: sysdate,
1526: NVL(p_user_id,FND_GLOBAL.user_id),
1527: NVL(p_user_id,FND_GLOBAL.login_id),
1528: p_request_id,
1529: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1530: 1, -- 1 for request log, 2 for approver log

Line 1527: NVL(p_user_id,FND_GLOBAL.login_id),

1523: sysdate,
1524: NVL(p_user_id,FND_GLOBAL.user_id),
1525: sysdate,
1526: NVL(p_user_id,FND_GLOBAL.user_id),
1527: NVL(p_user_id,FND_GLOBAL.login_id),
1528: p_request_id,
1529: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1530: 1, -- 1 for request log, 2 for approver log
1531: null

Line 1575: NVL(p_user_id,FND_GLOBAL.user_id),

1571: )
1572: VALUES(
1573: l_work_request_note_id,
1574: sysdate,
1575: NVL(p_user_id,FND_GLOBAL.user_id),
1576: sysdate,
1577: NVL(p_user_id,FND_GLOBAL.user_id),
1578: NVL(p_user_id,FND_GLOBAL.login_id),
1579: p_request_id,

Line 1577: NVL(p_user_id,FND_GLOBAL.user_id),

1573: l_work_request_note_id,
1574: sysdate,
1575: NVL(p_user_id,FND_GLOBAL.user_id),
1576: sysdate,
1577: NVL(p_user_id,FND_GLOBAL.user_id),
1578: NVL(p_user_id,FND_GLOBAL.login_id),
1579: p_request_id,
1580: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1581: 1, -- 1 for request log, 2 for approver log

Line 1578: NVL(p_user_id,FND_GLOBAL.login_id),

1574: sysdate,
1575: NVL(p_user_id,FND_GLOBAL.user_id),
1576: sysdate,
1577: NVL(p_user_id,FND_GLOBAL.user_id),
1578: NVL(p_user_id,FND_GLOBAL.login_id),
1579: p_request_id,
1580: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1581: 1, -- 1 for request log, 2 for approver log
1582: null

Line 1606: NVL(p_user_id,FND_GLOBAL.user_id),

1602: )
1603: VALUES(
1604: l_work_request_note_id,
1605: sysdate,
1606: NVL(p_user_id,FND_GLOBAL.user_id),
1607: sysdate,
1608: NVL(p_user_id,FND_GLOBAL.user_id),
1609: NVL(p_user_id,FND_GLOBAL.login_id),
1610: p_request_id,

Line 1608: NVL(p_user_id,FND_GLOBAL.user_id),

1604: l_work_request_note_id,
1605: sysdate,
1606: NVL(p_user_id,FND_GLOBAL.user_id),
1607: sysdate,
1608: NVL(p_user_id,FND_GLOBAL.user_id),
1609: NVL(p_user_id,FND_GLOBAL.login_id),
1610: p_request_id,
1611: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_attribute_category,l_null)||' -> '||nvl(l_new_attribute_category,l_null),
1612: 1, -- 1 for request log, 2 for approver log

Line 1609: NVL(p_user_id,FND_GLOBAL.login_id),

1605: sysdate,
1606: NVL(p_user_id,FND_GLOBAL.user_id),
1607: sysdate,
1608: NVL(p_user_id,FND_GLOBAL.user_id),
1609: NVL(p_user_id,FND_GLOBAL.login_id),
1610: p_request_id,
1611: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_attribute_category,l_null)||' -> '||nvl(l_new_attribute_category,l_null),
1612: 1, -- 1 for request log, 2 for approver log
1613: null

Line 1640: NVL(p_user_id,FND_GLOBAL.user_id),

1636: )
1637: VALUES(
1638: l_work_request_note_id,
1639: sysdate,
1640: NVL(p_user_id,FND_GLOBAL.user_id),
1641: sysdate,
1642: NVL(p_user_id,FND_GLOBAL.user_id),
1643: NVL(p_user_id,FND_GLOBAL.login_id),
1644: p_request_id,

Line 1642: NVL(p_user_id,FND_GLOBAL.user_id),

1638: l_work_request_note_id,
1639: sysdate,
1640: NVL(p_user_id,FND_GLOBAL.user_id),
1641: sysdate,
1642: NVL(p_user_id,FND_GLOBAL.user_id),
1643: NVL(p_user_id,FND_GLOBAL.login_id),
1644: p_request_id,
1645: l_dff_notes,
1646: 1, -- 1 for request log, 2 for approver log

Line 1643: NVL(p_user_id,FND_GLOBAL.login_id),

1639: sysdate,
1640: NVL(p_user_id,FND_GLOBAL.user_id),
1641: sysdate,
1642: NVL(p_user_id,FND_GLOBAL.user_id),
1643: NVL(p_user_id,FND_GLOBAL.login_id),
1644: p_request_id,
1645: l_dff_notes,
1646: 1, -- 1 for request log, 2 for approver log
1647: null

Line 1675: NVL(p_user_id,FND_GLOBAL.user_id),

1671: )
1672: VALUES(
1673: l_work_request_note_id,
1674: sysdate,
1675: NVL(p_user_id,FND_GLOBAL.user_id),
1676: sysdate,
1677: NVL(p_user_id,FND_GLOBAL.user_id),
1678: NVL(p_user_id,FND_GLOBAL.login_id),
1679: p_request_id,

Line 1677: NVL(p_user_id,FND_GLOBAL.user_id),

1673: l_work_request_note_id,
1674: sysdate,
1675: NVL(p_user_id,FND_GLOBAL.user_id),
1676: sysdate,
1677: NVL(p_user_id,FND_GLOBAL.user_id),
1678: NVL(p_user_id,FND_GLOBAL.login_id),
1679: p_request_id,
1680: l_dff_notes,
1681: 1, -- 1 for request log, 2 for approver log

Line 1678: NVL(p_user_id,FND_GLOBAL.login_id),

1674: sysdate,
1675: NVL(p_user_id,FND_GLOBAL.user_id),
1676: sysdate,
1677: NVL(p_user_id,FND_GLOBAL.user_id),
1678: NVL(p_user_id,FND_GLOBAL.login_id),
1679: p_request_id,
1680: l_dff_notes,
1681: 1, -- 1 for request log, 2 for approver log
1682: null

Line 1710: NVL(p_user_id,FND_GLOBAL.user_id),

1706: )
1707: VALUES(
1708: l_work_request_note_id,
1709: sysdate,
1710: NVL(p_user_id,FND_GLOBAL.user_id),
1711: sysdate,
1712: NVL(p_user_id,FND_GLOBAL.user_id),
1713: NVL(p_user_id,FND_GLOBAL.login_id),
1714: p_request_id,

Line 1712: NVL(p_user_id,FND_GLOBAL.user_id),

1708: l_work_request_note_id,
1709: sysdate,
1710: NVL(p_user_id,FND_GLOBAL.user_id),
1711: sysdate,
1712: NVL(p_user_id,FND_GLOBAL.user_id),
1713: NVL(p_user_id,FND_GLOBAL.login_id),
1714: p_request_id,
1715: l_dff_notes,
1716: 1, -- 1 for request log, 2 for approver log

Line 1713: NVL(p_user_id,FND_GLOBAL.login_id),

1709: sysdate,
1710: NVL(p_user_id,FND_GLOBAL.user_id),
1711: sysdate,
1712: NVL(p_user_id,FND_GLOBAL.user_id),
1713: NVL(p_user_id,FND_GLOBAL.login_id),
1714: p_request_id,
1715: l_dff_notes,
1716: 1, -- 1 for request log, 2 for approver log
1717: null

Line 1745: NVL(p_user_id,FND_GLOBAL.user_id),

1741: )
1742: VALUES(
1743: l_work_request_note_id,
1744: sysdate,
1745: NVL(p_user_id,FND_GLOBAL.user_id),
1746: sysdate,
1747: NVL(p_user_id,FND_GLOBAL.user_id),
1748: NVL(p_user_id,FND_GLOBAL.login_id),
1749: p_request_id,

Line 1747: NVL(p_user_id,FND_GLOBAL.user_id),

1743: l_work_request_note_id,
1744: sysdate,
1745: NVL(p_user_id,FND_GLOBAL.user_id),
1746: sysdate,
1747: NVL(p_user_id,FND_GLOBAL.user_id),
1748: NVL(p_user_id,FND_GLOBAL.login_id),
1749: p_request_id,
1750: l_dff_notes,
1751: 1, -- 1 for request log, 2 for approver log

Line 1748: NVL(p_user_id,FND_GLOBAL.login_id),

1744: sysdate,
1745: NVL(p_user_id,FND_GLOBAL.user_id),
1746: sysdate,
1747: NVL(p_user_id,FND_GLOBAL.user_id),
1748: NVL(p_user_id,FND_GLOBAL.login_id),
1749: p_request_id,
1750: l_dff_notes,
1751: 1, -- 1 for request log, 2 for approver log
1752: null

Line 1780: NVL(p_user_id,FND_GLOBAL.user_id),

1776: )
1777: VALUES(
1778: l_work_request_note_id,
1779: sysdate,
1780: NVL(p_user_id,FND_GLOBAL.user_id),
1781: sysdate,
1782: NVL(p_user_id,FND_GLOBAL.user_id),
1783: NVL(p_user_id,FND_GLOBAL.login_id),
1784: p_request_id,

Line 1782: NVL(p_user_id,FND_GLOBAL.user_id),

1778: l_work_request_note_id,
1779: sysdate,
1780: NVL(p_user_id,FND_GLOBAL.user_id),
1781: sysdate,
1782: NVL(p_user_id,FND_GLOBAL.user_id),
1783: NVL(p_user_id,FND_GLOBAL.login_id),
1784: p_request_id,
1785: l_dff_notes,
1786: 1, -- 1 for request log, 2 for approver log

Line 1783: NVL(p_user_id,FND_GLOBAL.login_id),

1779: sysdate,
1780: NVL(p_user_id,FND_GLOBAL.user_id),
1781: sysdate,
1782: NVL(p_user_id,FND_GLOBAL.user_id),
1783: NVL(p_user_id,FND_GLOBAL.login_id),
1784: p_request_id,
1785: l_dff_notes,
1786: 1, -- 1 for request log, 2 for approver log
1787: null

Line 1815: NVL(p_user_id,FND_GLOBAL.user_id),

1811: )
1812: VALUES(
1813: l_work_request_note_id,
1814: sysdate,
1815: NVL(p_user_id,FND_GLOBAL.user_id),
1816: sysdate,
1817: NVL(p_user_id,FND_GLOBAL.user_id),
1818: NVL(p_user_id,FND_GLOBAL.login_id),
1819: p_request_id,

Line 1817: NVL(p_user_id,FND_GLOBAL.user_id),

1813: l_work_request_note_id,
1814: sysdate,
1815: NVL(p_user_id,FND_GLOBAL.user_id),
1816: sysdate,
1817: NVL(p_user_id,FND_GLOBAL.user_id),
1818: NVL(p_user_id,FND_GLOBAL.login_id),
1819: p_request_id,
1820: l_dff_notes,
1821: 1, -- 1 for request log, 2 for approver log

Line 1818: NVL(p_user_id,FND_GLOBAL.login_id),

1814: sysdate,
1815: NVL(p_user_id,FND_GLOBAL.user_id),
1816: sysdate,
1817: NVL(p_user_id,FND_GLOBAL.user_id),
1818: NVL(p_user_id,FND_GLOBAL.login_id),
1819: p_request_id,
1820: l_dff_notes,
1821: 1, -- 1 for request log, 2 for approver log
1822: null

Line 1850: NVL(p_user_id,FND_GLOBAL.user_id),

1846: )
1847: VALUES(
1848: l_work_request_note_id,
1849: sysdate,
1850: NVL(p_user_id,FND_GLOBAL.user_id),
1851: sysdate,
1852: NVL(p_user_id,FND_GLOBAL.user_id),
1853: NVL(p_user_id,FND_GLOBAL.login_id),
1854: p_request_id,

Line 1852: NVL(p_user_id,FND_GLOBAL.user_id),

1848: l_work_request_note_id,
1849: sysdate,
1850: NVL(p_user_id,FND_GLOBAL.user_id),
1851: sysdate,
1852: NVL(p_user_id,FND_GLOBAL.user_id),
1853: NVL(p_user_id,FND_GLOBAL.login_id),
1854: p_request_id,
1855: l_dff_notes,
1856: 1, -- 1 for request log, 2 for approver log

Line 1853: NVL(p_user_id,FND_GLOBAL.login_id),

1849: sysdate,
1850: NVL(p_user_id,FND_GLOBAL.user_id),
1851: sysdate,
1852: NVL(p_user_id,FND_GLOBAL.user_id),
1853: NVL(p_user_id,FND_GLOBAL.login_id),
1854: p_request_id,
1855: l_dff_notes,
1856: 1, -- 1 for request log, 2 for approver log
1857: null

Line 1885: NVL(p_user_id,FND_GLOBAL.user_id),

1881: )
1882: VALUES(
1883: l_work_request_note_id,
1884: sysdate,
1885: NVL(p_user_id,FND_GLOBAL.user_id),
1886: sysdate,
1887: NVL(p_user_id,FND_GLOBAL.user_id),
1888: NVL(p_user_id,FND_GLOBAL.login_id),
1889: p_request_id,

Line 1887: NVL(p_user_id,FND_GLOBAL.user_id),

1883: l_work_request_note_id,
1884: sysdate,
1885: NVL(p_user_id,FND_GLOBAL.user_id),
1886: sysdate,
1887: NVL(p_user_id,FND_GLOBAL.user_id),
1888: NVL(p_user_id,FND_GLOBAL.login_id),
1889: p_request_id,
1890: l_dff_notes,
1891: 1, -- 1 for request log, 2 for approver log

Line 1888: NVL(p_user_id,FND_GLOBAL.login_id),

1884: sysdate,
1885: NVL(p_user_id,FND_GLOBAL.user_id),
1886: sysdate,
1887: NVL(p_user_id,FND_GLOBAL.user_id),
1888: NVL(p_user_id,FND_GLOBAL.login_id),
1889: p_request_id,
1890: l_dff_notes,
1891: 1, -- 1 for request log, 2 for approver log
1892: null

Line 1920: NVL(p_user_id,FND_GLOBAL.user_id),

1916: )
1917: VALUES(
1918: l_work_request_note_id,
1919: sysdate,
1920: NVL(p_user_id,FND_GLOBAL.user_id),
1921: sysdate,
1922: NVL(p_user_id,FND_GLOBAL.user_id),
1923: NVL(p_user_id,FND_GLOBAL.login_id),
1924: p_request_id,

Line 1922: NVL(p_user_id,FND_GLOBAL.user_id),

1918: l_work_request_note_id,
1919: sysdate,
1920: NVL(p_user_id,FND_GLOBAL.user_id),
1921: sysdate,
1922: NVL(p_user_id,FND_GLOBAL.user_id),
1923: NVL(p_user_id,FND_GLOBAL.login_id),
1924: p_request_id,
1925: l_dff_notes,
1926: 1, -- 1 for request log, 2 for approver log

Line 1923: NVL(p_user_id,FND_GLOBAL.login_id),

1919: sysdate,
1920: NVL(p_user_id,FND_GLOBAL.user_id),
1921: sysdate,
1922: NVL(p_user_id,FND_GLOBAL.user_id),
1923: NVL(p_user_id,FND_GLOBAL.login_id),
1924: p_request_id,
1925: l_dff_notes,
1926: 1, -- 1 for request log, 2 for approver log
1927: null

Line 1955: NVL(p_user_id,FND_GLOBAL.user_id),

1951: )
1952: VALUES(
1953: l_work_request_note_id,
1954: sysdate,
1955: NVL(p_user_id,FND_GLOBAL.user_id),
1956: sysdate,
1957: NVL(p_user_id,FND_GLOBAL.user_id),
1958: NVL(p_user_id,FND_GLOBAL.login_id),
1959: p_request_id,

Line 1957: NVL(p_user_id,FND_GLOBAL.user_id),

1953: l_work_request_note_id,
1954: sysdate,
1955: NVL(p_user_id,FND_GLOBAL.user_id),
1956: sysdate,
1957: NVL(p_user_id,FND_GLOBAL.user_id),
1958: NVL(p_user_id,FND_GLOBAL.login_id),
1959: p_request_id,
1960: l_dff_notes,
1961: 1, -- 1 for request log, 2 for approver log

Line 1958: NVL(p_user_id,FND_GLOBAL.login_id),

1954: sysdate,
1955: NVL(p_user_id,FND_GLOBAL.user_id),
1956: sysdate,
1957: NVL(p_user_id,FND_GLOBAL.user_id),
1958: NVL(p_user_id,FND_GLOBAL.login_id),
1959: p_request_id,
1960: l_dff_notes,
1961: 1, -- 1 for request log, 2 for approver log
1962: null

Line 1990: NVL(p_user_id,FND_GLOBAL.user_id),

1986: )
1987: VALUES(
1988: l_work_request_note_id,
1989: sysdate,
1990: NVL(p_user_id,FND_GLOBAL.user_id),
1991: sysdate,
1992: NVL(p_user_id,FND_GLOBAL.user_id),
1993: NVL(p_user_id,FND_GLOBAL.login_id),
1994: p_request_id,

Line 1992: NVL(p_user_id,FND_GLOBAL.user_id),

1988: l_work_request_note_id,
1989: sysdate,
1990: NVL(p_user_id,FND_GLOBAL.user_id),
1991: sysdate,
1992: NVL(p_user_id,FND_GLOBAL.user_id),
1993: NVL(p_user_id,FND_GLOBAL.login_id),
1994: p_request_id,
1995: l_dff_notes,
1996: 1, -- 1 for request log, 2 for approver log

Line 1993: NVL(p_user_id,FND_GLOBAL.login_id),

1989: sysdate,
1990: NVL(p_user_id,FND_GLOBAL.user_id),
1991: sysdate,
1992: NVL(p_user_id,FND_GLOBAL.user_id),
1993: NVL(p_user_id,FND_GLOBAL.login_id),
1994: p_request_id,
1995: l_dff_notes,
1996: 1, -- 1 for request log, 2 for approver log
1997: null

Line 2025: NVL(p_user_id,FND_GLOBAL.user_id),

2021: )
2022: VALUES(
2023: l_work_request_note_id,
2024: sysdate,
2025: NVL(p_user_id,FND_GLOBAL.user_id),
2026: sysdate,
2027: NVL(p_user_id,FND_GLOBAL.user_id),
2028: NVL(p_user_id,FND_GLOBAL.login_id),
2029: p_request_id,

Line 2027: NVL(p_user_id,FND_GLOBAL.user_id),

2023: l_work_request_note_id,
2024: sysdate,
2025: NVL(p_user_id,FND_GLOBAL.user_id),
2026: sysdate,
2027: NVL(p_user_id,FND_GLOBAL.user_id),
2028: NVL(p_user_id,FND_GLOBAL.login_id),
2029: p_request_id,
2030: l_dff_notes,
2031: 1, -- 1 for request log, 2 for approver log

Line 2028: NVL(p_user_id,FND_GLOBAL.login_id),

2024: sysdate,
2025: NVL(p_user_id,FND_GLOBAL.user_id),
2026: sysdate,
2027: NVL(p_user_id,FND_GLOBAL.user_id),
2028: NVL(p_user_id,FND_GLOBAL.login_id),
2029: p_request_id,
2030: l_dff_notes,
2031: 1, -- 1 for request log, 2 for approver log
2032: null

Line 2060: NVL(p_user_id,FND_GLOBAL.user_id),

2056: )
2057: VALUES(
2058: l_work_request_note_id,
2059: sysdate,
2060: NVL(p_user_id,FND_GLOBAL.user_id),
2061: sysdate,
2062: NVL(p_user_id,FND_GLOBAL.user_id),
2063: NVL(p_user_id,FND_GLOBAL.login_id),
2064: p_request_id,

Line 2062: NVL(p_user_id,FND_GLOBAL.user_id),

2058: l_work_request_note_id,
2059: sysdate,
2060: NVL(p_user_id,FND_GLOBAL.user_id),
2061: sysdate,
2062: NVL(p_user_id,FND_GLOBAL.user_id),
2063: NVL(p_user_id,FND_GLOBAL.login_id),
2064: p_request_id,
2065: l_dff_notes,
2066: 1, -- 1 for request log, 2 for approver log

Line 2063: NVL(p_user_id,FND_GLOBAL.login_id),

2059: sysdate,
2060: NVL(p_user_id,FND_GLOBAL.user_id),
2061: sysdate,
2062: NVL(p_user_id,FND_GLOBAL.user_id),
2063: NVL(p_user_id,FND_GLOBAL.login_id),
2064: p_request_id,
2065: l_dff_notes,
2066: 1, -- 1 for request log, 2 for approver log
2067: null

Line 2095: NVL(p_user_id,FND_GLOBAL.user_id),

2091: )
2092: VALUES(
2093: l_work_request_note_id,
2094: sysdate,
2095: NVL(p_user_id,FND_GLOBAL.user_id),
2096: sysdate,
2097: NVL(p_user_id,FND_GLOBAL.user_id),
2098: NVL(p_user_id,FND_GLOBAL.login_id),
2099: p_request_id,

Line 2097: NVL(p_user_id,FND_GLOBAL.user_id),

2093: l_work_request_note_id,
2094: sysdate,
2095: NVL(p_user_id,FND_GLOBAL.user_id),
2096: sysdate,
2097: NVL(p_user_id,FND_GLOBAL.user_id),
2098: NVL(p_user_id,FND_GLOBAL.login_id),
2099: p_request_id,
2100: l_dff_notes,
2101: 1, -- 1 for request log, 2 for approver log

Line 2098: NVL(p_user_id,FND_GLOBAL.login_id),

2094: sysdate,
2095: NVL(p_user_id,FND_GLOBAL.user_id),
2096: sysdate,
2097: NVL(p_user_id,FND_GLOBAL.user_id),
2098: NVL(p_user_id,FND_GLOBAL.login_id),
2099: p_request_id,
2100: l_dff_notes,
2101: 1, -- 1 for request log, 2 for approver log
2102: null

Line 2130: NVL(p_user_id,FND_GLOBAL.user_id),

2126: )
2127: VALUES(
2128: l_work_request_note_id,
2129: sysdate,
2130: NVL(p_user_id,FND_GLOBAL.user_id),
2131: sysdate,
2132: NVL(p_user_id,FND_GLOBAL.user_id),
2133: NVL(p_user_id,FND_GLOBAL.login_id),
2134: p_request_id,

Line 2132: NVL(p_user_id,FND_GLOBAL.user_id),

2128: l_work_request_note_id,
2129: sysdate,
2130: NVL(p_user_id,FND_GLOBAL.user_id),
2131: sysdate,
2132: NVL(p_user_id,FND_GLOBAL.user_id),
2133: NVL(p_user_id,FND_GLOBAL.login_id),
2134: p_request_id,
2135: l_dff_notes,
2136: 1, -- 1 for request log, 2 for approver log

Line 2133: NVL(p_user_id,FND_GLOBAL.login_id),

2129: sysdate,
2130: NVL(p_user_id,FND_GLOBAL.user_id),
2131: sysdate,
2132: NVL(p_user_id,FND_GLOBAL.user_id),
2133: NVL(p_user_id,FND_GLOBAL.login_id),
2134: p_request_id,
2135: l_dff_notes,
2136: 1, -- 1 for request log, 2 for approver log
2137: null

Line 2165: NVL(p_user_id,FND_GLOBAL.user_id),

2161: )
2162: VALUES(
2163: l_work_request_note_id,
2164: sysdate,
2165: NVL(p_user_id,FND_GLOBAL.user_id),
2166: sysdate,
2167: NVL(p_user_id,FND_GLOBAL.user_id),
2168: NVL(p_user_id,FND_GLOBAL.login_id),
2169: p_request_id,

Line 2167: NVL(p_user_id,FND_GLOBAL.user_id),

2163: l_work_request_note_id,
2164: sysdate,
2165: NVL(p_user_id,FND_GLOBAL.user_id),
2166: sysdate,
2167: NVL(p_user_id,FND_GLOBAL.user_id),
2168: NVL(p_user_id,FND_GLOBAL.login_id),
2169: p_request_id,
2170: l_dff_notes,
2171: 1, -- 1 for request log, 2 for approver log

Line 2168: NVL(p_user_id,FND_GLOBAL.login_id),

2164: sysdate,
2165: NVL(p_user_id,FND_GLOBAL.user_id),
2166: sysdate,
2167: NVL(p_user_id,FND_GLOBAL.user_id),
2168: NVL(p_user_id,FND_GLOBAL.login_id),
2169: p_request_id,
2170: l_dff_notes,
2171: 1, -- 1 for request log, 2 for approver log
2172: null

Line 2217: NVL(p_user_id,FND_GLOBAL.user_id),

2213: )
2214: VALUES(
2215: l_work_request_note_id,
2216: sysdate,
2217: NVL(p_user_id,FND_GLOBAL.user_id),
2218: sysdate,
2219: NVL(p_user_id,FND_GLOBAL.user_id),
2220: NVL(p_user_id,FND_GLOBAL.login_id),
2221: p_request_id,

Line 2219: NVL(p_user_id,FND_GLOBAL.user_id),

2215: l_work_request_note_id,
2216: sysdate,
2217: NVL(p_user_id,FND_GLOBAL.user_id),
2218: sysdate,
2219: NVL(p_user_id,FND_GLOBAL.user_id),
2220: NVL(p_user_id,FND_GLOBAL.login_id),
2221: p_request_id,
2222: p_request_log,
2223: 1, -- 1 for request log, 2 for approver log

Line 2220: NVL(p_user_id,FND_GLOBAL.login_id),

2216: sysdate,
2217: NVL(p_user_id,FND_GLOBAL.user_id),
2218: sysdate,
2219: NVL(p_user_id,FND_GLOBAL.user_id),
2220: NVL(p_user_id,FND_GLOBAL.login_id),
2221: p_request_id,
2222: p_request_log,
2223: 1, -- 1 for request log, 2 for approver log
2224: null