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 110: l_request_log := replace(p_request_log,fnd_global.local_chr(13)||fnd_global.local_chr(10),fnd_global.local_chr(10));

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

Line 271: FND_GLOBAL.user_id,

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

Line 273: FND_GLOBAL.user_id,

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

Line 274: FND_GLOBAL.login_id,

270: sysdate,
271: FND_GLOBAL.user_id,
272: sysdate,
273: FND_GLOBAL.user_id,
274: FND_GLOBAL.login_id,
275: p_asset_number,
276: p_asset_group_id,
277: p_org_id,
278: l_status_id,

Line 287: FND_GLOBAL.user_id,

283: p_request_by_date,
284: substr(l_request_log, 1, 240),
285: p_work_request_type_id,
286: l_auto_approve_flag,
287: FND_GLOBAL.user_id,
288: l_maintenance_object_type,
289: l_maintenance_object_id,
290: nvl(p_created_for,FND_GLOBAL.user_id),
291: p_phone_number,

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

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

Line 313: SELECT '*** '||FND_GLOBAL.USER_NAME||' ('

309: p_attribute14,
310: p_attribute15
311: );
312: l_stmt_num := 90;
313: SELECT '*** '||FND_GLOBAL.USER_NAME||' ('
314: ||to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS')||') *** '
315: INTO l_standard_log
316: FROM DUAL;
317: l_stmt_num := 100;

Line 337: FND_GLOBAL.user_id,

333: )
334: VALUES(
335: l_work_request_note_id,
336: sysdate,
337: FND_GLOBAL.user_id,
338: sysdate,
339: FND_GLOBAL.user_id,
340: FND_GLOBAL.login_id,
341: l_work_request_id,

Line 339: FND_GLOBAL.user_id,

335: l_work_request_note_id,
336: sysdate,
337: FND_GLOBAL.user_id,
338: sysdate,
339: FND_GLOBAL.user_id,
340: FND_GLOBAL.login_id,
341: l_work_request_id,
342: l_standard_log,
343: 1, -- 1 for request log, 2 for approver log

Line 340: FND_GLOBAL.login_id,

336: sysdate,
337: FND_GLOBAL.user_id,
338: sysdate,
339: FND_GLOBAL.user_id,
340: FND_GLOBAL.login_id,
341: l_work_request_id,
342: l_standard_log,
343: 1, -- 1 for request log, 2 for approver log
344: null

Line 367: FND_GLOBAL.user_id,

363: )
364: VALUES(
365: l_work_request_note_id,
366: sysdate,
367: FND_GLOBAL.user_id,
368: sysdate,
369: FND_GLOBAL.user_id,
370: FND_GLOBAL.login_id,
371: l_work_request_id,

Line 369: FND_GLOBAL.user_id,

365: l_work_request_note_id,
366: sysdate,
367: FND_GLOBAL.user_id,
368: sysdate,
369: FND_GLOBAL.user_id,
370: FND_GLOBAL.login_id,
371: l_work_request_id,
372: l_request_log,
373: 1, -- 1 for request log, 2 for approver log

Line 370: FND_GLOBAL.login_id,

366: sysdate,
367: FND_GLOBAL.user_id,
368: sysdate,
369: FND_GLOBAL.user_id,
370: FND_GLOBAL.login_id,
371: l_work_request_id,
372: l_request_log,
373: 1, -- 1 for request log, 2 for approver log
374: null

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

389: p_comments => l_request_log,
390: p_reference => l_work_request_id,
391: p_ref_id => l_work_request_id,
392: p_instance_number => null,
393: p_employee_id => nvl(p_created_for,FND_GLOBAL.user_id),
394: x_return_status => x_return_status,
395: x_msg_count => x_msg_count,
396: x_msg_data => x_msg_data
397: );

Line 854: SELECT '*** '||FND_GLOBAL.USER_NAME||' ('

850: FND_MSG_PUB.ADD;
851: RAISE FND_API.G_EXC_ERROR;
852: END IF;
853:
854: SELECT '*** '||FND_GLOBAL.USER_NAME||' ('
855: ||to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS')||') *** '
856: INTO l_standard_log
857: FROM DUAL;
858: l_another_log := l_standard_log;

Line 880: FND_GLOBAL.user_id,

