eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_LEADS_PKG dependencies on FND_API

Line 102: If (px_LEAD_ID IS NULL) OR (px_LEAD_ID = FND_API.G_MISS_NUM) then

98:
99: IS
100: CURSOR C2 IS SELECT AS_LEADS_S.nextval FROM sys.dual;
101: BEGIN
102: If (px_LEAD_ID IS NULL) OR (px_LEAD_ID = FND_API.G_MISS_NUM) then
103: OPEN C2;
104: FETCH C2 INTO px_LEAD_ID;
105: CLOSE C2;
106: End If;

Line 191: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),

187: PRM_REFERRAL_CODE,
188: TOTAL_REVENUE_OPP_FORECAST_AMT
189: ) VALUES (
190: px_LEAD_ID,
191: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
192: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
193: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
194: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
195: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

Line 192: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

188: TOTAL_REVENUE_OPP_FORECAST_AMT
189: ) VALUES (
190: px_LEAD_ID,
191: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
192: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
193: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
194: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
195: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
196: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),

Line 193: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),

189: ) VALUES (
190: px_LEAD_ID,
191: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
192: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
193: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
194: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
195: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
196: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
197: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),

Line 194: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

190: px_LEAD_ID,
191: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
192: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
193: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
194: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
195: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
196: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
197: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
198: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

Line 195: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

191: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
192: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
193: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
194: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
195: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
196: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
197: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
198: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
199: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),

Line 196: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),

192: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
193: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
194: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
195: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
196: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
197: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
198: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
199: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
200: -- decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LEAD_NUMBER),

Line 197: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),

193: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
194: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
195: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
196: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
197: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
198: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
199: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
200: -- decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LEAD_NUMBER),
201: px_LEAD_ID,

Line 198: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

194: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
195: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
196: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
197: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
198: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
199: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
200: -- decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LEAD_NUMBER),
201: px_LEAD_ID,
202: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),

Line 199: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),

195: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
196: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
197: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
198: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
199: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
200: -- decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LEAD_NUMBER),
201: px_LEAD_ID,
202: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),
203: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),

Line 200: -- decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LEAD_NUMBER),

196: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
197: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
198: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
199: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
200: -- decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LEAD_NUMBER),
201: px_LEAD_ID,
202: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),
203: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
204: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),

Line 202: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),

198: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
199: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
200: -- decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LEAD_NUMBER),
201: px_LEAD_ID,
202: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),
203: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
204: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
205: decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, NULL, p_SALES_STAGE_ID),
206: decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_INITIATING_CONTACT_ID),

Line 203: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),

199: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
200: -- decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LEAD_NUMBER),
201: px_LEAD_ID,
202: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),
203: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
204: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
205: decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, NULL, p_SALES_STAGE_ID),
206: decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_INITIATING_CONTACT_ID),
207: decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),

Line 204: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),

200: -- decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LEAD_NUMBER),
201: px_LEAD_ID,
202: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),
203: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
204: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
205: decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, NULL, p_SALES_STAGE_ID),
206: decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_INITIATING_CONTACT_ID),
207: decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
208: decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL, p_TOTAL_AMOUNT),

Line 205: decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, NULL, p_SALES_STAGE_ID),

201: px_LEAD_ID,
202: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),
203: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
204: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
205: decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, NULL, p_SALES_STAGE_ID),
206: decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_INITIATING_CONTACT_ID),
207: decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
208: decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL, p_TOTAL_AMOUNT),
209: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),

Line 206: decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_INITIATING_CONTACT_ID),

202: decode( p_STATUS, FND_API.G_MISS_CHAR, NULL, p_STATUS),
203: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
204: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
205: decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, NULL, p_SALES_STAGE_ID),
206: decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_INITIATING_CONTACT_ID),
207: decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
208: decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL, p_TOTAL_AMOUNT),
209: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
210: decode( p_DECISION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DECISION_DATE),

Line 207: decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),

203: decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
204: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
205: decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, NULL, p_SALES_STAGE_ID),
206: decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_INITIATING_CONTACT_ID),
207: decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
208: decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL, p_TOTAL_AMOUNT),
209: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
210: decode( p_DECISION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DECISION_DATE),
211: decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, NULL, p_WIN_PROBABILITY),

Line 208: decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL, p_TOTAL_AMOUNT),

204: decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
205: decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, NULL, p_SALES_STAGE_ID),
206: decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_INITIATING_CONTACT_ID),
207: decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
208: decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL, p_TOTAL_AMOUNT),
209: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
210: decode( p_DECISION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DECISION_DATE),
211: decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, NULL, p_WIN_PROBABILITY),
212: decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),

Line 209: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),

205: decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, NULL, p_SALES_STAGE_ID),
206: decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_INITIATING_CONTACT_ID),
207: decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
208: decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL, p_TOTAL_AMOUNT),
209: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
210: decode( p_DECISION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DECISION_DATE),
211: decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, NULL, p_WIN_PROBABILITY),
212: decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
213: decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR_CODE),

Line 210: decode( p_DECISION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DECISION_DATE),

206: decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_INITIATING_CONTACT_ID),
207: decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
208: decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL, p_TOTAL_AMOUNT),
209: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
210: decode( p_DECISION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DECISION_DATE),
211: decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, NULL, p_WIN_PROBABILITY),
212: decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
213: decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR_CODE),
214: decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR),

Line 211: decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, NULL, p_WIN_PROBABILITY),

207: decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
208: decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL, p_TOTAL_AMOUNT),
209: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
210: decode( p_DECISION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DECISION_DATE),
211: decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, NULL, p_WIN_PROBABILITY),
212: decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
213: decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR_CODE),
214: decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR),
215: decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMMENT),

Line 212: decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),

208: decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL, p_TOTAL_AMOUNT),
209: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
210: decode( p_DECISION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DECISION_DATE),
211: decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, NULL, p_WIN_PROBABILITY),
212: decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
213: decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR_CODE),
214: decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR),
215: decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMMENT),
216: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),

Line 213: decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR_CODE),

209: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
210: decode( p_DECISION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DECISION_DATE),
211: decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, NULL, p_WIN_PROBABILITY),
212: decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
213: decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR_CODE),
214: decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR),
215: decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMMENT),
216: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
217: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),

Line 214: decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR),

210: decode( p_DECISION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_DECISION_DATE),
211: decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, NULL, p_WIN_PROBABILITY),
212: decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
213: decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR_CODE),
214: decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR),
215: decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMMENT),
216: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
217: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
218: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_PROMOTION_ID),

Line 215: decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMMENT),

211: decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, NULL, p_WIN_PROBABILITY),
212: decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
213: decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR_CODE),
214: decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR),
215: decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMMENT),
216: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
217: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
218: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_PROMOTION_ID),
219: decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_CUSTOMER_ID),

Line 216: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),

212: decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
213: decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR_CODE),
214: decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR),
215: decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMMENT),
216: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
217: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
218: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_PROMOTION_ID),
219: decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_CUSTOMER_ID),
220: decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_ADDRESS_ID),

Line 217: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),

213: decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR_CODE),
214: decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR),
215: decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMMENT),
216: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
217: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
218: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_PROMOTION_ID),
219: decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_CUSTOMER_ID),
220: decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_ADDRESS_ID),
221: decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALESFORCE_ID),

Line 218: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_PROMOTION_ID),

214: decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMPETITOR),
215: decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMMENT),
216: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
217: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
218: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_PROMOTION_ID),
219: decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_CUSTOMER_ID),
220: decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_ADDRESS_ID),
221: decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALESFORCE_ID),
222: decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALES_GROUP_ID),

Line 219: decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_CUSTOMER_ID),

215: decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, NULL, p_CLOSE_COMMENT),
216: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
217: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
218: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_PROMOTION_ID),
219: decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_CUSTOMER_ID),
220: decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_ADDRESS_ID),
221: decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALESFORCE_ID),
222: decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALES_GROUP_ID),
223: --decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OWNER_ASSIGN_DATE),

Line 220: decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_ADDRESS_ID),

216: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
217: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
218: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_PROMOTION_ID),
219: decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_CUSTOMER_ID),
220: decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_ADDRESS_ID),
221: decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALESFORCE_ID),
222: decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALES_GROUP_ID),
223: --decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OWNER_ASSIGN_DATE),
224: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID),

Line 221: decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALESFORCE_ID),

217: decode( p_RANK, FND_API.G_MISS_CHAR, NULL, p_RANK),
218: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_PROMOTION_ID),
219: decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_CUSTOMER_ID),
220: decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_ADDRESS_ID),
221: decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALESFORCE_ID),
222: decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALES_GROUP_ID),
223: --decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OWNER_ASSIGN_DATE),
224: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID),
225: decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_NO_OPP_ALLOWED_FLAG),

Line 222: decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALES_GROUP_ID),

218: decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_PROMOTION_ID),
219: decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_CUSTOMER_ID),
220: decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_ADDRESS_ID),
221: decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALESFORCE_ID),
222: decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALES_GROUP_ID),
223: --decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OWNER_ASSIGN_DATE),
224: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID),
225: decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_NO_OPP_ALLOWED_FLAG),
226: decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETE_ALLOWED_FLAG),

Line 223: --decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OWNER_ASSIGN_DATE),

219: decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_CUSTOMER_ID),
220: decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_ADDRESS_ID),
221: decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALESFORCE_ID),
222: decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALES_GROUP_ID),
223: --decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OWNER_ASSIGN_DATE),
224: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID),
225: decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_NO_OPP_ALLOWED_FLAG),
226: decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETE_ALLOWED_FLAG),
227: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),

Line 224: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID),

220: decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_END_USER_ADDRESS_ID),
221: decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALESFORCE_ID),
222: decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALES_GROUP_ID),
223: --decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OWNER_ASSIGN_DATE),
224: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID),
225: decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_NO_OPP_ALLOWED_FLAG),
226: decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETE_ALLOWED_FLAG),
227: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
228: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

Line 225: decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_NO_OPP_ALLOWED_FLAG),

221: decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALESFORCE_ID),
222: decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALES_GROUP_ID),
223: --decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OWNER_ASSIGN_DATE),
224: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID),
225: decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_NO_OPP_ALLOWED_FLAG),
226: decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETE_ALLOWED_FLAG),
227: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
228: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
229: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

Line 226: decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETE_ALLOWED_FLAG),

222: decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_SALES_GROUP_ID),
223: --decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OWNER_ASSIGN_DATE),
224: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID),
225: decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_NO_OPP_ALLOWED_FLAG),
226: decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETE_ALLOWED_FLAG),
227: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
228: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
229: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
230: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

