DBA Data[Home] [Help]

APPS.ONT_IB_INSTALL_LOC_DEF_UTIL dependencies on FND_API

Line 38: IF NVL(p_record.IB_INSTALLED_AT_LOCATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

34: IS
35: BEGIN
36:
37: IF p_attr_code =('IB_INSTALLED_AT_LOCATION') THEN
38: IF NVL(p_record.IB_INSTALLED_AT_LOCATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
39: RETURN p_record.IB_INSTALLED_AT_LOCATION;
40: ELSE
41: RETURN NULL;
42: END IF;

Line 57: IF NVL(p_record.IB_INSTALLED_AT_LOCATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

53: IS
54: BEGIN
55:
56: IF p_attr_code =('IB_INSTALLED_AT_LOCATION') THEN
57: IF NVL(p_record.IB_INSTALLED_AT_LOCATION, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
58: RETURN to_date(p_record.IB_INSTALLED_AT_LOCATION,'RRRR/MM/DD HH24:MI:SS');
59: ELSE
60: RETURN NULL;
61: END IF;

Line 88: IF (NVL(p_IB_INSTALLED_AT_LOCATION,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR)

84: WHERE IB_INSTALLED_AT_LOCATION = p_IB_INSTALLED_AT_LOCATION
85: ;
86: BEGIN
87:
88: IF (NVL(p_IB_INSTALLED_AT_LOCATION,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR)
89: THEN
90: RETURN 0 ;
91: ELSIF (NVL(g_cached_record.IB_INSTALLED_AT_LOCATION,FND_API.G_MISS_CHAR) <> p_IB_INSTALLED_AT_LOCATION)
92: THEN

Line 91: ELSIF (NVL(g_cached_record.IB_INSTALLED_AT_LOCATION,FND_API.G_MISS_CHAR) <> p_IB_INSTALLED_AT_LOCATION)

87:
88: IF (NVL(p_IB_INSTALLED_AT_LOCATION,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR)
89: THEN
90: RETURN 0 ;
91: ELSIF (NVL(g_cached_record.IB_INSTALLED_AT_LOCATION,FND_API.G_MISS_CHAR) <> p_IB_INSTALLED_AT_LOCATION)
92: THEN
93: Clear_IB_INSTALL_LOC_Cache;
94: Open cache;
95: FETCH cache into g_cached_record;