APPS.ONT_CUST_ITEM_DEF_UTIL dependencies on FND_API

Line 38: IF NVL(p_record.CUSTOMER_ITEM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

34: IS
35: BEGIN
36:
37: IF p_attr_code =('CUSTOMER_ITEM_ID') THEN
38: IF NVL(p_record.CUSTOMER_ITEM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
39: RETURN p_record.CUSTOMER_ITEM_ID;
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') 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 50: IF NVL(p_record.DEP_PLAN_REQUIRED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

46: ELSE
47: RETURN NULL;
48: END IF;
49: ELSIF p_attr_code =('DEP_PLAN_REQUIRED_FLAG') THEN
50: IF NVL(p_record.DEP_PLAN_REQUIRED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
51: RETURN p_record.DEP_PLAN_REQUIRED_FLAG;
52: ELSE
53: RETURN NULL;
54: END IF;

Line 69: IF NVL(p_record.CUSTOMER_ITEM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

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

71: ELSE
72: RETURN NULL;
73: END IF;
74: ELSIF p_attr_code =('DEP_PLAN_REQUIRED') THEN
75: IF NVL(p_record.DEP_PLAN_REQUIRED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
76: RETURN to_date(p_record.DEP_PLAN_REQUIRED_FLAG,'RRRR/MM/DD HH24:MI:SS');
77: ELSE
78: RETURN NULL;
79: END IF;

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

77: ELSE
78: RETURN NULL;
79: END IF;
80: ELSIF p_attr_code =('DEP_PLAN_REQUIRED_FLAG') THEN
81: IF NVL(p_record.DEP_PLAN_REQUIRED_FLAG, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
82: RETURN to_date(p_record.DEP_PLAN_REQUIRED_FLAG,'RRRR/MM/DD HH24:MI:SS');
83: ELSE
84: RETURN NULL;
85: END IF;

Line 112: IF (NVL(p_CUSTOMER_ITEM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)

108: WHERE CUSTOMER_ITEM_ID = p_CUSTOMER_ITEM_ID
109: ;
110: BEGIN
111:
112: IF (NVL(p_CUSTOMER_ITEM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
113: THEN
114: RETURN 0 ;
115: ELSIF (NVL(g_cached_record.CUSTOMER_ITEM_ID,FND_API.G_MISS_NUM) <> p_CUSTOMER_ITEM_ID)
116: THEN

Line 115: ELSIF (NVL(g_cached_record.CUSTOMER_ITEM_ID,FND_API.G_MISS_NUM) <> p_CUSTOMER_ITEM_ID)

111:
112: IF (NVL(p_CUSTOMER_ITEM_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
113: THEN
114: RETURN 0 ;
115: ELSIF (NVL(g_cached_record.CUSTOMER_ITEM_ID,FND_API.G_MISS_NUM) <> p_CUSTOMER_ITEM_ID)
116: THEN
117: Clear_CUST_ITEM_Cache;
118: Open cache;
119: FETCH cache into g_cached_record;