Line 227: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),

223: --decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_OWNER_ASSIGN_DATE),
224: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID),
225: decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_NO_OPP_ALLOWED_FLAG),
226: decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETE_ALLOWED_FLAG),
227: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
228: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
229: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
230: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
231: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

Line 228: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

224: decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID),
225: decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_NO_OPP_ALLOWED_FLAG),
226: decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETE_ALLOWED_FLAG),
227: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
228: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
229: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
230: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
231: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
232: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

Line 229: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

225: decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_NO_OPP_ALLOWED_FLAG),
226: decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETE_ALLOWED_FLAG),
227: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
228: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
229: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
230: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
231: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
232: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
233: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

Line 230: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

226: decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETE_ALLOWED_FLAG),
227: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
228: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
229: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
230: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
231: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
232: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
233: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
234: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

Line 231: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

227: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
228: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
229: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
230: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
231: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
232: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
233: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
234: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
235: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

Line 232: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

228: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
229: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
230: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
231: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
232: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
233: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
234: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
235: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
236: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

Line 233: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

229: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
230: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
231: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
232: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
233: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
234: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
235: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
236: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
237: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

Line 234: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

230: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
231: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
232: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
233: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
234: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
235: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
236: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
237: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
238: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

Line 235: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

231: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
232: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
233: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
234: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
235: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
236: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
237: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
238: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
239: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

Line 236: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

232: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
233: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
234: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
235: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
236: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
237: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
238: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
239: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
240: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

Line 237: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

233: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
234: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
235: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
236: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
237: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
238: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
239: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
240: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
241: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

Line 238: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

234: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
235: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
236: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
237: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
238: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
239: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
240: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
241: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
242: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

Line 239: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

235: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
236: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
237: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
238: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
239: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
240: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
241: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
242: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
243: decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),

Line 240: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

236: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
237: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
238: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
239: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
240: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
241: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
242: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
243: decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
244: decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_SOURCE_CODE),

Line 241: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

237: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
238: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
239: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
240: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
241: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
242: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
243: decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
244: decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_SOURCE_CODE),
245: decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_REFERENCE),

Line 242: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

238: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
239: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
240: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
241: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
242: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
243: decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
244: decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_SOURCE_CODE),
245: decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_REFERENCE),
246: decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, NULL, p_CLOSE_COMPETITOR_ID),

Line 243: decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),

239: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
240: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
241: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
242: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
243: decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
244: decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_SOURCE_CODE),
245: decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_REFERENCE),
246: decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, NULL, p_CLOSE_COMPETITOR_ID),
247: decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, p_END_USER_CUSTOMER_NAME),

Line 244: decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_SOURCE_CODE),

240: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
241: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
242: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
243: decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
244: decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_SOURCE_CODE),
245: decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_REFERENCE),
246: decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, NULL, p_CLOSE_COMPETITOR_ID),
247: decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, p_END_USER_CUSTOMER_NAME),
248: decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, p_PRICE_LIST_ID),

Line 245: decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_REFERENCE),

241: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
242: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
243: decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
244: decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_SOURCE_CODE),
245: decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_REFERENCE),
246: decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, NULL, p_CLOSE_COMPETITOR_ID),
247: decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, p_END_USER_CUSTOMER_NAME),
248: decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, p_PRICE_LIST_ID),
249: decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),

Line 246: decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, NULL, p_CLOSE_COMPETITOR_ID),

242: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
243: decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
244: decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_SOURCE_CODE),
245: decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_REFERENCE),
246: decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, NULL, p_CLOSE_COMPETITOR_ID),
247: decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, p_END_USER_CUSTOMER_NAME),
248: decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, p_PRICE_LIST_ID),
249: decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
250: decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_AUTO_ASSIGNMENT_TYPE),

Line 247: decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, p_END_USER_CUSTOMER_NAME),

243: decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
244: decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_SOURCE_CODE),
245: decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_REFERENCE),
246: decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, NULL, p_CLOSE_COMPETITOR_ID),
247: decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, p_END_USER_CUSTOMER_NAME),
248: decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, p_PRICE_LIST_ID),
249: decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
250: decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_AUTO_ASSIGNMENT_TYPE),
251: decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_PRM_ASSIGNMENT_TYPE),

Line 248: decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, p_PRICE_LIST_ID),

244: decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_SOURCE_CODE),
245: decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_REFERENCE),
246: decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, NULL, p_CLOSE_COMPETITOR_ID),
247: decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, p_END_USER_CUSTOMER_NAME),
248: decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, p_PRICE_LIST_ID),
249: decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
250: decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_AUTO_ASSIGNMENT_TYPE),
251: decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_PRM_ASSIGNMENT_TYPE),
252: decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_BUDGET),

Line 249: decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),

245: decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_REFERENCE),
246: decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, NULL, p_CLOSE_COMPETITOR_ID),
247: decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, p_END_USER_CUSTOMER_NAME),
248: decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, p_PRICE_LIST_ID),
249: decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
250: decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_AUTO_ASSIGNMENT_TYPE),
251: decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_PRM_ASSIGNMENT_TYPE),
252: decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_BUDGET),
253: decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, NULL, p_METHODOLOGY_CODE),

Line 250: decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_AUTO_ASSIGNMENT_TYPE),

246: decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, NULL, p_CLOSE_COMPETITOR_ID),
247: decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, p_END_USER_CUSTOMER_NAME),
248: decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, p_PRICE_LIST_ID),
249: decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
250: decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_AUTO_ASSIGNMENT_TYPE),
251: decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_PRM_ASSIGNMENT_TYPE),
252: decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_BUDGET),
253: decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, NULL, p_METHODOLOGY_CODE),
254: decode( p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM, NULL, p_SALES_METHODOLOGY_ID),

Line 251: decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_PRM_ASSIGNMENT_TYPE),

247: decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, NULL, p_END_USER_CUSTOMER_NAME),
248: decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, p_PRICE_LIST_ID),
249: decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
250: decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_AUTO_ASSIGNMENT_TYPE),
251: decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_PRM_ASSIGNMENT_TYPE),
252: decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_BUDGET),
253: decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, NULL, p_METHODOLOGY_CODE),
254: decode( p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM, NULL, p_SALES_METHODOLOGY_ID),
255: decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_LEAD_ID),

Line 252: decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_BUDGET),

248: decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, p_PRICE_LIST_ID),
249: decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
250: decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_AUTO_ASSIGNMENT_TYPE),
251: decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_PRM_ASSIGNMENT_TYPE),
252: decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_BUDGET),
253: decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, NULL, p_METHODOLOGY_CODE),
254: decode( p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM, NULL, p_SALES_METHODOLOGY_ID),
255: decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_LEAD_ID),
256: decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE),

Line 253: decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, NULL, p_METHODOLOGY_CODE),

249: decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
250: decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_AUTO_ASSIGNMENT_TYPE),
251: decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_PRM_ASSIGNMENT_TYPE),
252: decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_BUDGET),
253: decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, NULL, p_METHODOLOGY_CODE),
254: decode( p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM, NULL, p_SALES_METHODOLOGY_ID),
255: decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_LEAD_ID),
256: decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE),
257: decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_RESOURCE_ID),

Line 254: decode( p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM, NULL, p_SALES_METHODOLOGY_ID),

250: decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_AUTO_ASSIGNMENT_TYPE),
251: decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_PRM_ASSIGNMENT_TYPE),
252: decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_BUDGET),
253: decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, NULL, p_METHODOLOGY_CODE),
254: decode( p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM, NULL, p_SALES_METHODOLOGY_ID),
255: decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_LEAD_ID),
256: decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE),
257: decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_RESOURCE_ID),
258: decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_PARTY_ID),

Line 255: decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_LEAD_ID),

251: decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_PRM_ASSIGNMENT_TYPE),
252: decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_BUDGET),
253: decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, NULL, p_METHODOLOGY_CODE),
254: decode( p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM, NULL, p_SALES_METHODOLOGY_ID),
255: decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_LEAD_ID),
256: decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE),
257: decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_RESOURCE_ID),
258: decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_PARTY_ID),
259: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),

Line 256: decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE),

252: decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_BUDGET),
253: decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, NULL, p_METHODOLOGY_CODE),
254: decode( p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM, NULL, p_SALES_METHODOLOGY_ID),
255: decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_LEAD_ID),
256: decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE),
257: decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_RESOURCE_ID),
258: decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_PARTY_ID),
259: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
260: decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL, p_VEHICLE_RESPONSE_CODE),

Line 257: decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_RESOURCE_ID),

253: decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, NULL, p_METHODOLOGY_CODE),
254: decode( p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM, NULL, p_SALES_METHODOLOGY_ID),
255: decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_LEAD_ID),
256: decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE),
257: decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_RESOURCE_ID),
258: decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_PARTY_ID),
259: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
260: decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL, p_VEHICLE_RESPONSE_CODE),
261: decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_BUDGET_STATUS_CODE),

Line 258: decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_PARTY_ID),

254: decode( p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM, NULL, p_SALES_METHODOLOGY_ID),
255: decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_LEAD_ID),
256: decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE),
257: decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_RESOURCE_ID),
258: decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_PARTY_ID),
259: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
260: decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL, p_VEHICLE_RESPONSE_CODE),
261: decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_BUDGET_STATUS_CODE),
262: decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, NULL, p_FOLLOWUP_DATE),

Line 259: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),

255: decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_ORIGINAL_LEAD_ID),
256: decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE),
257: decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_RESOURCE_ID),
258: decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_PARTY_ID),
259: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
260: decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL, p_VEHICLE_RESPONSE_CODE),
261: decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_BUDGET_STATUS_CODE),
262: decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, NULL, p_FOLLOWUP_DATE),
263: decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_EXEC_SPONSOR_FLAG),

Line 260: decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL, p_VEHICLE_RESPONSE_CODE),

256: decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL, p_DECISION_TIMEFRAME_CODE),
257: decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_RESOURCE_ID),
258: decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_PARTY_ID),
259: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
260: decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL, p_VEHICLE_RESPONSE_CODE),
261: decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_BUDGET_STATUS_CODE),
262: decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, NULL, p_FOLLOWUP_DATE),
263: decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_EXEC_SPONSOR_FLAG),
264: decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),

Line 261: decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_BUDGET_STATUS_CODE),

257: decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_RESOURCE_ID),
258: decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_PARTY_ID),
259: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
260: decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL, p_VEHICLE_RESPONSE_CODE),
261: decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_BUDGET_STATUS_CODE),
262: decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, NULL, p_FOLLOWUP_DATE),
263: decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_EXEC_SPONSOR_FLAG),
264: decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
265: decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_IND_CLASSIFICATION_CODE),

