APPS.ONT_DEL_TO_ORG_DEF_UTIL dependencies on FND_API

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

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

Line 44: IF NVL(p_record.FOB_POINT_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 =('FOB_POINT_CODE') THEN
44: IF NVL(p_record.FOB_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
45: RETURN p_record.FOB_POINT_CODE;
46: ELSE
47: RETURN NULL;
48: END IF;

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

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

Line 56: IF NVL(p_record.INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 62: IF NVL(p_record.ORGANIZATION_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

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

64: ELSE
65: RETURN NULL;
66: END IF;
67: ELSIF p_attr_code =('PRICE_LIST_ID') THEN
68: IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
69: RETURN p_record.PRICE_LIST_ID;
70: ELSE
71: RETURN NULL;
72: END IF;

Line 74: IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

70: ELSE
71: RETURN NULL;
72: END IF;
73: ELSIF p_attr_code =('SHIPPING_METHOD_CODE') THEN
74: IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
75: RETURN p_record.SHIPPING_METHOD_CODE;
76: ELSE
77: RETURN NULL;
78: END IF;

Line 80: IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

76: ELSE
77: RETURN NULL;
78: END IF;
79: ELSIF p_attr_code =('SHIP_FROM_ORG_ID') THEN
80: IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
81: RETURN p_record.SHIP_FROM_ORG_ID;
82: ELSE
83: RETURN NULL;
84: END IF;

Line 86: IF NVL(p_record.SHIP_PARTIAL_ALLOWED, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

82: ELSE
83: RETURN NULL;
84: END IF;
85: ELSIF p_attr_code =('SHIP_PARTIAL_ALLOWED') THEN
86: IF NVL(p_record.SHIP_PARTIAL_ALLOWED, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
87: RETURN p_record.SHIP_PARTIAL_ALLOWED;
88: ELSE
89: RETURN NULL;
90: END IF;

Line 105: IF NVL(p_record.CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 111: IF NVL(p_record.FOB_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

107: ELSE
108: RETURN NULL;
109: END IF;
110: ELSIF p_attr_code =('FOB_POINT_CODE') THEN
111: IF NVL(p_record.FOB_POINT_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
112: RETURN to_date(p_record.FOB_POINT_CODE,'RRRR/MM/DD HH24:MI:SS');
113: ELSE
114: RETURN NULL;
115: END IF;

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

113: ELSE
114: RETURN NULL;
115: END IF;
116: ELSIF p_attr_code =('FREIGHT_TERMS_CODE') THEN
117: IF NVL(p_record.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
118: RETURN to_date(p_record.FREIGHT_TERMS_CODE,'RRRR/MM/DD HH24:MI:SS');
119: ELSE
120: RETURN NULL;
121: END IF;

Line 123: IF NVL(p_record.INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

119: ELSE
120: RETURN NULL;
121: END IF;
122: ELSIF p_attr_code =('INVOICE_TO_ORG_ID') THEN
123: IF NVL(p_record.INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
124: RETURN to_date(p_record.INVOICE_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
125: ELSE
126: RETURN NULL;
127: END IF;

Line 129: IF NVL(p_record.ORGANIZATION_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

125: ELSE
126: RETURN NULL;
127: END IF;
128: ELSIF p_attr_code =('ORGANIZATION_ID') THEN
129: IF NVL(p_record.ORGANIZATION_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
130: RETURN to_date(p_record.ORGANIZATION_ID,'RRRR/MM/DD HH24:MI:SS');
131: ELSE
132: RETURN NULL;
133: END IF;

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

131: ELSE
132: RETURN NULL;
133: END IF;
134: ELSIF p_attr_code =('PRICE_LIST_ID') THEN
135: IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
136: RETURN to_date(p_record.PRICE_LIST_ID,'RRRR/MM/DD HH24:MI:SS');
137: ELSE
138: RETURN NULL;
139: END IF;

Line 141: IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

137: ELSE
138: RETURN NULL;
139: END IF;
140: ELSIF p_attr_code =('SHIPPING_METHOD_CODE') THEN
141: IF NVL(p_record.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
142: RETURN to_date(p_record.SHIPPING_METHOD_CODE,'RRRR/MM/DD HH24:MI:SS');
143: ELSE
144: RETURN NULL;
145: END IF;

Line 147: IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

143: ELSE
144: RETURN NULL;
145: END IF;
146: ELSIF p_attr_code =('SHIP_FROM_ORG_ID') THEN
147: IF NVL(p_record.SHIP_FROM_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
148: RETURN to_date(p_record.SHIP_FROM_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
149: ELSE
150: RETURN NULL;
151: END IF;

Line 153: IF NVL(p_record.SHIP_PARTIAL_ALLOWED, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

149: ELSE
150: RETURN NULL;
151: END IF;
152: ELSIF p_attr_code =('SHIP_PARTIAL_ALLOWED') THEN
153: IF NVL(p_record.SHIP_PARTIAL_ALLOWED, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
154: RETURN to_date(p_record.SHIP_PARTIAL_ALLOWED,'RRRR/MM/DD HH24:MI:SS');
155: ELSE
156: RETURN NULL;
157: END IF;

Line 184: IF (NVL(p_ORGANIZATION_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)

180: WHERE ORGANIZATION_ID = p_ORGANIZATION_ID
181: ;
182: BEGIN
183:
184: IF (NVL(p_ORGANIZATION_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
185: THEN
186: RETURN 0 ;
187: ELSIF (NVL(g_cached_record.ORGANIZATION_ID,FND_API.G_MISS_NUM) <> p_ORGANIZATION_ID)
188: THEN

Line 187: ELSIF (NVL(g_cached_record.ORGANIZATION_ID,FND_API.G_MISS_NUM) <> p_ORGANIZATION_ID)

183:
184: IF (NVL(p_ORGANIZATION_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
185: THEN
186: RETURN 0 ;
187: ELSIF (NVL(g_cached_record.ORGANIZATION_ID,FND_API.G_MISS_NUM) <> p_ORGANIZATION_ID)
188: THEN
189: Clear_DEL_TO_ORG_Cache;
190: Open cache;
191: FETCH cache into g_cached_record;