APPS.ONT_AGREEMENT_DEF_UTIL dependencies on FND_API

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

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

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

Line 50: IF NVL(p_record.AGREEMENT_TYPE_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 =('AGREEMENT_TYPE_CODE') THEN
50: IF NVL(p_record.AGREEMENT_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
51: RETURN p_record.AGREEMENT_TYPE_CODE;
52: ELSE
53: RETURN NULL;
54: END IF;

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

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

Line 62: IF NVL(p_record.INVOICE_TO_CONTACT_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 =('INVOICE_TO_CONTACT_ID') THEN
62: IF NVL(p_record.INVOICE_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
63: RETURN p_record.INVOICE_TO_CONTACT_ID;
64: ELSE
65: RETURN NULL;
66: END IF;

Line 68: IF NVL(p_record.INVOICE_TO_ORG_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 =('INVOICE_TO_ORG_ID') THEN
68: IF NVL(p_record.INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
69: RETURN p_record.INVOICE_TO_ORG_ID;
70: ELSE
71: RETURN NULL;
72: END IF;

Line 74: IF NVL(p_record.INVOICING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 80: IF NVL(p_record.PAYMENT_TERM_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 =('PAYMENT_TERM_ID') THEN
80: IF NVL(p_record.PAYMENT_TERM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
81: RETURN p_record.PAYMENT_TERM_ID;
82: ELSE
83: RETURN NULL;
84: END IF;

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

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

Line 92: IF NVL(p_record.SALESREP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

88: ELSE
89: RETURN NULL;
90: END IF;
91: ELSIF p_attr_code =('SALESREP_ID') THEN
92: IF NVL(p_record.SALESREP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
93: RETURN p_record.SALESREP_ID;
94: ELSE
95: RETURN NULL;
96: END IF;

Line 98: IF NVL(p_record.SOLD_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

94: ELSE
95: RETURN NULL;
96: END IF;
97: ELSIF p_attr_code =('SOLD_TO_ORG_ID') THEN
98: IF NVL(p_record.SOLD_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
99: RETURN p_record.SOLD_TO_ORG_ID;
100: ELSE
101: RETURN NULL;
102: END IF;

Line 117: IF NVL(p_record.ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 123: IF NVL(p_record.AGREEMENT_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 =('AGREEMENT_ID') THEN
123: IF NVL(p_record.AGREEMENT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
124: RETURN to_date(p_record.AGREEMENT_ID,'RRRR/MM/DD HH24:MI:SS');
125: ELSE
126: RETURN NULL;
127: END IF;

Line 129: IF NVL(p_record.AGREEMENT_TYPE_CODE, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

Line 135: IF NVL(p_record.CUST_PO_NUMBER, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

Line 141: IF NVL(p_record.INVOICE_TO_CONTACT_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 147: IF NVL(p_record.INVOICE_TO_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 =('INVOICE_TO_ORG_ID') THEN
147: IF NVL(p_record.INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
148: RETURN to_date(p_record.INVOICE_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
149: ELSE
150: RETURN NULL;
151: END IF;

Line 153: IF NVL(p_record.INVOICING_RULE_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

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

Line 159: IF NVL(p_record.PAYMENT_TERM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

155: ELSE
156: RETURN NULL;
157: END IF;
158: ELSIF p_attr_code =('PAYMENT_TERM_ID') THEN
159: IF NVL(p_record.PAYMENT_TERM_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
160: RETURN to_date(p_record.PAYMENT_TERM_ID,'RRRR/MM/DD HH24:MI:SS');
161: ELSE
162: RETURN NULL;
163: END IF;

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

161: ELSE
162: RETURN NULL;
163: END IF;
164: ELSIF p_attr_code =('PRICE_LIST_ID') THEN
165: IF NVL(p_record.PRICE_LIST_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
166: RETURN to_date(p_record.PRICE_LIST_ID,'RRRR/MM/DD HH24:MI:SS');
167: ELSE
168: RETURN NULL;
169: END IF;

Line 171: IF NVL(p_record.SALESREP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

167: ELSE
168: RETURN NULL;
169: END IF;
170: ELSIF p_attr_code =('SALESREP_ID') THEN
171: IF NVL(p_record.SALESREP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
172: RETURN to_date(p_record.SALESREP_ID,'RRRR/MM/DD HH24:MI:SS');
173: ELSE
174: RETURN NULL;
175: END IF;

Line 177: IF NVL(p_record.SOLD_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

173: ELSE
174: RETURN NULL;
175: END IF;
176: ELSIF p_attr_code =('SOLD_TO_ORG_ID') THEN
177: IF NVL(p_record.SOLD_TO_ORG_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
178: RETURN to_date(p_record.SOLD_TO_ORG_ID,'RRRR/MM/DD HH24:MI:SS');
179: ELSE
180: RETURN NULL;
181: END IF;

Line 208: IF (NVL(p_AGREEMENT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)

204: WHERE AGREEMENT_ID = p_AGREEMENT_ID
205: ;
206: BEGIN
207:
208: IF (NVL(p_AGREEMENT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
209: THEN
210: RETURN 0 ;
211: ELSIF (NVL(g_cached_record.AGREEMENT_ID,FND_API.G_MISS_NUM) <> p_AGREEMENT_ID)
212: THEN

Line 211: ELSIF (NVL(g_cached_record.AGREEMENT_ID,FND_API.G_MISS_NUM) <> p_AGREEMENT_ID)

207:
208: IF (NVL(p_AGREEMENT_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM)
209: THEN
210: RETURN 0 ;
211: ELSIF (NVL(g_cached_record.AGREEMENT_ID,FND_API.G_MISS_NUM) <> p_AGREEMENT_ID)
212: THEN
213: Clear_AGREEMENT_Cache;
214: Open cache;
215: FETCH cache into g_cached_record;