Line 262: decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, NULL, p_FOLLOWUP_DATE),

258: decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_INC_PARTNER_PARTY_ID),
259: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
260: decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL, p_VEHICLE_RESPONSE_CODE),
261: decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_BUDGET_STATUS_CODE),
262: decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, NULL, p_FOLLOWUP_DATE),
263: decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_EXEC_SPONSOR_FLAG),
264: decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
265: decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_IND_CLASSIFICATION_CODE),
266: decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR,NULL, p_PRM_LEAD_TYPE),

Line 263: decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_EXEC_SPONSOR_FLAG),

259: decode( p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
260: decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL, p_VEHICLE_RESPONSE_CODE),
261: decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_BUDGET_STATUS_CODE),
262: decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, NULL, p_FOLLOWUP_DATE),
263: decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_EXEC_SPONSOR_FLAG),
264: decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
265: decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_IND_CLASSIFICATION_CODE),
266: decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR,NULL, p_PRM_LEAD_TYPE),
267: decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FREEZE_FLAG),

Line 264: decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),

260: decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL, p_VEHICLE_RESPONSE_CODE),
261: decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_BUDGET_STATUS_CODE),
262: decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, NULL, p_FOLLOWUP_DATE),
263: decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_EXEC_SPONSOR_FLAG),
264: decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
265: decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_IND_CLASSIFICATION_CODE),
266: decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR,NULL, p_PRM_LEAD_TYPE),
267: decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FREEZE_FLAG),
268: decode( p_PRM_REFERRAL_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_REFERRAL_CODE),

Line 265: decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_IND_CLASSIFICATION_CODE),

261: decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_BUDGET_STATUS_CODE),
262: decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, NULL, p_FOLLOWUP_DATE),
263: decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_EXEC_SPONSOR_FLAG),
264: decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
265: decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_IND_CLASSIFICATION_CODE),
266: decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR,NULL, p_PRM_LEAD_TYPE),
267: decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FREEZE_FLAG),
268: decode( p_PRM_REFERRAL_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_REFERRAL_CODE),
269: decode( p_TOT_REVENUE_OPP_FORECAST_AMT, FND_API.G_MISS_NUM, 0, p_TOT_REVENUE_OPP_FORECAST_AMT)); -- Added for ASNB

Line 266: decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR,NULL, p_PRM_LEAD_TYPE),

262: decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, NULL, p_FOLLOWUP_DATE),
263: decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_EXEC_SPONSOR_FLAG),
264: decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
265: decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_IND_CLASSIFICATION_CODE),
266: decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR,NULL, p_PRM_LEAD_TYPE),
267: decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FREEZE_FLAG),
268: decode( p_PRM_REFERRAL_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_REFERRAL_CODE),
269: decode( p_TOT_REVENUE_OPP_FORECAST_AMT, FND_API.G_MISS_NUM, 0, p_TOT_REVENUE_OPP_FORECAST_AMT)); -- Added for ASNB
270: End Insert_Row;

Line 267: decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FREEZE_FLAG),

263: decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_EXEC_SPONSOR_FLAG),
264: decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
265: decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_IND_CLASSIFICATION_CODE),
266: decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR,NULL, p_PRM_LEAD_TYPE),
267: decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FREEZE_FLAG),
268: decode( p_PRM_REFERRAL_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_REFERRAL_CODE),
269: decode( p_TOT_REVENUE_OPP_FORECAST_AMT, FND_API.G_MISS_NUM, 0, p_TOT_REVENUE_OPP_FORECAST_AMT)); -- Added for ASNB
270: End Insert_Row;
271:

Line 268: decode( p_PRM_REFERRAL_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_REFERRAL_CODE),

264: decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
265: decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_IND_CLASSIFICATION_CODE),
266: decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR,NULL, p_PRM_LEAD_TYPE),
267: decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FREEZE_FLAG),
268: decode( p_PRM_REFERRAL_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_REFERRAL_CODE),
269: decode( p_TOT_REVENUE_OPP_FORECAST_AMT, FND_API.G_MISS_NUM, 0, p_TOT_REVENUE_OPP_FORECAST_AMT)); -- Added for ASNB
270: End Insert_Row;
271:
272: PROCEDURE Update_Row(

Line 269: decode( p_TOT_REVENUE_OPP_FORECAST_AMT, FND_API.G_MISS_NUM, 0, p_TOT_REVENUE_OPP_FORECAST_AMT)); -- Added for ASNB

265: decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_IND_CLASSIFICATION_CODE),
266: decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR,NULL, p_PRM_LEAD_TYPE),
267: decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FREEZE_FLAG),
268: decode( p_PRM_REFERRAL_CODE, FND_API.G_MISS_CHAR, NULL, p_PRM_REFERRAL_CODE),
269: decode( p_TOT_REVENUE_OPP_FORECAST_AMT, FND_API.G_MISS_NUM, 0, p_TOT_REVENUE_OPP_FORECAST_AMT)); -- Added for ASNB
270: End Insert_Row;
271:
272: PROCEDURE Update_Row(
273: p_LEAD_ID NUMBER,

Line 357: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

353: BEGIN
354: -- Update AS_LEADS
355: Update AS_LEADS_ALL
356: SET object_version_number = nvl(object_version_number,0) + 1,
357: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
358: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
359: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
360: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
361: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

Line 358: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

354: -- Update AS_LEADS
355: Update AS_LEADS_ALL
356: SET object_version_number = nvl(object_version_number,0) + 1,
357: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
358: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
359: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
360: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
361: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
362: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),

Line 359: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

355: Update AS_LEADS_ALL
356: SET object_version_number = nvl(object_version_number,0) + 1,
357: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
358: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
359: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
360: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
361: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
362: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
363: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),

Line 360: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

356: SET object_version_number = nvl(object_version_number,0) + 1,
357: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
358: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
359: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
360: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
361: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
362: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
363: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
364: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

Line 361: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

357: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
358: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
359: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
360: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
361: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
362: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
363: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
364: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
365: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),

Line 362: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),

358: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
359: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
360: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
361: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
362: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
363: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
364: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
365: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
366: LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER, p_LEAD_NUMBER),

Line 363: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),

359: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
360: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
361: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
362: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
363: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
364: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
365: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
366: LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER, p_LEAD_NUMBER),
367: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),

Line 364: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),

360: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
361: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
362: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
363: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
364: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
365: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
366: LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER, p_LEAD_NUMBER),
367: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
368: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID, p_CUSTOMER_ID),

Line 365: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),

361: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
362: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
363: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
364: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
365: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
366: LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER, p_LEAD_NUMBER),
367: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
368: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID, p_CUSTOMER_ID),
369: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID, p_ADDRESS_ID),

Line 366: LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER, p_LEAD_NUMBER),

362: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
363: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
364: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
365: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
366: LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER, p_LEAD_NUMBER),
367: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
368: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID, p_CUSTOMER_ID),
369: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID, p_ADDRESS_ID),
370: SALES_STAGE_ID = decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, SALES_STAGE_ID, p_SALES_STAGE_ID),

Line 367: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),

363: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
364: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
365: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
366: LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER, p_LEAD_NUMBER),
367: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
368: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID, p_CUSTOMER_ID),
369: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID, p_ADDRESS_ID),
370: SALES_STAGE_ID = decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, SALES_STAGE_ID, p_SALES_STAGE_ID),
371: INITIATING_CONTACT_ID = decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, INITIATING_CONTACT_ID, p_INITIATING_CONTACT_ID),

Line 368: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID, p_CUSTOMER_ID),

364: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
365: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
366: LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER, p_LEAD_NUMBER),
367: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
368: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID, p_CUSTOMER_ID),
369: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID, p_ADDRESS_ID),
370: SALES_STAGE_ID = decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, SALES_STAGE_ID, p_SALES_STAGE_ID),
371: INITIATING_CONTACT_ID = decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, INITIATING_CONTACT_ID, p_INITIATING_CONTACT_ID),
372: CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, p_CHANNEL_CODE),

Line 369: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID, p_ADDRESS_ID),

365: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
366: LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER, p_LEAD_NUMBER),
367: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
368: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID, p_CUSTOMER_ID),
369: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID, p_ADDRESS_ID),
370: SALES_STAGE_ID = decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, SALES_STAGE_ID, p_SALES_STAGE_ID),
371: INITIATING_CONTACT_ID = decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, INITIATING_CONTACT_ID, p_INITIATING_CONTACT_ID),
372: CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, p_CHANNEL_CODE),
373: TOTAL_AMOUNT = decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, TOTAL_AMOUNT, p_TOTAL_AMOUNT),

Line 370: SALES_STAGE_ID = decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, SALES_STAGE_ID, p_SALES_STAGE_ID),

366: LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER, p_LEAD_NUMBER),
367: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
368: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID, p_CUSTOMER_ID),
369: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID, p_ADDRESS_ID),
370: SALES_STAGE_ID = decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, SALES_STAGE_ID, p_SALES_STAGE_ID),
371: INITIATING_CONTACT_ID = decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, INITIATING_CONTACT_ID, p_INITIATING_CONTACT_ID),
372: CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, p_CHANNEL_CODE),
373: TOTAL_AMOUNT = decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, TOTAL_AMOUNT, p_TOTAL_AMOUNT),
374: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),

Line 371: INITIATING_CONTACT_ID = decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, INITIATING_CONTACT_ID, p_INITIATING_CONTACT_ID),

367: STATUS = decode( p_STATUS, FND_API.G_MISS_CHAR, STATUS, p_STATUS),
368: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID, p_CUSTOMER_ID),
369: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID, p_ADDRESS_ID),
370: SALES_STAGE_ID = decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, SALES_STAGE_ID, p_SALES_STAGE_ID),
371: INITIATING_CONTACT_ID = decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, INITIATING_CONTACT_ID, p_INITIATING_CONTACT_ID),
372: CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, p_CHANNEL_CODE),
373: TOTAL_AMOUNT = decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, TOTAL_AMOUNT, p_TOTAL_AMOUNT),
374: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
375: DECISION_DATE = decode( p_DECISION_DATE, FND_API.G_MISS_DATE, DECISION_DATE, p_DECISION_DATE),

Line 372: CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, p_CHANNEL_CODE),

368: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID, p_CUSTOMER_ID),
369: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID, p_ADDRESS_ID),
370: SALES_STAGE_ID = decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, SALES_STAGE_ID, p_SALES_STAGE_ID),
371: INITIATING_CONTACT_ID = decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, INITIATING_CONTACT_ID, p_INITIATING_CONTACT_ID),
372: CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, p_CHANNEL_CODE),
373: TOTAL_AMOUNT = decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, TOTAL_AMOUNT, p_TOTAL_AMOUNT),
374: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
375: DECISION_DATE = decode( p_DECISION_DATE, FND_API.G_MISS_DATE, DECISION_DATE, p_DECISION_DATE),
376: WIN_PROBABILITY = decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, WIN_PROBABILITY, p_WIN_PROBABILITY),

