[Home] [Help]
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;
333: l_stmt_num := 110;
334: INSERT INTO wip_eam_work_req_notes(
357: );
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,
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
890: INTO l_work_request_note_id
891: FROM dual;
892: l_stmt_num := 70;
893: INSERT INTO wip_eam_work_req_notes(
1010: isdifferent_number(l_old_asset_group_id, l_new_asset_group_id) = 1) THEN
1011: l_stmt_num := 230;
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
1066: 1, -- 1 for request log, 2 for approver log
1067: null
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:
1099: END IF;
1100:
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
1156: l_stmt_num := 182;
1157:
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
1212: END IF;
1213:
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
1268: END IF;
1269:
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
1325:
1326: IF (l_old_request_by_date <> l_new_request_by_date) THEN
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;
1368: END IF;
1369:
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
1419: );
1420: END IF;
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(
1450: );
1451: END IF;
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(
1481: );
1482: END IF;
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
1532: );
1533: END IF;
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
1583: );
1584: END IF;
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(
1618: l_dffprompt := NULL;
1619: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE1',l_new_attribute_category);
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,
1653: l_dffprompt := NULL;
1654: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE2',l_new_attribute_category);
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,
1688: l_dffprompt := NULL;
1689: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE3',l_new_attribute_category);
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,
1723: l_dffprompt := NULL;
1724: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE3',l_new_attribute_category);
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,
1758: l_dffprompt := NULL;
1759: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE4',l_new_attribute_category);
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,
1793: l_dffprompt := NULL;
1794: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE5',l_new_attribute_category);
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,
1828: l_dffprompt := NULL;
1829: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE6',l_new_attribute_category);
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,
1863: l_dffprompt := NULL;
1864: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE7',l_new_attribute_category);
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,
1898: l_dffprompt := NULL;
1899: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE8',l_new_attribute_category);
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,
1933: l_dffprompt := NULL;
1934: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE9',l_new_attribute_category);
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,
1968: l_dffprompt := NULL;
1969: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE10',l_new_attribute_category);
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,
2003: l_dffprompt := NULL;
2004: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE11',l_new_attribute_category);
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,
2038: l_dffprompt := NULL;
2039: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE12',l_new_attribute_category);
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,
2073: l_dffprompt := NULL;
2074: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE13',l_new_attribute_category);
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,
2108: l_dffprompt := NULL;
2109: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE14',l_new_attribute_category);
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,
2143: l_dffprompt := NULL;
2144: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE15',l_new_attribute_category);
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,
2194: WHERE work_request_id = p_request_id;
2195: END IF;
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(