APPS.AS_INTERESTS_PKG dependencies on FND_API

Line 318: X_Primary_Interest_Code_Id NUMBER DEFAULT FND_API.G_MISS_NUM,

314: X_Interest_Type_Id NUMBER,
315: X_Contact_Id NUMBER,
316: X_Customer_Id NUMBER,
317: X_Address_Id NUMBER,
318: X_Primary_Interest_Code_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
319: X_Secondary_Interest_Code_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
320: X_Status_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: X_Description VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: X_Attribute_Category VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 319: X_Secondary_Interest_Code_Id NUMBER DEFAULT FND_API.G_MISS_NUM,

315: X_Contact_Id NUMBER,
316: X_Customer_Id NUMBER,
317: X_Address_Id NUMBER,
318: X_Primary_Interest_Code_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
319: X_Secondary_Interest_Code_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
320: X_Status_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: X_Description VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: X_Attribute_Category VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: X_Attribute1 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 320: X_Status_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

316: X_Customer_Id NUMBER,
317: X_Address_Id NUMBER,
318: X_Primary_Interest_Code_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
319: X_Secondary_Interest_Code_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
320: X_Status_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: X_Description VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: X_Attribute_Category VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: X_Attribute1 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324: X_Attribute2 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 321: X_Description VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

317: X_Address_Id NUMBER,
318: X_Primary_Interest_Code_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
319: X_Secondary_Interest_Code_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
320: X_Status_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: X_Description VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: X_Attribute_Category VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: X_Attribute1 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324: X_Attribute2 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325: X_Attribute3 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 322: X_Attribute_Category VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

318: X_Primary_Interest_Code_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
319: X_Secondary_Interest_Code_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
320: X_Status_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: X_Description VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: X_Attribute_Category VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: X_Attribute1 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324: X_Attribute2 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325: X_Attribute3 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: X_Attribute4 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 323: X_Attribute1 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

319: X_Secondary_Interest_Code_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
320: X_Status_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: X_Description VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: X_Attribute_Category VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: X_Attribute1 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324: X_Attribute2 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325: X_Attribute3 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: X_Attribute4 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: X_Attribute5 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 324: X_Attribute2 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

320: X_Status_Code VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321: X_Description VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: X_Attribute_Category VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: X_Attribute1 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324: X_Attribute2 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325: X_Attribute3 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: X_Attribute4 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: X_Attribute5 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: X_Attribute6 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 325: X_Attribute3 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

321: X_Description VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322: X_Attribute_Category VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: X_Attribute1 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324: X_Attribute2 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325: X_Attribute3 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: X_Attribute4 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: X_Attribute5 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: X_Attribute6 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: X_Attribute7 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 326: X_Attribute4 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

322: X_Attribute_Category VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323: X_Attribute1 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324: X_Attribute2 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325: X_Attribute3 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: X_Attribute4 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: X_Attribute5 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: X_Attribute6 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: X_Attribute7 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: X_Attribute8 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 327: X_Attribute5 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

323: X_Attribute1 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324: X_Attribute2 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325: X_Attribute3 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: X_Attribute4 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: X_Attribute5 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: X_Attribute6 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: X_Attribute7 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: X_Attribute8 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
331: X_Attribute9 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 328: X_Attribute6 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

324: X_Attribute2 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325: X_Attribute3 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: X_Attribute4 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: X_Attribute5 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: X_Attribute6 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: X_Attribute7 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: X_Attribute8 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
331: X_Attribute9 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
332: X_Attribute10 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 329: X_Attribute7 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

325: X_Attribute3 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326: X_Attribute4 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: X_Attribute5 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: X_Attribute6 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: X_Attribute7 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: X_Attribute8 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
331: X_Attribute9 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
332: X_Attribute10 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
333: X_Attribute11 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 330: X_Attribute8 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

326: X_Attribute4 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327: X_Attribute5 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: X_Attribute6 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: X_Attribute7 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: X_Attribute8 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
331: X_Attribute9 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
332: X_Attribute10 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
333: X_Attribute11 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334: X_Attribute12 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 331: X_Attribute9 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

327: X_Attribute5 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328: X_Attribute6 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: X_Attribute7 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: X_Attribute8 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
331: X_Attribute9 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
332: X_Attribute10 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
333: X_Attribute11 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334: X_Attribute12 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
335: X_Attribute13 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 332: X_Attribute10 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

328: X_Attribute6 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329: X_Attribute7 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: X_Attribute8 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
331: X_Attribute9 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
332: X_Attribute10 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
333: X_Attribute11 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334: X_Attribute12 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
335: X_Attribute13 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
336: X_Attribute14 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 333: X_Attribute11 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