Line 373: TOTAL_AMOUNT = decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, TOTAL_AMOUNT, p_TOTAL_AMOUNT),

369: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID, p_ADDRESS_ID),
370: SALES_STAGE_ID = decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, SALES_STAGE_ID, p_SALES_STAGE_ID),
371: INITIATING_CONTACT_ID = decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, INITIATING_CONTACT_ID, p_INITIATING_CONTACT_ID),
372: CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, p_CHANNEL_CODE),
373: TOTAL_AMOUNT = decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, TOTAL_AMOUNT, p_TOTAL_AMOUNT),
374: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
375: DECISION_DATE = decode( p_DECISION_DATE, FND_API.G_MISS_DATE, DECISION_DATE, p_DECISION_DATE),
376: WIN_PROBABILITY = decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, WIN_PROBABILITY, p_WIN_PROBABILITY),
377: CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, CLOSE_REASON, p_CLOSE_REASON),

Line 374: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),

370: SALES_STAGE_ID = decode( p_SALES_STAGE_ID, FND_API.G_MISS_NUM, SALES_STAGE_ID, p_SALES_STAGE_ID),
371: INITIATING_CONTACT_ID = decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, INITIATING_CONTACT_ID, p_INITIATING_CONTACT_ID),
372: CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, p_CHANNEL_CODE),
373: TOTAL_AMOUNT = decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, TOTAL_AMOUNT, p_TOTAL_AMOUNT),
374: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
375: DECISION_DATE = decode( p_DECISION_DATE, FND_API.G_MISS_DATE, DECISION_DATE, p_DECISION_DATE),
376: WIN_PROBABILITY = decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, WIN_PROBABILITY, p_WIN_PROBABILITY),
377: CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, CLOSE_REASON, p_CLOSE_REASON),
378: CLOSE_COMPETITOR_CODE = decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR_CODE, p_CLOSE_COMPETITOR_CODE),

Line 375: DECISION_DATE = decode( p_DECISION_DATE, FND_API.G_MISS_DATE, DECISION_DATE, p_DECISION_DATE),

371: INITIATING_CONTACT_ID = decode( p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, INITIATING_CONTACT_ID, p_INITIATING_CONTACT_ID),
372: CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, p_CHANNEL_CODE),
373: TOTAL_AMOUNT = decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, TOTAL_AMOUNT, p_TOTAL_AMOUNT),
374: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
375: DECISION_DATE = decode( p_DECISION_DATE, FND_API.G_MISS_DATE, DECISION_DATE, p_DECISION_DATE),
376: WIN_PROBABILITY = decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, WIN_PROBABILITY, p_WIN_PROBABILITY),
377: CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, CLOSE_REASON, p_CLOSE_REASON),
378: CLOSE_COMPETITOR_CODE = decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR_CODE, p_CLOSE_COMPETITOR_CODE),
379: CLOSE_COMPETITOR = decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR, p_CLOSE_COMPETITOR),

Line 376: WIN_PROBABILITY = decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, WIN_PROBABILITY, p_WIN_PROBABILITY),

372: CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, p_CHANNEL_CODE),
373: TOTAL_AMOUNT = decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, TOTAL_AMOUNT, p_TOTAL_AMOUNT),
374: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
375: DECISION_DATE = decode( p_DECISION_DATE, FND_API.G_MISS_DATE, DECISION_DATE, p_DECISION_DATE),
376: WIN_PROBABILITY = decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, WIN_PROBABILITY, p_WIN_PROBABILITY),
377: CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, CLOSE_REASON, p_CLOSE_REASON),
378: CLOSE_COMPETITOR_CODE = decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR_CODE, p_CLOSE_COMPETITOR_CODE),
379: CLOSE_COMPETITOR = decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR, p_CLOSE_COMPETITOR),
380: CLOSE_COMMENT = decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, CLOSE_COMMENT, p_CLOSE_COMMENT),

Line 377: CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, CLOSE_REASON, p_CLOSE_REASON),

373: TOTAL_AMOUNT = decode( p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, TOTAL_AMOUNT, p_TOTAL_AMOUNT),
374: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
375: DECISION_DATE = decode( p_DECISION_DATE, FND_API.G_MISS_DATE, DECISION_DATE, p_DECISION_DATE),
376: WIN_PROBABILITY = decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, WIN_PROBABILITY, p_WIN_PROBABILITY),
377: CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, CLOSE_REASON, p_CLOSE_REASON),
378: CLOSE_COMPETITOR_CODE = decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR_CODE, p_CLOSE_COMPETITOR_CODE),
379: CLOSE_COMPETITOR = decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR, p_CLOSE_COMPETITOR),
380: CLOSE_COMMENT = decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, CLOSE_COMMENT, p_CLOSE_COMMENT),
381: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),

Line 378: CLOSE_COMPETITOR_CODE = decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR_CODE, p_CLOSE_COMPETITOR_CODE),

374: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
375: DECISION_DATE = decode( p_DECISION_DATE, FND_API.G_MISS_DATE, DECISION_DATE, p_DECISION_DATE),
376: WIN_PROBABILITY = decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, WIN_PROBABILITY, p_WIN_PROBABILITY),
377: CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, CLOSE_REASON, p_CLOSE_REASON),
378: CLOSE_COMPETITOR_CODE = decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR_CODE, p_CLOSE_COMPETITOR_CODE),
379: CLOSE_COMPETITOR = decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR, p_CLOSE_COMPETITOR),
380: CLOSE_COMMENT = decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, CLOSE_COMMENT, p_CLOSE_COMMENT),
381: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
382: RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),

Line 379: CLOSE_COMPETITOR = decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR, p_CLOSE_COMPETITOR),

375: DECISION_DATE = decode( p_DECISION_DATE, FND_API.G_MISS_DATE, DECISION_DATE, p_DECISION_DATE),
376: WIN_PROBABILITY = decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, WIN_PROBABILITY, p_WIN_PROBABILITY),
377: CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, CLOSE_REASON, p_CLOSE_REASON),
378: CLOSE_COMPETITOR_CODE = decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR_CODE, p_CLOSE_COMPETITOR_CODE),
379: CLOSE_COMPETITOR = decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR, p_CLOSE_COMPETITOR),
380: CLOSE_COMMENT = decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, CLOSE_COMMENT, p_CLOSE_COMMENT),
381: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
382: RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),
383: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID, p_SOURCE_PROMOTION_ID),

Line 380: CLOSE_COMMENT = decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, CLOSE_COMMENT, p_CLOSE_COMMENT),

376: WIN_PROBABILITY = decode( p_WIN_PROBABILITY, FND_API.G_MISS_NUM, WIN_PROBABILITY, p_WIN_PROBABILITY),
377: CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, CLOSE_REASON, p_CLOSE_REASON),
378: CLOSE_COMPETITOR_CODE = decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR_CODE, p_CLOSE_COMPETITOR_CODE),
379: CLOSE_COMPETITOR = decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR, p_CLOSE_COMPETITOR),
380: CLOSE_COMMENT = decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, CLOSE_COMMENT, p_CLOSE_COMMENT),
381: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
382: RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),
383: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID, p_SOURCE_PROMOTION_ID),
384: END_USER_CUSTOMER_ID = decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, END_USER_CUSTOMER_ID, p_END_USER_CUSTOMER_ID),

Line 381: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),

377: CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR, CLOSE_REASON, p_CLOSE_REASON),
378: CLOSE_COMPETITOR_CODE = decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR_CODE, p_CLOSE_COMPETITOR_CODE),
379: CLOSE_COMPETITOR = decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR, p_CLOSE_COMPETITOR),
380: CLOSE_COMMENT = decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, CLOSE_COMMENT, p_CLOSE_COMMENT),
381: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
382: RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),
383: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID, p_SOURCE_PROMOTION_ID),
384: END_USER_CUSTOMER_ID = decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, END_USER_CUSTOMER_ID, p_END_USER_CUSTOMER_ID),
385: END_USER_ADDRESS_ID = decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, END_USER_ADDRESS_ID, p_END_USER_ADDRESS_ID),

Line 382: RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),

378: CLOSE_COMPETITOR_CODE = decode( p_CLOSE_COMPETITOR_CODE, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR_CODE, p_CLOSE_COMPETITOR_CODE),
379: CLOSE_COMPETITOR = decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR, p_CLOSE_COMPETITOR),
380: CLOSE_COMMENT = decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, CLOSE_COMMENT, p_CLOSE_COMMENT),
381: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
382: RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),
383: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID, p_SOURCE_PROMOTION_ID),
384: END_USER_CUSTOMER_ID = decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, END_USER_CUSTOMER_ID, p_END_USER_CUSTOMER_ID),
385: END_USER_ADDRESS_ID = decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, END_USER_ADDRESS_ID, p_END_USER_ADDRESS_ID),
386: OWNER_SALESFORCE_ID = decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, OWNER_SALESFORCE_ID, p_OWNER_SALESFORCE_ID),

Line 383: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID, p_SOURCE_PROMOTION_ID),

379: CLOSE_COMPETITOR = decode( p_CLOSE_COMPETITOR, FND_API.G_MISS_CHAR, CLOSE_COMPETITOR, p_CLOSE_COMPETITOR),
380: CLOSE_COMMENT = decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, CLOSE_COMMENT, p_CLOSE_COMMENT),
381: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
382: RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),
383: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID, p_SOURCE_PROMOTION_ID),
384: END_USER_CUSTOMER_ID = decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, END_USER_CUSTOMER_ID, p_END_USER_CUSTOMER_ID),
385: END_USER_ADDRESS_ID = decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, END_USER_ADDRESS_ID, p_END_USER_ADDRESS_ID),
386: OWNER_SALESFORCE_ID = decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, OWNER_SALESFORCE_ID, p_OWNER_SALESFORCE_ID),
387: OWNER_SALES_GROUP_ID = decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, OWNER_SALES_GROUP_ID , p_OWNER_SALES_GROUP_ID),

Line 384: END_USER_CUSTOMER_ID = decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, END_USER_CUSTOMER_ID, p_END_USER_CUSTOMER_ID),

380: CLOSE_COMMENT = decode( p_CLOSE_COMMENT, FND_API.G_MISS_CHAR, CLOSE_COMMENT, p_CLOSE_COMMENT),
381: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
382: RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),
383: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID, p_SOURCE_PROMOTION_ID),
384: END_USER_CUSTOMER_ID = decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, END_USER_CUSTOMER_ID, p_END_USER_CUSTOMER_ID),
385: END_USER_ADDRESS_ID = decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, END_USER_ADDRESS_ID, p_END_USER_ADDRESS_ID),
386: OWNER_SALESFORCE_ID = decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, OWNER_SALESFORCE_ID, p_OWNER_SALESFORCE_ID),
387: OWNER_SALES_GROUP_ID = decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, OWNER_SALES_GROUP_ID , p_OWNER_SALES_GROUP_ID),
388: --OWNER_ASSIGN_DATE = decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, OWNER_ASSIGN_DATE, p_OWNER_ASSIGN_DATE),