876: )
877: values(
878: l_work_request_note_id,
879: sysdate,
880: FND_GLOBAL.user_id,
881: sysdate,
882: FND_GLOBAL.user_id,
883: FND_GLOBAL.login_id,
884: p_request_id,

Line 882: FND_GLOBAL.user_id,

878: l_work_request_note_id,
879: sysdate,
880: FND_GLOBAL.user_id,
881: sysdate,
882: FND_GLOBAL.user_id,
883: FND_GLOBAL.login_id,
884: p_request_id,
885: l_standard_log,
886: 1, -- 1 for request log, 2 for approver log

Line 883: FND_GLOBAL.login_id,

879: sysdate,
880: FND_GLOBAL.user_id,
881: sysdate,
882: FND_GLOBAL.user_id,
883: FND_GLOBAL.login_id,
884: p_request_id,
885: l_standard_log,
886: 1, -- 1 for request log, 2 for approver log
887: null -- Don't know what will be put here for notification_id

Line 925: last_updated_by = FND_GLOBAL.user_id,

921: END IF;
922:
923: UPDATE wip_eam_work_requests SET
924: last_update_date = sysdate,
925: last_updated_by = FND_GLOBAL.user_id,
926: last_update_login = FND_GLOBAL.login_id,
927: work_request_priority_id = l_new_priority_id,
928: work_request_owning_dept = l_new_owning_dept_id,
929: work_request_status_id = l_new_status_id,

Line 926: last_update_login = FND_GLOBAL.login_id,

922:
923: UPDATE wip_eam_work_requests SET
924: last_update_date = sysdate,
925: last_updated_by = FND_GLOBAL.user_id,
926: last_update_login = FND_GLOBAL.login_id,
927: work_request_priority_id = l_new_priority_id,
928: work_request_owning_dept = l_new_owning_dept_id,
929: work_request_status_id = l_new_status_id,
930: expected_resolution_date = l_new_request_by_date,

Line 1086: FND_GLOBAL.user_id,

1082: )
1083: VALUES(
1084: l_work_request_note_id,
1085: sysdate,
1086: FND_GLOBAL.user_id,
1087: sysdate,
1088: FND_GLOBAL.user_id,
1089: FND_GLOBAL.login_id,
1090: p_request_id,

Line 1088: FND_GLOBAL.user_id,

1084: l_work_request_note_id,
1085: sysdate,
1086: FND_GLOBAL.user_id,
1087: sysdate,
1088: FND_GLOBAL.user_id,
1089: FND_GLOBAL.login_id,
1090: p_request_id,
1091: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1092: 1, -- 1 for request log, 2 for approver log

Line 1089: FND_GLOBAL.login_id,

1085: sysdate,
1086: FND_GLOBAL.user_id,
1087: sysdate,
1088: FND_GLOBAL.user_id,
1089: FND_GLOBAL.login_id,
1090: p_request_id,
1091: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1092: 1, -- 1 for request log, 2 for approver log
1093: null

Line 1116: FND_GLOBAL.user_id,

1112: )
1113: VALUES(
1114: l_work_request_note_id,
1115: sysdate,
1116: FND_GLOBAL.user_id,
1117: sysdate,
1118: FND_GLOBAL.user_id,
1119: FND_GLOBAL.login_id,
1120: p_request_id,

Line 1118: FND_GLOBAL.user_id,

1114: l_work_request_note_id,
1115: sysdate,
1116: FND_GLOBAL.user_id,
1117: sysdate,
1118: FND_GLOBAL.user_id,
1119: FND_GLOBAL.login_id,
1120: p_request_id,
1121: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_asset_number,l_null)||' -> '||nvl(l_new_asset_number,l_null),
1122: 1, -- 1 for request log, 2 for approver log

Line 1119: FND_GLOBAL.login_id,

1115: sysdate,
1116: FND_GLOBAL.user_id,
1117: sysdate,
1118: FND_GLOBAL.user_id,
1119: FND_GLOBAL.login_id,
1120: p_request_id,
1121: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_asset_number,l_null)||' -> '||nvl(l_new_asset_number,l_null),
1122: 1, -- 1 for request log, 2 for approver log
1123: null

Line 1171: FND_GLOBAL.user_id,

