[Home] [Help]
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;
321: l_stmt_num := 110;
322: INSERT INTO wip_eam_work_req_notes(
345: );
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,
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
862: INTO l_work_request_note_id
863: FROM dual;
864: l_stmt_num := 70;
865: INSERT INTO wip_eam_work_req_notes(
1037: isdifferent_number(l_old_asset_group_id, l_new_asset_group_id) = 1) THEN
1038: l_stmt_num := 230;
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
1093: null
1094: );
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(
1125: END IF;
1126:
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
1181: l_stmt_num := 182;
1182:
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
1236: END IF;
1237:
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
1291: END IF;
1292:
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
1347:
1348: IF (l_old_request_by_date <> l_new_request_by_date) THEN
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;
1390: END IF;
1391:
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
1440: );
1441: END IF;
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(
1471: );
1472: END IF;
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(
1502: );
1503: END IF;
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
1553: );
1554: END IF;
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
1604: );
1605: END IF;
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(
1639: l_dffprompt := NULL;
1640: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE1',l_new_attribute_category);
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,
1674: l_dffprompt := NULL;
1675: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE2',l_new_attribute_category);
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,
1709: l_dffprompt := NULL;
1710: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE3',l_new_attribute_category);
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,
1744: l_dffprompt := NULL;
1745: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE3',l_new_attribute_category);
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,
1779: l_dffprompt := NULL;
1780: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE4',l_new_attribute_category);
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,
1814: l_dffprompt := NULL;
1815: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE5',l_new_attribute_category);
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,
1849: l_dffprompt := NULL;
1850: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE6',l_new_attribute_category);
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,
1884: l_dffprompt := NULL;
1885: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE7',l_new_attribute_category);
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,
1919: l_dffprompt := NULL;
1920: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE8',l_new_attribute_category);
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,
1954: l_dffprompt := NULL;
1955: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE9',l_new_attribute_category);
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,
1989: l_dffprompt := NULL;
1990: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE10',l_new_attribute_category);
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,
2024: l_dffprompt := NULL;
2025: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE11',l_new_attribute_category);
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,
2059: l_dffprompt := NULL;
2060: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE12',l_new_attribute_category);
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,
2094: l_dffprompt := NULL;
2095: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE13',l_new_attribute_category);
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,
2129: l_dffprompt := NULL;
2130: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE14',l_new_attribute_category);
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,
2164: l_dffprompt := NULL;
2165: l_dffprompt := dff_prompt_name('WIP','WIP_EAM_WORK_REQUESTS','ATTRIBUTE15',l_new_attribute_category);
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,
2215: WHERE work_request_id = p_request_id;
2216: END IF;
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(