Line 385: END_USER_ADDRESS_ID = decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, END_USER_ADDRESS_ID, p_END_USER_ADDRESS_ID),

381: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
382: RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),
383: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID, p_SOURCE_PROMOTION_ID),
384: END_USER_CUSTOMER_ID = decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, END_USER_CUSTOMER_ID, p_END_USER_CUSTOMER_ID),
385: END_USER_ADDRESS_ID = decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, END_USER_ADDRESS_ID, p_END_USER_ADDRESS_ID),
386: OWNER_SALESFORCE_ID = decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, OWNER_SALESFORCE_ID, p_OWNER_SALESFORCE_ID),
387: OWNER_SALES_GROUP_ID = decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, OWNER_SALES_GROUP_ID , p_OWNER_SALES_GROUP_ID),
388: --OWNER_ASSIGN_DATE = decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, OWNER_ASSIGN_DATE, p_OWNER_ASSIGN_DATE),
389: --ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID),

Line 386: OWNER_SALESFORCE_ID = decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, OWNER_SALESFORCE_ID, p_OWNER_SALESFORCE_ID),

382: RANK = decode( p_RANK, FND_API.G_MISS_CHAR, RANK, p_RANK),
383: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID, p_SOURCE_PROMOTION_ID),
384: END_USER_CUSTOMER_ID = decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, END_USER_CUSTOMER_ID, p_END_USER_CUSTOMER_ID),
385: END_USER_ADDRESS_ID = decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, END_USER_ADDRESS_ID, p_END_USER_ADDRESS_ID),
386: OWNER_SALESFORCE_ID = decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, OWNER_SALESFORCE_ID, p_OWNER_SALESFORCE_ID),
387: OWNER_SALES_GROUP_ID = decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, OWNER_SALES_GROUP_ID , p_OWNER_SALES_GROUP_ID),
388: --OWNER_ASSIGN_DATE = decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, OWNER_ASSIGN_DATE, p_OWNER_ASSIGN_DATE),
389: --ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID),
390: NO_OPP_ALLOWED_FLAG = decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NO_OPP_ALLOWED_FLAG, p_NO_OPP_ALLOWED_FLAG),

Line 387: OWNER_SALES_GROUP_ID = decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, OWNER_SALES_GROUP_ID , p_OWNER_SALES_GROUP_ID),

383: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID, p_SOURCE_PROMOTION_ID),
384: END_USER_CUSTOMER_ID = decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, END_USER_CUSTOMER_ID, p_END_USER_CUSTOMER_ID),
385: END_USER_ADDRESS_ID = decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, END_USER_ADDRESS_ID, p_END_USER_ADDRESS_ID),
386: OWNER_SALESFORCE_ID = decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, OWNER_SALESFORCE_ID, p_OWNER_SALESFORCE_ID),
387: OWNER_SALES_GROUP_ID = decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, OWNER_SALES_GROUP_ID , p_OWNER_SALES_GROUP_ID),
388: --OWNER_ASSIGN_DATE = decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, OWNER_ASSIGN_DATE, p_OWNER_ASSIGN_DATE),
389: --ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID),
390: NO_OPP_ALLOWED_FLAG = decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NO_OPP_ALLOWED_FLAG, p_NO_OPP_ALLOWED_FLAG),
391: DELETE_ALLOWED_FLAG = decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, DELETE_ALLOWED_FLAG, p_DELETE_ALLOWED_FLAG),

Line 388: --OWNER_ASSIGN_DATE = decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, OWNER_ASSIGN_DATE, p_OWNER_ASSIGN_DATE),

384: END_USER_CUSTOMER_ID = decode( p_END_USER_CUSTOMER_ID, FND_API.G_MISS_NUM, END_USER_CUSTOMER_ID, p_END_USER_CUSTOMER_ID),
385: END_USER_ADDRESS_ID = decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, END_USER_ADDRESS_ID, p_END_USER_ADDRESS_ID),
386: OWNER_SALESFORCE_ID = decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, OWNER_SALESFORCE_ID, p_OWNER_SALESFORCE_ID),
387: OWNER_SALES_GROUP_ID = decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, OWNER_SALES_GROUP_ID , p_OWNER_SALES_GROUP_ID),
388: --OWNER_ASSIGN_DATE = decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, OWNER_ASSIGN_DATE, p_OWNER_ASSIGN_DATE),
389: --ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID),
390: NO_OPP_ALLOWED_FLAG = decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NO_OPP_ALLOWED_FLAG, p_NO_OPP_ALLOWED_FLAG),
391: DELETE_ALLOWED_FLAG = decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, DELETE_ALLOWED_FLAG, p_DELETE_ALLOWED_FLAG),
392: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

Line 389: --ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID),

385: END_USER_ADDRESS_ID = decode( p_END_USER_ADDRESS_ID, FND_API.G_MISS_NUM, END_USER_ADDRESS_ID, p_END_USER_ADDRESS_ID),
386: OWNER_SALESFORCE_ID = decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, OWNER_SALESFORCE_ID, p_OWNER_SALESFORCE_ID),
387: OWNER_SALES_GROUP_ID = decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, OWNER_SALES_GROUP_ID , p_OWNER_SALES_GROUP_ID),
388: --OWNER_ASSIGN_DATE = decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, OWNER_ASSIGN_DATE, p_OWNER_ASSIGN_DATE),
389: --ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID),
390: NO_OPP_ALLOWED_FLAG = decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NO_OPP_ALLOWED_FLAG, p_NO_OPP_ALLOWED_FLAG),
391: DELETE_ALLOWED_FLAG = decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, DELETE_ALLOWED_FLAG, p_DELETE_ALLOWED_FLAG),
392: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
393: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

Line 390: NO_OPP_ALLOWED_FLAG = decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NO_OPP_ALLOWED_FLAG, p_NO_OPP_ALLOWED_FLAG),

386: OWNER_SALESFORCE_ID = decode( p_OWNER_SALESFORCE_ID, FND_API.G_MISS_NUM, OWNER_SALESFORCE_ID, p_OWNER_SALESFORCE_ID),
387: OWNER_SALES_GROUP_ID = decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, OWNER_SALES_GROUP_ID , p_OWNER_SALES_GROUP_ID),
388: --OWNER_ASSIGN_DATE = decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, OWNER_ASSIGN_DATE, p_OWNER_ASSIGN_DATE),
389: --ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID),
390: NO_OPP_ALLOWED_FLAG = decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NO_OPP_ALLOWED_FLAG, p_NO_OPP_ALLOWED_FLAG),
391: DELETE_ALLOWED_FLAG = decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, DELETE_ALLOWED_FLAG, p_DELETE_ALLOWED_FLAG),
392: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
393: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
394: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

Line 391: DELETE_ALLOWED_FLAG = decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, DELETE_ALLOWED_FLAG, p_DELETE_ALLOWED_FLAG),

387: OWNER_SALES_GROUP_ID = decode( p_OWNER_SALES_GROUP_ID, FND_API.G_MISS_NUM, OWNER_SALES_GROUP_ID , p_OWNER_SALES_GROUP_ID),
388: --OWNER_ASSIGN_DATE = decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, OWNER_ASSIGN_DATE, p_OWNER_ASSIGN_DATE),
389: --ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID),
390: NO_OPP_ALLOWED_FLAG = decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NO_OPP_ALLOWED_FLAG, p_NO_OPP_ALLOWED_FLAG),
391: DELETE_ALLOWED_FLAG = decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, DELETE_ALLOWED_FLAG, p_DELETE_ALLOWED_FLAG),
392: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
393: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
394: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
395: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

Line 392: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

388: --OWNER_ASSIGN_DATE = decode( p_OWNER_ASSIGN_DATE, FND_API.G_MISS_DATE, OWNER_ASSIGN_DATE, p_OWNER_ASSIGN_DATE),
389: --ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID),
390: NO_OPP_ALLOWED_FLAG = decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NO_OPP_ALLOWED_FLAG, p_NO_OPP_ALLOWED_FLAG),
391: DELETE_ALLOWED_FLAG = decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, DELETE_ALLOWED_FLAG, p_DELETE_ALLOWED_FLAG),
392: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
393: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
394: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
395: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
396: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

Line 393: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

389: --ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID),
390: NO_OPP_ALLOWED_FLAG = decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NO_OPP_ALLOWED_FLAG, p_NO_OPP_ALLOWED_FLAG),
391: DELETE_ALLOWED_FLAG = decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, DELETE_ALLOWED_FLAG, p_DELETE_ALLOWED_FLAG),
392: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
393: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
394: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
395: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
396: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
397: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

Line 394: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

390: NO_OPP_ALLOWED_FLAG = decode( p_NO_OPP_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NO_OPP_ALLOWED_FLAG, p_NO_OPP_ALLOWED_FLAG),
391: DELETE_ALLOWED_FLAG = decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, DELETE_ALLOWED_FLAG, p_DELETE_ALLOWED_FLAG),
392: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
393: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
394: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
395: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
396: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
397: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
398: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

Line 395: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

391: DELETE_ALLOWED_FLAG = decode( p_DELETE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, DELETE_ALLOWED_FLAG, p_DELETE_ALLOWED_FLAG),
392: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
393: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
394: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
395: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
396: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
397: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
398: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
399: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

Line 396: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

392: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
393: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
394: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
395: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
396: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
397: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
398: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
399: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
400: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

Line 397: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

393: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
394: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
395: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
396: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
397: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
398: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
399: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
400: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
401: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

Line 398: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

394: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
395: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
396: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
397: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
398: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
399: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
400: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
401: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
402: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

Line 399: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

395: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
396: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
397: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
398: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
399: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
400: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
401: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
402: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
403: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

Line 400: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

396: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
397: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
398: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
399: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
400: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
401: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
402: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
403: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
404: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

Line 401: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

397: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
398: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
399: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
400: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
401: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
402: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
403: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
404: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
405: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

Line 402: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

398: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
399: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
400: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
401: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
402: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
403: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
404: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
405: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
406: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

Line 403: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

399: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
400: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
401: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
402: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
403: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
404: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
405: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
406: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
407: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),

Line 404: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

400: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
401: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
402: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
403: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
404: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
405: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
406: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
407: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
408: PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, PARENT_PROJECT, p_PARENT_PROJECT),

Line 405: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

401: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
402: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
403: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
404: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
405: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
406: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
407: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
408: PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, PARENT_PROJECT, p_PARENT_PROJECT),
409: LEAD_SOURCE_CODE = decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, LEAD_SOURCE_CODE, p_LEAD_SOURCE_CODE),

Line 406: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

