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_SALES_LEADS_PKG dependencies on FND_API

Line 141: If (px_SALES_LEAD_ID IS NULL) OR (px_SALES_LEAD_ID = FND_API.G_MISS_NUM) then

137: )
138: IS
139: CURSOR C2 IS SELECT AS_SALES_LEADS_S.nextval FROM sys.dual;
140: BEGIN
141: If (px_SALES_LEAD_ID IS NULL) OR (px_SALES_LEAD_ID = FND_API.G_MISS_NUM) then
142: OPEN C2;
143: FETCH C2 INTO px_SALES_LEAD_ID;
144: CLOSE C2;
145: End If;

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

259:
260: )
261: VALUES (
262: px_SALES_LEAD_ID,
263: decode(p_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE),
264: decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
265: decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
266: decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
267: decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),

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

260: )
261: VALUES (
262: px_SALES_LEAD_ID,
263: decode(p_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE),
264: decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
265: decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
266: decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
267: decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),
268: decode(p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),

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

261: VALUES (
262: px_SALES_LEAD_ID,
263: decode(p_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE),
264: decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
265: decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
266: decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
267: decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),
268: decode(p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
269: decode(p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,

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

262: px_SALES_LEAD_ID,
263: decode(p_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE),
264: decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
265: decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
266: decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
267: decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),
268: decode(p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
269: decode(p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
270: p_PROGRAM_APPLICATION_ID),

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

263: decode(p_LAST_UPDATE_DATE,FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE),
264: decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
265: decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
266: decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
267: decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),
268: decode(p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
269: decode(p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
270: p_PROGRAM_APPLICATION_ID),
271: decode(p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),

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

264: decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
265: decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
266: decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
267: decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),
268: decode(p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
269: decode(p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
270: p_PROGRAM_APPLICATION_ID),
271: decode(p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
272: decode(p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),

Line 269: decode(p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,

265: decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
266: decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
267: decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),
268: decode(p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
269: decode(p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
270: p_PROGRAM_APPLICATION_ID),
271: decode(p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
272: decode(p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
273: p_PROGRAM_UPDATE_DATE),

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

267: decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN),
268: decode(p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
269: decode(p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
270: p_PROGRAM_APPLICATION_ID),
271: decode(p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
272: decode(p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
273: p_PROGRAM_UPDATE_DATE),
274: px_SALES_LEAD_ID,
275: decode(p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),

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

268: decode(p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
269: decode(p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
270: p_PROGRAM_APPLICATION_ID),
271: decode(p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
272: decode(p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
273: p_PROGRAM_UPDATE_DATE),
274: px_SALES_LEAD_ID,
275: decode(p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
276: decode(p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),

Line 275: decode(p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),

271: decode(p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
272: decode(p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
273: p_PROGRAM_UPDATE_DATE),
274: px_SALES_LEAD_ID,
275: decode(p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
276: decode(p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
277: decode(p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
278: decode(p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL,
279: p_SOURCE_PROMOTION_ID),

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

272: decode(p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
273: p_PROGRAM_UPDATE_DATE),
274: px_SALES_LEAD_ID,
275: decode(p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
276: decode(p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
277: decode(p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
278: decode(p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL,
279: p_SOURCE_PROMOTION_ID),
280: decode(p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL,

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

273: p_PROGRAM_UPDATE_DATE),
274: px_SALES_LEAD_ID,
275: decode(p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
276: decode(p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
277: decode(p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
278: decode(p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL,
279: p_SOURCE_PROMOTION_ID),
280: decode(p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL,
281: p_INITIATING_CONTACT_ID),

Line 278: decode(p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL,

274: px_SALES_LEAD_ID,
275: decode(p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
276: decode(p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
277: decode(p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
278: decode(p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL,
279: p_SOURCE_PROMOTION_ID),
280: decode(p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL,
281: p_INITIATING_CONTACT_ID),
282: decode(p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL,

Line 280: decode(p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL,

276: decode(p_CUSTOMER_ID, FND_API.G_MISS_NUM, NULL, p_CUSTOMER_ID),
277: decode(p_ADDRESS_ID, FND_API.G_MISS_NUM, NULL, p_ADDRESS_ID),
278: decode(p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL,
279: p_SOURCE_PROMOTION_ID),
280: decode(p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL,
281: p_INITIATING_CONTACT_ID),
282: decode(p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL,
283: p_ORIG_SYSTEM_REFERENCE),
284: decode(p_CONTACT_ROLE_CODE,FND_API.G_MISS_CHAR,NULL,p_CONTACT_ROLE_CODE),

Line 282: decode(p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL,

278: decode(p_SOURCE_PROMOTION_ID, FND_API.G_MISS_NUM, NULL,
279: p_SOURCE_PROMOTION_ID),
280: decode(p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL,
281: p_INITIATING_CONTACT_ID),
282: decode(p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL,
283: p_ORIG_SYSTEM_REFERENCE),
284: decode(p_CONTACT_ROLE_CODE,FND_API.G_MISS_CHAR,NULL,p_CONTACT_ROLE_CODE),
285: decode(p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
286: decode(p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),

Line 284: decode(p_CONTACT_ROLE_CODE,FND_API.G_MISS_CHAR,NULL,p_CONTACT_ROLE_CODE),

280: decode(p_INITIATING_CONTACT_ID, FND_API.G_MISS_NUM, NULL,
281: p_INITIATING_CONTACT_ID),
282: decode(p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL,
283: p_ORIG_SYSTEM_REFERENCE),
284: decode(p_CONTACT_ROLE_CODE,FND_API.G_MISS_CHAR,NULL,p_CONTACT_ROLE_CODE),
285: decode(p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
286: decode(p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),
287: decode(p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
288: decode(p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL,

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

281: p_INITIATING_CONTACT_ID),
282: decode(p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL,
283: p_ORIG_SYSTEM_REFERENCE),
284: decode(p_CONTACT_ROLE_CODE,FND_API.G_MISS_CHAR,NULL,p_CONTACT_ROLE_CODE),
285: decode(p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
286: decode(p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),
287: decode(p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
288: decode(p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL,
289: p_DECISION_TIMEFRAME_CODE),

Line 286: decode(p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),

282: decode(p_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL,
283: p_ORIG_SYSTEM_REFERENCE),
284: decode(p_CONTACT_ROLE_CODE,FND_API.G_MISS_CHAR,NULL,p_CONTACT_ROLE_CODE),
285: decode(p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
286: decode(p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),
287: decode(p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
288: decode(p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL,
289: p_DECISION_TIMEFRAME_CODE),
290: decode(p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),

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

283: p_ORIG_SYSTEM_REFERENCE),
284: decode(p_CONTACT_ROLE_CODE,FND_API.G_MISS_CHAR,NULL,p_CONTACT_ROLE_CODE),
285: decode(p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
286: decode(p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),
287: decode(p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
288: decode(p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL,
289: p_DECISION_TIMEFRAME_CODE),
290: decode(p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
291: decode(p_LEAD_RANK_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_RANK_ID),

Line 288: decode(p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL,

284: decode(p_CONTACT_ROLE_CODE,FND_API.G_MISS_CHAR,NULL,p_CONTACT_ROLE_CODE),
285: decode(p_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_CHANNEL_CODE),
286: decode(p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),
287: decode(p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
288: decode(p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL,
289: p_DECISION_TIMEFRAME_CODE),
290: decode(p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
291: decode(p_LEAD_RANK_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_RANK_ID),
292: decode(p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_RANK_CODE),

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

286: decode(p_BUDGET_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BUDGET_AMOUNT),
287: decode(p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
288: decode(p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL,
289: p_DECISION_TIMEFRAME_CODE),
290: decode(p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
291: decode(p_LEAD_RANK_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_RANK_ID),
292: decode(p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_RANK_CODE),
293: decode(p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
294: decode(p_DESCRIPTION, NULL, to_char(px_SALES_LEAD_ID), FND_API.G_MISS_CHAR, to_char(px_SALES_LEAD_ID), p_DESCRIPTION),

Line 291: decode(p_LEAD_RANK_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_RANK_ID),

287: decode(p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
288: decode(p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL,
289: p_DECISION_TIMEFRAME_CODE),
290: decode(p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
291: decode(p_LEAD_RANK_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_RANK_ID),
292: decode(p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_RANK_CODE),
293: decode(p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
294: decode(p_DESCRIPTION, NULL, to_char(px_SALES_LEAD_ID), FND_API.G_MISS_CHAR, to_char(px_SALES_LEAD_ID), p_DESCRIPTION),
295: decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,

Line 292: decode(p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_RANK_CODE),

288: decode(p_DECISION_TIMEFRAME_CODE, FND_API.G_MISS_CHAR, NULL,
289: p_DECISION_TIMEFRAME_CODE),
290: decode(p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
291: decode(p_LEAD_RANK_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_RANK_ID),
292: decode(p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_RANK_CODE),
293: decode(p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
294: decode(p_DESCRIPTION, NULL, to_char(px_SALES_LEAD_ID), FND_API.G_MISS_CHAR, to_char(px_SALES_LEAD_ID), p_DESCRIPTION),
295: decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
296: p_ATTRIBUTE_CATEGORY),

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

289: p_DECISION_TIMEFRAME_CODE),
290: decode(p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
291: decode(p_LEAD_RANK_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_RANK_ID),
292: decode(p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_RANK_CODE),
293: decode(p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
294: decode(p_DESCRIPTION, NULL, to_char(px_SALES_LEAD_ID), FND_API.G_MISS_CHAR, to_char(px_SALES_LEAD_ID), p_DESCRIPTION),
295: decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
296: p_ATTRIBUTE_CATEGORY),
297: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

Line 294: decode(p_DESCRIPTION, NULL, to_char(px_SALES_LEAD_ID), FND_API.G_MISS_CHAR, to_char(px_SALES_LEAD_ID), p_DESCRIPTION),

290: decode(p_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, p_CLOSE_REASON),
291: decode(p_LEAD_RANK_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_RANK_ID),
292: decode(p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_RANK_CODE),
293: decode(p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
294: decode(p_DESCRIPTION, NULL, to_char(px_SALES_LEAD_ID), FND_API.G_MISS_CHAR, to_char(px_SALES_LEAD_ID), p_DESCRIPTION),
295: decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
296: p_ATTRIBUTE_CATEGORY),
297: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
298: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

Line 295: decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,

291: decode(p_LEAD_RANK_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_RANK_ID),
292: decode(p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR, NULL, p_LEAD_RANK_CODE),
293: decode(p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
294: decode(p_DESCRIPTION, NULL, to_char(px_SALES_LEAD_ID), FND_API.G_MISS_CHAR, to_char(px_SALES_LEAD_ID), p_DESCRIPTION),
295: decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
296: p_ATTRIBUTE_CATEGORY),
297: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
298: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
299: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

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

293: decode(p_PARENT_PROJECT, FND_API.G_MISS_CHAR, NULL, p_PARENT_PROJECT),
294: decode(p_DESCRIPTION, NULL, to_char(px_SALES_LEAD_ID), FND_API.G_MISS_CHAR, to_char(px_SALES_LEAD_ID), p_DESCRIPTION),
295: decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
296: p_ATTRIBUTE_CATEGORY),
297: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
298: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
299: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
300: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
301: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

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

294: decode(p_DESCRIPTION, NULL, to_char(px_SALES_LEAD_ID), FND_API.G_MISS_CHAR, to_char(px_SALES_LEAD_ID), p_DESCRIPTION),
295: decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
296: p_ATTRIBUTE_CATEGORY),
297: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
298: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
299: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
300: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
301: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
302: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

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

295: decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
296: p_ATTRIBUTE_CATEGORY),
297: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
298: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
299: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
300: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
301: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
302: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
303: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

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

296: p_ATTRIBUTE_CATEGORY),
297: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
298: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
299: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
300: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
301: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
302: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
303: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
304: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

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

297: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
298: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
299: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
300: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
301: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
302: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
303: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
304: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
305: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

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

298: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
299: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
300: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
301: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
302: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
303: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
304: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
305: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
306: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

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

299: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
300: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
301: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
302: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
303: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
304: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
305: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
306: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
307: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

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

300: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
301: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
302: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
303: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
304: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
305: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
306: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
307: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
308: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

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

301: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
302: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
303: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
304: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
305: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
306: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
307: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
308: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
309: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

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

302: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
303: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
304: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
305: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
306: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
307: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
308: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
309: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
310: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

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

303: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
304: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
305: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
306: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
307: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
308: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
309: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
310: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
311: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

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

304: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
305: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
306: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
307: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
308: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
309: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
310: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
311: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
312: decode(p_ASSIGN_TO_PERSON_ID, FND_API.G_MISS_NUM, NULL,

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

305: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
306: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
307: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
308: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
309: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
310: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
311: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
312: decode(p_ASSIGN_TO_PERSON_ID, FND_API.G_MISS_NUM, NULL,
313: p_ASSIGN_TO_PERSON_ID),

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

306: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
307: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
308: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
309: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
310: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
311: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
312: decode(p_ASSIGN_TO_PERSON_ID, FND_API.G_MISS_NUM, NULL,
313: p_ASSIGN_TO_PERSON_ID),
314: decode(p_ASSIGN_TO_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL,

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

307: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
308: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
309: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
310: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
311: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
312: decode(p_ASSIGN_TO_PERSON_ID, FND_API.G_MISS_NUM, NULL,
313: p_ASSIGN_TO_PERSON_ID),
314: decode(p_ASSIGN_TO_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL,
315: p_ASSIGN_TO_SALESFORCE_ID),

Line 312: decode(p_ASSIGN_TO_PERSON_ID, FND_API.G_MISS_NUM, NULL,

308: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
309: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
310: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
311: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
312: decode(p_ASSIGN_TO_PERSON_ID, FND_API.G_MISS_NUM, NULL,
313: p_ASSIGN_TO_PERSON_ID),
314: decode(p_ASSIGN_TO_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL,
315: p_ASSIGN_TO_SALESFORCE_ID),
316: decode(p_ASSIGN_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL,

Line 314: decode(p_ASSIGN_TO_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL,

310: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
311: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
312: decode(p_ASSIGN_TO_PERSON_ID, FND_API.G_MISS_NUM, NULL,
313: p_ASSIGN_TO_PERSON_ID),
314: decode(p_ASSIGN_TO_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL,
315: p_ASSIGN_TO_SALESFORCE_ID),
316: decode(p_ASSIGN_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL,
317: p_ASSIGN_SALES_GROUP_ID),
318: decode(p_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ASSIGN_DATE),

Line 316: decode(p_ASSIGN_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL,

312: decode(p_ASSIGN_TO_PERSON_ID, FND_API.G_MISS_NUM, NULL,
313: p_ASSIGN_TO_PERSON_ID),
314: decode(p_ASSIGN_TO_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL,
315: p_ASSIGN_TO_SALESFORCE_ID),
316: decode(p_ASSIGN_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL,
317: p_ASSIGN_SALES_GROUP_ID),
318: decode(p_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ASSIGN_DATE),
319: decode(p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL,
320: p_BUDGET_STATUS_CODE),

Line 318: decode(p_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ASSIGN_DATE),

314: decode(p_ASSIGN_TO_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL,
315: p_ASSIGN_TO_SALESFORCE_ID),
316: decode(p_ASSIGN_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL,
317: p_ASSIGN_SALES_GROUP_ID),
318: decode(p_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ASSIGN_DATE),
319: decode(p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL,
320: p_BUDGET_STATUS_CODE),
321: decode(p_ACCEPT_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACCEPT_FLAG),
322: decode(p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL,

Line 319: decode(p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL,

315: p_ASSIGN_TO_SALESFORCE_ID),
316: decode(p_ASSIGN_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL,
317: p_ASSIGN_SALES_GROUP_ID),
318: decode(p_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ASSIGN_DATE),
319: decode(p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL,
320: p_BUDGET_STATUS_CODE),
321: decode(p_ACCEPT_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACCEPT_FLAG),
322: decode(p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL,
323: p_VEHICLE_RESPONSE_CODE),

Line 321: decode(p_ACCEPT_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACCEPT_FLAG),

317: p_ASSIGN_SALES_GROUP_ID),
318: decode(p_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ASSIGN_DATE),
319: decode(p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL,
320: p_BUDGET_STATUS_CODE),
321: decode(p_ACCEPT_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACCEPT_FLAG),
322: decode(p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL,
323: p_VEHICLE_RESPONSE_CODE),
324: decode(p_TOTAL_SCORE, FND_API.G_MISS_NUM, NULL, p_TOTAL_SCORE),
325: decode(p_SCORECARD_ID, FND_API.G_MISS_NUM, NULL, p_SCORECARD_ID),

Line 322: decode(p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL,

318: decode(p_ASSIGN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ASSIGN_DATE),
319: decode(p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR, NULL,
320: p_BUDGET_STATUS_CODE),
321: decode(p_ACCEPT_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACCEPT_FLAG),
322: decode(p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL,
323: p_VEHICLE_RESPONSE_CODE),
324: decode(p_TOTAL_SCORE, FND_API.G_MISS_NUM, NULL, p_TOTAL_SCORE),
325: decode(p_SCORECARD_ID, FND_API.G_MISS_NUM, NULL, p_SCORECARD_ID),
326: decode(p_KEEP_FLAG, FND_API.G_MISS_CHAR, NULL, p_KEEP_FLAG),

Line 324: decode(p_TOTAL_SCORE, FND_API.G_MISS_NUM, NULL, p_TOTAL_SCORE),

320: p_BUDGET_STATUS_CODE),
321: decode(p_ACCEPT_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACCEPT_FLAG),
322: decode(p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL,
323: p_VEHICLE_RESPONSE_CODE),
324: decode(p_TOTAL_SCORE, FND_API.G_MISS_NUM, NULL, p_TOTAL_SCORE),
325: decode(p_SCORECARD_ID, FND_API.G_MISS_NUM, NULL, p_SCORECARD_ID),
326: decode(p_KEEP_FLAG, FND_API.G_MISS_CHAR, NULL, p_KEEP_FLAG),
327: decode(p_URGENT_FLAG, FND_API.G_MISS_CHAR, NULL, p_URGENT_FLAG),
328: decode(p_IMPORT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IMPORT_FLAG),

Line 325: decode(p_SCORECARD_ID, FND_API.G_MISS_NUM, NULL, p_SCORECARD_ID),

321: decode(p_ACCEPT_FLAG, FND_API.G_MISS_CHAR, NULL, p_ACCEPT_FLAG),
322: decode(p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL,
323: p_VEHICLE_RESPONSE_CODE),
324: decode(p_TOTAL_SCORE, FND_API.G_MISS_NUM, NULL, p_TOTAL_SCORE),
325: decode(p_SCORECARD_ID, FND_API.G_MISS_NUM, NULL, p_SCORECARD_ID),
326: decode(p_KEEP_FLAG, FND_API.G_MISS_CHAR, NULL, p_KEEP_FLAG),
327: decode(p_URGENT_FLAG, FND_API.G_MISS_CHAR, NULL, p_URGENT_FLAG),
328: decode(p_IMPORT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IMPORT_FLAG),
329: decode(p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR, NULL,

Line 326: decode(p_KEEP_FLAG, FND_API.G_MISS_CHAR, NULL, p_KEEP_FLAG),

322: decode(p_VEHICLE_RESPONSE_CODE, FND_API.G_MISS_CHAR, NULL,
323: p_VEHICLE_RESPONSE_CODE),
324: decode(p_TOTAL_SCORE, FND_API.G_MISS_NUM, NULL, p_TOTAL_SCORE),
325: decode(p_SCORECARD_ID, FND_API.G_MISS_NUM, NULL, p_SCORECARD_ID),
326: decode(p_KEEP_FLAG, FND_API.G_MISS_CHAR, NULL, p_KEEP_FLAG),
327: decode(p_URGENT_FLAG, FND_API.G_MISS_CHAR, NULL, p_URGENT_FLAG),
328: decode(p_IMPORT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IMPORT_FLAG),
329: decode(p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR, NULL,
330: p_REJECT_REASON_CODE),

Line 327: decode(p_URGENT_FLAG, FND_API.G_MISS_CHAR, NULL, p_URGENT_FLAG),

323: p_VEHICLE_RESPONSE_CODE),
324: decode(p_TOTAL_SCORE, FND_API.G_MISS_NUM, NULL, p_TOTAL_SCORE),
325: decode(p_SCORECARD_ID, FND_API.G_MISS_NUM, NULL, p_SCORECARD_ID),
326: decode(p_KEEP_FLAG, FND_API.G_MISS_CHAR, NULL, p_KEEP_FLAG),
327: decode(p_URGENT_FLAG, FND_API.G_MISS_CHAR, NULL, p_URGENT_FLAG),
328: decode(p_IMPORT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IMPORT_FLAG),
329: decode(p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR, NULL,
330: p_REJECT_REASON_CODE),
331: decode(p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),

Line 328: decode(p_IMPORT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IMPORT_FLAG),

324: decode(p_TOTAL_SCORE, FND_API.G_MISS_NUM, NULL, p_TOTAL_SCORE),
325: decode(p_SCORECARD_ID, FND_API.G_MISS_NUM, NULL, p_SCORECARD_ID),
326: decode(p_KEEP_FLAG, FND_API.G_MISS_CHAR, NULL, p_KEEP_FLAG),
327: decode(p_URGENT_FLAG, FND_API.G_MISS_CHAR, NULL, p_URGENT_FLAG),
328: decode(p_IMPORT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IMPORT_FLAG),
329: decode(p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR, NULL,
330: p_REJECT_REASON_CODE),
331: decode(p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
332: decode(p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),

Line 329: decode(p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR, NULL,

325: decode(p_SCORECARD_ID, FND_API.G_MISS_NUM, NULL, p_SCORECARD_ID),
326: decode(p_KEEP_FLAG, FND_API.G_MISS_CHAR, NULL, p_KEEP_FLAG),
327: decode(p_URGENT_FLAG, FND_API.G_MISS_CHAR, NULL, p_URGENT_FLAG),
328: decode(p_IMPORT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IMPORT_FLAG),
329: decode(p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR, NULL,
330: p_REJECT_REASON_CODE),
331: decode(p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
332: decode(p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
333: decode(p_QUALIFIED_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUALIFIED_FLAG),

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

327: decode(p_URGENT_FLAG, FND_API.G_MISS_CHAR, NULL, p_URGENT_FLAG),
328: decode(p_IMPORT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IMPORT_FLAG),
329: decode(p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR, NULL,
330: p_REJECT_REASON_CODE),
331: decode(p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
332: decode(p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
333: decode(p_QUALIFIED_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUALIFIED_FLAG),
334: decode(p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_CODE),
335: -- decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SECURITY_GROUP_ID),

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

328: decode(p_IMPORT_FLAG, FND_API.G_MISS_CHAR, NULL, p_IMPORT_FLAG),
329: decode(p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR, NULL,
330: p_REJECT_REASON_CODE),
331: decode(p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
332: decode(p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
333: decode(p_QUALIFIED_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUALIFIED_FLAG),
334: decode(p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_CODE),
335: -- decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SECURITY_GROUP_ID),
336: decode(p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL,

Line 333: decode(p_QUALIFIED_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUALIFIED_FLAG),

329: decode(p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR, NULL,
330: p_REJECT_REASON_CODE),
331: decode(p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
332: decode(p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
333: decode(p_QUALIFIED_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUALIFIED_FLAG),
334: decode(p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_CODE),
335: -- decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SECURITY_GROUP_ID),
336: decode(p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL,
337: p_INC_PARTNER_PARTY_ID),

Line 334: decode(p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_CODE),

330: p_REJECT_REASON_CODE),
331: decode(p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
332: decode(p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
333: decode(p_QUALIFIED_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUALIFIED_FLAG),
334: decode(p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_CODE),
335: -- decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SECURITY_GROUP_ID),
336: decode(p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL,
337: p_INC_PARTNER_PARTY_ID),
338: decode(p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,

Line 335: -- decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SECURITY_GROUP_ID),

331: decode(p_DELETED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DELETED_FLAG),
332: decode(p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
333: decode(p_QUALIFIED_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUALIFIED_FLAG),
334: decode(p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_CODE),
335: -- decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SECURITY_GROUP_ID),
336: decode(p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL,
337: p_INC_PARTNER_PARTY_ID),
338: decode(p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,
339: p_INC_PARTNER_RESOURCE_ID),

Line 336: decode(p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL,

332: decode(p_OFFER_ID, FND_API.G_MISS_NUM, NULL, p_OFFER_ID),
333: decode(p_QUALIFIED_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUALIFIED_FLAG),
334: decode(p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_CODE),
335: -- decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SECURITY_GROUP_ID),
336: decode(p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL,
337: p_INC_PARTNER_PARTY_ID),
338: decode(p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,
339: p_INC_PARTNER_RESOURCE_ID),
340: decode(p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL,

Line 338: decode(p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,

334: decode(p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYSTEM_CODE),
335: -- decode(p_SECURITY_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SECURITY_GROUP_ID),
336: decode(p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL,
337: p_INC_PARTNER_PARTY_ID),
338: decode(p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,
339: p_INC_PARTNER_RESOURCE_ID),
340: decode(p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL,
341: p_PRM_EXEC_SPONSOR_FLAG),
342: decode(p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL,

Line 340: decode(p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL,

336: decode(p_INC_PARTNER_PARTY_ID, FND_API.G_MISS_NUM, NULL,
337: p_INC_PARTNER_PARTY_ID),
338: decode(p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,
339: p_INC_PARTNER_RESOURCE_ID),
340: decode(p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL,
341: p_PRM_EXEC_SPONSOR_FLAG),
342: decode(p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL,
343: p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
344: decode(p_PRM_SALES_LEAD_TYPE, FND_API.G_MISS_CHAR, NULL,

Line 342: decode(p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL,

338: decode(p_INC_PARTNER_RESOURCE_ID, FND_API.G_MISS_NUM, NULL,
339: p_INC_PARTNER_RESOURCE_ID),
340: decode(p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL,
341: p_PRM_EXEC_SPONSOR_FLAG),
342: decode(p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL,
343: p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
344: decode(p_PRM_SALES_LEAD_TYPE, FND_API.G_MISS_CHAR, NULL,
345: p_PRM_SALES_LEAD_TYPE),
346: decode(p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL,

Line 344: decode(p_PRM_SALES_LEAD_TYPE, FND_API.G_MISS_CHAR, NULL,

340: decode(p_PRM_EXEC_SPONSOR_FLAG, FND_API.G_MISS_CHAR, NULL,
341: p_PRM_EXEC_SPONSOR_FLAG),
342: decode(p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL,
343: p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
344: decode(p_PRM_SALES_LEAD_TYPE, FND_API.G_MISS_CHAR, NULL,
345: p_PRM_SALES_LEAD_TYPE),
346: decode(p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL,
347: p_PRM_IND_CLASSIFICATION_CODE),
348: decode(p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL,

Line 346: decode(p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL,

342: decode(p_PRM_PRJ_LEAD_IN_PLACE_FLAG, FND_API.G_MISS_CHAR, NULL,
343: p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
344: decode(p_PRM_SALES_LEAD_TYPE, FND_API.G_MISS_CHAR, NULL,
345: p_PRM_SALES_LEAD_TYPE),
346: decode(p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL,
347: p_PRM_IND_CLASSIFICATION_CODE),
348: decode(p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL,
349: p_PRM_ASSIGNMENT_TYPE),
350: decode(p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL,

Line 348: decode(p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL,

344: decode(p_PRM_SALES_LEAD_TYPE, FND_API.G_MISS_CHAR, NULL,
345: p_PRM_SALES_LEAD_TYPE),
346: decode(p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL,
347: p_PRM_IND_CLASSIFICATION_CODE),
348: decode(p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL,
349: p_PRM_ASSIGNMENT_TYPE),
350: decode(p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL,
351: p_AUTO_ASSIGNMENT_TYPE),
352: decode(p_PRIMARY_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, NULL,

Line 350: decode(p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL,

346: decode(p_PRM_IND_CLASSIFICATION_CODE, FND_API.G_MISS_CHAR, NULL,
347: p_PRM_IND_CLASSIFICATION_CODE),
348: decode(p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL,
349: p_PRM_ASSIGNMENT_TYPE),
350: decode(p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL,
351: p_AUTO_ASSIGNMENT_TYPE),
352: decode(p_PRIMARY_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, NULL,
353: p_PRIMARY_CONTACT_PARTY_ID),
354: decode(p_PRIMARY_CNT_PERSON_PARTY_ID, FND_API.G_MISS_NUM, NULL,

Line 352: decode(p_PRIMARY_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, NULL,

348: decode(p_PRM_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL,
349: p_PRM_ASSIGNMENT_TYPE),
350: decode(p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL,
351: p_AUTO_ASSIGNMENT_TYPE),
352: decode(p_PRIMARY_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, NULL,
353: p_PRIMARY_CONTACT_PARTY_ID),
354: decode(p_PRIMARY_CNT_PERSON_PARTY_ID, FND_API.G_MISS_NUM, NULL,
355: p_PRIMARY_CNT_PERSON_PARTY_ID),
356: decode(p_PRIMARY_CONTACT_PHONE_ID, FND_API.G_MISS_NUM, NULL,

Line 354: decode(p_PRIMARY_CNT_PERSON_PARTY_ID, FND_API.G_MISS_NUM, NULL,

350: decode(p_AUTO_ASSIGNMENT_TYPE, FND_API.G_MISS_CHAR, NULL,
351: p_AUTO_ASSIGNMENT_TYPE),
352: decode(p_PRIMARY_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, NULL,
353: p_PRIMARY_CONTACT_PARTY_ID),
354: decode(p_PRIMARY_CNT_PERSON_PARTY_ID, FND_API.G_MISS_NUM, NULL,
355: p_PRIMARY_CNT_PERSON_PARTY_ID),
356: decode(p_PRIMARY_CONTACT_PHONE_ID, FND_API.G_MISS_NUM, NULL,
357: p_PRIMARY_CONTACT_PHONE_ID),
358: decode(p_REFERRED_BY, FND_API.G_MISS_NUM, NULL,

Line 356: decode(p_PRIMARY_CONTACT_PHONE_ID, FND_API.G_MISS_NUM, NULL,

352: decode(p_PRIMARY_CONTACT_PARTY_ID, FND_API.G_MISS_NUM, NULL,
353: p_PRIMARY_CONTACT_PARTY_ID),
354: decode(p_PRIMARY_CNT_PERSON_PARTY_ID, FND_API.G_MISS_NUM, NULL,
355: p_PRIMARY_CNT_PERSON_PARTY_ID),
356: decode(p_PRIMARY_CONTACT_PHONE_ID, FND_API.G_MISS_NUM, NULL,
357: p_PRIMARY_CONTACT_PHONE_ID),
358: decode(p_REFERRED_BY, FND_API.G_MISS_NUM, NULL,
359: p_REFERRED_BY),
360: decode(p_REFERRAL_TYPE, FND_API.G_MISS_CHAR, NULL,

Line 358: decode(p_REFERRED_BY, FND_API.G_MISS_NUM, NULL,

354: decode(p_PRIMARY_CNT_PERSON_PARTY_ID, FND_API.G_MISS_NUM, NULL,
355: p_PRIMARY_CNT_PERSON_PARTY_ID),
356: decode(p_PRIMARY_CONTACT_PHONE_ID, FND_API.G_MISS_NUM, NULL,
357: p_PRIMARY_CONTACT_PHONE_ID),
358: decode(p_REFERRED_BY, FND_API.G_MISS_NUM, NULL,
359: p_REFERRED_BY),
360: decode(p_REFERRAL_TYPE, FND_API.G_MISS_CHAR, NULL,
361: p_REFERRAL_TYPE),
362: decode(p_REFERRAL_STATUS, FND_API.G_MISS_CHAR, NULL,

Line 360: decode(p_REFERRAL_TYPE, FND_API.G_MISS_CHAR, NULL,

356: decode(p_PRIMARY_CONTACT_PHONE_ID, FND_API.G_MISS_NUM, NULL,
357: p_PRIMARY_CONTACT_PHONE_ID),
358: decode(p_REFERRED_BY, FND_API.G_MISS_NUM, NULL,
359: p_REFERRED_BY),
360: decode(p_REFERRAL_TYPE, FND_API.G_MISS_CHAR, NULL,
361: p_REFERRAL_TYPE),
362: decode(p_REFERRAL_STATUS, FND_API.G_MISS_CHAR, NULL,
363: p_REFERRAL_STATUS),
364: decode(p_REF_DECLINE_REASON, FND_API.G_MISS_CHAR, NULL,

Line 362: decode(p_REFERRAL_STATUS, FND_API.G_MISS_CHAR, NULL,

358: decode(p_REFERRED_BY, FND_API.G_MISS_NUM, NULL,
359: p_REFERRED_BY),
360: decode(p_REFERRAL_TYPE, FND_API.G_MISS_CHAR, NULL,
361: p_REFERRAL_TYPE),
362: decode(p_REFERRAL_STATUS, FND_API.G_MISS_CHAR, NULL,
363: p_REFERRAL_STATUS),
364: decode(p_REF_DECLINE_REASON, FND_API.G_MISS_CHAR, NULL,
365: p_REF_DECLINE_REASON),
366: decode(p_REF_COMM_LTR_STATUS, FND_API.G_MISS_CHAR, NULL,

Line 364: decode(p_REF_DECLINE_REASON, FND_API.G_MISS_CHAR, NULL,

360: decode(p_REFERRAL_TYPE, FND_API.G_MISS_CHAR, NULL,
361: p_REFERRAL_TYPE),
362: decode(p_REFERRAL_STATUS, FND_API.G_MISS_CHAR, NULL,
363: p_REFERRAL_STATUS),
364: decode(p_REF_DECLINE_REASON, FND_API.G_MISS_CHAR, NULL,
365: p_REF_DECLINE_REASON),
366: decode(p_REF_COMM_LTR_STATUS, FND_API.G_MISS_CHAR, NULL,
367: p_REF_COMM_LTR_STATUS),
368: decode(p_REF_ORDER_NUMBER, FND_API.G_MISS_NUM, NULL,

Line 366: decode(p_REF_COMM_LTR_STATUS, FND_API.G_MISS_CHAR, NULL,

362: decode(p_REFERRAL_STATUS, FND_API.G_MISS_CHAR, NULL,
363: p_REFERRAL_STATUS),
364: decode(p_REF_DECLINE_REASON, FND_API.G_MISS_CHAR, NULL,
365: p_REF_DECLINE_REASON),
366: decode(p_REF_COMM_LTR_STATUS, FND_API.G_MISS_CHAR, NULL,
367: p_REF_COMM_LTR_STATUS),
368: decode(p_REF_ORDER_NUMBER, FND_API.G_MISS_NUM, NULL,
369: p_REF_ORDER_NUMBER),
370: decode(p_REF_ORDER_AMT, FND_API.G_MISS_NUM, NULL,

Line 368: decode(p_REF_ORDER_NUMBER, FND_API.G_MISS_NUM, NULL,

364: decode(p_REF_DECLINE_REASON, FND_API.G_MISS_CHAR, NULL,
365: p_REF_DECLINE_REASON),
366: decode(p_REF_COMM_LTR_STATUS, FND_API.G_MISS_CHAR, NULL,
367: p_REF_COMM_LTR_STATUS),
368: decode(p_REF_ORDER_NUMBER, FND_API.G_MISS_NUM, NULL,
369: p_REF_ORDER_NUMBER),
370: decode(p_REF_ORDER_AMT, FND_API.G_MISS_NUM, NULL,
371: p_REF_ORDER_AMT),
372: decode(p_REF_COMM_AMT, FND_API.G_MISS_NUM, NULL,

Line 370: decode(p_REF_ORDER_AMT, FND_API.G_MISS_NUM, NULL,

366: decode(p_REF_COMM_LTR_STATUS, FND_API.G_MISS_CHAR, NULL,
367: p_REF_COMM_LTR_STATUS),
368: decode(p_REF_ORDER_NUMBER, FND_API.G_MISS_NUM, NULL,
369: p_REF_ORDER_NUMBER),
370: decode(p_REF_ORDER_AMT, FND_API.G_MISS_NUM, NULL,
371: p_REF_ORDER_AMT),
372: decode(p_REF_COMM_AMT, FND_API.G_MISS_NUM, NULL,
373: p_REF_COMM_AMT),
374: decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TRUNC(TO_DATE(NULL)), TRUNC(p_CREATION_DATE)),

Line 372: decode(p_REF_COMM_AMT, FND_API.G_MISS_NUM, NULL,

368: decode(p_REF_ORDER_NUMBER, FND_API.G_MISS_NUM, NULL,
369: p_REF_ORDER_NUMBER),
370: decode(p_REF_ORDER_AMT, FND_API.G_MISS_NUM, NULL,
371: p_REF_ORDER_AMT),
372: decode(p_REF_COMM_AMT, FND_API.G_MISS_NUM, NULL,
373: p_REF_COMM_AMT),
374: decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TRUNC(TO_DATE(NULL)), TRUNC(p_CREATION_DATE)),
375: decode(p_LEAD_DATE, FND_API.G_MISS_DATE, SYSDATE, p_LEAD_DATE),
376: decode(p_SOURCE_SYSTEM, FND_API.G_MISS_CHAR, 'USER', p_SOURCE_SYSTEM),

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

370: decode(p_REF_ORDER_AMT, FND_API.G_MISS_NUM, NULL,
371: p_REF_ORDER_AMT),
372: decode(p_REF_COMM_AMT, FND_API.G_MISS_NUM, NULL,
373: p_REF_COMM_AMT),
374: decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TRUNC(TO_DATE(NULL)), TRUNC(p_CREATION_DATE)),
375: decode(p_LEAD_DATE, FND_API.G_MISS_DATE, SYSDATE, p_LEAD_DATE),
376: decode(p_SOURCE_SYSTEM, FND_API.G_MISS_CHAR, 'USER', p_SOURCE_SYSTEM),
377: decode(p_COUNTRY, FND_API.G_MISS_CHAR, NULL, p_COUNTRY),
378:

Line 375: decode(p_LEAD_DATE, FND_API.G_MISS_DATE, SYSDATE, p_LEAD_DATE),

371: p_REF_ORDER_AMT),
372: decode(p_REF_COMM_AMT, FND_API.G_MISS_NUM, NULL,
373: p_REF_COMM_AMT),
374: decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TRUNC(TO_DATE(NULL)), TRUNC(p_CREATION_DATE)),
375: decode(p_LEAD_DATE, FND_API.G_MISS_DATE, SYSDATE, p_LEAD_DATE),
376: decode(p_SOURCE_SYSTEM, FND_API.G_MISS_CHAR, 'USER', p_SOURCE_SYSTEM),
377: decode(p_COUNTRY, FND_API.G_MISS_CHAR, NULL, p_COUNTRY),
378:
379: decode(p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL,p_TOTAL_AMOUNT),

Line 376: decode(p_SOURCE_SYSTEM, FND_API.G_MISS_CHAR, 'USER', p_SOURCE_SYSTEM),

372: decode(p_REF_COMM_AMT, FND_API.G_MISS_NUM, NULL,
373: p_REF_COMM_AMT),
374: decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TRUNC(TO_DATE(NULL)), TRUNC(p_CREATION_DATE)),
375: decode(p_LEAD_DATE, FND_API.G_MISS_DATE, SYSDATE, p_LEAD_DATE),
376: decode(p_SOURCE_SYSTEM, FND_API.G_MISS_CHAR, 'USER', p_SOURCE_SYSTEM),
377: decode(p_COUNTRY, FND_API.G_MISS_CHAR, NULL, p_COUNTRY),
378:
379: decode(p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL,p_TOTAL_AMOUNT),
380: decode(p_EXPIRATION_DATE, FND_API.G_MISS_DATE, SYSDATE, p_EXPIRATION_DATE),

Line 377: decode(p_COUNTRY, FND_API.G_MISS_CHAR, NULL, p_COUNTRY),

373: p_REF_COMM_AMT),
374: decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TRUNC(TO_DATE(NULL)), TRUNC(p_CREATION_DATE)),
375: decode(p_LEAD_DATE, FND_API.G_MISS_DATE, SYSDATE, p_LEAD_DATE),
376: decode(p_SOURCE_SYSTEM, FND_API.G_MISS_CHAR, 'USER', p_SOURCE_SYSTEM),
377: decode(p_COUNTRY, FND_API.G_MISS_CHAR, NULL, p_COUNTRY),
378:
379: decode(p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL,p_TOTAL_AMOUNT),
380: decode(p_EXPIRATION_DATE, FND_API.G_MISS_DATE, SYSDATE, p_EXPIRATION_DATE),
381: decode(p_LEAD_RANK_IND, FND_API.G_MISS_CHAR, NULL,p_LEAD_RANK_IND),

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

375: decode(p_LEAD_DATE, FND_API.G_MISS_DATE, SYSDATE, p_LEAD_DATE),
376: decode(p_SOURCE_SYSTEM, FND_API.G_MISS_CHAR, 'USER', p_SOURCE_SYSTEM),
377: decode(p_COUNTRY, FND_API.G_MISS_CHAR, NULL, p_COUNTRY),
378:
379: decode(p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL,p_TOTAL_AMOUNT),
380: decode(p_EXPIRATION_DATE, FND_API.G_MISS_DATE, SYSDATE, p_EXPIRATION_DATE),
381: decode(p_LEAD_RANK_IND, FND_API.G_MISS_CHAR, NULL,p_LEAD_RANK_IND),
382: decode(p_LEAD_ENGINE_RUN_DATE, FND_API.G_MISS_DATE, NULL, p_LEAD_ENGINE_RUN_DATE),
383: decode(p_CURRENT_REROUTES, FND_API.G_MISS_NUM, NULL,p_CURRENT_REROUTES)

Line 380: decode(p_EXPIRATION_DATE, FND_API.G_MISS_DATE, SYSDATE, p_EXPIRATION_DATE),

376: decode(p_SOURCE_SYSTEM, FND_API.G_MISS_CHAR, 'USER', p_SOURCE_SYSTEM),
377: decode(p_COUNTRY, FND_API.G_MISS_CHAR, NULL, p_COUNTRY),
378:
379: decode(p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL,p_TOTAL_AMOUNT),
380: decode(p_EXPIRATION_DATE, FND_API.G_MISS_DATE, SYSDATE, p_EXPIRATION_DATE),
381: decode(p_LEAD_RANK_IND, FND_API.G_MISS_CHAR, NULL,p_LEAD_RANK_IND),
382: decode(p_LEAD_ENGINE_RUN_DATE, FND_API.G_MISS_DATE, NULL, p_LEAD_ENGINE_RUN_DATE),
383: decode(p_CURRENT_REROUTES, FND_API.G_MISS_NUM, NULL,p_CURRENT_REROUTES)
384:

Line 381: decode(p_LEAD_RANK_IND, FND_API.G_MISS_CHAR, NULL,p_LEAD_RANK_IND),

377: decode(p_COUNTRY, FND_API.G_MISS_CHAR, NULL, p_COUNTRY),
378:
379: decode(p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL,p_TOTAL_AMOUNT),
380: decode(p_EXPIRATION_DATE, FND_API.G_MISS_DATE, SYSDATE, p_EXPIRATION_DATE),
381: decode(p_LEAD_RANK_IND, FND_API.G_MISS_CHAR, NULL,p_LEAD_RANK_IND),
382: decode(p_LEAD_ENGINE_RUN_DATE, FND_API.G_MISS_DATE, NULL, p_LEAD_ENGINE_RUN_DATE),
383: decode(p_CURRENT_REROUTES, FND_API.G_MISS_NUM, NULL,p_CURRENT_REROUTES)
384:
385: -- new columns for appsperf CRMAP denorm project bug 2928041

Line 382: decode(p_LEAD_ENGINE_RUN_DATE, FND_API.G_MISS_DATE, NULL, p_LEAD_ENGINE_RUN_DATE),

378:
379: decode(p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL,p_TOTAL_AMOUNT),
380: decode(p_EXPIRATION_DATE, FND_API.G_MISS_DATE, SYSDATE, p_EXPIRATION_DATE),
381: decode(p_LEAD_RANK_IND, FND_API.G_MISS_CHAR, NULL,p_LEAD_RANK_IND),
382: decode(p_LEAD_ENGINE_RUN_DATE, FND_API.G_MISS_DATE, NULL, p_LEAD_ENGINE_RUN_DATE),
383: decode(p_CURRENT_REROUTES, FND_API.G_MISS_NUM, NULL,p_CURRENT_REROUTES)
384:
385: -- new columns for appsperf CRMAP denorm project bug 2928041
386:

Line 383: decode(p_CURRENT_REROUTES, FND_API.G_MISS_NUM, NULL,p_CURRENT_REROUTES)

379: decode(p_TOTAL_AMOUNT, FND_API.G_MISS_NUM, NULL,p_TOTAL_AMOUNT),
380: decode(p_EXPIRATION_DATE, FND_API.G_MISS_DATE, SYSDATE, p_EXPIRATION_DATE),
381: decode(p_LEAD_RANK_IND, FND_API.G_MISS_CHAR, NULL,p_LEAD_RANK_IND),
382: decode(p_LEAD_ENGINE_RUN_DATE, FND_API.G_MISS_DATE, NULL, p_LEAD_ENGINE_RUN_DATE),
383: decode(p_CURRENT_REROUTES, FND_API.G_MISS_NUM, NULL,p_CURRENT_REROUTES)
384:
385: -- new columns for appsperf CRMAP denorm project bug 2928041
386:
387: , decode(p_STATUS_OPEN_FLAG, FND_API.G_MISS_CHAR, NULL, p_STATUS_OPEN_FLAG)

Line 387: , decode(p_STATUS_OPEN_FLAG, FND_API.G_MISS_CHAR, NULL, p_STATUS_OPEN_FLAG)

383: decode(p_CURRENT_REROUTES, FND_API.G_MISS_NUM, NULL,p_CURRENT_REROUTES)
384:
385: -- new columns for appsperf CRMAP denorm project bug 2928041
386:
387: , decode(p_STATUS_OPEN_FLAG, FND_API.G_MISS_CHAR, NULL, p_STATUS_OPEN_FLAG)
388:
389: , decode(p_LEAD_RANK_SCORE, FND_API.G_MISS_NUM, NULL,p_LEAD_RANK_SCORE)
390:
391:

Line 389: , decode(p_LEAD_RANK_SCORE, FND_API.G_MISS_NUM, NULL,p_LEAD_RANK_SCORE)

385: -- new columns for appsperf CRMAP denorm project bug 2928041
386:
387: , decode(p_STATUS_OPEN_FLAG, FND_API.G_MISS_CHAR, NULL, p_STATUS_OPEN_FLAG)
388:
389: , decode(p_LEAD_RANK_SCORE, FND_API.G_MISS_NUM, NULL,p_LEAD_RANK_SCORE)
390:
391:
392: -- 11.5.10 - ckapoor : new columns
393:

Line 395: , decode(p_MARKETING_SCORE, FND_API.G_MISS_NUM, NULL, p_MARKETING_SCORE)

391:
392: -- 11.5.10 - ckapoor : new columns
393:
394:
395: , decode(p_MARKETING_SCORE, FND_API.G_MISS_NUM, NULL, p_MARKETING_SCORE)
396:
397: , decode(p_INTERACTION_SCORE, FND_API.G_MISS_NUM, NULL,p_INTERACTION_SCORE)
398:
399: , decode(p_SOURCE_PRIMARY_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_PRIMARY_REFERENCE)

Line 397: , decode(p_INTERACTION_SCORE, FND_API.G_MISS_NUM, NULL,p_INTERACTION_SCORE)

393:
394:
395: , decode(p_MARKETING_SCORE, FND_API.G_MISS_NUM, NULL, p_MARKETING_SCORE)
396:
397: , decode(p_INTERACTION_SCORE, FND_API.G_MISS_NUM, NULL,p_INTERACTION_SCORE)
398:
399: , decode(p_SOURCE_PRIMARY_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_PRIMARY_REFERENCE)
400:
401: , decode(p_SOURCE_SECONDARY_REFERENCE, FND_API.G_MISS_CHAR, NULL,p_SOURCE_SECONDARY_REFERENCE)

Line 399: , decode(p_SOURCE_PRIMARY_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_PRIMARY_REFERENCE)

395: , decode(p_MARKETING_SCORE, FND_API.G_MISS_NUM, NULL, p_MARKETING_SCORE)
396:
397: , decode(p_INTERACTION_SCORE, FND_API.G_MISS_NUM, NULL,p_INTERACTION_SCORE)
398:
399: , decode(p_SOURCE_PRIMARY_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_PRIMARY_REFERENCE)
400:
401: , decode(p_SOURCE_SECONDARY_REFERENCE, FND_API.G_MISS_CHAR, NULL,p_SOURCE_SECONDARY_REFERENCE)
402: , decode(p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM, NULL, p_SALES_METHODOLOGY_ID)
403:

Line 401: , decode(p_SOURCE_SECONDARY_REFERENCE, FND_API.G_MISS_CHAR, NULL,p_SOURCE_SECONDARY_REFERENCE)

397: , decode(p_INTERACTION_SCORE, FND_API.G_MISS_NUM, NULL,p_INTERACTION_SCORE)
398:
399: , decode(p_SOURCE_PRIMARY_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_PRIMARY_REFERENCE)
400:
401: , decode(p_SOURCE_SECONDARY_REFERENCE, FND_API.G_MISS_CHAR, NULL,p_SOURCE_SECONDARY_REFERENCE)
402: , decode(p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM, NULL, p_SALES_METHODOLOGY_ID)
403:
404: , decode(p_SALES_STAGE_ID, FND_API.G_MISS_NUM, NULL,p_SALES_STAGE_ID)
405:

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

398:
399: , decode(p_SOURCE_PRIMARY_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_PRIMARY_REFERENCE)
400:
401: , decode(p_SOURCE_SECONDARY_REFERENCE, FND_API.G_MISS_CHAR, NULL,p_SOURCE_SECONDARY_REFERENCE)
402: , decode(p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM, NULL, p_SALES_METHODOLOGY_ID)
403:
404: , decode(p_SALES_STAGE_ID, FND_API.G_MISS_NUM, NULL,p_SALES_STAGE_ID)
405:
406:

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

400:
401: , decode(p_SOURCE_SECONDARY_REFERENCE, FND_API.G_MISS_CHAR, NULL,p_SOURCE_SECONDARY_REFERENCE)
402: , decode(p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM, NULL, p_SALES_METHODOLOGY_ID)
403:
404: , decode(p_SALES_STAGE_ID, FND_API.G_MISS_NUM, NULL,p_SALES_STAGE_ID)
405:
406:
407: );
408: End Sales_Lead_Insert_Row;

Line 535: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,

531: */
532: BEGIN
533: Update AS_SALES_LEADS
534: SET
535: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
536: LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
537: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
538: LAST_UPDATED_BY, p_LAST_UPDATED_BY),
539: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,

Line 537: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,

533: Update AS_SALES_LEADS
534: SET
535: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
536: LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
537: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
538: LAST_UPDATED_BY, p_LAST_UPDATED_BY),
539: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
540: CREATION_DATE, p_CREATION_DATE),
541: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,

Line 539: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,

535: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
536: LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
537: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
538: LAST_UPDATED_BY, p_LAST_UPDATED_BY),
539: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
540: CREATION_DATE, p_CREATION_DATE),
541: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,
542: p_CREATED_BY),
543: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,

Line 541: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,

537: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
538: LAST_UPDATED_BY, p_LAST_UPDATED_BY),
539: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
540: CREATION_DATE, p_CREATION_DATE),
541: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,
542: p_CREATED_BY),
543: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,
544: LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
545: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,

Line 543: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,

539: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
540: CREATION_DATE, p_CREATION_DATE),
541: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,
542: p_CREATED_BY),
543: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,
544: LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
545: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,
546: p_REQUEST_ID),
547: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID,

Line 545: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,

541: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,
542: p_CREATED_BY),
543: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,
544: LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
545: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,
546: p_REQUEST_ID),
547: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID,
548: FND_API.G_MISS_NUM,
549: PROGRAM_APPLICATION_ID,

Line 548: FND_API.G_MISS_NUM,

544: LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
545: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,
546: p_REQUEST_ID),
547: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID,
548: FND_API.G_MISS_NUM,
549: PROGRAM_APPLICATION_ID,
550: p_PROGRAM_APPLICATION_ID),
551: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,
552: p_PROGRAM_ID),

Line 551: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,

547: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID,
548: FND_API.G_MISS_NUM,
549: PROGRAM_APPLICATION_ID,
550: p_PROGRAM_APPLICATION_ID),
551: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,
552: p_PROGRAM_ID),
553: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE,
554: FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE,
555: p_PROGRAM_UPDATE_DATE),

Line 554: FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE,

550: p_PROGRAM_APPLICATION_ID),
551: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,
552: p_PROGRAM_ID),
553: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE,
554: FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE,
555: p_PROGRAM_UPDATE_DATE),
556: LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER,
557: p_LEAD_NUMBER),
558: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE,

Line 556: LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER,

552: p_PROGRAM_ID),
553: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE,
554: FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE,
555: p_PROGRAM_UPDATE_DATE),
556: LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER,
557: p_LEAD_NUMBER),
558: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE,
559: p_STATUS_CODE),
560: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID,

Line 558: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE,

554: FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE,
555: p_PROGRAM_UPDATE_DATE),
556: LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER,
557: p_LEAD_NUMBER),
558: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE,
559: p_STATUS_CODE),
560: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID,
561: p_CUSTOMER_ID),
562: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID,

Line 560: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID,

556: LEAD_NUMBER = decode( p_LEAD_NUMBER, FND_API.G_MISS_CHAR, LEAD_NUMBER,
557: p_LEAD_NUMBER),
558: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE,
559: p_STATUS_CODE),
560: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID,
561: p_CUSTOMER_ID),
562: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID,
563: p_ADDRESS_ID),
564: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID,FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID,

Line 562: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID,

558: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE,
559: p_STATUS_CODE),
560: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID,
561: p_CUSTOMER_ID),
562: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID,
563: p_ADDRESS_ID),
564: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID,FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID,
565: p_SOURCE_PROMOTION_ID),
566: INITIATING_CONTACT_ID = decode( p_INITIATING_CONTACT_ID,

Line 564: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID,FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID,

560: CUSTOMER_ID = decode( p_CUSTOMER_ID, FND_API.G_MISS_NUM, CUSTOMER_ID,
561: p_CUSTOMER_ID),
562: ADDRESS_ID = decode( p_ADDRESS_ID, FND_API.G_MISS_NUM, ADDRESS_ID,
563: p_ADDRESS_ID),
564: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID,FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID,
565: p_SOURCE_PROMOTION_ID),
566: INITIATING_CONTACT_ID = decode( p_INITIATING_CONTACT_ID,
567: FND_API.G_MISS_NUM,
568: INITIATING_CONTACT_ID,

Line 567: FND_API.G_MISS_NUM,

563: p_ADDRESS_ID),
564: SOURCE_PROMOTION_ID = decode( p_SOURCE_PROMOTION_ID,FND_API.G_MISS_NUM, SOURCE_PROMOTION_ID,
565: p_SOURCE_PROMOTION_ID),
566: INITIATING_CONTACT_ID = decode( p_INITIATING_CONTACT_ID,
567: FND_API.G_MISS_NUM,
568: INITIATING_CONTACT_ID,
569: p_INITIATING_CONTACT_ID),
570: ORIG_SYSTEM_REFERENCE = decode( p_ORIG_SYSTEM_REFERENCE,
571: FND_API.G_MISS_CHAR,

Line 571: FND_API.G_MISS_CHAR,

567: FND_API.G_MISS_NUM,
568: INITIATING_CONTACT_ID,
569: p_INITIATING_CONTACT_ID),
570: ORIG_SYSTEM_REFERENCE = decode( p_ORIG_SYSTEM_REFERENCE,
571: FND_API.G_MISS_CHAR,
572: ORIG_SYSTEM_REFERENCE,
573: p_ORIG_SYSTEM_REFERENCE),
574: CONTACT_ROLE_CODE = decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR,
575: CONTACT_ROLE_CODE, p_CONTACT_ROLE_CODE),

Line 574: CONTACT_ROLE_CODE = decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR,

570: ORIG_SYSTEM_REFERENCE = decode( p_ORIG_SYSTEM_REFERENCE,
571: FND_API.G_MISS_CHAR,
572: ORIG_SYSTEM_REFERENCE,
573: p_ORIG_SYSTEM_REFERENCE),
574: CONTACT_ROLE_CODE = decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR,
575: CONTACT_ROLE_CODE, p_CONTACT_ROLE_CODE),
576: CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR,
577: CHANNEL_CODE, p_CHANNEL_CODE),
578: BUDGET_AMOUNT = decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM,

Line 576: CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR,

572: ORIG_SYSTEM_REFERENCE,
573: p_ORIG_SYSTEM_REFERENCE),
574: CONTACT_ROLE_CODE = decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR,
575: CONTACT_ROLE_CODE, p_CONTACT_ROLE_CODE),
576: CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR,
577: CHANNEL_CODE, p_CHANNEL_CODE),
578: BUDGET_AMOUNT = decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM,
579: BUDGET_AMOUNT, p_BUDGET_AMOUNT),
580: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR,

Line 578: BUDGET_AMOUNT = decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM,

574: CONTACT_ROLE_CODE = decode( p_CONTACT_ROLE_CODE, FND_API.G_MISS_CHAR,
575: CONTACT_ROLE_CODE, p_CONTACT_ROLE_CODE),
576: CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR,
577: CHANNEL_CODE, p_CHANNEL_CODE),
578: BUDGET_AMOUNT = decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM,
579: BUDGET_AMOUNT, p_BUDGET_AMOUNT),
580: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR,
581: CURRENCY_CODE, p_CURRENCY_CODE),
582: DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE,

Line 580: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR,

576: CHANNEL_CODE = decode( p_CHANNEL_CODE, FND_API.G_MISS_CHAR,
577: CHANNEL_CODE, p_CHANNEL_CODE),
578: BUDGET_AMOUNT = decode( p_BUDGET_AMOUNT, FND_API.G_MISS_NUM,
579: BUDGET_AMOUNT, p_BUDGET_AMOUNT),
580: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR,
581: CURRENCY_CODE, p_CURRENCY_CODE),
582: DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE,
583: FND_API.G_MISS_CHAR,
584: DECISION_TIMEFRAME_CODE,

Line 583: FND_API.G_MISS_CHAR,

579: BUDGET_AMOUNT, p_BUDGET_AMOUNT),
580: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR,
581: CURRENCY_CODE, p_CURRENCY_CODE),
582: DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE,
583: FND_API.G_MISS_CHAR,
584: DECISION_TIMEFRAME_CODE,
585: p_DECISION_TIMEFRAME_CODE),
586: CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR,
587: CLOSE_REASON, p_CLOSE_REASON),

Line 586: CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR,

582: DECISION_TIMEFRAME_CODE = decode( p_DECISION_TIMEFRAME_CODE,
583: FND_API.G_MISS_CHAR,
584: DECISION_TIMEFRAME_CODE,
585: p_DECISION_TIMEFRAME_CODE),
586: CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR,
587: CLOSE_REASON, p_CLOSE_REASON),
588: LEAD_RANK_ID = decode( p_LEAD_RANK_ID, FND_API.G_MISS_NUM,
589: LEAD_RANK_ID, p_LEAD_RANK_ID),
590: LEAD_RANK_CODE = decode( p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR,

Line 588: LEAD_RANK_ID = decode( p_LEAD_RANK_ID, FND_API.G_MISS_NUM,

584: DECISION_TIMEFRAME_CODE,
585: p_DECISION_TIMEFRAME_CODE),
586: CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR,
587: CLOSE_REASON, p_CLOSE_REASON),
588: LEAD_RANK_ID = decode( p_LEAD_RANK_ID, FND_API.G_MISS_NUM,
589: LEAD_RANK_ID, p_LEAD_RANK_ID),
590: LEAD_RANK_CODE = decode( p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR,
591: LEAD_RANK_CODE, p_LEAD_RANK_CODE),
592: PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR,

Line 590: LEAD_RANK_CODE = decode( p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR,

586: CLOSE_REASON = decode( p_CLOSE_REASON, FND_API.G_MISS_CHAR,
587: CLOSE_REASON, p_CLOSE_REASON),
588: LEAD_RANK_ID = decode( p_LEAD_RANK_ID, FND_API.G_MISS_NUM,
589: LEAD_RANK_ID, p_LEAD_RANK_ID),
590: LEAD_RANK_CODE = decode( p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR,
591: LEAD_RANK_CODE, p_LEAD_RANK_CODE),
592: PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR,
593: PARENT_PROJECT, p_PARENT_PROJECT),
594: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR,

Line 592: PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR,

588: LEAD_RANK_ID = decode( p_LEAD_RANK_ID, FND_API.G_MISS_NUM,
589: LEAD_RANK_ID, p_LEAD_RANK_ID),
590: LEAD_RANK_CODE = decode( p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR,
591: LEAD_RANK_CODE, p_LEAD_RANK_CODE),
592: PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR,
593: PARENT_PROJECT, p_PARENT_PROJECT),
594: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR,
595: DESCRIPTION, p_DESCRIPTION),
596: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,

Line 594: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR,

590: LEAD_RANK_CODE = decode( p_LEAD_RANK_CODE, FND_API.G_MISS_CHAR,
591: LEAD_RANK_CODE, p_LEAD_RANK_CODE),
592: PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR,
593: PARENT_PROJECT, p_PARENT_PROJECT),
594: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR,
595: DESCRIPTION, p_DESCRIPTION),
596: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,
597: ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
598: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,

Line 596: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,

592: PARENT_PROJECT = decode( p_PARENT_PROJECT, FND_API.G_MISS_CHAR,
593: PARENT_PROJECT, p_PARENT_PROJECT),
594: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR,
595: DESCRIPTION, p_DESCRIPTION),
596: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,
597: ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
598: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,
599: p_ATTRIBUTE1),
600: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,

Line 598: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,

594: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR,
595: DESCRIPTION, p_DESCRIPTION),
596: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,
597: ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
598: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,
599: p_ATTRIBUTE1),
600: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,
601: p_ATTRIBUTE2),
602: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,

Line 600: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,

596: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,
597: ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
598: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,
599: p_ATTRIBUTE1),
600: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,
601: p_ATTRIBUTE2),
602: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,
603: p_ATTRIBUTE3),
604: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,

Line 602: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,

598: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,
599: p_ATTRIBUTE1),
600: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,
601: p_ATTRIBUTE2),
602: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,
603: p_ATTRIBUTE3),
604: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,
605: p_ATTRIBUTE4),
606: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,

Line 604: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,

600: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,
601: p_ATTRIBUTE2),
602: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,
603: p_ATTRIBUTE3),
604: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,
605: p_ATTRIBUTE4),
606: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,
607: p_ATTRIBUTE5),
608: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,

Line 606: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,

602: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,
603: p_ATTRIBUTE3),
604: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,
605: p_ATTRIBUTE4),
606: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,
607: p_ATTRIBUTE5),
608: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,
609: p_ATTRIBUTE6),
610: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,

Line 608: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,

604: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,
605: p_ATTRIBUTE4),
606: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,
607: p_ATTRIBUTE5),
608: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,
609: p_ATTRIBUTE6),
610: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,
611: p_ATTRIBUTE7),
612: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,

Line 610: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,

606: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,
607: p_ATTRIBUTE5),
608: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,
609: p_ATTRIBUTE6),
610: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,
611: p_ATTRIBUTE7),
612: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,
613: p_ATTRIBUTE8),
614: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,

