[Home] [Help]
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;
115: l_stmt_num := 60;
116: BEGIN
117: select NVL(work_request_auto_approve,'N')
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;
318: SELECT wip_eam_work_req_notes_s.nextval
319: INTO l_work_request_note_id
320: FROM dual;
316: FROM DUAL;
317: l_stmt_num := 100;
318: SELECT wip_eam_work_req_notes_s.nextval
319: INTO l_work_request_note_id
320: FROM dual;
321: l_stmt_num := 110;
322: INSERT INTO wip_eam_work_req_notes(
323: work_request_note_id,
324: last_update_date,
346: l_stmt_num := 120;
347: IF p_request_log is not null then
348: l_stmt_num := 130;
349: SELECT wip_eam_work_req_notes_s.nextval
350: INTO l_work_request_note_id FROM DUAL;
351: l_stmt_num := 90;
352: INSERT INTO wip_eam_work_req_notes(
353: work_request_note_id,
354: last_update_date,
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;
859: l_stmt_num := 60;
860:
861: SELECT wip_eam_work_req_notes_s.nextval
859: l_stmt_num := 60;
860:
861: SELECT wip_eam_work_req_notes_s.nextval
862: INTO l_work_request_note_id
863: FROM dual;
864: l_stmt_num := 70;
865: INSERT INTO wip_eam_work_req_notes(
866: work_request_note_id,
867: last_update_date,
1039:
1040: IF (isdifferent_number(l_old_asset_group_id, l_new_asset_group_id) = 1) THEN
1041: SELECT wip_eam_work_req_notes_s.nextval
1042: INTO l_work_request_note_id
1043: FROM dual;
1044: IF (l_old_asset_group_id IS NOT NULL) THEN
1045: BEGIN
1046: SELECT concatenated_segments INTO l_old_data
1047: FROM mtl_system_items_b_kfv
1095: END IF;
1096:
1097: SELECT wip_eam_work_req_notes_s.nextval
1098: INTO l_work_request_note_id
1099: FROM dual;
1100: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_ASSET_NUMBER_PROMPT');
1101: INSERT INTO wip_eam_work_req_notes(
1102: work_request_note_id,
1103: last_update_date,
1127: IF (isdifferent_number(l_old_priority_id,l_new_priority_id) = 1) THEN
1128: l_stmt_num := 150;
1129: SELECT wip_eam_work_req_notes_s.nextval
1130: INTO l_work_request_note_id
1131: FROM dual;
1132: l_stmt_num := 160;
1133: BEGIN
1134: SELECT meaning
1135: INTO l_old_data
1183: IF (isdifferent_number(l_old_work_request_type_id,l_new_work_request_type_id) = 1) THEN
1184: l_stmt_num := 150;
1185: SELECT wip_eam_work_req_notes_s.nextval
1186: INTO l_work_request_note_id
1187: FROM DUAL;
1188: l_stmt_num := 184;
1189: BEGIN
1190: SELECT meaning
1191: INTO l_old_data
1238: IF (isdifferent_number(l_old_status_id, l_new_status_id) = 1) THEN
1239: l_stmt_num := 190;
1240: SELECT wip_eam_work_req_notes_s.nextval
1241: INTO l_work_request_note_id
1242: FROM DUAL;
1243: l_stmt_num := 200;
1244: BEGIN
1245: SELECT meaning
1246: INTO l_old_data
1293: IF (isdifferent_number(l_old_owning_dept_id, l_new_owning_dept_id) = 1) THEN
1294: l_stmt_num := 230;
1295: SELECT wip_eam_work_req_notes_s.nextval
1296: INTO l_work_request_note_id
1297: FROM dual;
1298: l_stmt_num := 240;
1299: BEGIN
1300: SELECT department_code
1301: INTO l_old_data
1349: FND_MESSAGE.SET_NAME ('WIP','WIP_EAM_REQ_BY_DATE_PROMPT');
1350: l_stmt_num := 270;
1351: SELECT wip_eam_work_req_notes_s.nextval
1352: INTO l_work_request_note_id
1353: FROM DUAL;
1354: -- To display server time zone code.
1355: SELECT fnd_profile.value('SERVER_TIMEZONE_ID') INTO l_timezone_id FROM DUAL;
1356: l_timezone_code := null;
1357: IF (l_timezone_id is not null) THEN
1351: SELECT wip_eam_work_req_notes_s.nextval
1352: INTO l_work_request_note_id
1353: FROM DUAL;
1354: -- To display server time zone code.
1355: SELECT fnd_profile.value('SERVER_TIMEZONE_ID') INTO l_timezone_id FROM DUAL;
1356: l_timezone_code := null;
1357: IF (l_timezone_id is not null) THEN
1358: SELECT timezone_code INTO l_timezone_code FROM fnd_timezones_vl WHERE upgrade_tz_id = l_timezone_id;
1359: IF (l_timezone_code IS NOT null) THEN
1392: IF (isdifferent_number(l_old_created_for, l_new_created_for) = 1) THEN
1393: l_stmt_num := 150;
1394: SELECT wip_eam_work_req_notes_s.nextval
1395: INTO l_work_request_note_id
1396: FROM DUAL;
1397: l_stmt_num := 184;
1398: BEGIN
1399: SELECT user_name
1400: INTO l_old_data
1442:
1443: IF (isdifferent(l_old_email, l_new_email) = 1) THEN
1444: SELECT wip_eam_work_req_notes_s.nextval
1445: INTO l_work_request_note_id
1446: FROM DUAL;
1447: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_EMAIL_PROMPT');
1448: INSERT INTO wip_eam_work_req_notes(
1449: work_request_note_id,
1450: last_update_date,
1473:
1474: IF (isdifferent(l_old_phone_number, l_new_phone_number) = 1) THEN
1475: SELECT wip_eam_work_req_notes_s.nextval
1476: INTO l_work_request_note_id
1477: FROM DUAL;
1478: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_PHONE_NUMBER_PROMPT');
1479: INSERT INTO wip_eam_work_req_notes(
1480: work_request_note_id,
1481: last_update_date,
1504:
1505: IF (isdifferent_number(l_new_notify_originator, l_old_notify_originator) = 1) THEN
1506: SELECT wip_eam_work_req_notes_s.nextval
1507: INTO l_work_request_note_id
1508: FROM DUAL;
1509: BEGIN
1510: SELECT meaning
1511: INTO l_old_data
1512: FROM MFG_LOOKUPS
1555:
1556: IF (isdifferent_number(l_new_contact_preference,l_old_contact_preference) = 1) THEN
1557: SELECT wip_eam_work_req_notes_s.nextval
1558: INTO l_work_request_note_id
1559: FROM DUAL;
1560: BEGIN
1561: SELECT meaning
1562: INTO l_old_data
1563: FROM MFG_LOOKUPS
1606:
1607: IF (isdifferent(l_new_attribute_category,l_old_attribute_category) = 1) THEN
1608: SELECT wip_eam_work_req_notes_s.nextval
1609: INTO l_work_request_note_id
1610: FROM DUAL;
1611: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_CONTEXT_VALUE_PROMPT');
1612: INSERT INTO wip_eam_work_req_notes(
1613: work_request_note_id,
1614: last_update_date,
1641: IF (l_dffprompt IS NOT NULL) THEN
1642: l_dff_notes := get_dff_notes(l_new_attribute1,l_old_attribute1,l_dffprompt,l_null);
1643: SELECT wip_eam_work_req_notes_s.nextval
1644: INTO l_work_request_note_id
1645: FROM DUAL;
1646: INSERT INTO wip_eam_work_req_notes(
1647: work_request_note_id,
1648: last_update_date,
1649: last_updated_by,
1676: IF (l_dffprompt IS NOT NULL) THEN
1677: l_dff_notes := get_dff_notes(l_new_attribute2,l_old_attribute2,l_dffprompt,l_null);
1678: SELECT wip_eam_work_req_notes_s.nextval
1679: INTO l_work_request_note_id
1680: FROM DUAL;
1681: INSERT INTO wip_eam_work_req_notes(
1682: work_request_note_id,
1683: last_update_date,
1684: last_updated_by,
1711: IF (l_dffprompt IS NOT NULL) THEN
1712: l_dff_notes := get_dff_notes(l_new_attribute3,l_old_attribute3,l_dffprompt,l_null);
1713: SELECT wip_eam_work_req_notes_s.nextval
1714: INTO l_work_request_note_id
1715: FROM DUAL;
1716: INSERT INTO wip_eam_work_req_notes(
1717: work_request_note_id,
1718: last_update_date,
1719: last_updated_by,
1746: IF (l_dffprompt IS NOT NULL) THEN
1747: l_dff_notes := get_dff_notes(l_new_attribute3,l_old_attribute3,l_dffprompt,l_null);
1748: SELECT wip_eam_work_req_notes_s.nextval
1749: INTO l_work_request_note_id
1750: FROM DUAL;
1751: INSERT INTO wip_eam_work_req_notes(
1752: work_request_note_id,
1753: last_update_date,
1754: last_updated_by,
1781: IF (l_dffprompt IS NOT NULL) THEN
1782: l_dff_notes := get_dff_notes(l_new_attribute4,l_old_attribute4,l_dffprompt,l_null);
1783: SELECT wip_eam_work_req_notes_s.nextval
1784: INTO l_work_request_note_id
1785: FROM DUAL;
1786: INSERT INTO wip_eam_work_req_notes(
1787: work_request_note_id,
1788: last_update_date,
1789: last_updated_by,
1816: IF (l_dffprompt IS NOT NULL) THEN
1817: l_dff_notes := get_dff_notes(l_new_attribute5,l_old_attribute5,l_dffprompt,l_null);
1818: SELECT wip_eam_work_req_notes_s.nextval
1819: INTO l_work_request_note_id
1820: FROM DUAL;
1821: INSERT INTO wip_eam_work_req_notes(
1822: work_request_note_id,
1823: last_update_date,
1824: last_updated_by,
1851: IF (l_dffprompt IS NOT NULL) THEN
1852: l_dff_notes := get_dff_notes(l_new_attribute6,l_old_attribute6,l_dffprompt,l_null);
1853: SELECT wip_eam_work_req_notes_s.nextval
1854: INTO l_work_request_note_id
1855: FROM DUAL;
1856: INSERT INTO wip_eam_work_req_notes(
1857: work_request_note_id,
1858: last_update_date,
1859: last_updated_by,
1886: IF (l_dffprompt IS NOT NULL) THEN
1887: l_dff_notes := get_dff_notes(l_new_attribute7,l_old_attribute7,l_dffprompt,l_null);
1888: SELECT wip_eam_work_req_notes_s.nextval
1889: INTO l_work_request_note_id
1890: FROM DUAL;
1891: INSERT INTO wip_eam_work_req_notes(
1892: work_request_note_id,
1893: last_update_date,
1894: last_updated_by,
1921: IF (l_dffprompt IS NOT NULL) THEN
1922: l_dff_notes := get_dff_notes(l_new_attribute8,l_old_attribute8,l_dffprompt,l_null);
1923: SELECT wip_eam_work_req_notes_s.nextval
1924: INTO l_work_request_note_id
1925: FROM DUAL;
1926: INSERT INTO wip_eam_work_req_notes(
1927: work_request_note_id,
1928: last_update_date,
1929: last_updated_by,
1956: IF (l_dffprompt IS NOT NULL) THEN
1957: l_dff_notes := get_dff_notes(l_new_attribute9,l_old_attribute9,l_dffprompt,l_null);
1958: SELECT wip_eam_work_req_notes_s.nextval
1959: INTO l_work_request_note_id
1960: FROM DUAL;
1961: INSERT INTO wip_eam_work_req_notes(
1962: work_request_note_id,
1963: last_update_date,
1964: last_updated_by,
1991: IF (l_dffprompt IS NOT NULL) THEN
1992: l_dff_notes := get_dff_notes(l_new_attribute10,l_old_attribute10,l_dffprompt,l_null);
1993: SELECT wip_eam_work_req_notes_s.nextval
1994: INTO l_work_request_note_id
1995: FROM DUAL;
1996: INSERT INTO wip_eam_work_req_notes(
1997: work_request_note_id,
1998: last_update_date,
1999: last_updated_by,
2026: IF (l_dffprompt IS NOT NULL) THEN
2027: l_dff_notes := get_dff_notes(l_new_attribute11,l_old_attribute11,l_dffprompt,l_null);
2028: SELECT wip_eam_work_req_notes_s.nextval
2029: INTO l_work_request_note_id
2030: FROM DUAL;
2031: INSERT INTO wip_eam_work_req_notes(
2032: work_request_note_id,
2033: last_update_date,
2034: last_updated_by,
2061: IF (l_dffprompt IS NOT NULL) THEN
2062: l_dff_notes := get_dff_notes(l_new_attribute12,l_old_attribute12,l_dffprompt,l_null);
2063: SELECT wip_eam_work_req_notes_s.nextval
2064: INTO l_work_request_note_id
2065: FROM DUAL;
2066: INSERT INTO wip_eam_work_req_notes(
2067: work_request_note_id,
2068: last_update_date,
2069: last_updated_by,
2096: IF (l_dffprompt IS NOT NULL) THEN
2097: l_dff_notes := get_dff_notes(l_new_attribute13,l_old_attribute13,l_dffprompt,l_null);
2098: SELECT wip_eam_work_req_notes_s.nextval
2099: INTO l_work_request_note_id
2100: FROM DUAL;
2101: INSERT INTO wip_eam_work_req_notes(
2102: work_request_note_id,
2103: last_update_date,
2104: last_updated_by,
2131: IF (l_dffprompt IS NOT NULL) THEN
2132: l_dff_notes := get_dff_notes(l_new_attribute14,l_old_attribute14,l_dffprompt,l_null);
2133: SELECT wip_eam_work_req_notes_s.nextval
2134: INTO l_work_request_note_id
2135: FROM DUAL;
2136: INSERT INTO wip_eam_work_req_notes(
2137: work_request_note_id,
2138: last_update_date,
2139: last_updated_by,
2166: IF (l_dffprompt IS NOT NULL) THEN
2167: l_dff_notes := get_dff_notes(l_new_attribute15,l_old_attribute15,l_dffprompt,l_null);
2168: SELECT wip_eam_work_req_notes_s.nextval
2169: INTO l_work_request_note_id
2170: FROM DUAL;
2171: INSERT INTO wip_eam_work_req_notes(
2172: work_request_note_id,
2173: last_update_date,
2174: last_updated_by,
2217: -- end check
2218: l_stmt_num := 310;
2219: SELECT wip_eam_work_req_notes_s.nextval
2220: INTO l_work_request_note_id
2221: FROM dual;
2222: l_stmt_num := 320;
2223: INSERT INTO wip_eam_work_req_notes(
2224: work_request_note_id,
2225: last_update_date,