402: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
403: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
404: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
405: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
406: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
407: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
408: PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, PARENT_PROJECT, p_PARENT_PROJECT),
409: LEAD_SOURCE_CODE = decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, LEAD_SOURCE_CODE, p_LEAD_SOURCE_CODE),
410: ORIG_SYSTEM_REFERENCE = decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, p_ORIG_SYSTEM_REFERENCE),

Line 407: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),

403: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
404: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
405: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
406: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
407: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
408: PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, PARENT_PROJECT, p_PARENT_PROJECT),
409: LEAD_SOURCE_CODE = decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, LEAD_SOURCE_CODE, p_LEAD_SOURCE_CODE),
410: ORIG_SYSTEM_REFERENCE = decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, p_ORIG_SYSTEM_REFERENCE),
411: CLOSE_COMPETITOR_ID = decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, CLOSE_COMPETITOR_ID, p_CLOSE_COMPETITOR_ID),

Line 408: PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, PARENT_PROJECT, p_PARENT_PROJECT),

404: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
405: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
406: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
407: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
408: PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, PARENT_PROJECT, p_PARENT_PROJECT),
409: LEAD_SOURCE_CODE = decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, LEAD_SOURCE_CODE, p_LEAD_SOURCE_CODE),
410: ORIG_SYSTEM_REFERENCE = decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, p_ORIG_SYSTEM_REFERENCE),
411: CLOSE_COMPETITOR_ID = decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, CLOSE_COMPETITOR_ID, p_CLOSE_COMPETITOR_ID),
412: END_USER_CUSTOMER_NAME = decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, END_USER_CUSTOMER_NAME, p_END_USER_CUSTOMER_NAME),

Line 409: LEAD_SOURCE_CODE = decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, LEAD_SOURCE_CODE, p_LEAD_SOURCE_CODE),

405: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
406: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
407: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
408: PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, PARENT_PROJECT, p_PARENT_PROJECT),
409: LEAD_SOURCE_CODE = decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, LEAD_SOURCE_CODE, p_LEAD_SOURCE_CODE),
410: ORIG_SYSTEM_REFERENCE = decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, p_ORIG_SYSTEM_REFERENCE),
411: CLOSE_COMPETITOR_ID = decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, CLOSE_COMPETITOR_ID, p_CLOSE_COMPETITOR_ID),
412: END_USER_CUSTOMER_NAME = decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, END_USER_CUSTOMER_NAME, p_END_USER_CUSTOMER_NAME),
413: PRICE_LIST_ID = decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, PRICE_LIST_ID, p_PRICE_LIST_ID),

Line 410: ORIG_SYSTEM_REFERENCE = decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, p_ORIG_SYSTEM_REFERENCE),

406: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
407: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
408: PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, PARENT_PROJECT, p_PARENT_PROJECT),
409: LEAD_SOURCE_CODE = decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, LEAD_SOURCE_CODE, p_LEAD_SOURCE_CODE),
410: ORIG_SYSTEM_REFERENCE = decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, p_ORIG_SYSTEM_REFERENCE),
411: CLOSE_COMPETITOR_ID = decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, CLOSE_COMPETITOR_ID, p_CLOSE_COMPETITOR_ID),
412: END_USER_CUSTOMER_NAME = decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, END_USER_CUSTOMER_NAME, p_END_USER_CUSTOMER_NAME),
413: PRICE_LIST_ID = decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, PRICE_LIST_ID, p_PRICE_LIST_ID),
414: DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, DELETED_FLAG, p_DELETED_FLAG),

Line 411: CLOSE_COMPETITOR_ID = decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, CLOSE_COMPETITOR_ID, p_CLOSE_COMPETITOR_ID),

407: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
408: PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, PARENT_PROJECT, p_PARENT_PROJECT),
409: LEAD_SOURCE_CODE = decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, LEAD_SOURCE_CODE, p_LEAD_SOURCE_CODE),
410: ORIG_SYSTEM_REFERENCE = decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, p_ORIG_SYSTEM_REFERENCE),
411: CLOSE_COMPETITOR_ID = decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, CLOSE_COMPETITOR_ID, p_CLOSE_COMPETITOR_ID),
412: END_USER_CUSTOMER_NAME = decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, END_USER_CUSTOMER_NAME, p_END_USER_CUSTOMER_NAME),
413: PRICE_LIST_ID = decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, PRICE_LIST_ID, p_PRICE_LIST_ID),
414: DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, DELETED_FLAG, p_DELETED_FLAG),
415: AUTO_ASSIGNMENT_TYPE = decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, AUTO_ASSIGNMENT_TYPE, p_AUTO_ASSIGNMENT_TYPE),

Line 412: END_USER_CUSTOMER_NAME = decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, END_USER_CUSTOMER_NAME, p_END_USER_CUSTOMER_NAME),

408: PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR, PARENT_PROJECT, p_PARENT_PROJECT),
409: LEAD_SOURCE_CODE = decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, LEAD_SOURCE_CODE, p_LEAD_SOURCE_CODE),
410: ORIG_SYSTEM_REFERENCE = decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, p_ORIG_SYSTEM_REFERENCE),
411: CLOSE_COMPETITOR_ID = decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, CLOSE_COMPETITOR_ID, p_CLOSE_COMPETITOR_ID),
412: END_USER_CUSTOMER_NAME = decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, END_USER_CUSTOMER_NAME, p_END_USER_CUSTOMER_NAME),
413: PRICE_LIST_ID = decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, PRICE_LIST_ID, p_PRICE_LIST_ID),
414: DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, DELETED_FLAG, p_DELETED_FLAG),
415: AUTO_ASSIGNMENT_TYPE = decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, AUTO_ASSIGNMENT_TYPE, p_AUTO_ASSIGNMENT_TYPE),
416: PRM_ASSIGNMENT_TYPE = decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, PRM_ASSIGNMENT_TYPE, p_PRM_ASSIGNMENT_TYPE),

Line 413: PRICE_LIST_ID = decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, PRICE_LIST_ID, p_PRICE_LIST_ID),

409: LEAD_SOURCE_CODE = decode( p_LEAD_SOURCE_CODE, FND_API.G_MISS_CHAR, LEAD_SOURCE_CODE, p_LEAD_SOURCE_CODE),
410: ORIG_SYSTEM_REFERENCE = decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, p_ORIG_SYSTEM_REFERENCE),
411: CLOSE_COMPETITOR_ID = decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, CLOSE_COMPETITOR_ID, p_CLOSE_COMPETITOR_ID),
412: END_USER_CUSTOMER_NAME = decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, END_USER_CUSTOMER_NAME, p_END_USER_CUSTOMER_NAME),
413: PRICE_LIST_ID = decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, PRICE_LIST_ID, p_PRICE_LIST_ID),
414: DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, DELETED_FLAG, p_DELETED_FLAG),
415: AUTO_ASSIGNMENT_TYPE = decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, AUTO_ASSIGNMENT_TYPE, p_AUTO_ASSIGNMENT_TYPE),
416: PRM_ASSIGNMENT_TYPE = decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, PRM_ASSIGNMENT_TYPE, p_PRM_ASSIGNMENT_TYPE),
417: CUSTOMER_BUDGET = decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, CUSTOMER_BUDGET, p_CUSTOMER_BUDGET),

Line 414: DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, DELETED_FLAG, p_DELETED_FLAG),

410: ORIG_SYSTEM_REFERENCE = decode( p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, p_ORIG_SYSTEM_REFERENCE),
411: CLOSE_COMPETITOR_ID = decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, CLOSE_COMPETITOR_ID, p_CLOSE_COMPETITOR_ID),
412: END_USER_CUSTOMER_NAME = decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, END_USER_CUSTOMER_NAME, p_END_USER_CUSTOMER_NAME),
413: PRICE_LIST_ID = decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, PRICE_LIST_ID, p_PRICE_LIST_ID),
414: DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, DELETED_FLAG, p_DELETED_FLAG),
415: AUTO_ASSIGNMENT_TYPE = decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, AUTO_ASSIGNMENT_TYPE, p_AUTO_ASSIGNMENT_TYPE),
416: PRM_ASSIGNMENT_TYPE = decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, PRM_ASSIGNMENT_TYPE, p_PRM_ASSIGNMENT_TYPE),
417: CUSTOMER_BUDGET = decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, CUSTOMER_BUDGET, p_CUSTOMER_BUDGET),
418: METHODOLOGY_CODE = decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, METHODOLOGY_CODE, p_METHODOLOGY_CODE),

Line 415: AUTO_ASSIGNMENT_TYPE = decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, AUTO_ASSIGNMENT_TYPE, p_AUTO_ASSIGNMENT_TYPE),

411: CLOSE_COMPETITOR_ID = decode( p_CLOSE_COMPETITOR_ID, FND_API.G_MISS_NUM, CLOSE_COMPETITOR_ID, p_CLOSE_COMPETITOR_ID),
412: END_USER_CUSTOMER_NAME = decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, END_USER_CUSTOMER_NAME, p_END_USER_CUSTOMER_NAME),
413: PRICE_LIST_ID = decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, PRICE_LIST_ID, p_PRICE_LIST_ID),
414: DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, DELETED_FLAG, p_DELETED_FLAG),
415: AUTO_ASSIGNMENT_TYPE = decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, AUTO_ASSIGNMENT_TYPE, p_AUTO_ASSIGNMENT_TYPE),
416: PRM_ASSIGNMENT_TYPE = decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, PRM_ASSIGNMENT_TYPE, p_PRM_ASSIGNMENT_TYPE),
417: CUSTOMER_BUDGET = decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, CUSTOMER_BUDGET, p_CUSTOMER_BUDGET),
418: METHODOLOGY_CODE = decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, METHODOLOGY_CODE, p_METHODOLOGY_CODE),
419: SALES_METHODOLOGY_ID = decode(p_SALES_METHODOLOGY_ID , FND_API.G_MISS_NUM, SALES_METHODOLOGY_ID, p_SALES_METHODOLOGY_ID),

Line 416: PRM_ASSIGNMENT_TYPE = decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, PRM_ASSIGNMENT_TYPE, p_PRM_ASSIGNMENT_TYPE),

412: END_USER_CUSTOMER_NAME = decode( p_END_USER_CUSTOMER_NAME, FND_API.G_MISS_CHAR, END_USER_CUSTOMER_NAME, p_END_USER_CUSTOMER_NAME),
413: PRICE_LIST_ID = decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, PRICE_LIST_ID, p_PRICE_LIST_ID),
414: DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, DELETED_FLAG, p_DELETED_FLAG),
415: AUTO_ASSIGNMENT_TYPE = decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, AUTO_ASSIGNMENT_TYPE, p_AUTO_ASSIGNMENT_TYPE),
416: PRM_ASSIGNMENT_TYPE = decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, PRM_ASSIGNMENT_TYPE, p_PRM_ASSIGNMENT_TYPE),
417: CUSTOMER_BUDGET = decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, CUSTOMER_BUDGET, p_CUSTOMER_BUDGET),
418: METHODOLOGY_CODE = decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, METHODOLOGY_CODE, p_METHODOLOGY_CODE),
419: SALES_METHODOLOGY_ID = decode(p_SALES_METHODOLOGY_ID , FND_API.G_MISS_NUM, SALES_METHODOLOGY_ID, p_SALES_METHODOLOGY_ID),
420: ORIGINAL_LEAD_ID = decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, ORIGINAL_LEAD_ID, p_ORIGINAL_LEAD_ID),