329: X_Attribute7 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330: X_Attribute8 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
331: X_Attribute9 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
332: X_Attribute10 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
333: X_Attribute11 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334: X_Attribute12 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
335: X_Attribute13 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
336: X_Attribute14 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
337: X_Attribute15 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 334: X_Attribute12 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

330: X_Attribute8 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
331: X_Attribute9 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
332: X_Attribute10 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
333: X_Attribute11 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334: X_Attribute12 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
335: X_Attribute13 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
336: X_Attribute14 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
337: X_Attribute15 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
338: X_Lead_Id NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 335: X_Attribute13 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

331: X_Attribute9 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
332: X_Attribute10 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
333: X_Attribute11 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334: X_Attribute12 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
335: X_Attribute13 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
336: X_Attribute14 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
337: X_Attribute15 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
338: X_Lead_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
339: X_Request_Id NUMBER DEFAULT NULL,

Line 336: X_Attribute14 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

332: X_Attribute10 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
333: X_Attribute11 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334: X_Attribute12 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
335: X_Attribute13 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
336: X_Attribute14 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
337: X_Attribute15 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
338: X_Lead_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
339: X_Request_Id NUMBER DEFAULT NULL,
340: X_Program_Application_Id NUMBER DEFAULT NULL,

Line 337: X_Attribute15 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

333: X_Attribute11 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334: X_Attribute12 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
335: X_Attribute13 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
336: X_Attribute14 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
337: X_Attribute15 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
338: X_Lead_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
339: X_Request_Id NUMBER DEFAULT NULL,
340: X_Program_Application_Id NUMBER DEFAULT NULL,
341: X_Program_Id NUMBER DEFAULT NULL,

Line 338: X_Lead_Id NUMBER DEFAULT FND_API.G_MISS_NUM,

334: X_Attribute12 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
335: X_Attribute13 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
336: X_Attribute14 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
337: X_Attribute15 VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
338: X_Lead_Id NUMBER DEFAULT FND_API.G_MISS_NUM,
339: X_Request_Id NUMBER DEFAULT NULL,
340: X_Program_Application_Id NUMBER DEFAULT NULL,
341: X_Program_Id NUMBER DEFAULT NULL,
342: X_Program_Update_Date DATE DEFAULT NULL,

Line 352: interest_id = decode(X_Interest_Id,FND_API.G_MISS_NUM, interest_id, X_Interest_Id),

348: BEGIN
349: UPDATE as_interests_all
350: SET
351: object_version_number = nvl(object_version_number,0) + 1,
352: interest_id = decode(X_Interest_Id,FND_API.G_MISS_NUM, interest_id, X_Interest_Id),
353: last_update_date = X_Last_Update_Date,
354: last_updated_by = X_Last_Updated_By,
355: last_update_login = X_Last_Update_Login,
356: interest_use_code = decode(X_Interest_Use_Code,FND_API.G_MISS_CHAR,interest_use_code,X_Interest_Use_Code),

Line 356: interest_use_code = decode(X_Interest_Use_Code,FND_API.G_MISS_CHAR,interest_use_code,X_Interest_Use_Code),

352: interest_id = decode(X_Interest_Id,FND_API.G_MISS_NUM, interest_id, X_Interest_Id),
353: last_update_date = X_Last_Update_Date,
354: last_updated_by = X_Last_Updated_By,
355: last_update_login = X_Last_Update_Login,
356: interest_use_code = decode(X_Interest_Use_Code,FND_API.G_MISS_CHAR,interest_use_code,X_Interest_Use_Code),
357: interest_type_id = decode(X_Interest_Type_Id, FND_API.G_MISS_NUM,interest_type_id, X_Interest_Type_Id),
358: contact_id = decode(X_Contact_Id,FND_API.G_MISS_NUM, contact_id, X_Contact_Id),
359: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),
360: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM, address_id, X_Address_Id),

Line 357: interest_type_id = decode(X_Interest_Type_Id, FND_API.G_MISS_NUM,interest_type_id, X_Interest_Type_Id),