Line 612: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,

608: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,
609: p_ATTRIBUTE6),
610: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,
611: p_ATTRIBUTE7),
612: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,
613: p_ATTRIBUTE8),
614: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,
615: p_ATTRIBUTE9),
616: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,

Line 614: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,

610: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,
611: p_ATTRIBUTE7),
612: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,
613: p_ATTRIBUTE8),
614: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,
615: p_ATTRIBUTE9),
616: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,
617: p_ATTRIBUTE10),
618: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,

Line 616: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,

612: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,
613: p_ATTRIBUTE8),
614: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,
615: p_ATTRIBUTE9),
616: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,
617: p_ATTRIBUTE10),
618: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,
619: p_ATTRIBUTE11),
620: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,

Line 618: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,

614: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,
615: p_ATTRIBUTE9),
616: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,
617: p_ATTRIBUTE10),
618: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,
619: p_ATTRIBUTE11),
620: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,
621: p_ATTRIBUTE12),
622: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,

Line 620: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,

616: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,
617: p_ATTRIBUTE10),
618: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,
619: p_ATTRIBUTE11),
620: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,
621: p_ATTRIBUTE12),
622: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,
623: p_ATTRIBUTE13),
624: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,

Line 622: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,

618: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,
619: p_ATTRIBUTE11),
620: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,
621: p_ATTRIBUTE12),
622: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,
623: p_ATTRIBUTE13),
624: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,
625: p_ATTRIBUTE14),
626: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,

