[Home] [Help]
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;
116: l_stmt_num := 60;
117: BEGIN
118: select NVL(work_request_auto_approve,'N')
324:
325: SELECT '*** '||l_user_name||' ('
326: ||to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS')||') *** '
327: INTO l_standard_log
328: FROM DUAL;
329: l_stmt_num := 100;
330: SELECT wip_eam_work_req_notes_s.nextval
331: INTO l_work_request_note_id
332: FROM dual;
328: FROM DUAL;
329: l_stmt_num := 100;
330: SELECT wip_eam_work_req_notes_s.nextval
331: INTO l_work_request_note_id
332: FROM dual;
333: l_stmt_num := 110;
334: INSERT INTO wip_eam_work_req_notes(
335: work_request_note_id,
336: last_update_date,
358: l_stmt_num := 120;
359: IF p_request_log is not null then
360: l_stmt_num := 130;
361: SELECT wip_eam_work_req_notes_s.nextval
362: INTO l_work_request_note_id FROM DUAL;
363: l_stmt_num := 90;
364: INSERT INTO wip_eam_work_req_notes(
365: work_request_note_id,
366: last_update_date,
881:
882: SELECT '*** '||l_user_name||' ('
883: ||to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS')||') *** '
884: INTO l_standard_log
885: FROM DUAL;
886: l_another_log := l_standard_log;
887: l_stmt_num := 60;
888:
889: SELECT wip_eam_work_req_notes_s.nextval
887: l_stmt_num := 60;
888:
889: SELECT wip_eam_work_req_notes_s.nextval
890: INTO l_work_request_note_id
891: FROM dual;
892: l_stmt_num := 70;
893: INSERT INTO wip_eam_work_req_notes(
894: work_request_note_id,
895: last_update_date,
1012:
1013: IF (isdifferent_number(l_old_asset_group_id, l_new_asset_group_id) = 1) THEN
1014: SELECT wip_eam_work_req_notes_s.nextval
1015: INTO l_work_request_note_id
1016: FROM dual;
1017: IF (l_old_asset_group_id IS NOT NULL) THEN
1018: BEGIN
1019: SELECT concatenated_segments INTO l_old_data
1020: FROM mtl_system_items_b_kfv
1068: );
1069: END IF;
1070: SELECT wip_eam_work_req_notes_s.nextval
1071: INTO l_work_request_note_id
1072: FROM dual;
1073: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_ASSET_NUMBER_PROMPT');
1074:
1075: INSERT INTO wip_eam_work_req_notes(
1076: work_request_note_id,
1101: IF (isdifferent_number(l_old_priority_id,l_new_priority_id) = 1) THEN
1102: l_stmt_num := 150;
1103: SELECT wip_eam_work_req_notes_s.nextval
1104: INTO l_work_request_note_id
1105: FROM dual;
1106: l_stmt_num := 160;
1107: BEGIN
1108: SELECT meaning
1109: INTO l_old_data
1158: IF (isdifferent_number(l_old_work_request_type_id,l_new_work_request_type_id) = 1) THEN
1159: l_stmt_num := 150;
1160: SELECT wip_eam_work_req_notes_s.nextval
1161: INTO l_work_request_note_id
1162: FROM DUAL;
1163: l_stmt_num := 184;
1164: BEGIN
1165: SELECT meaning
1166: INTO l_old_data
1214: IF (isdifferent_number(l_old_status_id, l_new_status_id) = 1) THEN
1215: l_stmt_num := 190;
1216: SELECT wip_eam_work_req_notes_s.nextval
1217: INTO l_work_request_note_id
1218: FROM DUAL;
1219: l_stmt_num := 200;
1220: BEGIN
1221: SELECT meaning
1222: INTO l_old_data
1270: IF (isdifferent_number(l_old_owning_dept_id, l_new_owning_dept_id) = 1) THEN
1271: l_stmt_num := 230;
1272: SELECT wip_eam_work_req_notes_s.nextval
1273: INTO l_work_request_note_id
1274: FROM dual;
1275: l_stmt_num := 240;
1276: BEGIN
1277: SELECT department_code
1278: INTO l_old_data
1327: FND_MESSAGE.SET_NAME ('WIP','WIP_EAM_REQ_BY_DATE_PROMPT');
1328: l_stmt_num := 270;
1329: SELECT wip_eam_work_req_notes_s.nextval
1330: INTO l_work_request_note_id
1331: FROM DUAL;
1332: -- To display server time zone code.
1333: SELECT fnd_profile.value('SERVER_TIMEZONE_ID') INTO l_timezone_id FROM DUAL;
1334: l_timezone_code := null;
1335: IF (l_timezone_id is not null) THEN
1329: SELECT wip_eam_work_req_notes_s.nextval
1330: INTO l_work_request_note_id
1331: FROM DUAL;
1332: -- To display server time zone code.
1333: SELECT fnd_profile.value('SERVER_TIMEZONE_ID') INTO l_timezone_id FROM DUAL;
1334: l_timezone_code := null;
1335: IF (l_timezone_id is not null) THEN
1336: SELECT timezone_code INTO l_timezone_code FROM fnd_timezones_vl WHERE upgrade_tz_id = l_timezone_id;
1337: IF (l_timezone_code IS NOT null) THEN
1370: IF (isdifferent_number(l_old_created_for, l_new_created_for) = 1) THEN
1371: l_stmt_num := 150;
1372: SELECT wip_eam_work_req_notes_s.nextval
1373: INTO l_work_request_note_id
1374: FROM DUAL;
1375: l_stmt_num := 184;
1376: BEGIN
1377: SELECT user_name
1378: INTO l_old_data
1421:
1422: IF (isdifferent(l_old_email, l_new_email) = 1) THEN
1423: SELECT wip_eam_work_req_notes_s.nextval
1424: INTO l_work_request_note_id
1425: FROM DUAL;
1426: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_EMAIL_PROMPT');
1427: INSERT INTO wip_eam_work_req_notes(
1428: work_request_note_id,
1429: last_update_date,
1452:
1453: IF (isdifferent(l_old_phone_number, l_new_phone_number) = 1) THEN
1454: SELECT wip_eam_work_req_notes_s.nextval
1455: INTO l_work_request_note_id
1456: FROM DUAL;
1457: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_PHONE_NUMBER_PROMPT');
1458: INSERT INTO wip_eam_work_req_notes(
1459: work_request_note_id,
1460: last_update_date,
1483:
1484: IF (isdifferent_number(l_new_notify_originator, l_old_notify_originator) = 1) THEN
1485: SELECT wip_eam_work_req_notes_s.nextval
1486: INTO l_work_request_note_id
1487: FROM DUAL;
1488: BEGIN
1489: SELECT meaning
1490: INTO l_old_data
1491: FROM MFG_LOOKUPS
1534:
1535: IF (isdifferent_number(l_new_contact_preference,l_old_contact_preference) = 1) THEN
1536: SELECT wip_eam_work_req_notes_s.nextval
1537: INTO l_work_request_note_id
1538: FROM DUAL;
1539: BEGIN
1540: SELECT meaning
1541: INTO l_old_data
1542: FROM MFG_LOOKUPS
1585:
1586: IF (isdifferent(l_new_attribute_category,l_old_attribute_category) = 1) THEN
1587: SELECT wip_eam_work_req_notes_s.nextval
1588: INTO l_work_request_note_id
1589: FROM DUAL;
1590: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_CONTEXT_VALUE_PROMPT');
1591: INSERT INTO wip_eam_work_req_notes(
1592: work_request_note_id,
1593: last_update_date,
1620: IF (l_dffprompt IS NOT NULL) THEN
1621: l_dff_notes := get_dff_notes(l_new_attribute1,l_old_attribute1,l_dffprompt,l_null);
1622: SELECT wip_eam_work_req_notes_s.nextval
1623: INTO l_work_request_note_id
1624: FROM DUAL;
1625: INSERT INTO wip_eam_work_req_notes(
1626: work_request_note_id,
1627: last_update_date,
1628: last_updated_by,
1655: IF (l_dffprompt IS NOT NULL) THEN
1656: l_dff_notes := get_dff_notes(l_new_attribute2,l_old_attribute2,l_dffprompt,l_null);
1657: SELECT wip_eam_work_req_notes_s.nextval
1658: INTO l_work_request_note_id
1659: FROM DUAL;
1660: INSERT INTO wip_eam_work_req_notes(
1661: work_request_note_id,
1662: last_update_date,
1663: last_updated_by,
1690: IF (l_dffprompt IS NOT NULL) THEN
1691: l_dff_notes := get_dff_notes(l_new_attribute3,l_old_attribute3,l_dffprompt,l_null);
1692: SELECT wip_eam_work_req_notes_s.nextval
1693: INTO l_work_request_note_id
1694: FROM DUAL;
1695: INSERT INTO wip_eam_work_req_notes(
1696: work_request_note_id,
1697: last_update_date,
1698: last_updated_by,
1725: IF (l_dffprompt IS NOT NULL) THEN
1726: l_dff_notes := get_dff_notes(l_new_attribute3,l_old_attribute3,l_dffprompt,l_null);
1727: SELECT wip_eam_work_req_notes_s.nextval
1728: INTO l_work_request_note_id
1729: FROM DUAL;
1730: INSERT INTO wip_eam_work_req_notes(
1731: work_request_note_id,
1732: last_update_date,
1733: last_updated_by,
1760: IF (l_dffprompt IS NOT NULL) THEN
1761: l_dff_notes := get_dff_notes(l_new_attribute4,l_old_attribute4,l_dffprompt,l_null);
1762: SELECT wip_eam_work_req_notes_s.nextval
1763: INTO l_work_request_note_id
1764: FROM DUAL;
1765: INSERT INTO wip_eam_work_req_notes(
1766: work_request_note_id,
1767: last_update_date,
1768: last_updated_by,
1795: IF (l_dffprompt IS NOT NULL) THEN
1796: l_dff_notes := get_dff_notes(l_new_attribute5,l_old_attribute5,l_dffprompt,l_null);
1797: SELECT wip_eam_work_req_notes_s.nextval
1798: INTO l_work_request_note_id
1799: FROM DUAL;
1800: INSERT INTO wip_eam_work_req_notes(
1801: work_request_note_id,
1802: last_update_date,
1803: last_updated_by,
1830: IF (l_dffprompt IS NOT NULL) THEN
1831: l_dff_notes := get_dff_notes(l_new_attribute6,l_old_attribute6,l_dffprompt,l_null);
1832: SELECT wip_eam_work_req_notes_s.nextval
1833: INTO l_work_request_note_id
1834: FROM DUAL;
1835: INSERT INTO wip_eam_work_req_notes(
1836: work_request_note_id,
1837: last_update_date,
1838: last_updated_by,
1865: IF (l_dffprompt IS NOT NULL) THEN
1866: l_dff_notes := get_dff_notes(l_new_attribute7,l_old_attribute7,l_dffprompt,l_null);
1867: SELECT wip_eam_work_req_notes_s.nextval
1868: INTO l_work_request_note_id
1869: FROM DUAL;
1870: INSERT INTO wip_eam_work_req_notes(
1871: work_request_note_id,
1872: last_update_date,
1873: last_updated_by,
1900: IF (l_dffprompt IS NOT NULL) THEN
1901: l_dff_notes := get_dff_notes(l_new_attribute8,l_old_attribute8,l_dffprompt,l_null);
1902: SELECT wip_eam_work_req_notes_s.nextval
1903: INTO l_work_request_note_id
1904: FROM DUAL;
1905: INSERT INTO wip_eam_work_req_notes(
1906: work_request_note_id,
1907: last_update_date,
1908: last_updated_by,
1935: IF (l_dffprompt IS NOT NULL) THEN
1936: l_dff_notes := get_dff_notes(l_new_attribute9,l_old_attribute9,l_dffprompt,l_null);
1937: SELECT wip_eam_work_req_notes_s.nextval
1938: INTO l_work_request_note_id
1939: FROM DUAL;
1940: INSERT INTO wip_eam_work_req_notes(
1941: work_request_note_id,
1942: last_update_date,
1943: last_updated_by,
1970: IF (l_dffprompt IS NOT NULL) THEN
1971: l_dff_notes := get_dff_notes(l_new_attribute10,l_old_attribute10,l_dffprompt,l_null);
1972: SELECT wip_eam_work_req_notes_s.nextval
1973: INTO l_work_request_note_id
1974: FROM DUAL;
1975: INSERT INTO wip_eam_work_req_notes(
1976: work_request_note_id,
1977: last_update_date,
1978: last_updated_by,
2005: IF (l_dffprompt IS NOT NULL) THEN
2006: l_dff_notes := get_dff_notes(l_new_attribute11,l_old_attribute11,l_dffprompt,l_null);
2007: SELECT wip_eam_work_req_notes_s.nextval
2008: INTO l_work_request_note_id
2009: FROM DUAL;
2010: INSERT INTO wip_eam_work_req_notes(
2011: work_request_note_id,
2012: last_update_date,
2013: last_updated_by,
2040: IF (l_dffprompt IS NOT NULL) THEN
2041: l_dff_notes := get_dff_notes(l_new_attribute12,l_old_attribute12,l_dffprompt,l_null);
2042: SELECT wip_eam_work_req_notes_s.nextval
2043: INTO l_work_request_note_id
2044: FROM DUAL;
2045: INSERT INTO wip_eam_work_req_notes(
2046: work_request_note_id,
2047: last_update_date,
2048: last_updated_by,
2075: IF (l_dffprompt IS NOT NULL) THEN
2076: l_dff_notes := get_dff_notes(l_new_attribute13,l_old_attribute13,l_dffprompt,l_null);
2077: SELECT wip_eam_work_req_notes_s.nextval
2078: INTO l_work_request_note_id
2079: FROM DUAL;
2080: INSERT INTO wip_eam_work_req_notes(
2081: work_request_note_id,
2082: last_update_date,
2083: last_updated_by,
2110: IF (l_dffprompt IS NOT NULL) THEN
2111: l_dff_notes := get_dff_notes(l_new_attribute14,l_old_attribute14,l_dffprompt,l_null);
2112: SELECT wip_eam_work_req_notes_s.nextval
2113: INTO l_work_request_note_id
2114: FROM DUAL;
2115: INSERT INTO wip_eam_work_req_notes(
2116: work_request_note_id,
2117: last_update_date,
2118: last_updated_by,
2145: IF (l_dffprompt IS NOT NULL) THEN
2146: l_dff_notes := get_dff_notes(l_new_attribute15,l_old_attribute15,l_dffprompt,l_null);
2147: SELECT wip_eam_work_req_notes_s.nextval
2148: INTO l_work_request_note_id
2149: FROM DUAL;
2150: INSERT INTO wip_eam_work_req_notes(
2151: work_request_note_id,
2152: last_update_date,
2153: last_updated_by,
2196: -- end check
2197: l_stmt_num := 310;
2198: SELECT wip_eam_work_req_notes_s.nextval
2199: INTO l_work_request_note_id
2200: FROM dual;
2201: l_stmt_num := 320;
2202: INSERT INTO wip_eam_work_req_notes(
2203: work_request_note_id,
2204: last_update_date,