353: last_update_date = X_Last_Update_Date,
354: last_updated_by = X_Last_Updated_By,
355: last_update_login = X_Last_Update_Login,
356: interest_use_code = decode(X_Interest_Use_Code,FND_API.G_MISS_CHAR,interest_use_code,X_Interest_Use_Code),
357: interest_type_id = decode(X_Interest_Type_Id, FND_API.G_MISS_NUM,interest_type_id, X_Interest_Type_Id),
358: contact_id = decode(X_Contact_Id,FND_API.G_MISS_NUM, contact_id, X_Contact_Id),
359: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),
360: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM, address_id, X_Address_Id),
361: primary_interest_code_id =decode(X_Primary_Interest_Code_Id,

Line 358: contact_id = decode(X_Contact_Id,FND_API.G_MISS_NUM, contact_id, X_Contact_Id),

354: last_updated_by = X_Last_Updated_By,
355: last_update_login = X_Last_Update_Login,
356: interest_use_code = decode(X_Interest_Use_Code,FND_API.G_MISS_CHAR,interest_use_code,X_Interest_Use_Code),
357: interest_type_id = decode(X_Interest_Type_Id, FND_API.G_MISS_NUM,interest_type_id, X_Interest_Type_Id),
358: contact_id = decode(X_Contact_Id,FND_API.G_MISS_NUM, contact_id, X_Contact_Id),
359: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),
360: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM, address_id, X_Address_Id),
361: primary_interest_code_id =decode(X_Primary_Interest_Code_Id,
362: FND_API.G_MISS_NUM, primary_interest_code_id,X_Primary_Interest_Code_Id),

Line 359: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),

355: last_update_login = X_Last_Update_Login,
356: interest_use_code = decode(X_Interest_Use_Code,FND_API.G_MISS_CHAR,interest_use_code,X_Interest_Use_Code),
357: interest_type_id = decode(X_Interest_Type_Id, FND_API.G_MISS_NUM,interest_type_id, X_Interest_Type_Id),
358: contact_id = decode(X_Contact_Id,FND_API.G_MISS_NUM, contact_id, X_Contact_Id),
359: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),
360: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM, address_id, X_Address_Id),
361: primary_interest_code_id =decode(X_Primary_Interest_Code_Id,
362: FND_API.G_MISS_NUM, primary_interest_code_id,X_Primary_Interest_Code_Id),
363: secondary_interest_code_id = decode(X_Secondary_Interest_Code_Id,

Line 360: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM, address_id, X_Address_Id),

356: interest_use_code = decode(X_Interest_Use_Code,FND_API.G_MISS_CHAR,interest_use_code,X_Interest_Use_Code),
357: interest_type_id = decode(X_Interest_Type_Id, FND_API.G_MISS_NUM,interest_type_id, X_Interest_Type_Id),
358: contact_id = decode(X_Contact_Id,FND_API.G_MISS_NUM, contact_id, X_Contact_Id),
359: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),
360: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM, address_id, X_Address_Id),
361: primary_interest_code_id =decode(X_Primary_Interest_Code_Id,
362: FND_API.G_MISS_NUM, primary_interest_code_id,X_Primary_Interest_Code_Id),
363: secondary_interest_code_id = decode(X_Secondary_Interest_Code_Id,
364: FND_API.G_MISS_NUM, Secondary_interest_code_id,X_Secondary_Interest_Code_Id),

Line 362: FND_API.G_MISS_NUM, primary_interest_code_id,X_Primary_Interest_Code_Id),

358: contact_id = decode(X_Contact_Id,FND_API.G_MISS_NUM, contact_id, X_Contact_Id),
359: customer_id = decode(X_Customer_Id,FND_API.G_MISS_NUM,customer_id,X_Customer_Id),
360: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM, address_id, X_Address_Id),
361: primary_interest_code_id =decode(X_Primary_Interest_Code_Id,
362: FND_API.G_MISS_NUM, primary_interest_code_id,X_Primary_Interest_Code_Id),
363: secondary_interest_code_id = decode(X_Secondary_Interest_Code_Id,
364: FND_API.G_MISS_NUM, Secondary_interest_code_id,X_Secondary_Interest_Code_Id),
365: Status_Code = decode(X_Status_Code,FND_API.G_MISS_CHAR, status_code, X_Status_Code),
366: description = decode(X_Description,FND_API.G_MISS_CHAR, description, X_Description),

Line 364: FND_API.G_MISS_NUM, Secondary_interest_code_id,X_Secondary_Interest_Code_Id),

360: address_id = decode(X_Address_Id,FND_API.G_MISS_NUM, address_id, X_Address_Id),
361: primary_interest_code_id =decode(X_Primary_Interest_Code_Id,
362: FND_API.G_MISS_NUM, primary_interest_code_id,X_Primary_Interest_Code_Id),
363: secondary_interest_code_id = decode(X_Secondary_Interest_Code_Id,
364: FND_API.G_MISS_NUM, Secondary_interest_code_id,X_Secondary_Interest_Code_Id),
365: Status_Code = decode(X_Status_Code,FND_API.G_MISS_CHAR, status_code, X_Status_Code),
366: description = decode(X_Description,FND_API.G_MISS_CHAR, description, X_Description),
367: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),
368: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),