Line 624: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,

620: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,
621: p_ATTRIBUTE12),
622: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,
623: p_ATTRIBUTE13),
624: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,
625: p_ATTRIBUTE14),
626: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,
627: p_ATTRIBUTE15),
628: ASSIGN_TO_PERSON_ID = decode( p_ASSIGN_TO_PERSON_ID,FND_API.G_MISS_NUM,

Line 626: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,

622: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,
623: p_ATTRIBUTE13),
624: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,
625: p_ATTRIBUTE14),
626: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,
627: p_ATTRIBUTE15),
628: ASSIGN_TO_PERSON_ID = decode( p_ASSIGN_TO_PERSON_ID,FND_API.G_MISS_NUM,
629: ASSIGN_TO_PERSON_ID,
630: p_ASSIGN_TO_PERSON_ID),

Line 628: ASSIGN_TO_PERSON_ID = decode( p_ASSIGN_TO_PERSON_ID,FND_API.G_MISS_NUM,

624: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,
625: p_ATTRIBUTE14),
626: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,
627: p_ATTRIBUTE15),
628: ASSIGN_TO_PERSON_ID = decode( p_ASSIGN_TO_PERSON_ID,FND_API.G_MISS_NUM,
629: ASSIGN_TO_PERSON_ID,
630: p_ASSIGN_TO_PERSON_ID),
631: ASSIGN_TO_SALESFORCE_ID = decode( p_ASSIGN_TO_SALESFORCE_ID,
632: FND_API.G_MISS_NUM,

Line 632: FND_API.G_MISS_NUM,

628: ASSIGN_TO_PERSON_ID = decode( p_ASSIGN_TO_PERSON_ID,FND_API.G_MISS_NUM,
629: ASSIGN_TO_PERSON_ID,
630: p_ASSIGN_TO_PERSON_ID),
631: ASSIGN_TO_SALESFORCE_ID = decode( p_ASSIGN_TO_SALESFORCE_ID,
632: FND_API.G_MISS_NUM,
633: ASSIGN_TO_SALESFORCE_ID,
634: p_ASSIGN_TO_SALESFORCE_ID),
635: ASSIGN_SALES_GROUP_ID = decode( p_ASSIGN_SALES_GROUP_ID,
636: FND_API.G_MISS_NUM,

Line 636: FND_API.G_MISS_NUM,

632: FND_API.G_MISS_NUM,
633: ASSIGN_TO_SALESFORCE_ID,
634: p_ASSIGN_TO_SALESFORCE_ID),
635: ASSIGN_SALES_GROUP_ID = decode( p_ASSIGN_SALES_GROUP_ID,
636: FND_API.G_MISS_NUM,
637: ASSIGN_SALES_GROUP_ID,
638: p_ASSIGN_SALES_GROUP_ID),
639: ASSIGN_DATE = decode( p_ASSIGN_DATE, FND_API.G_MISS_DATE, ASSIGN_DATE,
640: p_ASSIGN_DATE),

Line 639: ASSIGN_DATE = decode( p_ASSIGN_DATE, FND_API.G_MISS_DATE, ASSIGN_DATE,

635: ASSIGN_SALES_GROUP_ID = decode( p_ASSIGN_SALES_GROUP_ID,
636: FND_API.G_MISS_NUM,
637: ASSIGN_SALES_GROUP_ID,
638: p_ASSIGN_SALES_GROUP_ID),
639: ASSIGN_DATE = decode( p_ASSIGN_DATE, FND_API.G_MISS_DATE, ASSIGN_DATE,
640: p_ASSIGN_DATE),
641: BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR,
642: BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),
643: ACCEPT_FLAG = decode( p_ACCEPT_FLAG, FND_API.G_MISS_CHAR, ACCEPT_FLAG,

Line 641: BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR,

637: ASSIGN_SALES_GROUP_ID,
638: p_ASSIGN_SALES_GROUP_ID),
639: ASSIGN_DATE = decode( p_ASSIGN_DATE, FND_API.G_MISS_DATE, ASSIGN_DATE,
640: p_ASSIGN_DATE),
641: BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR,
642: BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),
643: ACCEPT_FLAG = decode( p_ACCEPT_FLAG, FND_API.G_MISS_CHAR, ACCEPT_FLAG,
644: p_ACCEPT_FLAG),
645: VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE,