1167: )
1168: VALUES(
1169: l_work_request_note_id,
1170: sysdate,
1171: FND_GLOBAL.user_id,
1172: sysdate,
1173: FND_GLOBAL.user_id,
1174: FND_GLOBAL.login_id,
1175: p_request_id,

Line 1173: FND_GLOBAL.user_id,

1169: l_work_request_note_id,
1170: sysdate,
1171: FND_GLOBAL.user_id,
1172: sysdate,
1173: FND_GLOBAL.user_id,
1174: FND_GLOBAL.login_id,
1175: p_request_id,
1176: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1177: 1, -- 1 for request log, 2 for approver log

Line 1174: FND_GLOBAL.login_id,

1170: sysdate,
1171: FND_GLOBAL.user_id,
1172: sysdate,
1173: FND_GLOBAL.user_id,
1174: FND_GLOBAL.login_id,
1175: p_request_id,
1176: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1177: 1, -- 1 for request log, 2 for approver log
1178: null

Line 1227: FND_GLOBAL.user_id,

1223: )
1224: VALUES(
1225: l_work_request_note_id,
1226: sysdate,
1227: FND_GLOBAL.user_id,
1228: sysdate,
1229: FND_GLOBAL.user_id,
1230: FND_GLOBAL.login_id,
1231: p_request_id,

Line 1229: FND_GLOBAL.user_id,

1225: l_work_request_note_id,
1226: sysdate,
1227: FND_GLOBAL.user_id,
1228: sysdate,
1229: FND_GLOBAL.user_id,
1230: FND_GLOBAL.login_id,
1231: p_request_id,
1232: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1233: 1, -- 1 for request log, 2 for approver log

Line 1230: FND_GLOBAL.login_id,

1226: sysdate,
1227: FND_GLOBAL.user_id,
1228: sysdate,
1229: FND_GLOBAL.user_id,
1230: FND_GLOBAL.login_id,
1231: p_request_id,
1232: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1233: 1, -- 1 for request log, 2 for approver log
1234: null

Line 1282: FND_GLOBAL.user_id,

1278: )
1279: VALUES(
1280: l_work_request_note_id,
1281: sysdate,
1282: FND_GLOBAL.user_id,
1283: sysdate,
1284: FND_GLOBAL.user_id,
1285: FND_GLOBAL.login_id,
1286: p_request_id,

Line 1284: FND_GLOBAL.user_id,

1280: l_work_request_note_id,
1281: sysdate,
1282: FND_GLOBAL.user_id,
1283: sysdate,
1284: FND_GLOBAL.user_id,
1285: FND_GLOBAL.login_id,
1286: p_request_id,
1287: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1288: 1, -- 1 for request log, 2 for approver log

Line 1285: FND_GLOBAL.login_id,

1281: sysdate,
1282: FND_GLOBAL.user_id,
1283: sysdate,
1284: FND_GLOBAL.user_id,
1285: FND_GLOBAL.login_id,
1286: p_request_id,
1287: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1288: 1, -- 1 for request log, 2 for approver log
1289: null

Line 1337: FND_GLOBAL.user_id,

1333: )
1334: VALUES(
1335: l_work_request_note_id,
1336: sysdate,
1337: FND_GLOBAL.user_id,
1338: sysdate,
1339: FND_GLOBAL.user_id,
1340: FND_GLOBAL.login_id,
1341: p_request_id,

Line 1339: FND_GLOBAL.user_id,

1335: l_work_request_note_id,
1336: sysdate,
1337: FND_GLOBAL.user_id,
1338: sysdate,
1339: FND_GLOBAL.user_id,
1340: FND_GLOBAL.login_id,
1341: p_request_id,
1342: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1343: 1, -- 1 for request log, 2 for approver log

Line 1340: FND_GLOBAL.login_id,

1336: sysdate,
1337: FND_GLOBAL.user_id,
1338: sysdate,
1339: FND_GLOBAL.user_id,
1340: FND_GLOBAL.login_id,
1341: p_request_id,
1342: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1343: 1, -- 1 for request log, 2 for approver log
1344: null

Line 1379: FND_GLOBAL.user_id,

1375: )
1376: VALUES(
1377: l_work_request_note_id,
1378: sysdate,
1379: FND_GLOBAL.user_id,
1380: sysdate,
1381: FND_GLOBAL.user_id,
1382: FND_GLOBAL.login_id,
1383: p_request_id,

Line 1381: FND_GLOBAL.user_id,

1377: l_work_request_note_id,
1378: sysdate,
1379: FND_GLOBAL.user_id,
1380: sysdate,
1381: FND_GLOBAL.user_id,
1382: FND_GLOBAL.login_id,
1383: p_request_id,
1384: '@@@ '||FND_MESSAGE.GET||l_timezone_code ||' : '||to_char(l_old_request_by_date, 'dd-MON-yyyy hh24:mi:ss')||' -> '
1385: ||to_char(l_new_request_by_date, 'dd-MON-yyyy hh24:mi:ss') ,

Line 1382: FND_GLOBAL.login_id,

1378: sysdate,
1379: FND_GLOBAL.user_id,
1380: sysdate,
1381: FND_GLOBAL.user_id,
1382: FND_GLOBAL.login_id,
1383: p_request_id,
1384: '@@@ '||FND_MESSAGE.GET||l_timezone_code ||' : '||to_char(l_old_request_by_date, 'dd-MON-yyyy hh24:mi:ss')||' -> '
1385: ||to_char(l_new_request_by_date, 'dd-MON-yyyy hh24:mi:ss') ,
1386: 1, -- 1 for request log, 2 for approver log

Line 1432: FND_GLOBAL.user_id,

1428: )
1429: VALUES(
1430: l_work_request_note_id,
1431: sysdate,
1432: FND_GLOBAL.user_id,
1433: sysdate,
1434: FND_GLOBAL.user_id,
1435: FND_GLOBAL.login_id,
1436: p_request_id,

Line 1434: FND_GLOBAL.user_id,

1430: l_work_request_note_id,
1431: sysdate,
1432: FND_GLOBAL.user_id,
1433: sysdate,
1434: FND_GLOBAL.user_id,
1435: FND_GLOBAL.login_id,
1436: p_request_id,
1437: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1438: 1, -- 1 for request log, 2 for approver log

Line 1435: FND_GLOBAL.login_id,

1431: sysdate,
1432: FND_GLOBAL.user_id,
1433: sysdate,
1434: FND_GLOBAL.user_id,
1435: FND_GLOBAL.login_id,
1436: p_request_id,
1437: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1438: 1, -- 1 for request log, 2 for approver log
1439: null

Line 1463: FND_GLOBAL.user_id,

1459: )
1460: VALUES(
1461: l_work_request_note_id,
1462: sysdate,
1463: FND_GLOBAL.user_id,
1464: sysdate,
1465: FND_GLOBAL.user_id,
1466: FND_GLOBAL.login_id,
1467: p_request_id,

Line 1465: FND_GLOBAL.user_id,

1461: l_work_request_note_id,
1462: sysdate,
1463: FND_GLOBAL.user_id,
1464: sysdate,
1465: FND_GLOBAL.user_id,
1466: FND_GLOBAL.login_id,
1467: p_request_id,
1468: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_email,l_null)||' -> '||nvl(l_new_email,l_null),
1469: 1, -- 1 for request log, 2 for approver log