Line 365: Status_Code = decode(X_Status_Code,FND_API.G_MISS_CHAR, status_code, X_Status_Code),

361: primary_interest_code_id =decode(X_Primary_Interest_Code_Id,
362: FND_API.G_MISS_NUM, primary_interest_code_id,X_Primary_Interest_Code_Id),
363: secondary_interest_code_id = decode(X_Secondary_Interest_Code_Id,
364: FND_API.G_MISS_NUM, Secondary_interest_code_id,X_Secondary_Interest_Code_Id),
365: Status_Code = decode(X_Status_Code,FND_API.G_MISS_CHAR, status_code, X_Status_Code),
366: description = decode(X_Description,FND_API.G_MISS_CHAR, description, X_Description),
367: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),
368: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),
369: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),

Line 366: description = decode(X_Description,FND_API.G_MISS_CHAR, description, X_Description),

362: FND_API.G_MISS_NUM, primary_interest_code_id,X_Primary_Interest_Code_Id),
363: secondary_interest_code_id = decode(X_Secondary_Interest_Code_Id,
364: FND_API.G_MISS_NUM, Secondary_interest_code_id,X_Secondary_Interest_Code_Id),
365: Status_Code = decode(X_Status_Code,FND_API.G_MISS_CHAR, status_code, X_Status_Code),
366: description = decode(X_Description,FND_API.G_MISS_CHAR, description, X_Description),
367: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),
368: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),
369: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),
370: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),

Line 367: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),

363: secondary_interest_code_id = decode(X_Secondary_Interest_Code_Id,
364: FND_API.G_MISS_NUM, Secondary_interest_code_id,X_Secondary_Interest_Code_Id),
365: Status_Code = decode(X_Status_Code,FND_API.G_MISS_CHAR, status_code, X_Status_Code),
366: description = decode(X_Description,FND_API.G_MISS_CHAR, description, X_Description),
367: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),
368: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),
369: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),
370: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),
371: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),

Line 368: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),

364: FND_API.G_MISS_NUM, Secondary_interest_code_id,X_Secondary_Interest_Code_Id),
365: Status_Code = decode(X_Status_Code,FND_API.G_MISS_CHAR, status_code, X_Status_Code),
366: description = decode(X_Description,FND_API.G_MISS_CHAR, description, X_Description),
367: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),
368: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),
369: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),
370: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),
371: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),
372: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),

Line 369: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),

365: Status_Code = decode(X_Status_Code,FND_API.G_MISS_CHAR, status_code, X_Status_Code),
366: description = decode(X_Description,FND_API.G_MISS_CHAR, description, X_Description),
367: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),
368: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),
369: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),
370: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),
371: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),
372: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),
373: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),

Line 370: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),

366: description = decode(X_Description,FND_API.G_MISS_CHAR, description, X_Description),
367: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),
368: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),
369: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),
370: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),
371: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),
372: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),
373: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),
374: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),

Line 371: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),

367: attribute_category = decode(X_Attribute_Category,FND_API.G_MISS_CHAR,attribute_category,X_Attribute_Category),
368: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),
369: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),
370: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),
371: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),
372: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),
373: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),
374: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),
375: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),

Line 372: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),

368: attribute1 = decode(X_Attribute1,FND_API.G_MISS_CHAR,attribute1,X_Attribute1),
369: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),
370: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),
371: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),
372: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),
373: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),
374: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),
375: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),
376: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),

Line 373: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),

369: attribute2 = decode(X_Attribute2,FND_API.G_MISS_CHAR,attribute2,X_Attribute2),
370: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),
371: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),
372: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),
373: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),
374: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),
375: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),
376: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),
377: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),

Line 374: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),

370: attribute3 = decode(X_Attribute3,FND_API.G_MISS_CHAR,attribute3,X_Attribute3),
371: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),
372: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),
373: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),
374: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),
375: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),
376: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),
377: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),
378: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),

Line 375: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),

371: attribute4 = decode(X_Attribute4,FND_API.G_MISS_CHAR,attribute4,X_Attribute4),
372: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),
373: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),
374: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),
375: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),
376: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),
377: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),
378: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),
379: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),

Line 376: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),

372: attribute5 = decode(X_Attribute5,FND_API.G_MISS_CHAR,attribute5,X_Attribute5),
373: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),
374: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),
375: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),
376: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),
377: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),
378: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),
379: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),
380: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),

