APPS.ONT_PRICE_LIST_DEF_UTIL dependencies on FND_API

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

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

Line 44: IF NVL(p_record.TERMS_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 50: IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 56: IF NVL(p_record.SHIP_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

52: ELSE
53: RETURN NULL;
54: END IF;
55: ELSIF p_attr_code =('SHIPPING_METHOD_CODE') THEN
56: IF NVL(p_record.SHIP_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
57: RETURN p_record.SHIP_METHOD_CODE;
58: ELSE
59: RETURN NULL;
60: END IF;

Line 62: IF NVL(p_record.CURRENCY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

58: ELSE
59: RETURN NULL;
60: END IF;
61: ELSIF p_attr_code =('TRANSACTIONAL_CURR_CODE') THEN
62: IF NVL(p_record.CURRENCY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
63: RETURN p_record.CURRENCY_CODE;
64: ELSE
65: RETURN NULL;
66: END IF;

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

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

Line 87: IF NVL(p_record.TERMS_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

83: ELSE
84: RETURN NULL;
85: END IF;
86: ELSIF p_attr_code =('PAYMENT_TERM_ID') THEN
87: IF NVL(p_record.TERMS_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
88: RETURN to_date(p_record.TERMS_ID,'RRRR/MM/DD HH24:MI:SS');
89: ELSE
90: RETURN NULL;
91: END IF;

Line 93: IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

89: ELSE
90: RETURN NULL;
91: END IF;
92: ELSIF p_attr_code =('PRICE_LIST_ID') THEN
93: IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
94: RETURN to_date(p_record.PRICE_LIST_ID,'RRRR/MM/DD HH24:MI:SS');
95: ELSE
96: RETURN NULL;
97: END IF;

Line 99: IF NVL(p_record.SHIP_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

95: ELSE
96: RETURN NULL;
97: END IF;
98: ELSIF p_attr_code =('SHIPPING_METHOD_CODE') THEN
99: IF NVL(p_record.SHIP_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
100: RETURN to_date(p_record.SHIP_METHOD_CODE,'RRRR/MM/DD HH24:MI:SS');
101: ELSE
102: RETURN NULL;
103: END IF;

Line 105: IF NVL(p_record.CURRENCY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

101: ELSE
102: RETURN NULL;
103: END IF;
104: ELSIF p_attr_code =('TRANSACTIONAL_CURR_CODE') THEN
105: IF NVL(p_record.CURRENCY_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
106: RETURN to_date(p_record.CURRENCY_CODE,'RRRR/MM/DD HH24:MI:SS');
107: ELSE
108: RETURN NULL;
109: END IF;

Line 136: IF (NVL(p_PRICE_LIST_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)

132: WHERE PRICE_LIST_ID = p_PRICE_LIST_ID
133: ;
134: BEGIN
135:
136: IF (NVL(p_PRICE_LIST_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
137: THEN
138: RETURN 0 ;
139: ELSIF (NVL(g_cached_record.PRICE_LIST_ID,FND_API.G_MISS_NUM) <> p_PRICE_LIST_ID)
140: THEN

Line 139: ELSIF (NVL(g_cached_record.PRICE_LIST_ID,FND_API.G_MISS_NUM) <> p_PRICE_LIST_ID)

135:
136: IF (NVL(p_PRICE_LIST_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
137: THEN
138: RETURN 0 ;
139: ELSIF (NVL(g_cached_record.PRICE_LIST_ID,FND_API.G_MISS_NUM) <> p_PRICE_LIST_ID)
140: THEN
141: Clear_PRICE_LIST_Cache;
142: Open cache;
143: FETCH cache into g_cached_record;