Line 417: CUSTOMER_BUDGET = decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, CUSTOMER_BUDGET, p_CUSTOMER_BUDGET),

413: PRICE_LIST_ID = decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, PRICE_LIST_ID, p_PRICE_LIST_ID),
414: DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, DELETED_FLAG, p_DELETED_FLAG),
415: AUTO_ASSIGNMENT_TYPE = decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, AUTO_ASSIGNMENT_TYPE, p_AUTO_ASSIGNMENT_TYPE),
416: PRM_ASSIGNMENT_TYPE = decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, PRM_ASSIGNMENT_TYPE, p_PRM_ASSIGNMENT_TYPE),
417: CUSTOMER_BUDGET = decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, CUSTOMER_BUDGET, p_CUSTOMER_BUDGET),
418: METHODOLOGY_CODE = decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, METHODOLOGY_CODE, p_METHODOLOGY_CODE),
419: SALES_METHODOLOGY_ID = decode(p_SALES_METHODOLOGY_ID , FND_API.G_MISS_NUM, SALES_METHODOLOGY_ID, p_SALES_METHODOLOGY_ID),
420: ORIGINAL_LEAD_ID = decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, ORIGINAL_LEAD_ID, p_ORIGINAL_LEAD_ID),
421: DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, DECISION_TIMEFRAME_CODE, p_DECISION_TIMEFRAME_CODE),

Line 418: METHODOLOGY_CODE = decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, METHODOLOGY_CODE, p_METHODOLOGY_CODE),

414: DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR, DELETED_FLAG, p_DELETED_FLAG),
415: AUTO_ASSIGNMENT_TYPE = decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, AUTO_ASSIGNMENT_TYPE, p_AUTO_ASSIGNMENT_TYPE),
416: PRM_ASSIGNMENT_TYPE = decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, PRM_ASSIGNMENT_TYPE, p_PRM_ASSIGNMENT_TYPE),
417: CUSTOMER_BUDGET = decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, CUSTOMER_BUDGET, p_CUSTOMER_BUDGET),
418: METHODOLOGY_CODE = decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, METHODOLOGY_CODE, p_METHODOLOGY_CODE),
419: SALES_METHODOLOGY_ID = decode(p_SALES_METHODOLOGY_ID , FND_API.G_MISS_NUM, SALES_METHODOLOGY_ID, p_SALES_METHODOLOGY_ID),
420: ORIGINAL_LEAD_ID = decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, ORIGINAL_LEAD_ID, p_ORIGINAL_LEAD_ID),
421: DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, DECISION_TIMEFRAME_CODE, p_DECISION_TIMEFRAME_CODE),
422: INCUMBENT_PARTNER_RESOURCE_ID = decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_RESOURCE_ID, p_INC_PARTNER_RESOURCE_ID),

Line 419: SALES_METHODOLOGY_ID = decode(p_SALES_METHODOLOGY_ID , FND_API.G_MISS_NUM, SALES_METHODOLOGY_ID, p_SALES_METHODOLOGY_ID),

415: AUTO_ASSIGNMENT_TYPE = decode( p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, AUTO_ASSIGNMENT_TYPE, p_AUTO_ASSIGNMENT_TYPE),
416: PRM_ASSIGNMENT_TYPE = decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, PRM_ASSIGNMENT_TYPE, p_PRM_ASSIGNMENT_TYPE),
417: CUSTOMER_BUDGET = decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, CUSTOMER_BUDGET, p_CUSTOMER_BUDGET),
418: METHODOLOGY_CODE = decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, METHODOLOGY_CODE, p_METHODOLOGY_CODE),
419: SALES_METHODOLOGY_ID = decode(p_SALES_METHODOLOGY_ID , FND_API.G_MISS_NUM, SALES_METHODOLOGY_ID, p_SALES_METHODOLOGY_ID),
420: ORIGINAL_LEAD_ID = decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, ORIGINAL_LEAD_ID, p_ORIGINAL_LEAD_ID),
421: DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, DECISION_TIMEFRAME_CODE, p_DECISION_TIMEFRAME_CODE),
422: INCUMBENT_PARTNER_RESOURCE_ID = decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_RESOURCE_ID, p_INC_PARTNER_RESOURCE_ID),
423: INCUMBENT_PARTNER_PARTY_ID = decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_PARTY_ID, P_INC_PARTNER_PARTY_ID),

Line 420: ORIGINAL_LEAD_ID = decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, ORIGINAL_LEAD_ID, p_ORIGINAL_LEAD_ID),

416: PRM_ASSIGNMENT_TYPE = decode( p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, PRM_ASSIGNMENT_TYPE, p_PRM_ASSIGNMENT_TYPE),
417: CUSTOMER_BUDGET = decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, CUSTOMER_BUDGET, p_CUSTOMER_BUDGET),
418: METHODOLOGY_CODE = decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, METHODOLOGY_CODE, p_METHODOLOGY_CODE),
419: SALES_METHODOLOGY_ID = decode(p_SALES_METHODOLOGY_ID , FND_API.G_MISS_NUM, SALES_METHODOLOGY_ID, p_SALES_METHODOLOGY_ID),
420: ORIGINAL_LEAD_ID = decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, ORIGINAL_LEAD_ID, p_ORIGINAL_LEAD_ID),
421: DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, DECISION_TIMEFRAME_CODE, p_DECISION_TIMEFRAME_CODE),
422: INCUMBENT_PARTNER_RESOURCE_ID = decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_RESOURCE_ID, p_INC_PARTNER_RESOURCE_ID),
423: INCUMBENT_PARTNER_PARTY_ID = decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_PARTY_ID, P_INC_PARTNER_PARTY_ID),
424: OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),

Line 421: DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, DECISION_TIMEFRAME_CODE, p_DECISION_TIMEFRAME_CODE),

417: CUSTOMER_BUDGET = decode( p_CUSTOMER_BUDGET, FND_API.G_MISS_NUM, CUSTOMER_BUDGET, p_CUSTOMER_BUDGET),
418: METHODOLOGY_CODE = decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, METHODOLOGY_CODE, p_METHODOLOGY_CODE),
419: SALES_METHODOLOGY_ID = decode(p_SALES_METHODOLOGY_ID , FND_API.G_MISS_NUM, SALES_METHODOLOGY_ID, p_SALES_METHODOLOGY_ID),
420: ORIGINAL_LEAD_ID = decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, ORIGINAL_LEAD_ID, p_ORIGINAL_LEAD_ID),
421: DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, DECISION_TIMEFRAME_CODE, p_DECISION_TIMEFRAME_CODE),
422: INCUMBENT_PARTNER_RESOURCE_ID = decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_RESOURCE_ID, p_INC_PARTNER_RESOURCE_ID),
423: INCUMBENT_PARTNER_PARTY_ID = decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_PARTY_ID, P_INC_PARTNER_PARTY_ID),
424: OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
425: VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, VEHICLE_RESPONSE_CODE, p_VEHICLE_RESPONSE_CODE),

Line 422: INCUMBENT_PARTNER_RESOURCE_ID = decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_RESOURCE_ID, p_INC_PARTNER_RESOURCE_ID),

418: METHODOLOGY_CODE = decode( p_METHODOLOGY_CODE, FND_API.G_MISS_CHAR, METHODOLOGY_CODE, p_METHODOLOGY_CODE),
419: SALES_METHODOLOGY_ID = decode(p_SALES_METHODOLOGY_ID , FND_API.G_MISS_NUM, SALES_METHODOLOGY_ID, p_SALES_METHODOLOGY_ID),
420: ORIGINAL_LEAD_ID = decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, ORIGINAL_LEAD_ID, p_ORIGINAL_LEAD_ID),
421: DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, DECISION_TIMEFRAME_CODE, p_DECISION_TIMEFRAME_CODE),
422: INCUMBENT_PARTNER_RESOURCE_ID = decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_RESOURCE_ID, p_INC_PARTNER_RESOURCE_ID),
423: INCUMBENT_PARTNER_PARTY_ID = decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_PARTY_ID, P_INC_PARTNER_PARTY_ID),
424: OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
425: VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, VEHICLE_RESPONSE_CODE, p_VEHICLE_RESPONSE_CODE),
426: BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),

Line 423: INCUMBENT_PARTNER_PARTY_ID = decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_PARTY_ID, P_INC_PARTNER_PARTY_ID),

419: SALES_METHODOLOGY_ID = decode(p_SALES_METHODOLOGY_ID , FND_API.G_MISS_NUM, SALES_METHODOLOGY_ID, p_SALES_METHODOLOGY_ID),
420: ORIGINAL_LEAD_ID = decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, ORIGINAL_LEAD_ID, p_ORIGINAL_LEAD_ID),
421: DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, DECISION_TIMEFRAME_CODE, p_DECISION_TIMEFRAME_CODE),
422: INCUMBENT_PARTNER_RESOURCE_ID = decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_RESOURCE_ID, p_INC_PARTNER_RESOURCE_ID),
423: INCUMBENT_PARTNER_PARTY_ID = decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_PARTY_ID, P_INC_PARTNER_PARTY_ID),
424: OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
425: VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, VEHICLE_RESPONSE_CODE, p_VEHICLE_RESPONSE_CODE),
426: BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),
427: FOLLOWUP_DATE = decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, FOLLOWUP_DATE, p_FOLLOWUP_DATE),

Line 424: OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),

420: ORIGINAL_LEAD_ID = decode( p_ORIGINAL_LEAD_ID, FND_API.G_MISS_NUM, ORIGINAL_LEAD_ID, p_ORIGINAL_LEAD_ID),
421: DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, DECISION_TIMEFRAME_CODE, p_DECISION_TIMEFRAME_CODE),
422: INCUMBENT_PARTNER_RESOURCE_ID = decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_RESOURCE_ID, p_INC_PARTNER_RESOURCE_ID),
423: INCUMBENT_PARTNER_PARTY_ID = decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_PARTY_ID, P_INC_PARTNER_PARTY_ID),
424: OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
425: VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, VEHICLE_RESPONSE_CODE, p_VEHICLE_RESPONSE_CODE),
426: BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),
427: FOLLOWUP_DATE = decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, FOLLOWUP_DATE, p_FOLLOWUP_DATE),
428: PRM_EXEC_SPONSOR_FLAG = decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, PRM_EXEC_SPONSOR_FLAG, p_PRM_EXEC_SPONSOR_FLAG),

Line 425: VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, VEHICLE_RESPONSE_CODE, p_VEHICLE_RESPONSE_CODE),