Line 1466: FND_GLOBAL.login_id,

1462: sysdate,
1463: FND_GLOBAL.user_id,
1464: sysdate,
1465: FND_GLOBAL.user_id,
1466: FND_GLOBAL.login_id,
1467: p_request_id,
1468: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_email,l_null)||' -> '||nvl(l_new_email,l_null),
1469: 1, -- 1 for request log, 2 for approver log
1470: null

Line 1494: FND_GLOBAL.user_id,

1490: )
1491: VALUES(
1492: l_work_request_note_id,
1493: sysdate,
1494: FND_GLOBAL.user_id,
1495: sysdate,
1496: FND_GLOBAL.user_id,
1497: FND_GLOBAL.login_id,
1498: p_request_id,

Line 1496: FND_GLOBAL.user_id,

1492: l_work_request_note_id,
1493: sysdate,
1494: FND_GLOBAL.user_id,
1495: sysdate,
1496: FND_GLOBAL.user_id,
1497: FND_GLOBAL.login_id,
1498: p_request_id,
1499: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_phone_number,l_null)||' -> '||nvl(l_new_phone_number,l_null),
1500: 1, /* 1 for request log, 2 for approver log*/

Line 1497: FND_GLOBAL.login_id,

1493: sysdate,
1494: FND_GLOBAL.user_id,
1495: sysdate,
1496: FND_GLOBAL.user_id,
1497: FND_GLOBAL.login_id,
1498: p_request_id,
1499: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_phone_number,l_null)||' -> '||nvl(l_new_phone_number,l_null),
1500: 1, /* 1 for request log, 2 for approver log*/
1501: null

Line 1545: FND_GLOBAL.user_id,

1541: )
1542: VALUES(
1543: l_work_request_note_id,
1544: sysdate,
1545: FND_GLOBAL.user_id,
1546: sysdate,
1547: FND_GLOBAL.user_id,
1548: FND_GLOBAL.login_id,
1549: p_request_id,

Line 1547: FND_GLOBAL.user_id,

1543: l_work_request_note_id,
1544: sysdate,
1545: FND_GLOBAL.user_id,
1546: sysdate,
1547: FND_GLOBAL.user_id,
1548: FND_GLOBAL.login_id,
1549: p_request_id,
1550: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1551: 1, -- 1 for request log, 2 for approver log

Line 1548: FND_GLOBAL.login_id,

1544: sysdate,
1545: FND_GLOBAL.user_id,
1546: sysdate,
1547: FND_GLOBAL.user_id,
1548: FND_GLOBAL.login_id,
1549: p_request_id,
1550: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1551: 1, -- 1 for request log, 2 for approver log
1552: null

Line 1596: FND_GLOBAL.user_id,

1592: )
1593: VALUES(
1594: l_work_request_note_id,
1595: sysdate,
1596: FND_GLOBAL.user_id,
1597: sysdate,
1598: FND_GLOBAL.user_id,
1599: FND_GLOBAL.login_id,
1600: p_request_id,

Line 1598: FND_GLOBAL.user_id,

1594: l_work_request_note_id,
1595: sysdate,
1596: FND_GLOBAL.user_id,
1597: sysdate,
1598: FND_GLOBAL.user_id,
1599: FND_GLOBAL.login_id,
1600: p_request_id,
1601: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1602: 1, -- 1 for request log, 2 for approver log

Line 1599: FND_GLOBAL.login_id,

1595: sysdate,
1596: FND_GLOBAL.user_id,
1597: sysdate,
1598: FND_GLOBAL.user_id,
1599: FND_GLOBAL.login_id,
1600: p_request_id,
1601: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1602: 1, -- 1 for request log, 2 for approver log
1603: null

Line 1627: FND_GLOBAL.user_id,

1623: )
1624: VALUES(
1625: l_work_request_note_id,
1626: sysdate,
1627: FND_GLOBAL.user_id,
1628: sysdate,
1629: FND_GLOBAL.user_id,
1630: FND_GLOBAL.login_id,
1631: p_request_id,

Line 1629: FND_GLOBAL.user_id,

1625: l_work_request_note_id,
1626: sysdate,
1627: FND_GLOBAL.user_id,
1628: sysdate,
1629: FND_GLOBAL.user_id,
1630: FND_GLOBAL.login_id,
1631: p_request_id,
1632: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_attribute_category,l_null)||' -> '||nvl(l_new_attribute_category,l_null),
1633: 1, -- 1 for request log, 2 for approver log

