DBA Data[Home] [Help]

APPS.CS_AUDIT_UPGRADE_CON_PRG dependencies on FND_API

Line 1353: l_create_audit_rec.OWNER_ASSIGNED_TIME = FND_API.G_MISS_DATE) THEN

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

Line 1358: l_create_audit_rec.OLD_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
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

Line 2124: l_create_audit_rec.OWNER_ASSIGNED_TIME = FND_API.G_MISS_DATE) 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

Line 2129: l_create_audit_rec.OLD_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
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

Line 2134: l_create_audit_rec.CLOSE_DATE = 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
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

Line 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