421: DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, DECISION_TIMEFRAME_CODE, p_DECISION_TIMEFRAME_CODE),
422: INCUMBENT_PARTNER_RESOURCE_ID = decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_RESOURCE_ID, p_INC_PARTNER_RESOURCE_ID),
423: INCUMBENT_PARTNER_PARTY_ID = decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_PARTY_ID, P_INC_PARTNER_PARTY_ID),
424: OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
425: VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, VEHICLE_RESPONSE_CODE, p_VEHICLE_RESPONSE_CODE),
426: BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),
427: FOLLOWUP_DATE = decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, FOLLOWUP_DATE, p_FOLLOWUP_DATE),
428: PRM_EXEC_SPONSOR_FLAG = decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, PRM_EXEC_SPONSOR_FLAG, p_PRM_EXEC_SPONSOR_FLAG),
429: PRM_PRJ_LEAD_IN_PLACE_FLAG = decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, PRM_PRJ_LEAD_IN_PLACE_FLAG, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),

Line 426: BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),

422: INCUMBENT_PARTNER_RESOURCE_ID = decode( p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_RESOURCE_ID, p_INC_PARTNER_RESOURCE_ID),
423: INCUMBENT_PARTNER_PARTY_ID = decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_PARTY_ID, P_INC_PARTNER_PARTY_ID),
424: OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
425: VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, VEHICLE_RESPONSE_CODE, p_VEHICLE_RESPONSE_CODE),
426: BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),
427: FOLLOWUP_DATE = decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, FOLLOWUP_DATE, p_FOLLOWUP_DATE),
428: PRM_EXEC_SPONSOR_FLAG = decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, PRM_EXEC_SPONSOR_FLAG, p_PRM_EXEC_SPONSOR_FLAG),
429: PRM_PRJ_LEAD_IN_PLACE_FLAG = decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, PRM_PRJ_LEAD_IN_PLACE_FLAG, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
430: PRM_IND_CLASSIFICATION_CODE = decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, PRM_IND_CLASSIFICATION_CODE, p_PRM_IND_CLASSIFICATION_CODE),

Line 427: FOLLOWUP_DATE = decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, FOLLOWUP_DATE, p_FOLLOWUP_DATE),

423: INCUMBENT_PARTNER_PARTY_ID = decode( p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, INCUMBENT_PARTNER_PARTY_ID, P_INC_PARTNER_PARTY_ID),
424: OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
425: VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, VEHICLE_RESPONSE_CODE, p_VEHICLE_RESPONSE_CODE),
426: BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),
427: FOLLOWUP_DATE = decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, FOLLOWUP_DATE, p_FOLLOWUP_DATE),
428: PRM_EXEC_SPONSOR_FLAG = decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, PRM_EXEC_SPONSOR_FLAG, p_PRM_EXEC_SPONSOR_FLAG),
429: PRM_PRJ_LEAD_IN_PLACE_FLAG = decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, PRM_PRJ_LEAD_IN_PLACE_FLAG, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
430: PRM_IND_CLASSIFICATION_CODE = decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, PRM_IND_CLASSIFICATION_CODE, p_PRM_IND_CLASSIFICATION_CODE),
431: PRM_LEAD_TYPE = decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR, PRM_LEAD_TYPE, p_PRM_LEAD_TYPE),

Line 428: PRM_EXEC_SPONSOR_FLAG = decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, PRM_EXEC_SPONSOR_FLAG, p_PRM_EXEC_SPONSOR_FLAG),

424: OFFER_ID = decode( p_OFFER_ID, FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
425: VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, VEHICLE_RESPONSE_CODE, p_VEHICLE_RESPONSE_CODE),
426: BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),
427: FOLLOWUP_DATE = decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, FOLLOWUP_DATE, p_FOLLOWUP_DATE),
428: PRM_EXEC_SPONSOR_FLAG = decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, PRM_EXEC_SPONSOR_FLAG, p_PRM_EXEC_SPONSOR_FLAG),
429: PRM_PRJ_LEAD_IN_PLACE_FLAG = decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, PRM_PRJ_LEAD_IN_PLACE_FLAG, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
430: PRM_IND_CLASSIFICATION_CODE = decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, PRM_IND_CLASSIFICATION_CODE, p_PRM_IND_CLASSIFICATION_CODE),
431: PRM_LEAD_TYPE = decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR, PRM_LEAD_TYPE, p_PRM_LEAD_TYPE),
432: FREEZE_FLAG = decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, FREEZE_FLAG, p_FREEZE_FLAG),

Line 429: PRM_PRJ_LEAD_IN_PLACE_FLAG = decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, PRM_PRJ_LEAD_IN_PLACE_FLAG, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),

425: VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, VEHICLE_RESPONSE_CODE, p_VEHICLE_RESPONSE_CODE),
426: BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),
427: FOLLOWUP_DATE = decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, FOLLOWUP_DATE, p_FOLLOWUP_DATE),
428: PRM_EXEC_SPONSOR_FLAG = decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, PRM_EXEC_SPONSOR_FLAG, p_PRM_EXEC_SPONSOR_FLAG),
429: PRM_PRJ_LEAD_IN_PLACE_FLAG = decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, PRM_PRJ_LEAD_IN_PLACE_FLAG, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
430: PRM_IND_CLASSIFICATION_CODE = decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, PRM_IND_CLASSIFICATION_CODE, p_PRM_IND_CLASSIFICATION_CODE),
431: PRM_LEAD_TYPE = decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR, PRM_LEAD_TYPE, p_PRM_LEAD_TYPE),
432: FREEZE_FLAG = decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, FREEZE_FLAG, p_FREEZE_FLAG),
433: PRM_REFERRAL_CODE = decode( p_PRM_REFERRAL_CODE, FND_API.G_MISS_CHAR, PRM_REFERRAL_CODE, p_PRM_REFERRAL_CODE)

Line 430: PRM_IND_CLASSIFICATION_CODE = decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, PRM_IND_CLASSIFICATION_CODE, p_PRM_IND_CLASSIFICATION_CODE),

426: BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),
427: FOLLOWUP_DATE = decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, FOLLOWUP_DATE, p_FOLLOWUP_DATE),
428: PRM_EXEC_SPONSOR_FLAG = decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, PRM_EXEC_SPONSOR_FLAG, p_PRM_EXEC_SPONSOR_FLAG),
429: PRM_PRJ_LEAD_IN_PLACE_FLAG = decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, PRM_PRJ_LEAD_IN_PLACE_FLAG, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
430: PRM_IND_CLASSIFICATION_CODE = decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, PRM_IND_CLASSIFICATION_CODE, p_PRM_IND_CLASSIFICATION_CODE),
431: PRM_LEAD_TYPE = decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR, PRM_LEAD_TYPE, p_PRM_LEAD_TYPE),
432: FREEZE_FLAG = decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, FREEZE_FLAG, p_FREEZE_FLAG),
433: PRM_REFERRAL_CODE = decode( p_PRM_REFERRAL_CODE, FND_API.G_MISS_CHAR, PRM_REFERRAL_CODE, p_PRM_REFERRAL_CODE)
434: where LEAD_ID = p_LEAD_ID;

Line 431: PRM_LEAD_TYPE = decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR, PRM_LEAD_TYPE, p_PRM_LEAD_TYPE),

427: FOLLOWUP_DATE = decode( p_FOLLOWUP_DATE, FND_API.G_MISS_DATE, FOLLOWUP_DATE, p_FOLLOWUP_DATE),
428: PRM_EXEC_SPONSOR_FLAG = decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, PRM_EXEC_SPONSOR_FLAG, p_PRM_EXEC_SPONSOR_FLAG),
429: PRM_PRJ_LEAD_IN_PLACE_FLAG = decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, PRM_PRJ_LEAD_IN_PLACE_FLAG, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
430: PRM_IND_CLASSIFICATION_CODE = decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, PRM_IND_CLASSIFICATION_CODE, p_PRM_IND_CLASSIFICATION_CODE),
431: PRM_LEAD_TYPE = decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR, PRM_LEAD_TYPE, p_PRM_LEAD_TYPE),
432: FREEZE_FLAG = decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, FREEZE_FLAG, p_FREEZE_FLAG),
433: PRM_REFERRAL_CODE = decode( p_PRM_REFERRAL_CODE, FND_API.G_MISS_CHAR, PRM_REFERRAL_CODE, p_PRM_REFERRAL_CODE)
434: where LEAD_ID = p_LEAD_ID;
435:

Line 432: FREEZE_FLAG = decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, FREEZE_FLAG, p_FREEZE_FLAG),

428: PRM_EXEC_SPONSOR_FLAG = decode( p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, PRM_EXEC_SPONSOR_FLAG, p_PRM_EXEC_SPONSOR_FLAG),
429: PRM_PRJ_LEAD_IN_PLACE_FLAG = decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, PRM_PRJ_LEAD_IN_PLACE_FLAG, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
430: PRM_IND_CLASSIFICATION_CODE = decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, PRM_IND_CLASSIFICATION_CODE, p_PRM_IND_CLASSIFICATION_CODE),
431: PRM_LEAD_TYPE = decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR, PRM_LEAD_TYPE, p_PRM_LEAD_TYPE),
432: FREEZE_FLAG = decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, FREEZE_FLAG, p_FREEZE_FLAG),
433: PRM_REFERRAL_CODE = decode( p_PRM_REFERRAL_CODE, FND_API.G_MISS_CHAR, PRM_REFERRAL_CODE, p_PRM_REFERRAL_CODE)
434: where LEAD_ID = p_LEAD_ID;
435:
436: If (SQL%NOTFOUND) then

Line 433: PRM_REFERRAL_CODE = decode( p_PRM_REFERRAL_CODE, FND_API.G_MISS_CHAR, PRM_REFERRAL_CODE, p_PRM_REFERRAL_CODE)

429: PRM_PRJ_LEAD_IN_PLACE_FLAG = decode( p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, PRM_PRJ_LEAD_IN_PLACE_FLAG, p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
430: PRM_IND_CLASSIFICATION_CODE = decode( p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, PRM_IND_CLASSIFICATION_CODE, p_PRM_IND_CLASSIFICATION_CODE),
431: PRM_LEAD_TYPE = decode( p_PRM_LEAD_TYPE, FND_API.G_MISS_CHAR, PRM_LEAD_TYPE, p_PRM_LEAD_TYPE),
432: FREEZE_FLAG = decode( p_FREEZE_FLAG, FND_API.G_MISS_CHAR, FREEZE_FLAG, p_FREEZE_FLAG),
433: PRM_REFERRAL_CODE = decode( p_PRM_REFERRAL_CODE, FND_API.G_MISS_CHAR, PRM_REFERRAL_CODE, p_PRM_REFERRAL_CODE)
434: where LEAD_ID = p_LEAD_ID;
435:
436: If (SQL%NOTFOUND) then
437: RAISE NO_DATA_FOUND;