Line 1630: FND_GLOBAL.login_id,

1626: sysdate,
1627: FND_GLOBAL.user_id,
1628: sysdate,
1629: FND_GLOBAL.user_id,
1630: FND_GLOBAL.login_id,
1631: p_request_id,
1632: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_attribute_category,l_null)||' -> '||nvl(l_new_attribute_category,l_null),
1633: 1, -- 1 for request log, 2 for approver log
1634: null

Line 1661: FND_GLOBAL.user_id,

1657: )
1658: VALUES(
1659: l_work_request_note_id,
1660: sysdate,
1661: FND_GLOBAL.user_id,
1662: sysdate,
1663: FND_GLOBAL.user_id,
1664: FND_GLOBAL.login_id,
1665: p_request_id,

Line 1663: FND_GLOBAL.user_id,

1659: l_work_request_note_id,
1660: sysdate,
1661: FND_GLOBAL.user_id,
1662: sysdate,
1663: FND_GLOBAL.user_id,
1664: FND_GLOBAL.login_id,
1665: p_request_id,
1666: l_dff_notes,
1667: 1, -- 1 for request log, 2 for approver log

Line 1664: FND_GLOBAL.login_id,

1660: sysdate,
1661: FND_GLOBAL.user_id,
1662: sysdate,
1663: FND_GLOBAL.user_id,
1664: FND_GLOBAL.login_id,
1665: p_request_id,
1666: l_dff_notes,
1667: 1, -- 1 for request log, 2 for approver log
1668: null

Line 1696: FND_GLOBAL.user_id,

1692: )
1693: VALUES(
1694: l_work_request_note_id,
1695: sysdate,
1696: FND_GLOBAL.user_id,
1697: sysdate,
1698: FND_GLOBAL.user_id,
1699: FND_GLOBAL.login_id,
1700: p_request_id,

Line 1698: FND_GLOBAL.user_id,

1694: l_work_request_note_id,
1695: sysdate,
1696: FND_GLOBAL.user_id,
1697: sysdate,
1698: FND_GLOBAL.user_id,
1699: FND_GLOBAL.login_id,
1700: p_request_id,
1701: l_dff_notes,
1702: 1, -- 1 for request log, 2 for approver log

Line 1699: FND_GLOBAL.login_id,

1695: sysdate,
1696: FND_GLOBAL.user_id,
1697: sysdate,
1698: FND_GLOBAL.user_id,
1699: FND_GLOBAL.login_id,
1700: p_request_id,
1701: l_dff_notes,
1702: 1, -- 1 for request log, 2 for approver log
1703: null

Line 1731: FND_GLOBAL.user_id,

1727: )
1728: VALUES(
1729: l_work_request_note_id,
1730: sysdate,
1731: FND_GLOBAL.user_id,
1732: sysdate,
1733: FND_GLOBAL.user_id,
1734: FND_GLOBAL.login_id,
1735: p_request_id,

Line 1733: FND_GLOBAL.user_id,

1729: l_work_request_note_id,
1730: sysdate,
1731: FND_GLOBAL.user_id,
1732: sysdate,
1733: FND_GLOBAL.user_id,
1734: FND_GLOBAL.login_id,
1735: p_request_id,
1736: l_dff_notes,
1737: 1, -- 1 for request log, 2 for approver log

Line 1734: FND_GLOBAL.login_id,

1730: sysdate,
1731: FND_GLOBAL.user_id,
1732: sysdate,
1733: FND_GLOBAL.user_id,
1734: FND_GLOBAL.login_id,
1735: p_request_id,
1736: l_dff_notes,
1737: 1, -- 1 for request log, 2 for approver log
1738: null

Line 1766: FND_GLOBAL.user_id,

1762: )
1763: VALUES(
1764: l_work_request_note_id,
1765: sysdate,
1766: FND_GLOBAL.user_id,
1767: sysdate,
1768: FND_GLOBAL.user_id,
1769: FND_GLOBAL.login_id,
1770: p_request_id,

Line 1768: FND_GLOBAL.user_id,

1764: l_work_request_note_id,
1765: sysdate,
1766: FND_GLOBAL.user_id,
1767: sysdate,
1768: FND_GLOBAL.user_id,
1769: FND_GLOBAL.login_id,
1770: p_request_id,
1771: l_dff_notes,
1772: 1, -- 1 for request log, 2 for approver log

Line 1769: FND_GLOBAL.login_id,

1765: sysdate,
1766: FND_GLOBAL.user_id,
1767: sysdate,
1768: FND_GLOBAL.user_id,
1769: FND_GLOBAL.login_id,
1770: p_request_id,
1771: l_dff_notes,
1772: 1, -- 1 for request log, 2 for approver log
1773: null

Line 1801: FND_GLOBAL.user_id,

1797: )
1798: VALUES(
1799: l_work_request_note_id,
1800: sysdate,
1801: FND_GLOBAL.user_id,
1802: sysdate,
1803: FND_GLOBAL.user_id,
1804: FND_GLOBAL.login_id,
1805: p_request_id,

Line 1803: FND_GLOBAL.user_id,

1799: l_work_request_note_id,
1800: sysdate,
1801: FND_GLOBAL.user_id,
1802: sysdate,
1803: FND_GLOBAL.user_id,
1804: FND_GLOBAL.login_id,
1805: p_request_id,
1806: l_dff_notes,
1807: 1, -- 1 for request log, 2 for approver log

Line 1804: FND_GLOBAL.login_id,

1800: sysdate,
1801: FND_GLOBAL.user_id,
1802: sysdate,
1803: FND_GLOBAL.user_id,
1804: FND_GLOBAL.login_id,
1805: p_request_id,
1806: l_dff_notes,
1807: 1, -- 1 for request log, 2 for approver log
1808: null

Line 1836: FND_GLOBAL.user_id,

1832: )
1833: VALUES(
1834: l_work_request_note_id,
1835: sysdate,
1836: FND_GLOBAL.user_id,
1837: sysdate,
1838: FND_GLOBAL.user_id,
1839: FND_GLOBAL.login_id,
1840: p_request_id,

Line 1838: FND_GLOBAL.user_id,

1834: l_work_request_note_id,
1835: sysdate,
1836: FND_GLOBAL.user_id,
1837: sysdate,
1838: FND_GLOBAL.user_id,
1839: FND_GLOBAL.login_id,
1840: p_request_id,
1841: l_dff_notes,
1842: 1, -- 1 for request log, 2 for approver log

Line 1839: FND_GLOBAL.login_id,

1835: sysdate,
1836: FND_GLOBAL.user_id,
1837: sysdate,
1838: FND_GLOBAL.user_id,
1839: FND_GLOBAL.login_id,
1840: p_request_id,
1841: l_dff_notes,
1842: 1, -- 1 for request log, 2 for approver log
1843: null

Line 1871: FND_GLOBAL.user_id,

1867: )
1868: VALUES(
1869: l_work_request_note_id,
1870: sysdate,
1871: FND_GLOBAL.user_id,
1872: sysdate,
1873: FND_GLOBAL.user_id,
1874: FND_GLOBAL.login_id,
1875: p_request_id,

Line 1873: FND_GLOBAL.user_id,

1869: l_work_request_note_id,
1870: sysdate,
1871: FND_GLOBAL.user_id,
1872: sysdate,
1873: FND_GLOBAL.user_id,
1874: FND_GLOBAL.login_id,
1875: p_request_id,
1876: l_dff_notes,
1877: 1, -- 1 for request log, 2 for approver log

Line 1874: FND_GLOBAL.login_id,

1870: sysdate,
1871: FND_GLOBAL.user_id,
1872: sysdate,
1873: FND_GLOBAL.user_id,
1874: FND_GLOBAL.login_id,
1875: p_request_id,
1876: l_dff_notes,
1877: 1, -- 1 for request log, 2 for approver log
1878: null

Line 1906: FND_GLOBAL.user_id,

1902: )
1903: VALUES(
1904: l_work_request_note_id,
1905: sysdate,
1906: FND_GLOBAL.user_id,
1907: sysdate,
1908: FND_GLOBAL.user_id,
1909: FND_GLOBAL.login_id,
1910: p_request_id,

Line 1908: FND_GLOBAL.user_id,

1904: l_work_request_note_id,
1905: sysdate,
1906: FND_GLOBAL.user_id,
1907: sysdate,
1908: FND_GLOBAL.user_id,
1909: FND_GLOBAL.login_id,
1910: p_request_id,
1911: l_dff_notes,
1912: 1, -- 1 for request log, 2 for approver log

Line 1909: FND_GLOBAL.login_id,

1905: sysdate,
1906: FND_GLOBAL.user_id,
1907: sysdate,
1908: FND_GLOBAL.user_id,
1909: FND_GLOBAL.login_id,
1910: p_request_id,
1911: l_dff_notes,
1912: 1, -- 1 for request log, 2 for approver log
1913: null

Line 1941: FND_GLOBAL.user_id,

1937: )
1938: VALUES(
1939: l_work_request_note_id,
1940: sysdate,
1941: FND_GLOBAL.user_id,
1942: sysdate,
1943: FND_GLOBAL.user_id,
1944: FND_GLOBAL.login_id,
1945: p_request_id,

Line 1943: FND_GLOBAL.user_id,

1939: l_work_request_note_id,
1940: sysdate,
1941: FND_GLOBAL.user_id,
1942: sysdate,
1943: FND_GLOBAL.user_id,
1944: FND_GLOBAL.login_id,
1945: p_request_id,
1946: l_dff_notes,
1947: 1, -- 1 for request log, 2 for approver log

Line 1944: FND_GLOBAL.login_id,

1940: sysdate,
1941: FND_GLOBAL.user_id,
1942: sysdate,
1943: FND_GLOBAL.user_id,
1944: FND_GLOBAL.login_id,
1945: p_request_id,
1946: l_dff_notes,
1947: 1, -- 1 for request log, 2 for approver log
1948: null

Line 1976: FND_GLOBAL.user_id,

1972: )
1973: VALUES(
1974: l_work_request_note_id,
1975: sysdate,
1976: FND_GLOBAL.user_id,
1977: sysdate,
1978: FND_GLOBAL.user_id,
1979: FND_GLOBAL.login_id,
1980: p_request_id,

Line 1978: FND_GLOBAL.user_id,

1974: l_work_request_note_id,
1975: sysdate,
1976: FND_GLOBAL.user_id,
1977: sysdate,
1978: FND_GLOBAL.user_id,
1979: FND_GLOBAL.login_id,
1980: p_request_id,
1981: l_dff_notes,
1982: 1, -- 1 for request log, 2 for approver log

Line 1979: FND_GLOBAL.login_id,

1975: sysdate,
1976: FND_GLOBAL.user_id,
1977: sysdate,
1978: FND_GLOBAL.user_id,
1979: FND_GLOBAL.login_id,
1980: p_request_id,
1981: l_dff_notes,
1982: 1, -- 1 for request log, 2 for approver log
1983: null

Line 2011: FND_GLOBAL.user_id,

2007: )
2008: VALUES(
2009: l_work_request_note_id,
2010: sysdate,
2011: FND_GLOBAL.user_id,
2012: sysdate,
2013: FND_GLOBAL.user_id,
2014: FND_GLOBAL.login_id,
2015: p_request_id,

Line 2013: FND_GLOBAL.user_id,

2009: l_work_request_note_id,
2010: sysdate,
2011: FND_GLOBAL.user_id,
2012: sysdate,
2013: FND_GLOBAL.user_id,
2014: FND_GLOBAL.login_id,
2015: p_request_id,
2016: l_dff_notes,
2017: 1, -- 1 for request log, 2 for approver log

Line 2014: FND_GLOBAL.login_id,

2010: sysdate,
2011: FND_GLOBAL.user_id,
2012: sysdate,
2013: FND_GLOBAL.user_id,
2014: FND_GLOBAL.login_id,
2015: p_request_id,
2016: l_dff_notes,
2017: 1, -- 1 for request log, 2 for approver log
2018: null

Line 2046: FND_GLOBAL.user_id,

2042: )
2043: VALUES(
2044: l_work_request_note_id,
2045: sysdate,
2046: FND_GLOBAL.user_id,
2047: sysdate,
2048: FND_GLOBAL.user_id,
2049: FND_GLOBAL.login_id,
2050: p_request_id,

Line 2048: FND_GLOBAL.user_id,

2044: l_work_request_note_id,
2045: sysdate,
2046: FND_GLOBAL.user_id,
2047: sysdate,
2048: FND_GLOBAL.user_id,
2049: FND_GLOBAL.login_id,
2050: p_request_id,
2051: l_dff_notes,
2052: 1, -- 1 for request log, 2 for approver log

Line 2049: FND_GLOBAL.login_id,

2045: sysdate,
2046: FND_GLOBAL.user_id,
2047: sysdate,
2048: FND_GLOBAL.user_id,
2049: FND_GLOBAL.login_id,
2050: p_request_id,
2051: l_dff_notes,
2052: 1, -- 1 for request log, 2 for approver log
2053: null

Line 2081: FND_GLOBAL.user_id,

2077: )
2078: VALUES(
2079: l_work_request_note_id,
2080: sysdate,
2081: FND_GLOBAL.user_id,
2082: sysdate,
2083: FND_GLOBAL.user_id,
2084: FND_GLOBAL.login_id,
2085: p_request_id,

Line 2083: FND_GLOBAL.user_id,

2079: l_work_request_note_id,
2080: sysdate,
2081: FND_GLOBAL.user_id,
2082: sysdate,
2083: FND_GLOBAL.user_id,
2084: FND_GLOBAL.login_id,
2085: p_request_id,
2086: l_dff_notes,
2087: 1, -- 1 for request log, 2 for approver log

Line 2084: FND_GLOBAL.login_id,

2080: sysdate,
2081: FND_GLOBAL.user_id,
2082: sysdate,
2083: FND_GLOBAL.user_id,
2084: FND_GLOBAL.login_id,
2085: p_request_id,
2086: l_dff_notes,
2087: 1, -- 1 for request log, 2 for approver log
2088: null

Line 2116: FND_GLOBAL.user_id,

2112: )
2113: VALUES(
2114: l_work_request_note_id,
2115: sysdate,
2116: FND_GLOBAL.user_id,
2117: sysdate,
2118: FND_GLOBAL.user_id,
2119: FND_GLOBAL.login_id,
2120: p_request_id,

Line 2118: FND_GLOBAL.user_id,

2114: l_work_request_note_id,
2115: sysdate,
2116: FND_GLOBAL.user_id,
2117: sysdate,
2118: FND_GLOBAL.user_id,
2119: FND_GLOBAL.login_id,
2120: p_request_id,
2121: l_dff_notes,
2122: 1, -- 1 for request log, 2 for approver log

Line 2119: FND_GLOBAL.login_id,

2115: sysdate,
2116: FND_GLOBAL.user_id,
2117: sysdate,
2118: FND_GLOBAL.user_id,
2119: FND_GLOBAL.login_id,
2120: p_request_id,
2121: l_dff_notes,
2122: 1, -- 1 for request log, 2 for approver log
2123: null

Line 2151: FND_GLOBAL.user_id,

2147: )
2148: VALUES(
2149: l_work_request_note_id,
2150: sysdate,
2151: FND_GLOBAL.user_id,
2152: sysdate,
2153: FND_GLOBAL.user_id,
2154: FND_GLOBAL.login_id,
2155: p_request_id,

Line 2153: FND_GLOBAL.user_id,

2149: l_work_request_note_id,
2150: sysdate,
2151: FND_GLOBAL.user_id,
2152: sysdate,
2153: FND_GLOBAL.user_id,
2154: FND_GLOBAL.login_id,
2155: p_request_id,
2156: l_dff_notes,
2157: 1, -- 1 for request log, 2 for approver log

Line 2154: FND_GLOBAL.login_id,

2150: sysdate,
2151: FND_GLOBAL.user_id,
2152: sysdate,
2153: FND_GLOBAL.user_id,
2154: FND_GLOBAL.login_id,
2155: p_request_id,
2156: l_dff_notes,
2157: 1, -- 1 for request log, 2 for approver log
2158: null

Line 2186: FND_GLOBAL.user_id,

2182: )
2183: VALUES(
2184: l_work_request_note_id,
2185: sysdate,
2186: FND_GLOBAL.user_id,
2187: sysdate,
2188: FND_GLOBAL.user_id,
2189: FND_GLOBAL.login_id,
2190: p_request_id,

Line 2188: FND_GLOBAL.user_id,

2184: l_work_request_note_id,
2185: sysdate,
2186: FND_GLOBAL.user_id,
2187: sysdate,
2188: FND_GLOBAL.user_id,
2189: FND_GLOBAL.login_id,
2190: p_request_id,
2191: l_dff_notes,
2192: 1, -- 1 for request log, 2 for approver log

Line 2189: FND_GLOBAL.login_id,

2185: sysdate,
2186: FND_GLOBAL.user_id,
2187: sysdate,
2188: FND_GLOBAL.user_id,
2189: FND_GLOBAL.login_id,
2190: p_request_id,
2191: l_dff_notes,
2192: 1, -- 1 for request log, 2 for approver log
2193: null

Line 2238: FND_GLOBAL.user_id,

2234: )
2235: VALUES(
2236: l_work_request_note_id,
2237: sysdate,
2238: FND_GLOBAL.user_id,
2239: sysdate,
2240: FND_GLOBAL.user_id,
2241: FND_GLOBAL.login_id,
2242: p_request_id,

Line 2240: FND_GLOBAL.user_id,

2236: l_work_request_note_id,
2237: sysdate,
2238: FND_GLOBAL.user_id,
2239: sysdate,
2240: FND_GLOBAL.user_id,
2241: FND_GLOBAL.login_id,
2242: p_request_id,
2243: p_request_log,
2244: 1, -- 1 for request log, 2 for approver log

Line 2241: FND_GLOBAL.login_id,

2237: sysdate,
2238: FND_GLOBAL.user_id,
2239: sysdate,
2240: FND_GLOBAL.user_id,
2241: FND_GLOBAL.login_id,
2242: p_request_id,
2243: p_request_log,
2244: 1, -- 1 for request log, 2 for approver log
2245: null