Line 377: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),

373: attribute6 = decode(X_Attribute6,FND_API.G_MISS_CHAR,attribute6,X_Attribute6),
374: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),
375: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),
376: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),
377: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),
378: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),
379: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),
380: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),
381: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),

Line 378: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),

374: attribute7 = decode(X_Attribute7,FND_API.G_MISS_CHAR,attribute7,X_Attribute7),
375: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),
376: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),
377: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),
378: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),
379: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),
380: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),
381: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),
382: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),

Line 379: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),

375: attribute8 = decode(X_Attribute8,FND_API.G_MISS_CHAR,attribute8,X_Attribute8),
376: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),
377: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),
378: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),
379: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),
380: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),
381: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),
382: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),
383: lead_id = decode(X_Lead_Id,FND_API.G_MISS_NUM, lead_id,X_Lead_Id),

Line 380: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),

376: attribute9 = decode(X_Attribute9,FND_API.G_MISS_CHAR,attribute9,X_Attribute9),
377: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),
378: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),
379: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),
380: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),
381: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),
382: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),
383: lead_id = decode(X_Lead_Id,FND_API.G_MISS_NUM, lead_id,X_Lead_Id),
384: request_id = X_Request_Id,

Line 381: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),

377: attribute10 = decode(X_Attribute10,FND_API.G_MISS_CHAR,attribute10,X_Attribute10),
378: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),
379: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),
380: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),
381: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),
382: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),
383: lead_id = decode(X_Lead_Id,FND_API.G_MISS_NUM, lead_id,X_Lead_Id),
384: request_id = X_Request_Id,
385: program_application_id = X_Program_Application_Id,

Line 382: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),

378: attribute11 = decode(X_Attribute11,FND_API.G_MISS_CHAR,attribute11,X_Attribute11),
379: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),
380: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),
381: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),
382: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),
383: lead_id = decode(X_Lead_Id,FND_API.G_MISS_NUM, lead_id,X_Lead_Id),
384: request_id = X_Request_Id,
385: program_application_id = X_Program_Application_Id,
386: program_id = X_Program_Id,

Line 383: lead_id = decode(X_Lead_Id,FND_API.G_MISS_NUM, lead_id,X_Lead_Id),

379: attribute12 = decode(X_Attribute12,FND_API.G_MISS_CHAR,attribute12,X_Attribute12),
380: attribute13 = decode(X_Attribute13,FND_API.G_MISS_CHAR,attribute13,X_Attribute13),
381: attribute14 = decode(X_Attribute14,FND_API.G_MISS_CHAR,attribute14,X_Attribute14),
382: attribute15 = decode(X_Attribute15,FND_API.G_MISS_CHAR,attribute15,X_Attribute15),
383: lead_id = decode(X_Lead_Id,FND_API.G_MISS_NUM, lead_id,X_Lead_Id),
384: request_id = X_Request_Id,
385: program_application_id = X_Program_Application_Id,
386: program_id = X_Program_Id,
387: program_update_date = X_Program_Update_Date,

Line 388: product_category_id = decode(X_Product_Category_Id, FND_API.G_MISS_NUM,product_category_id, X_Product_Category_Id),

384: request_id = X_Request_Id,
385: program_application_id = X_Program_Application_Id,
386: program_id = X_Program_Id,
387: program_update_date = X_Program_Update_Date,
388: product_category_id = decode(X_Product_Category_Id, FND_API.G_MISS_NUM,product_category_id, X_Product_Category_Id),
389: product_cat_set_id = decode(X_Product_Cat_Set_Id, FND_API.G_MISS_NUM,product_cat_set_id, X_Product_Cat_Set_Id)
390: WHERE rowid = X_rowid;
391:
392: if (SQL%NOTFOUND) then

Line 389: product_cat_set_id = decode(X_Product_Cat_Set_Id, FND_API.G_MISS_NUM,product_cat_set_id, X_Product_Cat_Set_Id)

385: program_application_id = X_Program_Application_Id,
386: program_id = X_Program_Id,
387: program_update_date = X_Program_Update_Date,
388: product_category_id = decode(X_Product_Category_Id, FND_API.G_MISS_NUM,product_category_id, X_Product_Category_Id),
389: product_cat_set_id = decode(X_Product_Cat_Set_Id, FND_API.G_MISS_NUM,product_cat_set_id, X_Product_Cat_Set_Id)
390: WHERE rowid = X_rowid;
391:
392: if (SQL%NOTFOUND) then
393: RAISE NO_DATA_FOUND;