Line 643: ACCEPT_FLAG = decode( p_ACCEPT_FLAG, FND_API.G_MISS_CHAR, ACCEPT_FLAG,

639: ASSIGN_DATE = decode( p_ASSIGN_DATE, FND_API.G_MISS_DATE, ASSIGN_DATE,
640: p_ASSIGN_DATE),
641: BUDGET_STATUS_CODE = decode( p_BUDGET_STATUS_CODE, FND_API.G_MISS_CHAR,
642: BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),
643: ACCEPT_FLAG = decode( p_ACCEPT_FLAG, FND_API.G_MISS_CHAR, ACCEPT_FLAG,
644: p_ACCEPT_FLAG),
645: VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE,
646: FND_API.G_MISS_CHAR,
647: VEHICLE_RESPONSE_CODE,

Line 646: FND_API.G_MISS_CHAR,

642: BUDGET_STATUS_CODE, p_BUDGET_STATUS_CODE),
643: ACCEPT_FLAG = decode( p_ACCEPT_FLAG, FND_API.G_MISS_CHAR, ACCEPT_FLAG,
644: p_ACCEPT_FLAG),
645: VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE,
646: FND_API.G_MISS_CHAR,
647: VEHICLE_RESPONSE_CODE,
648: p_VEHICLE_RESPONSE_CODE),
649: TOTAL_SCORE = decode( p_TOTAL_SCORE, FND_API.G_MISS_NUM, TOTAL_SCORE,
650: p_TOTAL_SCORE),

