1349: l_create_audit_rec.OLD_STATUS_FLAG := 'C';
1350: END IF;
1351: -- Added this to populate the G_MISS_DATE in some records
1352: IF (l_create_audit_rec.OWNER_ASSIGNED_TIME > SYSDATE OR
1353: l_create_audit_rec.OWNER_ASSIGNED_TIME = FND_API.G_MISS_DATE) THEN
1354: l_create_audit_rec.OWNER_ASSIGNED_TIME := l_create_audit_rec.creation_date;
1355: END IF;
1356:
1357: IF (l_create_audit_rec.OLD_OWNER_ASSIGNED_TIME > SYSDATE OR
1354: l_create_audit_rec.OWNER_ASSIGNED_TIME := l_create_audit_rec.creation_date;
1355: END IF;
1356:
1357: IF (l_create_audit_rec.OLD_OWNER_ASSIGNED_TIME > SYSDATE OR
1358: l_create_audit_rec.OLD_OWNER_ASSIGNED_TIME = FND_API.G_MISS_DATE) THEN
1359: l_create_audit_rec.OLD_OWNER_ASSIGNED_TIME := l_create_audit_rec.creation_date;
1360: END IF;
1361:
1362: if (l_create_audit_rec.CLOSE_DATE > sysdate) then
2120: end if;
2121:
2122: -- Added this to populate the G_MISS_DATE in some records
2123: if (l_create_audit_rec.OWNER_ASSIGNED_TIME > sysdate OR
2124: l_create_audit_rec.OWNER_ASSIGNED_TIME = FND_API.G_MISS_DATE) then
2125: l_create_audit_rec.OWNER_ASSIGNED_TIME := l_create_audit_rec.creation_date;
2126: end if;
2127:
2128: if (l_create_audit_rec.OLD_OWNER_ASSIGNED_TIME > sysdate OR
2125: l_create_audit_rec.OWNER_ASSIGNED_TIME := l_create_audit_rec.creation_date;
2126: end if;
2127:
2128: if (l_create_audit_rec.OLD_OWNER_ASSIGNED_TIME > sysdate OR
2129: l_create_audit_rec.OLD_OWNER_ASSIGNED_TIME = FND_API.G_MISS_DATE) then
2130: l_create_audit_rec.OLD_OWNER_ASSIGNED_TIME := l_create_audit_rec.creation_date;
2131: end if;
2132:
2133: if (l_create_audit_rec.CLOSE_DATE > sysdate OR
2130: l_create_audit_rec.OLD_OWNER_ASSIGNED_TIME := l_create_audit_rec.creation_date;
2131: end if;
2132:
2133: if (l_create_audit_rec.CLOSE_DATE > sysdate OR
2134: l_create_audit_rec.CLOSE_DATE = FND_API.G_MISS_DATE) then
2135: l_create_audit_rec.CLOSE_DATE := l_create_audit_rec.creation_date;
2136: end if;
2137: if (l_create_audit_rec.OLD_CLOSE_DATE > sysdate OR
2138: l_create_audit_rec.OLD_CLOSE_DATE = FND_API.G_MISS_DATE) then
2134: l_create_audit_rec.CLOSE_DATE = FND_API.G_MISS_DATE) then
2135: l_create_audit_rec.CLOSE_DATE := l_create_audit_rec.creation_date;
2136: end if;
2137: if (l_create_audit_rec.OLD_CLOSE_DATE > sysdate OR
2138: l_create_audit_rec.OLD_CLOSE_DATE = FND_API.G_MISS_DATE) then
2139: l_create_audit_rec.old_CLOSE_DATE := l_create_audit_rec.creation_date;
2140: end if;
2141:
2142: UPDATE cs_incidents_audit_b