APPS.ONT_ORDER_CAT_DEF_UTIL dependencies on FND_API

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

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

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

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

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

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

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

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

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

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

Line 103: ELSIF (NVL(g_cached_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) <> p_ORDER_CATEGORY_CODE)

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