Line 649: TOTAL_SCORE = decode( p_TOTAL_SCORE, FND_API.G_MISS_NUM, TOTAL_SCORE,

645: VEHICLE_RESPONSE_CODE = decode( p_VEHICLE_RESPONSE_CODE,
646: FND_API.G_MISS_CHAR,
647: VEHICLE_RESPONSE_CODE,
648: p_VEHICLE_RESPONSE_CODE),
649: TOTAL_SCORE = decode( p_TOTAL_SCORE, FND_API.G_MISS_NUM, TOTAL_SCORE,
650: p_TOTAL_SCORE),
651: SCORECARD_ID = decode( p_SCORECARD_ID, FND_API.G_MISS_NUM,SCORECARD_ID,
652: p_SCORECARD_ID),
653: KEEP_FLAG = decode( p_KEEP_FLAG, FND_API.G_MISS_CHAR, KEEP_FLAG,

Line 651: SCORECARD_ID = decode( p_SCORECARD_ID, FND_API.G_MISS_NUM,SCORECARD_ID,

647: VEHICLE_RESPONSE_CODE,
648: p_VEHICLE_RESPONSE_CODE),
649: TOTAL_SCORE = decode( p_TOTAL_SCORE, FND_API.G_MISS_NUM, TOTAL_SCORE,
650: p_TOTAL_SCORE),
651: SCORECARD_ID = decode( p_SCORECARD_ID, FND_API.G_MISS_NUM,SCORECARD_ID,
652: p_SCORECARD_ID),
653: KEEP_FLAG = decode( p_KEEP_FLAG, FND_API.G_MISS_CHAR, KEEP_FLAG,
654: p_KEEP_FLAG),
655: URGENT_FLAG = decode( p_URGENT_FLAG, FND_API.G_MISS_CHAR, URGENT_FLAG,

Line 653: KEEP_FLAG = decode( p_KEEP_FLAG, FND_API.G_MISS_CHAR, KEEP_FLAG,

649: TOTAL_SCORE = decode( p_TOTAL_SCORE, FND_API.G_MISS_NUM, TOTAL_SCORE,
650: p_TOTAL_SCORE),
651: SCORECARD_ID = decode( p_SCORECARD_ID, FND_API.G_MISS_NUM,SCORECARD_ID,
652: p_SCORECARD_ID),
653: KEEP_FLAG = decode( p_KEEP_FLAG, FND_API.G_MISS_CHAR, KEEP_FLAG,
654: p_KEEP_FLAG),
655: URGENT_FLAG = decode( p_URGENT_FLAG, FND_API.G_MISS_CHAR, URGENT_FLAG,
656: p_URGENT_FLAG),
657: IMPORT_FLAG = decode( p_IMPORT_FLAG, FND_API.G_MISS_CHAR, IMPORT_FLAG,

Line 655: URGENT_FLAG = decode( p_URGENT_FLAG, FND_API.G_MISS_CHAR, URGENT_FLAG,

651: SCORECARD_ID = decode( p_SCORECARD_ID, FND_API.G_MISS_NUM,SCORECARD_ID,
652: p_SCORECARD_ID),
653: KEEP_FLAG = decode( p_KEEP_FLAG, FND_API.G_MISS_CHAR, KEEP_FLAG,
654: p_KEEP_FLAG),
655: URGENT_FLAG = decode( p_URGENT_FLAG, FND_API.G_MISS_CHAR, URGENT_FLAG,
656: p_URGENT_FLAG),
657: IMPORT_FLAG = decode( p_IMPORT_FLAG, FND_API.G_MISS_CHAR, IMPORT_FLAG,
658: p_IMPORT_FLAG),
659: REJECT_REASON_CODE = decode( p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR,

Line 657: IMPORT_FLAG = decode( p_IMPORT_FLAG, FND_API.G_MISS_CHAR, IMPORT_FLAG,

653: KEEP_FLAG = decode( p_KEEP_FLAG, FND_API.G_MISS_CHAR, KEEP_FLAG,
654: p_KEEP_FLAG),
655: URGENT_FLAG = decode( p_URGENT_FLAG, FND_API.G_MISS_CHAR, URGENT_FLAG,
656: p_URGENT_FLAG),
657: IMPORT_FLAG = decode( p_IMPORT_FLAG, FND_API.G_MISS_CHAR, IMPORT_FLAG,
658: p_IMPORT_FLAG),
659: REJECT_REASON_CODE = decode( p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR,
660: REJECT_REASON_CODE, p_REJECT_REASON_CODE),
661: DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR,

Line 659: REJECT_REASON_CODE = decode( p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR,

655: URGENT_FLAG = decode( p_URGENT_FLAG, FND_API.G_MISS_CHAR, URGENT_FLAG,
656: p_URGENT_FLAG),
657: IMPORT_FLAG = decode( p_IMPORT_FLAG, FND_API.G_MISS_CHAR, IMPORT_FLAG,
658: p_IMPORT_FLAG),
659: REJECT_REASON_CODE = decode( p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR,
660: REJECT_REASON_CODE, p_REJECT_REASON_CODE),
661: DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR,
662: DELETED_FLAG, p_DELETED_FLAG),
663: OFFER_ID = decode(p_OFFER_ID,FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),

Line 661: DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR,

657: IMPORT_FLAG = decode( p_IMPORT_FLAG, FND_API.G_MISS_CHAR, IMPORT_FLAG,
658: p_IMPORT_FLAG),
659: REJECT_REASON_CODE = decode( p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR,
660: REJECT_REASON_CODE, p_REJECT_REASON_CODE),
661: DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR,
662: DELETED_FLAG, p_DELETED_FLAG),
663: OFFER_ID = decode(p_OFFER_ID,FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
664: QUALIFIED_FLAG = decode( p_QUALIFIED_FLAG, FND_API.G_MISS_CHAR,
665: QUALIFIED_FLAG, p_QUALIFIED_FLAG),

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

659: REJECT_REASON_CODE = decode( p_REJECT_REASON_CODE, FND_API.G_MISS_CHAR,
660: REJECT_REASON_CODE, p_REJECT_REASON_CODE),
661: DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR,
662: DELETED_FLAG, p_DELETED_FLAG),
663: OFFER_ID = decode(p_OFFER_ID,FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
664: QUALIFIED_FLAG = decode( p_QUALIFIED_FLAG, FND_API.G_MISS_CHAR,
665: QUALIFIED_FLAG, p_QUALIFIED_FLAG),
666: ORIG_SYSTEM_CODE = decode( p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR,
667: ORIG_SYSTEM_CODE, p_ORIG_SYSTEM_CODE),

Line 664: QUALIFIED_FLAG = decode( p_QUALIFIED_FLAG, FND_API.G_MISS_CHAR,

660: REJECT_REASON_CODE, p_REJECT_REASON_CODE),
661: DELETED_FLAG = decode( p_DELETED_FLAG, FND_API.G_MISS_CHAR,
662: DELETED_FLAG, p_DELETED_FLAG),
663: OFFER_ID = decode(p_OFFER_ID,FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
664: QUALIFIED_FLAG = decode( p_QUALIFIED_FLAG, FND_API.G_MISS_CHAR,
665: QUALIFIED_FLAG, p_QUALIFIED_FLAG),
666: ORIG_SYSTEM_CODE = decode( p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR,
667: ORIG_SYSTEM_CODE, p_ORIG_SYSTEM_CODE),
668: -- SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM,

Line 666: ORIG_SYSTEM_CODE = decode( p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR,

662: DELETED_FLAG, p_DELETED_FLAG),
663: OFFER_ID = decode(p_OFFER_ID,FND_API.G_MISS_NUM, OFFER_ID, p_OFFER_ID),
664: QUALIFIED_FLAG = decode( p_QUALIFIED_FLAG, FND_API.G_MISS_CHAR,
665: QUALIFIED_FLAG, p_QUALIFIED_FLAG),
666: ORIG_SYSTEM_CODE = decode( p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR,
667: ORIG_SYSTEM_CODE, p_ORIG_SYSTEM_CODE),
668: -- SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM,
669: -- SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),
670: INCUMBENT_PARTNER_PARTY_ID = decode(p_INC_PARTNER_PARTY_ID,

Line 668: -- SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM,

664: QUALIFIED_FLAG = decode( p_QUALIFIED_FLAG, FND_API.G_MISS_CHAR,
665: QUALIFIED_FLAG, p_QUALIFIED_FLAG),
666: ORIG_SYSTEM_CODE = decode( p_ORIG_SYSTEM_CODE, FND_API.G_MISS_CHAR,
667: ORIG_SYSTEM_CODE, p_ORIG_SYSTEM_CODE),
668: -- SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM,
669: -- SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),
670: INCUMBENT_PARTNER_PARTY_ID = decode(p_INC_PARTNER_PARTY_ID,
671: FND_API.G_MISS_NUM,
672: INCUMBENT_PARTNER_PARTY_ID,

Line 671: FND_API.G_MISS_NUM,

667: ORIG_SYSTEM_CODE, p_ORIG_SYSTEM_CODE),
668: -- SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM,
669: -- SECURITY_GROUP_ID, p_SECURITY_GROUP_ID),
670: INCUMBENT_PARTNER_PARTY_ID = decode(p_INC_PARTNER_PARTY_ID,
671: FND_API.G_MISS_NUM,
672: INCUMBENT_PARTNER_PARTY_ID,
673: p_INC_PARTNER_PARTY_ID),
674: INCUMBENT_PARTNER_RESOURCE_ID = decode(p_INC_PARTNER_RESOURCE_ID,
675: FND_API.G_MISS_NUM,

Line 675: FND_API.G_MISS_NUM,

671: FND_API.G_MISS_NUM,
672: INCUMBENT_PARTNER_PARTY_ID,
673: p_INC_PARTNER_PARTY_ID),
674: INCUMBENT_PARTNER_RESOURCE_ID = decode(p_INC_PARTNER_RESOURCE_ID,
675: FND_API.G_MISS_NUM,
676: INCUMBENT_PARTNER_RESOURCE_ID,
677: p_INC_PARTNER_RESOURCE_ID),
678: PRM_EXEC_SPONSOR_FLAG = decode(p_PRM_EXEC_SPONSOR_FLAG,
679: FND_API.G_MISS_CHAR,

Line 679: FND_API.G_MISS_CHAR,

675: FND_API.G_MISS_NUM,
676: INCUMBENT_PARTNER_RESOURCE_ID,
677: p_INC_PARTNER_RESOURCE_ID),
678: PRM_EXEC_SPONSOR_FLAG = decode(p_PRM_EXEC_SPONSOR_FLAG,
679: FND_API.G_MISS_CHAR,
680: PRM_EXEC_SPONSOR_FLAG,
681: p_PRM_EXEC_SPONSOR_FLAG),
682: PRM_PRJ_LEAD_IN_PLACE_FLAG = decode(p_PRM_PRJ_LEAD_IN_PLACE_FLAG,
683: FND_API.G_MISS_CHAR,

Line 683: FND_API.G_MISS_CHAR,

679: FND_API.G_MISS_CHAR,
680: PRM_EXEC_SPONSOR_FLAG,
681: p_PRM_EXEC_SPONSOR_FLAG),
682: PRM_PRJ_LEAD_IN_PLACE_FLAG = decode(p_PRM_PRJ_LEAD_IN_PLACE_FLAG,
683: FND_API.G_MISS_CHAR,
684: PRM_PRJ_LEAD_IN_PLACE_FLAG,
685: p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
686: PRM_SALES_LEAD_TYPE = decode(p_PRM_SALES_LEAD_TYPE,
687: FND_API.G_MISS_CHAR,

Line 687: FND_API.G_MISS_CHAR,

683: FND_API.G_MISS_CHAR,
684: PRM_PRJ_LEAD_IN_PLACE_FLAG,
685: p_PRM_PRJ_LEAD_IN_PLACE_FLAG),
686: PRM_SALES_LEAD_TYPE = decode(p_PRM_SALES_LEAD_TYPE,
687: FND_API.G_MISS_CHAR,
688: PRM_SALES_LEAD_TYPE,
689: p_PRM_SALES_LEAD_TYPE),
690: PRM_IND_CLASSIFICATION_CODE = decode(p_PRM_IND_CLASSIFICATION_CODE,
691: FND_API.G_MISS_CHAR,

Line 691: FND_API.G_MISS_CHAR,

687: FND_API.G_MISS_CHAR,
688: PRM_SALES_LEAD_TYPE,
689: p_PRM_SALES_LEAD_TYPE),
690: PRM_IND_CLASSIFICATION_CODE = decode(p_PRM_IND_CLASSIFICATION_CODE,
691: FND_API.G_MISS_CHAR,
692: PRM_IND_CLASSIFICATION_CODE,
693: p_PRM_IND_CLASSIFICATION_CODE),
694: PRM_ASSIGNMENT_TYPE = decode(p_PRM_ASSIGNMENT_TYPE,
695: FND_API.G_MISS_CHAR,

Line 695: FND_API.G_MISS_CHAR,

691: FND_API.G_MISS_CHAR,
692: PRM_IND_CLASSIFICATION_CODE,
693: p_PRM_IND_CLASSIFICATION_CODE),
694: PRM_ASSIGNMENT_TYPE = decode(p_PRM_ASSIGNMENT_TYPE,
695: FND_API.G_MISS_CHAR,
696: PRM_ASSIGNMENT_TYPE,
697: p_PRM_ASSIGNMENT_TYPE),
698: AUTO_ASSIGNMENT_TYPE = decode(p_AUTO_ASSIGNMENT_TYPE,
699: FND_API.G_MISS_CHAR,

Line 699: FND_API.G_MISS_CHAR,

695: FND_API.G_MISS_CHAR,
696: PRM_ASSIGNMENT_TYPE,
697: p_PRM_ASSIGNMENT_TYPE),
698: AUTO_ASSIGNMENT_TYPE = decode(p_AUTO_ASSIGNMENT_TYPE,
699: FND_API.G_MISS_CHAR,
700: AUTO_ASSIGNMENT_TYPE,
701: p_AUTO_ASSIGNMENT_TYPE),
702:
703: PRIMARY_CONTACT_PARTY_ID = decode(p_PRIMARY_CONTACT_PARTY_ID,

Line 704: FND_API.G_MISS_NUM,

700: AUTO_ASSIGNMENT_TYPE,
701: p_AUTO_ASSIGNMENT_TYPE),
702:
703: PRIMARY_CONTACT_PARTY_ID = decode(p_PRIMARY_CONTACT_PARTY_ID,
704: FND_API.G_MISS_NUM,
705: PRIMARY_CONTACT_PARTY_ID,
706: p_PRIMARY_CONTACT_PARTY_ID),
707:
708: PRIMARY_CNT_PERSON_PARTY_ID = decode(p_PRIMARY_CNT_PERSON_PARTY_ID,

Line 709: FND_API.G_MISS_NUM,

705: PRIMARY_CONTACT_PARTY_ID,
706: p_PRIMARY_CONTACT_PARTY_ID),
707:
708: PRIMARY_CNT_PERSON_PARTY_ID = decode(p_PRIMARY_CNT_PERSON_PARTY_ID,
709: FND_API.G_MISS_NUM,
710: PRIMARY_CNT_PERSON_PARTY_ID,
711: p_PRIMARY_CNT_PERSON_PARTY_ID),
712:
713: PRIMARY_CONTACT_PHONE_ID = decode(p_PRIMARY_CONTACT_PHONE_ID,

Line 714: FND_API.G_MISS_NUM,

710: PRIMARY_CNT_PERSON_PARTY_ID,
711: p_PRIMARY_CNT_PERSON_PARTY_ID),
712:
713: PRIMARY_CONTACT_PHONE_ID = decode(p_PRIMARY_CONTACT_PHONE_ID,
714: FND_API.G_MISS_NUM,
715: PRIMARY_CONTACT_PHONE_ID,
716: p_PRIMARY_CONTACT_PHONE_ID),
717:
718: REFERRED_BY = decode(p_REFERRED_BY,

Line 719: FND_API.G_MISS_NUM,

715: PRIMARY_CONTACT_PHONE_ID,
716: p_PRIMARY_CONTACT_PHONE_ID),
717:
718: REFERRED_BY = decode(p_REFERRED_BY,
719: FND_API.G_MISS_NUM,
720: REFERRED_BY,
721: p_REFERRED_BY),
722:
723: REFERRAL_TYPE = decode(p_REFERRAL_TYPE,

Line 724: FND_API.G_MISS_CHAR,

720: REFERRED_BY,
721: p_REFERRED_BY),
722:
723: REFERRAL_TYPE = decode(p_REFERRAL_TYPE,
724: FND_API.G_MISS_CHAR,
725: REFERRAL_TYPE,
726: p_REFERRAL_TYPE),
727:
728:

Line 730: FND_API.G_MISS_CHAR,

726: p_REFERRAL_TYPE),
727:
728:
729: REFERRAL_STATUS = decode(p_REFERRAL_STATUS,
730: FND_API.G_MISS_CHAR,
731: REFERRAL_STATUS,
732: p_REFERRAL_STATUS),
733:
734:

Line 736: FND_API.G_MISS_CHAR,

732: p_REFERRAL_STATUS),
733:
734:
735: REF_DECLINE_REASON = decode(p_REF_DECLINE_REASON,
736: FND_API.G_MISS_CHAR,
737: REF_DECLINE_REASON,
738: p_REF_DECLINE_REASON),
739:
740:

Line 742: FND_API.G_MISS_CHAR,

738: p_REF_DECLINE_REASON),
739:
740:
741: REF_COMM_LTR_STATUS = decode(p_REF_COMM_LTR_STATUS,
742: FND_API.G_MISS_CHAR,
743: REF_COMM_LTR_STATUS,
744: p_REF_COMM_LTR_STATUS),
745:
746:

Line 748: FND_API.G_MISS_NUM,

744: p_REF_COMM_LTR_STATUS),
745:
746:
747: REF_ORDER_NUMBER = decode(p_REF_ORDER_NUMBER,
748: FND_API.G_MISS_NUM,
749: REF_ORDER_NUMBER,
750: p_REF_ORDER_NUMBER),
751:
752: REF_ORDER_AMT = decode(p_REF_ORDER_AMT,

Line 753: FND_API.G_MISS_NUM,

749: REF_ORDER_NUMBER,
750: p_REF_ORDER_NUMBER),
751:
752: REF_ORDER_AMT = decode(p_REF_ORDER_AMT,
753: FND_API.G_MISS_NUM,
754: REF_ORDER_AMT,
755: p_REF_ORDER_AMT),
756:
757:

Line 759: FND_API.G_MISS_NUM,

755: p_REF_ORDER_AMT),
756:
757:
758: REF_COMM_AMT = decode(p_REF_COMM_AMT,
759: FND_API.G_MISS_NUM,
760: REF_COMM_AMT,
761: p_REF_COMM_AMT),
762:
763: TRUNC_CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,

Line 763: TRUNC_CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,

759: FND_API.G_MISS_NUM,
760: REF_COMM_AMT,
761: p_REF_COMM_AMT),
762:
763: TRUNC_CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
764: TRUNC_CREATION_DATE, TRUNC(p_CREATION_DATE)),
765:
766: LEAD_DATE = decode( p_LEAD_DATE , FND_API.G_MISS_DATE,
767: LEAD_DATE , p_LEAD_DATE ),

Line 766: LEAD_DATE = decode( p_LEAD_DATE , FND_API.G_MISS_DATE,

762:
763: TRUNC_CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
764: TRUNC_CREATION_DATE, TRUNC(p_CREATION_DATE)),
765:
766: LEAD_DATE = decode( p_LEAD_DATE , FND_API.G_MISS_DATE,
767: LEAD_DATE , p_LEAD_DATE ),
768:
769: SOURCE_SYSTEM = decode( p_SOURCE_SYSTEM , FND_API.G_MISS_CHAR,
770: SOURCE_SYSTEM , p_SOURCE_SYSTEM ),

Line 769: SOURCE_SYSTEM = decode( p_SOURCE_SYSTEM , FND_API.G_MISS_CHAR,

765:
766: LEAD_DATE = decode( p_LEAD_DATE , FND_API.G_MISS_DATE,
767: LEAD_DATE , p_LEAD_DATE ),
768:
769: SOURCE_SYSTEM = decode( p_SOURCE_SYSTEM , FND_API.G_MISS_CHAR,
770: SOURCE_SYSTEM , p_SOURCE_SYSTEM ),
771:
772: COUNTRY = decode( p_COUNTRY , FND_API.G_MISS_CHAR,
773: COUNTRY , p_COUNTRY ),

Line 772: COUNTRY = decode( p_COUNTRY , FND_API.G_MISS_CHAR,

768:
769: SOURCE_SYSTEM = decode( p_SOURCE_SYSTEM , FND_API.G_MISS_CHAR,
770: SOURCE_SYSTEM , p_SOURCE_SYSTEM ),
771:
772: COUNTRY = decode( p_COUNTRY , FND_API.G_MISS_CHAR,
773: COUNTRY , p_COUNTRY ),
774:
775: TOTAL_AMOUNT = decode(p_TOTAL_AMOUNT, FND_API.G_MISS_NUM,TOTAL_AMOUNT,p_TOTAL_AMOUNT),
776:

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

771:
772: COUNTRY = decode( p_COUNTRY , FND_API.G_MISS_CHAR,
773: COUNTRY , p_COUNTRY ),
774:
775: TOTAL_AMOUNT = decode(p_TOTAL_AMOUNT, FND_API.G_MISS_NUM,TOTAL_AMOUNT,p_TOTAL_AMOUNT),
776:
777: EXPIRATION_DATE = decode( p_EXPIRATION_DATE , FND_API.G_MISS_DATE,
778: EXPIRATION_DATE , p_EXPIRATION_DATE ),
779:

Line 777: EXPIRATION_DATE = decode( p_EXPIRATION_DATE , FND_API.G_MISS_DATE,

773: COUNTRY , p_COUNTRY ),
774:
775: TOTAL_AMOUNT = decode(p_TOTAL_AMOUNT, FND_API.G_MISS_NUM,TOTAL_AMOUNT,p_TOTAL_AMOUNT),
776:
777: EXPIRATION_DATE = decode( p_EXPIRATION_DATE , FND_API.G_MISS_DATE,
778: EXPIRATION_DATE , p_EXPIRATION_DATE ),
779:
780: LEAD_RANK_IND = decode(p_LEAD_RANK_IND, FND_API.G_MISS_CHAR,LEAD_RANK_IND,p_LEAD_RANK_IND),
781:

Line 780: LEAD_RANK_IND = decode(p_LEAD_RANK_IND, FND_API.G_MISS_CHAR,LEAD_RANK_IND,p_LEAD_RANK_IND),

776:
777: EXPIRATION_DATE = decode( p_EXPIRATION_DATE , FND_API.G_MISS_DATE,
778: EXPIRATION_DATE , p_EXPIRATION_DATE ),
779:
780: LEAD_RANK_IND = decode(p_LEAD_RANK_IND, FND_API.G_MISS_CHAR,LEAD_RANK_IND,p_LEAD_RANK_IND),
781:
782: LEAD_ENGINE_RUN_DATE = decode( p_LEAD_ENGINE_RUN_DATE, FND_API.G_MISS_DATE,
783: LEAD_ENGINE_RUN_DATE , p_LEAD_ENGINE_RUN_DATE ),
784:

Line 782: LEAD_ENGINE_RUN_DATE = decode( p_LEAD_ENGINE_RUN_DATE, FND_API.G_MISS_DATE,

778: EXPIRATION_DATE , p_EXPIRATION_DATE ),
779:
780: LEAD_RANK_IND = decode(p_LEAD_RANK_IND, FND_API.G_MISS_CHAR,LEAD_RANK_IND,p_LEAD_RANK_IND),
781:
782: LEAD_ENGINE_RUN_DATE = decode( p_LEAD_ENGINE_RUN_DATE, FND_API.G_MISS_DATE,
783: LEAD_ENGINE_RUN_DATE , p_LEAD_ENGINE_RUN_DATE ),
784:
785: CURRENT_REROUTES = decode(p_CURRENT_REROUTES, FND_API.G_MISS_NUM,CURRENT_REROUTES,p_CURRENT_REROUTES)
786:

Line 785: CURRENT_REROUTES = decode(p_CURRENT_REROUTES, FND_API.G_MISS_NUM,CURRENT_REROUTES,p_CURRENT_REROUTES)

781:
782: LEAD_ENGINE_RUN_DATE = decode( p_LEAD_ENGINE_RUN_DATE, FND_API.G_MISS_DATE,
783: LEAD_ENGINE_RUN_DATE , p_LEAD_ENGINE_RUN_DATE ),
784:
785: CURRENT_REROUTES = decode(p_CURRENT_REROUTES, FND_API.G_MISS_NUM,CURRENT_REROUTES,p_CURRENT_REROUTES)
786:
787: -- new columns for appsperf CRMAP denorm project bug 2928041
788:
789: , STATUS_OPEN_FLAG = decode( p_STATUS_OPEN_FLAG, FND_API.G_MISS_CHAR,

Line 789: , STATUS_OPEN_FLAG = decode( p_STATUS_OPEN_FLAG, FND_API.G_MISS_CHAR,

785: CURRENT_REROUTES = decode(p_CURRENT_REROUTES, FND_API.G_MISS_NUM,CURRENT_REROUTES,p_CURRENT_REROUTES)
786:
787: -- new columns for appsperf CRMAP denorm project bug 2928041
788:
789: , STATUS_OPEN_FLAG = decode( p_STATUS_OPEN_FLAG, FND_API.G_MISS_CHAR,
790: STATUS_OPEN_FLAG, p_STATUS_OPEN_FLAG)
791:
792: , LEAD_RANK_SCORE = decode(p_LEAD_RANK_SCORE,
793: FND_API.G_MISS_NUM,

Line 793: FND_API.G_MISS_NUM,

789: , STATUS_OPEN_FLAG = decode( p_STATUS_OPEN_FLAG, FND_API.G_MISS_CHAR,
790: STATUS_OPEN_FLAG, p_STATUS_OPEN_FLAG)
791:
792: , LEAD_RANK_SCORE = decode(p_LEAD_RANK_SCORE,
793: FND_API.G_MISS_NUM,
794: LEAD_RANK_SCORE,
795: p_LEAD_RANK_SCORE)
796:
797: -- 11.5.10 - ckapoor : new columns

Line 799: , MARKETING_SCORE = decode( p_MARKETING_SCORE, FND_API.G_MISS_NUM,

795: p_LEAD_RANK_SCORE)
796:
797: -- 11.5.10 - ckapoor : new columns
798:
799: , MARKETING_SCORE = decode( p_MARKETING_SCORE, FND_API.G_MISS_NUM,
800: MARKETING_SCORE, p_MARKETING_SCORE)
801:
802: , INTERACTION_SCORE = decode(p_INTERACTION_SCORE,
803: FND_API.G_MISS_NUM,

Line 803: FND_API.G_MISS_NUM,

799: , MARKETING_SCORE = decode( p_MARKETING_SCORE, FND_API.G_MISS_NUM,
800: MARKETING_SCORE, p_MARKETING_SCORE)
801:
802: , INTERACTION_SCORE = decode(p_INTERACTION_SCORE,
803: FND_API.G_MISS_NUM,
804: INTERACTION_SCORE,
805: p_INTERACTION_SCORE)
806:
807: , SOURCE_PRIMARY_REFERENCE = decode( p_SOURCE_PRIMARY_REFERENCE, FND_API.G_MISS_CHAR,

Line 807: , SOURCE_PRIMARY_REFERENCE = decode( p_SOURCE_PRIMARY_REFERENCE, FND_API.G_MISS_CHAR,

803: FND_API.G_MISS_NUM,
804: INTERACTION_SCORE,
805: p_INTERACTION_SCORE)
806:
807: , SOURCE_PRIMARY_REFERENCE = decode( p_SOURCE_PRIMARY_REFERENCE, FND_API.G_MISS_CHAR,
808: SOURCE_PRIMARY_REFERENCE, p_SOURCE_PRIMARY_REFERENCE)
809:
810: , SOURCE_SECONDARY_REFERENCE = decode(p_SOURCE_SECONDARY_REFERENCE,
811: FND_API.G_MISS_CHAR,

Line 811: FND_API.G_MISS_CHAR,

807: , SOURCE_PRIMARY_REFERENCE = decode( p_SOURCE_PRIMARY_REFERENCE, FND_API.G_MISS_CHAR,
808: SOURCE_PRIMARY_REFERENCE, p_SOURCE_PRIMARY_REFERENCE)
809:
810: , SOURCE_SECONDARY_REFERENCE = decode(p_SOURCE_SECONDARY_REFERENCE,
811: FND_API.G_MISS_CHAR,
812: SOURCE_SECONDARY_REFERENCE,
813: p_SOURCE_SECONDARY_REFERENCE)
814:
815: , SALES_METHODOLOGY_ID = decode( p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM,

Line 815: , SALES_METHODOLOGY_ID = decode( p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM,

811: FND_API.G_MISS_CHAR,
812: SOURCE_SECONDARY_REFERENCE,
813: p_SOURCE_SECONDARY_REFERENCE)
814:
815: , SALES_METHODOLOGY_ID = decode( p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM,
816: SALES_METHODOLOGY_ID, p_SALES_METHODOLOGY_ID)
817:
818: , SALES_STAGE_ID = decode(p_SALES_STAGE_ID,
819: FND_API.G_MISS_NUM,

Line 819: FND_API.G_MISS_NUM,

815: , SALES_METHODOLOGY_ID = decode( p_SALES_METHODOLOGY_ID, FND_API.G_MISS_NUM,
816: SALES_METHODOLOGY_ID, p_SALES_METHODOLOGY_ID)
817:
818: , SALES_STAGE_ID = decode(p_SALES_STAGE_ID,
819: FND_API.G_MISS_NUM,
820: SALES_STAGE_ID,
821: p_SALES_STAGE_ID)
822: , object_version_number = decode(object_version_number, null, 1, object_version_number+1)
823: