DBA Data[Home] [Help]

APPS.ONT_DEP_PLANNING_DEF_UTIL dependencies on FND_API

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

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

Line 44: IF NVL(p_record.DEP_PLAN_REQUIRED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

40: ELSE
41: RETURN NULL;
42: END IF;
43: ELSIF p_attr_code =('DEP_PLAN_REQUIRED_FLAG') THEN
44: IF NVL(p_record.DEP_PLAN_REQUIRED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
45: RETURN p_record.DEP_PLAN_REQUIRED_FLAG;
46: ELSE
47: RETURN NULL;
48: END IF;

Line 63: IF NVL(p_record.DEP_PLAN_REQUIRED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

59: IS
60: BEGIN
61:
62: IF p_attr_code =('DEP_PLAN_REQUIRED') THEN
63: IF NVL(p_record.DEP_PLAN_REQUIRED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
64: RETURN to_date(p_record.DEP_PLAN_REQUIRED_FLAG,'RRRR/MM/DD HH24:MI:SS');
65: ELSE
66: RETURN NULL;
67: END IF;

Line 69: IF NVL(p_record.DEP_PLAN_REQUIRED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

65: ELSE
66: RETURN NULL;
67: END IF;
68: ELSIF p_attr_code =('DEP_PLAN_REQUIRED_FLAG') THEN
69: IF NVL(p_record.DEP_PLAN_REQUIRED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
70: RETURN to_date(p_record.DEP_PLAN_REQUIRED_FLAG,'RRRR/MM/DD HH24:MI:SS');
71: ELSE
72: RETURN NULL;
73: END IF;

Line 100: IF (NVL(p_DEP_PLAN_REQUIRED_FLAG,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR)

96: WHERE DEP_PLAN_REQUIRED_FLAG = p_DEP_PLAN_REQUIRED_FLAG
97: ;
98: BEGIN
99:
100: IF (NVL(p_DEP_PLAN_REQUIRED_FLAG,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR)
101: THEN
102: RETURN 0 ;
103: ELSIF (NVL(g_cached_record.DEP_PLAN_REQUIRED_FLAG,FND_API.G_MISS_CHAR) <> p_DEP_PLAN_REQUIRED_FLAG)
104: THEN

Line 103: ELSIF (NVL(g_cached_record.DEP_PLAN_REQUIRED_FLAG,FND_API.G_MISS_CHAR) <> p_DEP_PLAN_REQUIRED_FLAG)

99:
100: IF (NVL(p_DEP_PLAN_REQUIRED_FLAG,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR)
101: THEN
102: RETURN 0 ;
103: ELSIF (NVL(g_cached_record.DEP_PLAN_REQUIRED_FLAG,FND_API.G_MISS_CHAR) <> p_DEP_PLAN_REQUIRED_FLAG)
104: THEN
105: Clear_DEP_PLANNING_Cache;
106: Open cache;
107: FETCH cache into g_cached_record;