401: SET
402: transaction_header_id
403: = decode(X_Transaction_Header_Id,
404: NULL, transaction_header_id,
405: FND_API.G_MISS_NUM, null,
406: X_Transaction_Header_Id),
407: book_type_code = decode(X_Book_Type_Code,
408: NULL, book_type_code,
409: FND_API.G_MISS_CHAR, null,
405: FND_API.G_MISS_NUM, null,
406: X_Transaction_Header_Id),
407: book_type_code = decode(X_Book_Type_Code,
408: NULL, book_type_code,
409: FND_API.G_MISS_CHAR, null,
410: X_Book_Type_Code),
411: asset_id = decode(X_Asset_Id,
412: NULL, asset_id,
413: FND_API.G_MISS_NUM, null,
409: FND_API.G_MISS_CHAR, null,
410: X_Book_Type_Code),
411: asset_id = decode(X_Asset_Id,
412: NULL, asset_id,
413: FND_API.G_MISS_NUM, null,
414: X_Asset_Id),
415: transaction_type_code
416: = decode(X_Transaction_Type_Code,
417: NULL, transaction_type_code,
414: X_Asset_Id),
415: transaction_type_code
416: = decode(X_Transaction_Type_Code,
417: NULL, transaction_type_code,
418: FND_API.G_MISS_CHAR, null,
419: X_Transaction_Type_Code),
420: transaction_date_entered
421: = decode(X_Transaction_Date_Entered,
422: NULL, transaction_date_entered,
428: NULL, last_update_date,
429: X_Last_Update_Date),
430: last_updated_by = decode(X_Last_Updated_By,
431: NULL, last_updated_by,
432: FND_API.G_MISS_NUM, null,
433: X_Last_Updated_By),
434: transaction_name = decode(X_Transaction_Name,
435: NULL, transaction_name,
436: FND_API.G_MISS_CHAR, null,
432: FND_API.G_MISS_NUM, null,
433: X_Last_Updated_By),
434: transaction_name = decode(X_Transaction_Name,
435: NULL, transaction_name,
436: FND_API.G_MISS_CHAR, null,
437: X_Transaction_Name),
438: invoice_transaction_id
439: = decode(X_Invoice_Transaction_Id,
440: NULL, invoice_transaction_id,
437: X_Transaction_Name),
438: invoice_transaction_id
439: = decode(X_Invoice_Transaction_Id,
440: NULL, invoice_transaction_id,
441: FND_API.G_MISS_NUM, null,
442: X_Invoice_Transaction_Id),
443: source_transaction_header_id
444: = decode(X_Source_Transaction_Header_Id,
445: NULL, source_transaction_header_id,
442: X_Invoice_Transaction_Id),
443: source_transaction_header_id
444: = decode(X_Source_Transaction_Header_Id,
445: NULL, source_transaction_header_id,
446: FND_API.G_MISS_NUM, null,
447: X_Source_Transaction_Header_Id),
448: mass_reference_id = decode(X_Mass_Reference_Id,
449: NULL, mass_reference_id,
450: FND_API.G_MISS_NUM, null,
446: FND_API.G_MISS_NUM, null,
447: X_Source_Transaction_Header_Id),
448: mass_reference_id = decode(X_Mass_Reference_Id,
449: NULL, mass_reference_id,
450: FND_API.G_MISS_NUM, null,
451: X_Mass_Reference_Id),
452: last_update_login = decode(X_Last_Update_Login,
453: NULL, last_update_login,
454: FND_API.G_MISS_NUM, null,
450: FND_API.G_MISS_NUM, null,
451: X_Mass_Reference_Id),
452: last_update_login = decode(X_Last_Update_Login,
453: NULL, last_update_login,
454: FND_API.G_MISS_NUM, null,
455: X_Last_Update_Login),
456: transaction_subtype
457: = decode(X_Transaction_Subtype,
458: NULL, transaction_subtype,
455: X_Last_Update_Login),
456: transaction_subtype
457: = decode(X_Transaction_Subtype,
458: NULL, transaction_subtype,
459: FND_API.G_MISS_CHAR, null,
460: X_Transaction_Subtype),
461: attribute1 = decode(X_Attribute1,
462: NULL, attribute1,
463: FND_API.G_MISS_CHAR, null,
459: FND_API.G_MISS_CHAR, null,
460: X_Transaction_Subtype),
461: attribute1 = decode(X_Attribute1,
462: NULL, attribute1,
463: FND_API.G_MISS_CHAR, null,
464: X_Attribute1),
465: attribute2 = decode(X_Attribute2,
466: NULL, attribute2,
467: FND_API.G_MISS_CHAR, null,
463: FND_API.G_MISS_CHAR, null,
464: X_Attribute1),
465: attribute2 = decode(X_Attribute2,
466: NULL, attribute2,
467: FND_API.G_MISS_CHAR, null,
468: X_Attribute2),
469: attribute3 = decode(X_Attribute3,
470: NULL, attribute3,
471: FND_API.G_MISS_CHAR, null,
467: FND_API.G_MISS_CHAR, null,
468: X_Attribute2),
469: attribute3 = decode(X_Attribute3,
470: NULL, attribute3,
471: FND_API.G_MISS_CHAR, null,
472: X_Attribute3),
473: attribute4 = decode(X_Attribute4,
474: NULL, attribute4,
475: FND_API.G_MISS_CHAR, null,
471: FND_API.G_MISS_CHAR, null,
472: X_Attribute3),
473: attribute4 = decode(X_Attribute4,
474: NULL, attribute4,
475: FND_API.G_MISS_CHAR, null,
476: X_Attribute4),
477: attribute5 = decode(X_Attribute5,
478: NULL, attribute5,
479: FND_API.G_MISS_CHAR, null,
475: FND_API.G_MISS_CHAR, null,
476: X_Attribute4),
477: attribute5 = decode(X_Attribute5,
478: NULL, attribute5,
479: FND_API.G_MISS_CHAR, null,
480: X_Attribute5),
481: attribute6 = decode(X_Attribute6,
482: NULL, attribute6,
483: FND_API.G_MISS_CHAR, null,
479: FND_API.G_MISS_CHAR, null,
480: X_Attribute5),
481: attribute6 = decode(X_Attribute6,
482: NULL, attribute6,
483: FND_API.G_MISS_CHAR, null,
484: X_Attribute6),
485: attribute7 = decode(X_Attribute7,
486: NULL, attribute7,
487: FND_API.G_MISS_CHAR, null,
483: FND_API.G_MISS_CHAR, null,
484: X_Attribute6),
485: attribute7 = decode(X_Attribute7,
486: NULL, attribute7,
487: FND_API.G_MISS_CHAR, null,
488: X_Attribute7),
489: attribute8 = decode(X_Attribute8,
490: NULL, attribute8,
491: FND_API.G_MISS_CHAR, null,
487: FND_API.G_MISS_CHAR, null,
488: X_Attribute7),
489: attribute8 = decode(X_Attribute8,
490: NULL, attribute8,
491: FND_API.G_MISS_CHAR, null,
492: X_Attribute8),
493: attribute9 = decode(X_Attribute9,
494: NULL, attribute9,
495: FND_API.G_MISS_CHAR, null,
491: FND_API.G_MISS_CHAR, null,
492: X_Attribute8),
493: attribute9 = decode(X_Attribute9,
494: NULL, attribute9,
495: FND_API.G_MISS_CHAR, null,
496: X_Attribute9),
497: attribute10 = decode(X_Attribute10,
498: NULL, attribute10,
499: FND_API.G_MISS_CHAR, null,
495: FND_API.G_MISS_CHAR, null,
496: X_Attribute9),
497: attribute10 = decode(X_Attribute10,
498: NULL, attribute10,
499: FND_API.G_MISS_CHAR, null,
500: X_Attribute10),
501: attribute11 = decode(X_Attribute11,
502: NULL, attribute11,
503: FND_API.G_MISS_CHAR, null,
499: FND_API.G_MISS_CHAR, null,
500: X_Attribute10),
501: attribute11 = decode(X_Attribute11,
502: NULL, attribute11,
503: FND_API.G_MISS_CHAR, null,
504: X_Attribute11),
505: attribute12 = decode(X_Attribute12,
506: NULL, attribute12,
507: FND_API.G_MISS_CHAR, null,
503: FND_API.G_MISS_CHAR, null,
504: X_Attribute11),
505: attribute12 = decode(X_Attribute12,
506: NULL, attribute12,
507: FND_API.G_MISS_CHAR, null,
508: X_Attribute12),
509: attribute13 = decode(X_Attribute13,
510: NULL, attribute13,
511: FND_API.G_MISS_CHAR, null,
507: FND_API.G_MISS_CHAR, null,
508: X_Attribute12),
509: attribute13 = decode(X_Attribute13,
510: NULL, attribute13,
511: FND_API.G_MISS_CHAR, null,
512: X_Attribute13),
513: attribute14 = decode(X_Attribute14,
514: NULL, attribute14,
515: FND_API.G_MISS_CHAR, null,
511: FND_API.G_MISS_CHAR, null,
512: X_Attribute13),
513: attribute14 = decode(X_Attribute14,
514: NULL, attribute14,
515: FND_API.G_MISS_CHAR, null,
516: X_Attribute14),
517: attribute15 = decode(X_Attribute15,
518: NULL, attribute15,
519: FND_API.G_MISS_CHAR, null,
515: FND_API.G_MISS_CHAR, null,
516: X_Attribute14),
517: attribute15 = decode(X_Attribute15,
518: NULL, attribute15,
519: FND_API.G_MISS_CHAR, null,
520: X_Attribute15),
521: attribute_category_code
522: = decode(X_Attribute_Category_Code,
523: NULL, attribute_category_code,
520: X_Attribute15),
521: attribute_category_code
522: = decode(X_Attribute_Category_Code,
523: NULL, attribute_category_code,
524: FND_API.G_MISS_CHAR, null,
525: X_Attribute_Category_Code),
526: transaction_key = decode(X_Transaction_Key,
527: NULL, transaction_key,
528: FND_API.G_MISS_CHAR, null,
524: FND_API.G_MISS_CHAR, null,
525: X_Attribute_Category_Code),
526: transaction_key = decode(X_Transaction_Key,
527: NULL, transaction_key,
528: FND_API.G_MISS_CHAR, null,
529: X_Transaction_Key),
530: amortization_start_date
531: = decode(X_Amortization_Start_Date,
532: NULL, amortization_start_date,
532: NULL, amortization_start_date,
533: X_Amortization_Start_Date),
534: calling_interface = decode(X_Calling_Interface,
535: NULL, calling_interface,
536: FND_API.G_MISS_CHAR, null,
537: X_Calling_Interface),
538: mass_transaction_id = decode(X_mass_transaction_id,
539: NULL, mass_transaction_id,
540: FND_API.G_MISS_NUM, null,
536: FND_API.G_MISS_CHAR, null,
537: X_Calling_Interface),
538: mass_transaction_id = decode(X_mass_transaction_id,
539: NULL, mass_transaction_id,
540: FND_API.G_MISS_NUM, null,
541: X_Mass_transaction_id),
542: member_transaction_header_id = decode(X_Member_Transaction_Header_Id,
543: NULL, member_transaction_header_id,
544: FND_API.G_MISS_NUM, null,
540: FND_API.G_MISS_NUM, null,
541: X_Mass_transaction_id),
542: member_transaction_header_id = decode(X_Member_Transaction_Header_Id,
543: NULL, member_transaction_header_id,
544: FND_API.G_MISS_NUM, null,
545: X_Member_Transaction_Header_Id),
546: trx_reference_id = decode(X_Trx_Reference_Id,
547: NULL, trx_reference_id,
548: FND_API.G_MISS_NUM, null,
544: FND_API.G_MISS_NUM, null,
545: X_Member_Transaction_Header_Id),
546: trx_reference_id = decode(X_Trx_Reference_Id,
547: NULL, trx_reference_id,
548: FND_API.G_MISS_NUM, null,
549: X_Trx_Reference_Id),
550: event_id = decode(X_event_id,
551: NULL, event_id,
552: FND_API.G_MISS_NUM, null,
548: FND_API.G_MISS_NUM, null,
549: X_Trx_Reference_Id),
550: event_id = decode(X_event_id,
551: NULL, event_id,
552: FND_API.G_MISS_NUM, null,
553: X_event_id)
554: WHERE rowid = X_Rowid;
555:
556: if (SQL%NOTFOUND) then