316: finance_owner_id,
317: application_owner_id,
318: standard_variation
319: ) VALUES (
320: DECODE( p_significant_process_flag, FND_API.g_miss_char, NULL, p_significant_process_flag),
321: DECODE( p_standard_process_flag, FND_API.g_miss_char, NULL, p_standard_process_flag),
322: DECODE( p_approval_status, FND_API.g_miss_char, NULL, p_approval_status),
323: DECODE( p_certification_status, FND_API.g_miss_char, NULL, p_certification_status),
324: DECODE( p_process_owner_id, FND_API.g_miss_num, NULL, p_process_owner_id),
317: application_owner_id,
318: standard_variation
319: ) VALUES (
320: DECODE( p_significant_process_flag, FND_API.g_miss_char, NULL, p_significant_process_flag),
321: DECODE( p_standard_process_flag, FND_API.g_miss_char, NULL, p_standard_process_flag),
322: DECODE( p_approval_status, FND_API.g_miss_char, NULL, p_approval_status),
323: DECODE( p_certification_status, FND_API.g_miss_char, NULL, p_certification_status),
324: DECODE( p_process_owner_id, FND_API.g_miss_num, NULL, p_process_owner_id),
325: DECODE( px_process_id, FND_API.g_miss_num, NULL, px_process_id),
318: standard_variation
319: ) VALUES (
320: DECODE( p_significant_process_flag, FND_API.g_miss_char, NULL, p_significant_process_flag),
321: DECODE( p_standard_process_flag, FND_API.g_miss_char, NULL, p_standard_process_flag),
322: DECODE( p_approval_status, FND_API.g_miss_char, NULL, p_approval_status),
323: DECODE( p_certification_status, FND_API.g_miss_char, NULL, p_certification_status),
324: DECODE( p_process_owner_id, FND_API.g_miss_num, NULL, p_process_owner_id),
325: DECODE( px_process_id, FND_API.g_miss_num, NULL, px_process_id),
326: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
319: ) VALUES (
320: DECODE( p_significant_process_flag, FND_API.g_miss_char, NULL, p_significant_process_flag),
321: DECODE( p_standard_process_flag, FND_API.g_miss_char, NULL, p_standard_process_flag),
322: DECODE( p_approval_status, FND_API.g_miss_char, NULL, p_approval_status),
323: DECODE( p_certification_status, FND_API.g_miss_char, NULL, p_certification_status),
324: DECODE( p_process_owner_id, FND_API.g_miss_num, NULL, p_process_owner_id),
325: DECODE( px_process_id, FND_API.g_miss_num, NULL, px_process_id),
326: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
327: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
320: DECODE( p_significant_process_flag, FND_API.g_miss_char, NULL, p_significant_process_flag),
321: DECODE( p_standard_process_flag, FND_API.g_miss_char, NULL, p_standard_process_flag),
322: DECODE( p_approval_status, FND_API.g_miss_char, NULL, p_approval_status),
323: DECODE( p_certification_status, FND_API.g_miss_char, NULL, p_certification_status),
324: DECODE( p_process_owner_id, FND_API.g_miss_num, NULL, p_process_owner_id),
325: DECODE( px_process_id, FND_API.g_miss_num, NULL, px_process_id),
326: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
327: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
328: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
321: DECODE( p_standard_process_flag, FND_API.g_miss_char, NULL, p_standard_process_flag),
322: DECODE( p_approval_status, FND_API.g_miss_char, NULL, p_approval_status),
323: DECODE( p_certification_status, FND_API.g_miss_char, NULL, p_certification_status),
324: DECODE( p_process_owner_id, FND_API.g_miss_num, NULL, p_process_owner_id),
325: DECODE( px_process_id, FND_API.g_miss_num, NULL, px_process_id),
326: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
327: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
328: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
329: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
322: DECODE( p_approval_status, FND_API.g_miss_char, NULL, p_approval_status),
323: DECODE( p_certification_status, FND_API.g_miss_char, NULL, p_certification_status),
324: DECODE( p_process_owner_id, FND_API.g_miss_num, NULL, p_process_owner_id),
325: DECODE( px_process_id, FND_API.g_miss_num, NULL, px_process_id),
326: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
327: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
328: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
329: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
330: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
323: DECODE( p_certification_status, FND_API.g_miss_char, NULL, p_certification_status),
324: DECODE( p_process_owner_id, FND_API.g_miss_num, NULL, p_process_owner_id),
325: DECODE( px_process_id, FND_API.g_miss_num, NULL, px_process_id),
326: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
327: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
328: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
329: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
330: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
331: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
324: DECODE( p_process_owner_id, FND_API.g_miss_num, NULL, p_process_owner_id),
325: DECODE( px_process_id, FND_API.g_miss_num, NULL, px_process_id),
326: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
327: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
328: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
329: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
330: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
331: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
332: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
325: DECODE( px_process_id, FND_API.g_miss_num, NULL, px_process_id),
326: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
327: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
328: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
329: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
330: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
331: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
332: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
333: DECODE( p_created_from, FND_API.g_miss_char, NULL, p_created_from),
326: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
327: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
328: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
329: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
330: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
331: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
332: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
333: DECODE( p_created_from, FND_API.g_miss_char, NULL, p_created_from),
334: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
327: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
328: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
329: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
330: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
331: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
332: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
333: DECODE( p_created_from, FND_API.g_miss_char, NULL, p_created_from),
334: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
335: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
328: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
329: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
330: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
331: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
332: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
333: DECODE( p_created_from, FND_API.g_miss_char, NULL, p_created_from),
334: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
335: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
336: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
329: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
330: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
331: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
332: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
333: DECODE( p_created_from, FND_API.g_miss_char, NULL, p_created_from),
334: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
335: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
336: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
337: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
330: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
331: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
332: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
333: DECODE( p_created_from, FND_API.g_miss_char, NULL, p_created_from),
334: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
335: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
336: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
337: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
338: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
331: DECODE( p_item_type, FND_API.g_miss_char, NULL, p_item_type),
332: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
333: DECODE( p_created_from, FND_API.g_miss_char, NULL, p_created_from),
334: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
335: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
336: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
337: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
338: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
339: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
332: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
333: DECODE( p_created_from, FND_API.g_miss_char, NULL, p_created_from),
334: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
335: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
336: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
337: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
338: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
339: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
340: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
333: DECODE( p_created_from, FND_API.g_miss_char, NULL, p_created_from),
334: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
335: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
336: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
337: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
338: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
339: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
340: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
341: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
334: DECODE( p_request_id, FND_API.g_miss_num, NULL, p_request_id),
335: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
336: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
337: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
338: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
339: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
340: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
341: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
342: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
335: DECODE( p_program_application_id, FND_API.g_miss_num, NULL, p_program_application_id),
336: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
337: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
338: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
339: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
340: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
341: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
342: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
343: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
336: DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id),
337: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
338: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
339: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
340: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
341: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
342: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
343: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
344: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
337: DECODE( p_program_update_date, FND_API.g_miss_date, NULL, p_program_update_date),
338: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
339: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
340: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
341: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
342: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
343: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
344: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
345: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
338: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
339: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
340: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
341: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
342: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
343: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
344: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
345: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
346: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
339: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
340: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
341: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
342: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
343: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
344: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
345: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
346: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
347: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
340: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
341: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
342: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
343: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
344: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
345: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
346: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
347: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
348: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
341: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
342: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
343: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
344: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
345: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
346: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
347: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
348: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
349: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
342: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
343: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
344: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
345: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
346: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
347: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
348: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
349: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
350: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
343: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
344: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
345: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
346: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
347: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
348: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
349: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
350: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
351: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
344: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
345: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
346: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
347: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
348: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
349: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
350: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
351: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
352: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
345: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
346: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
347: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
348: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
349: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
350: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
351: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
352: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
353: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
346: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
347: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
348: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
349: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
350: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
351: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
352: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
353: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
354: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
347: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
348: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
349: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
350: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
351: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
352: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
353: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
354: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
355: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
348: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
349: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
350: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
351: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
352: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
353: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
354: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
355: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
356: DECODE( px_process_rev_id, FND_API.g_miss_num, NULL, px_process_rev_id),
349: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
350: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
351: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
352: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
353: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
354: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
355: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
356: DECODE( px_process_rev_id, FND_API.g_miss_num, NULL, px_process_rev_id),
357: DECODE( p_control_count, FND_API.g_miss_num, NULL, p_control_count),
350: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
351: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
352: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
353: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
354: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
355: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
356: DECODE( px_process_rev_id, FND_API.g_miss_num, NULL, px_process_rev_id),
357: DECODE( p_control_count, FND_API.g_miss_num, NULL, p_control_count),
358: DECODE( p_risk_count, FND_API.g_miss_num, NULL, p_risk_count),
351: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
352: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
353: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
354: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
355: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
356: DECODE( px_process_rev_id, FND_API.g_miss_num, NULL, px_process_rev_id),
357: DECODE( p_control_count, FND_API.g_miss_num, NULL, p_control_count),
358: DECODE( p_risk_count, FND_API.g_miss_num, NULL, p_risk_count),
359: DECODE( p_org_count, FND_API.g_miss_num, NULL, p_org_count),
352: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
353: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
354: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
355: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
356: DECODE( px_process_rev_id, FND_API.g_miss_num, NULL, px_process_rev_id),
357: DECODE( p_control_count, FND_API.g_miss_num, NULL, p_control_count),
358: DECODE( p_risk_count, FND_API.g_miss_num, NULL, p_risk_count),
359: DECODE( p_org_count, FND_API.g_miss_num, NULL, p_org_count),
360: DECODE( p_process_category, FND_API.g_miss_char, NULL, p_process_category),
353: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15),
354: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
355: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
356: DECODE( px_process_rev_id, FND_API.g_miss_num, NULL, px_process_rev_id),
357: DECODE( p_control_count, FND_API.g_miss_num, NULL, p_control_count),
358: DECODE( p_risk_count, FND_API.g_miss_num, NULL, p_risk_count),
359: DECODE( p_org_count, FND_API.g_miss_num, NULL, p_org_count),
360: DECODE( p_process_category, FND_API.g_miss_char, NULL, p_process_category),
361: DECODE( p_finance_owner_id, FND_API.g_miss_num, NULL, p_finance_owner_id),
354: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
355: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
356: DECODE( px_process_rev_id, FND_API.g_miss_num, NULL, px_process_rev_id),
357: DECODE( p_control_count, FND_API.g_miss_num, NULL, p_control_count),
358: DECODE( p_risk_count, FND_API.g_miss_num, NULL, p_risk_count),
359: DECODE( p_org_count, FND_API.g_miss_num, NULL, p_org_count),
360: DECODE( p_process_category, FND_API.g_miss_char, NULL, p_process_category),
361: DECODE( p_finance_owner_id, FND_API.g_miss_num, NULL, p_finance_owner_id),
362: DECODE( p_application_owner_id, FND_API.g_miss_num, NULL, p_application_owner_id),
355: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
356: DECODE( px_process_rev_id, FND_API.g_miss_num, NULL, px_process_rev_id),
357: DECODE( p_control_count, FND_API.g_miss_num, NULL, p_control_count),
358: DECODE( p_risk_count, FND_API.g_miss_num, NULL, p_risk_count),
359: DECODE( p_org_count, FND_API.g_miss_num, NULL, p_org_count),
360: DECODE( p_process_category, FND_API.g_miss_char, NULL, p_process_category),
361: DECODE( p_finance_owner_id, FND_API.g_miss_num, NULL, p_finance_owner_id),
362: DECODE( p_application_owner_id, FND_API.g_miss_num, NULL, p_application_owner_id),
363: DECODE( p_standard_variation, FND_API.g_miss_num, NULL, p_standard_variation)
356: DECODE( px_process_rev_id, FND_API.g_miss_num, NULL, px_process_rev_id),
357: DECODE( p_control_count, FND_API.g_miss_num, NULL, p_control_count),
358: DECODE( p_risk_count, FND_API.g_miss_num, NULL, p_risk_count),
359: DECODE( p_org_count, FND_API.g_miss_num, NULL, p_org_count),
360: DECODE( p_process_category, FND_API.g_miss_char, NULL, p_process_category),
361: DECODE( p_finance_owner_id, FND_API.g_miss_num, NULL, p_finance_owner_id),
362: DECODE( p_application_owner_id, FND_API.g_miss_num, NULL, p_application_owner_id),
363: DECODE( p_standard_variation, FND_API.g_miss_num, NULL, p_standard_variation)
364: );
357: DECODE( p_control_count, FND_API.g_miss_num, NULL, p_control_count),
358: DECODE( p_risk_count, FND_API.g_miss_num, NULL, p_risk_count),
359: DECODE( p_org_count, FND_API.g_miss_num, NULL, p_org_count),
360: DECODE( p_process_category, FND_API.g_miss_char, NULL, p_process_category),
361: DECODE( p_finance_owner_id, FND_API.g_miss_num, NULL, p_finance_owner_id),
362: DECODE( p_application_owner_id, FND_API.g_miss_num, NULL, p_application_owner_id),
363: DECODE( p_standard_variation, FND_API.g_miss_num, NULL, p_standard_variation)
364: );
365: END Insert_Row;
358: DECODE( p_risk_count, FND_API.g_miss_num, NULL, p_risk_count),
359: DECODE( p_org_count, FND_API.g_miss_num, NULL, p_org_count),
360: DECODE( p_process_category, FND_API.g_miss_char, NULL, p_process_category),
361: DECODE( p_finance_owner_id, FND_API.g_miss_num, NULL, p_finance_owner_id),
362: DECODE( p_application_owner_id, FND_API.g_miss_num, NULL, p_application_owner_id),
363: DECODE( p_standard_variation, FND_API.g_miss_num, NULL, p_standard_variation)
364: );
365: END Insert_Row;
366:
359: DECODE( p_org_count, FND_API.g_miss_num, NULL, p_org_count),
360: DECODE( p_process_category, FND_API.g_miss_char, NULL, p_process_category),
361: DECODE( p_finance_owner_id, FND_API.g_miss_num, NULL, p_finance_owner_id),
362: DECODE( p_application_owner_id, FND_API.g_miss_num, NULL, p_application_owner_id),
363: DECODE( p_standard_variation, FND_API.g_miss_num, NULL, p_standard_variation)
364: );
365: END Insert_Row;
366:
367:
442: l_object_version_number := l_obj_num.object_version_number+1;
443:
444: Update AMW_PROCESS
445: SET
446: significant_process_flag = DECODE(p_significant_process_flag, FND_API.g_miss_char, significant_process_flag, p_significant_process_flag),
447: standard_process_flag = DECODE(p_standard_process_flag, FND_API.g_miss_char, standard_process_flag, p_standard_process_flag),
448: approval_status = DECODE(p_approval_status, FND_API.g_miss_char, approval_status, p_approval_status),
449: certification_status = DECODE(p_certification_status, FND_API.g_miss_char, certification_status, p_certification_status),
450: process_owner_id = DECODE( p_process_owner_id, FND_API.g_miss_num, process_owner_id, p_process_owner_id),
443:
444: Update AMW_PROCESS
445: SET
446: significant_process_flag = DECODE(p_significant_process_flag, FND_API.g_miss_char, significant_process_flag, p_significant_process_flag),
447: standard_process_flag = DECODE(p_standard_process_flag, FND_API.g_miss_char, standard_process_flag, p_standard_process_flag),
448: approval_status = DECODE(p_approval_status, FND_API.g_miss_char, approval_status, p_approval_status),
449: certification_status = DECODE(p_certification_status, FND_API.g_miss_char, certification_status, p_certification_status),
450: process_owner_id = DECODE( p_process_owner_id, FND_API.g_miss_num, process_owner_id, p_process_owner_id),
451: process_id = DECODE( p_process_id, FND_API.g_miss_num, process_id, p_process_id),
444: Update AMW_PROCESS
445: SET
446: significant_process_flag = DECODE(p_significant_process_flag, FND_API.g_miss_char, significant_process_flag, p_significant_process_flag),
447: standard_process_flag = DECODE(p_standard_process_flag, FND_API.g_miss_char, standard_process_flag, p_standard_process_flag),
448: approval_status = DECODE(p_approval_status, FND_API.g_miss_char, approval_status, p_approval_status),
449: certification_status = DECODE(p_certification_status, FND_API.g_miss_char, certification_status, p_certification_status),
450: process_owner_id = DECODE( p_process_owner_id, FND_API.g_miss_num, process_owner_id, p_process_owner_id),
451: process_id = DECODE( p_process_id, FND_API.g_miss_num, process_id, p_process_id),
452: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
445: SET
446: significant_process_flag = DECODE(p_significant_process_flag, FND_API.g_miss_char, significant_process_flag, p_significant_process_flag),
447: standard_process_flag = DECODE(p_standard_process_flag, FND_API.g_miss_char, standard_process_flag, p_standard_process_flag),
448: approval_status = DECODE(p_approval_status, FND_API.g_miss_char, approval_status, p_approval_status),
449: certification_status = DECODE(p_certification_status, FND_API.g_miss_char, certification_status, p_certification_status),
450: process_owner_id = DECODE( p_process_owner_id, FND_API.g_miss_num, process_owner_id, p_process_owner_id),
451: process_id = DECODE( p_process_id, FND_API.g_miss_num, process_id, p_process_id),
452: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
453: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
446: significant_process_flag = DECODE(p_significant_process_flag, FND_API.g_miss_char, significant_process_flag, p_significant_process_flag),
447: standard_process_flag = DECODE(p_standard_process_flag, FND_API.g_miss_char, standard_process_flag, p_standard_process_flag),
448: approval_status = DECODE(p_approval_status, FND_API.g_miss_char, approval_status, p_approval_status),
449: certification_status = DECODE(p_certification_status, FND_API.g_miss_char, certification_status, p_certification_status),
450: process_owner_id = DECODE( p_process_owner_id, FND_API.g_miss_num, process_owner_id, p_process_owner_id),
451: process_id = DECODE( p_process_id, FND_API.g_miss_num, process_id, p_process_id),
452: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
453: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
454: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
447: standard_process_flag = DECODE(p_standard_process_flag, FND_API.g_miss_char, standard_process_flag, p_standard_process_flag),
448: approval_status = DECODE(p_approval_status, FND_API.g_miss_char, approval_status, p_approval_status),
449: certification_status = DECODE(p_certification_status, FND_API.g_miss_char, certification_status, p_certification_status),
450: process_owner_id = DECODE( p_process_owner_id, FND_API.g_miss_num, process_owner_id, p_process_owner_id),
451: process_id = DECODE( p_process_id, FND_API.g_miss_num, process_id, p_process_id),
452: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
453: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
454: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
455: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
448: approval_status = DECODE(p_approval_status, FND_API.g_miss_char, approval_status, p_approval_status),
449: certification_status = DECODE(p_certification_status, FND_API.g_miss_char, certification_status, p_certification_status),
450: process_owner_id = DECODE( p_process_owner_id, FND_API.g_miss_num, process_owner_id, p_process_owner_id),
451: process_id = DECODE( p_process_id, FND_API.g_miss_num, process_id, p_process_id),
452: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
453: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
454: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
455: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
456: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
449: certification_status = DECODE(p_certification_status, FND_API.g_miss_char, certification_status, p_certification_status),
450: process_owner_id = DECODE( p_process_owner_id, FND_API.g_miss_num, process_owner_id, p_process_owner_id),
451: process_id = DECODE( p_process_id, FND_API.g_miss_num, process_id, p_process_id),
452: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
453: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
454: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
455: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
456: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
457: item_type = DECODE( p_item_type, FND_API.g_miss_char, item_type, p_item_type),
450: process_owner_id = DECODE( p_process_owner_id, FND_API.g_miss_num, process_owner_id, p_process_owner_id),
451: process_id = DECODE( p_process_id, FND_API.g_miss_num, process_id, p_process_id),
452: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
453: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
454: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
455: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
456: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
457: item_type = DECODE( p_item_type, FND_API.g_miss_char, item_type, p_item_type),
458: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
451: process_id = DECODE( p_process_id, FND_API.g_miss_num, process_id, p_process_id),
452: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
453: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
454: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
455: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
456: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
457: item_type = DECODE( p_item_type, FND_API.g_miss_char, item_type, p_item_type),
458: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
459: created_from = DECODE( p_created_from, FND_API.g_miss_char, created_from, p_created_from),
452: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
453: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
454: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
455: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
456: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
457: item_type = DECODE( p_item_type, FND_API.g_miss_char, item_type, p_item_type),
458: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
459: created_from = DECODE( p_created_from, FND_API.g_miss_char, created_from, p_created_from),
460: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
453: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
454: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
455: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
456: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
457: item_type = DECODE( p_item_type, FND_API.g_miss_char, item_type, p_item_type),
458: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
459: created_from = DECODE( p_created_from, FND_API.g_miss_char, created_from, p_created_from),
460: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
461: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
454: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
455: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
456: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
457: item_type = DECODE( p_item_type, FND_API.g_miss_char, item_type, p_item_type),
458: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
459: created_from = DECODE( p_created_from, FND_API.g_miss_char, created_from, p_created_from),
460: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
461: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
462: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
455: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
456: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
457: item_type = DECODE( p_item_type, FND_API.g_miss_char, item_type, p_item_type),
458: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
459: created_from = DECODE( p_created_from, FND_API.g_miss_char, created_from, p_created_from),
460: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
461: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
462: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
463: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
456: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
457: item_type = DECODE( p_item_type, FND_API.g_miss_char, item_type, p_item_type),
458: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
459: created_from = DECODE( p_created_from, FND_API.g_miss_char, created_from, p_created_from),
460: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
461: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
462: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
463: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
464: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
457: item_type = DECODE( p_item_type, FND_API.g_miss_char, item_type, p_item_type),
458: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
459: created_from = DECODE( p_created_from, FND_API.g_miss_char, created_from, p_created_from),
460: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
461: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
462: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
463: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
464: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
465: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
458: name = DECODE( p_name, FND_API.g_miss_char, name, p_name),
459: created_from = DECODE( p_created_from, FND_API.g_miss_char, created_from, p_created_from),
460: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
461: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
462: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
463: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
464: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
465: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
466: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
459: created_from = DECODE( p_created_from, FND_API.g_miss_char, created_from, p_created_from),
460: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
461: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
462: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
463: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
464: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
465: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
466: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
467: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
460: request_id = DECODE( p_request_id, FND_API.g_miss_num, request_id, p_request_id),
461: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
462: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
463: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
464: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
465: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
466: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
467: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
468: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
461: program_application_id = DECODE( p_program_application_id, FND_API.g_miss_num, program_application_id, p_program_application_id),
462: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
463: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
464: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
465: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
466: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
467: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
468: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
469: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
462: program_id = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id),
463: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
464: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
465: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
466: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
467: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
468: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
469: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
470: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
463: program_update_date = DECODE( p_program_update_date, FND_API.g_miss_date, program_update_date, p_program_update_date),
464: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
465: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
466: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
467: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
468: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
469: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
470: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
471: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
464: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
465: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
466: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
467: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
468: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
469: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
470: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
471: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
472: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
465: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
466: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
467: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
468: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
469: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
470: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
471: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
472: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
473: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
466: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
467: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
468: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
469: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
470: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
471: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
472: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
473: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
474: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
467: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
468: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
469: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
470: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
471: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
472: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
473: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
474: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
475: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
468: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
469: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
470: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
471: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
472: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
473: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
474: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
475: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
476: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
469: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
470: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
471: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
472: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
473: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
474: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
475: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
476: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
477: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
470: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
471: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
472: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
473: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
474: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
475: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
476: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
477: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
478: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
471: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
472: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
473: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
474: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
475: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
476: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
477: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
478: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
479: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
472: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
473: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
474: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
475: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
476: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
477: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
478: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
479: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
480: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
473: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
474: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
475: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
476: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
477: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
478: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
479: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
480: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
481: object_version_number = DECODE( l_object_version_number, FND_API.g_miss_num, object_version_number, l_object_version_number),
474: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
475: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
476: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
477: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
478: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
479: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
480: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
481: object_version_number = DECODE( l_object_version_number, FND_API.g_miss_num, object_version_number, l_object_version_number),
482: control_count = DECODE( p_control_count, FND_API.g_miss_num, control_count, p_control_count),
475: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
476: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
477: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
478: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
479: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
480: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
481: object_version_number = DECODE( l_object_version_number, FND_API.g_miss_num, object_version_number, l_object_version_number),
482: control_count = DECODE( p_control_count, FND_API.g_miss_num, control_count, p_control_count),
483: risk_count = DECODE( p_risk_count, FND_API.g_miss_num, risk_count, p_risk_count),
476: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
477: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
478: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
479: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
480: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
481: object_version_number = DECODE( l_object_version_number, FND_API.g_miss_num, object_version_number, l_object_version_number),
482: control_count = DECODE( p_control_count, FND_API.g_miss_num, control_count, p_control_count),
483: risk_count = DECODE( p_risk_count, FND_API.g_miss_num, risk_count, p_risk_count),
484: org_count = DECODE( p_org_count, FND_API.g_miss_num, org_count, p_org_count),
477: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
478: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
479: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
480: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
481: object_version_number = DECODE( l_object_version_number, FND_API.g_miss_num, object_version_number, l_object_version_number),
482: control_count = DECODE( p_control_count, FND_API.g_miss_num, control_count, p_control_count),
483: risk_count = DECODE( p_risk_count, FND_API.g_miss_num, risk_count, p_risk_count),
484: org_count = DECODE( p_org_count, FND_API.g_miss_num, org_count, p_org_count),
485: process_category = DECODE( p_process_category, FND_API.g_miss_char, process_category, p_process_category),
478: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
479: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
480: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
481: object_version_number = DECODE( l_object_version_number, FND_API.g_miss_num, object_version_number, l_object_version_number),
482: control_count = DECODE( p_control_count, FND_API.g_miss_num, control_count, p_control_count),
483: risk_count = DECODE( p_risk_count, FND_API.g_miss_num, risk_count, p_risk_count),
484: org_count = DECODE( p_org_count, FND_API.g_miss_num, org_count, p_org_count),
485: process_category = DECODE( p_process_category, FND_API.g_miss_char, process_category, p_process_category),
486: finance_owner_id = DECODE( p_finance_owner_id, FND_API.g_miss_num, finance_owner_id, p_finance_owner_id),
479: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15),
480: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
481: object_version_number = DECODE( l_object_version_number, FND_API.g_miss_num, object_version_number, l_object_version_number),
482: control_count = DECODE( p_control_count, FND_API.g_miss_num, control_count, p_control_count),
483: risk_count = DECODE( p_risk_count, FND_API.g_miss_num, risk_count, p_risk_count),
484: org_count = DECODE( p_org_count, FND_API.g_miss_num, org_count, p_org_count),
485: process_category = DECODE( p_process_category, FND_API.g_miss_char, process_category, p_process_category),
486: finance_owner_id = DECODE( p_finance_owner_id, FND_API.g_miss_num, finance_owner_id, p_finance_owner_id),
487: application_owner_id = DECODE( p_application_owner_id, FND_API.g_miss_num, application_owner_id, p_application_owner_id),
480: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id),
481: object_version_number = DECODE( l_object_version_number, FND_API.g_miss_num, object_version_number, l_object_version_number),
482: control_count = DECODE( p_control_count, FND_API.g_miss_num, control_count, p_control_count),
483: risk_count = DECODE( p_risk_count, FND_API.g_miss_num, risk_count, p_risk_count),
484: org_count = DECODE( p_org_count, FND_API.g_miss_num, org_count, p_org_count),
485: process_category = DECODE( p_process_category, FND_API.g_miss_char, process_category, p_process_category),
486: finance_owner_id = DECODE( p_finance_owner_id, FND_API.g_miss_num, finance_owner_id, p_finance_owner_id),
487: application_owner_id = DECODE( p_application_owner_id, FND_API.g_miss_num, application_owner_id, p_application_owner_id),
488: standard_variation = DECODE( p_standard_variation, FND_API.g_miss_num, standard_variation, p_standard_variation)
481: object_version_number = DECODE( l_object_version_number, FND_API.g_miss_num, object_version_number, l_object_version_number),
482: control_count = DECODE( p_control_count, FND_API.g_miss_num, control_count, p_control_count),
483: risk_count = DECODE( p_risk_count, FND_API.g_miss_num, risk_count, p_risk_count),
484: org_count = DECODE( p_org_count, FND_API.g_miss_num, org_count, p_org_count),
485: process_category = DECODE( p_process_category, FND_API.g_miss_char, process_category, p_process_category),
486: finance_owner_id = DECODE( p_finance_owner_id, FND_API.g_miss_num, finance_owner_id, p_finance_owner_id),
487: application_owner_id = DECODE( p_application_owner_id, FND_API.g_miss_num, application_owner_id, p_application_owner_id),
488: standard_variation = DECODE( p_standard_variation, FND_API.g_miss_num, standard_variation, p_standard_variation)
489: WHERE PROCESS_rev_ID = p_PROCESS_rev_ID;
482: control_count = DECODE( p_control_count, FND_API.g_miss_num, control_count, p_control_count),
483: risk_count = DECODE( p_risk_count, FND_API.g_miss_num, risk_count, p_risk_count),
484: org_count = DECODE( p_org_count, FND_API.g_miss_num, org_count, p_org_count),
485: process_category = DECODE( p_process_category, FND_API.g_miss_char, process_category, p_process_category),
486: finance_owner_id = DECODE( p_finance_owner_id, FND_API.g_miss_num, finance_owner_id, p_finance_owner_id),
487: application_owner_id = DECODE( p_application_owner_id, FND_API.g_miss_num, application_owner_id, p_application_owner_id),
488: standard_variation = DECODE( p_standard_variation, FND_API.g_miss_num, standard_variation, p_standard_variation)
489: WHERE PROCESS_rev_ID = p_PROCESS_rev_ID;
490:
483: risk_count = DECODE( p_risk_count, FND_API.g_miss_num, risk_count, p_risk_count),
484: org_count = DECODE( p_org_count, FND_API.g_miss_num, org_count, p_org_count),
485: process_category = DECODE( p_process_category, FND_API.g_miss_char, process_category, p_process_category),
486: finance_owner_id = DECODE( p_finance_owner_id, FND_API.g_miss_num, finance_owner_id, p_finance_owner_id),
487: application_owner_id = DECODE( p_application_owner_id, FND_API.g_miss_num, application_owner_id, p_application_owner_id),
488: standard_variation = DECODE( p_standard_variation, FND_API.g_miss_num, standard_variation, p_standard_variation)
489: WHERE PROCESS_rev_ID = p_PROCESS_rev_ID;
490:
491: IF (SQL%NOTFOUND) THEN
484: org_count = DECODE( p_org_count, FND_API.g_miss_num, org_count, p_org_count),
485: process_category = DECODE( p_process_category, FND_API.g_miss_char, process_category, p_process_category),
486: finance_owner_id = DECODE( p_finance_owner_id, FND_API.g_miss_num, finance_owner_id, p_finance_owner_id),
487: application_owner_id = DECODE( p_application_owner_id, FND_API.g_miss_num, application_owner_id, p_application_owner_id),
488: standard_variation = DECODE( p_standard_variation, FND_API.g_miss_num, standard_variation, p_standard_variation)
489: WHERE PROCESS_rev_ID = p_PROCESS_rev_ID;
490:
491: IF (SQL%NOTFOUND) THEN
492: RAISE NO_DATA_FOUND;
516: BEGIN
517: DELETE FROM AMW_PROCESS
518: WHERE PROCESS_rev_ID = p_PROCESS_rev_ID;
519: If (SQL%NOTFOUND) then
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: End If;
522: END Delete_Row ;
523:
524: