APPS.FA_RETIREMENTS_PKG dependencies on FND_API

Line 697: FND_API.G_MISS_NUM, NULL,

693:
694: UPDATE fa_retirements_mrc_v
695: SET
696: retirement_id = decode(X_Retirement_Id,
697: FND_API.G_MISS_NUM, NULL,
698: NULL, retirement_id,
699: X_retirement_id),
700: book_type_code = decode(X_Book_Type_Code,
701: FND_API.G_MISS_CHAR, NULL,

Line 701: FND_API.G_MISS_CHAR, NULL,

697: FND_API.G_MISS_NUM, NULL,
698: NULL, retirement_id,
699: X_retirement_id),
700: book_type_code = decode(X_Book_Type_Code,
701: FND_API.G_MISS_CHAR, NULL,
702: NULL, book_type_code,
703: X_book_type_code),
704: asset_id = decode(X_Asset_Id,
705: FND_API.G_MISS_NUM, NULL,

Line 705: FND_API.G_MISS_NUM, NULL,

701: FND_API.G_MISS_CHAR, NULL,
702: NULL, book_type_code,
703: X_book_type_code),
704: asset_id = decode(X_Asset_Id,
705: FND_API.G_MISS_NUM, NULL,
706: NULL, asset_id,
707: X_asset_id),
708: transaction_header_id_in = decode(X_Transaction_Header_Id_In,
709: FND_API.G_MISS_NUM, NULL,

Line 709: FND_API.G_MISS_NUM, NULL,

705: FND_API.G_MISS_NUM, NULL,
706: NULL, asset_id,
707: X_asset_id),
708: transaction_header_id_in = decode(X_Transaction_Header_Id_In,
709: FND_API.G_MISS_NUM, NULL,
710: NULL, transaction_header_id_in,
711: X_transaction_header_id_in),
712: /* removed G_MISS_DATE comparison */
713: date_retired = decode(X_Date_Retired,

Line 721: FND_API.G_MISS_NUM, NULL,

717: NULL, date_effective,
718: X_date_effective),
719:
720: cost_retired = decode(X_Cost_Retired,
721: FND_API.G_MISS_NUM, NULL,
722: NULL, cost_retired,
723: X_cost_retired),
724: status = decode(X_Status,
725: FND_API.G_MISS_CHAR, NULL,

Line 725: FND_API.G_MISS_CHAR, NULL,

721: FND_API.G_MISS_NUM, NULL,
722: NULL, cost_retired,
723: X_cost_retired),
724: status = decode(X_Status,
725: FND_API.G_MISS_CHAR, NULL,
726: NULL, status,
727: X_status),
728: /* removed G_MISS_DATE comparison */
729: last_update_date = decode(X_Last_Update_Date,

Line 733: FND_API.G_MISS_NUM, NULL,

729: last_update_date = decode(X_Last_Update_Date,
730: NULL, last_update_date,
731: X_last_update_date),
732: last_updated_by = decode(X_Last_Updated_By,
733: FND_API.G_MISS_NUM, NULL,
734: NULL, last_updated_by,
735: X_last_updated_by),
736: retirement_prorate_convention = decode(X_Ret_Prorate_Convention,
737: FND_API.G_MISS_CHAR, NULL,

Line 737: FND_API.G_MISS_CHAR, NULL,

733: FND_API.G_MISS_NUM, NULL,
734: NULL, last_updated_by,
735: X_last_updated_by),
736: retirement_prorate_convention = decode(X_Ret_Prorate_Convention,
737: FND_API.G_MISS_CHAR, NULL,
738: NULL, retirement_prorate_convention,
739: X_ret_prorate_convention),
740: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
741: FND_API.G_MISS_NUM, NULL,

Line 741: FND_API.G_MISS_NUM, NULL,

737: FND_API.G_MISS_CHAR, NULL,
738: NULL, retirement_prorate_convention,
739: X_ret_prorate_convention),
740: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
741: FND_API.G_MISS_NUM, NULL,
742: NULL, transaction_header_id_out,
743: X_transaction_header_id_out),
744: units = decode(X_Units,
745: FND_API.G_MISS_NUM, NULL,

Line 745: FND_API.G_MISS_NUM, NULL,

741: FND_API.G_MISS_NUM, NULL,
742: NULL, transaction_header_id_out,
743: X_transaction_header_id_out),
744: units = decode(X_Units,
745: FND_API.G_MISS_NUM, NULL,
746: NULL, units,
747: X_units),
748: cost_of_removal = decode(X_Cost_Of_Removal,
749: FND_API.G_MISS_NUM, NULL,

Line 749: FND_API.G_MISS_NUM, NULL,

745: FND_API.G_MISS_NUM, NULL,
746: NULL, units,
747: X_units),
748: cost_of_removal = decode(X_Cost_Of_Removal,
749: FND_API.G_MISS_NUM, NULL,
750: NULL, cost_of_removal,
751: X_cost_of_removal),
752: nbv_retired = decode(X_Nbv_Retired,
753: FND_API.G_MISS_NUM, NULL,

Line 753: FND_API.G_MISS_NUM, NULL,

749: FND_API.G_MISS_NUM, NULL,
750: NULL, cost_of_removal,
751: X_cost_of_removal),
752: nbv_retired = decode(X_Nbv_Retired,
753: FND_API.G_MISS_NUM, NULL,
754: NULL, nbv_retired,
755: X_nbv_retired),
756: gain_loss_amount = decode(X_Gain_Loss_Amount,
757: FND_API.G_MISS_NUM, NULL,

Line 757: FND_API.G_MISS_NUM, NULL,

753: FND_API.G_MISS_NUM, NULL,
754: NULL, nbv_retired,
755: X_nbv_retired),
756: gain_loss_amount = decode(X_Gain_Loss_Amount,
757: FND_API.G_MISS_NUM, NULL,
758: NULL, gain_loss_amount,
759: X_gain_loss_amount),
760: proceeds_of_sale = decode(X_Proceeds_Of_Sale,
761: FND_API.G_MISS_NUM, NULL,

Line 761: FND_API.G_MISS_NUM, NULL,

757: FND_API.G_MISS_NUM, NULL,
758: NULL, gain_loss_amount,
759: X_gain_loss_amount),
760: proceeds_of_sale = decode(X_Proceeds_Of_Sale,
761: FND_API.G_MISS_NUM, NULL,
762: NULL, proceeds_of_sale,
763: X_proceeds_of_sale),
764: gain_loss_type_code = decode(X_Gain_Loss_Type_Code,
765: FND_API.G_MISS_CHAR, NULL,

Line 765: FND_API.G_MISS_CHAR, NULL,

761: FND_API.G_MISS_NUM, NULL,
762: NULL, proceeds_of_sale,
763: X_proceeds_of_sale),
764: gain_loss_type_code = decode(X_Gain_Loss_Type_Code,
765: FND_API.G_MISS_CHAR, NULL,
766: NULL, gain_loss_type_code,
767: X_gain_loss_type_code),
768: retirement_type_code = decode(X_Retirement_Type_Code,
769: FND_API.G_MISS_CHAR, NULL,

Line 769: FND_API.G_MISS_CHAR, NULL,

765: FND_API.G_MISS_CHAR, NULL,
766: NULL, gain_loss_type_code,
767: X_gain_loss_type_code),
768: retirement_type_code = decode(X_Retirement_Type_Code,
769: FND_API.G_MISS_CHAR, NULL,
770: NULL, retirement_type_code,
771: X_retirement_type_code),
772: itc_recaptured = decode(X_Itc_Recaptured,
773: FND_API.G_MISS_NUM, NULL,

Line 773: FND_API.G_MISS_NUM, NULL,

769: FND_API.G_MISS_CHAR, NULL,
770: NULL, retirement_type_code,
771: X_retirement_type_code),
772: itc_recaptured = decode(X_Itc_Recaptured,
773: FND_API.G_MISS_NUM, NULL,
774: NULL, itc_recaptured,
775: X_itc_recaptured),
776: itc_recapture_id = decode(X_Itc_Recapture_Id,
777: FND_API.G_MISS_NUM, NULL,

Line 777: FND_API.G_MISS_NUM, NULL,

773: FND_API.G_MISS_NUM, NULL,
774: NULL, itc_recaptured,
775: X_itc_recaptured),
776: itc_recapture_id = decode(X_Itc_Recapture_Id,
777: FND_API.G_MISS_NUM, NULL,
778: NULL, itc_recapture_id,
779: X_itc_recapture_id),
780: reference_num = decode(X_Reference_Num,
781: FND_API.G_MISS_CHAR, NULL,

Line 781: FND_API.G_MISS_CHAR, NULL,

777: FND_API.G_MISS_NUM, NULL,
778: NULL, itc_recapture_id,
779: X_itc_recapture_id),
780: reference_num = decode(X_Reference_Num,
781: FND_API.G_MISS_CHAR, NULL,
782: NULL, reference_num,
783: X_reference_num),
784: sold_to = decode(X_Sold_To,
785: FND_API.G_MISS_CHAR, NULL,

Line 785: FND_API.G_MISS_CHAR, NULL,

781: FND_API.G_MISS_CHAR, NULL,
782: NULL, reference_num,
783: X_reference_num),
784: sold_to = decode(X_Sold_To,
785: FND_API.G_MISS_CHAR, NULL,
786: NULL, sold_to,
787: X_sold_to),
788: trade_in_asset_id = decode(X_Trade_In_Asset_Id,
789: FND_API.G_MISS_NUM, NULL,

Line 789: FND_API.G_MISS_NUM, NULL,

785: FND_API.G_MISS_CHAR, NULL,
786: NULL, sold_to,
787: X_sold_to),
788: trade_in_asset_id = decode(X_Trade_In_Asset_Id,
789: FND_API.G_MISS_NUM, NULL,
790: NULL, trade_in_asset_id,
791: X_trade_in_asset_id),
792: stl_method_code = decode(X_Stl_Method_Code,
793: FND_API.G_MISS_CHAR, NULL,

Line 793: FND_API.G_MISS_CHAR, NULL,

789: FND_API.G_MISS_NUM, NULL,
790: NULL, trade_in_asset_id,
791: X_trade_in_asset_id),
792: stl_method_code = decode(X_Stl_Method_Code,
793: FND_API.G_MISS_CHAR, NULL,
794: NULL, stl_method_code,
795: X_stl_method_code),
796: stl_life_in_months = decode(X_Stl_Life_In_Months,
797: FND_API.G_MISS_NUM, NULL,

Line 797: FND_API.G_MISS_NUM, NULL,

793: FND_API.G_MISS_CHAR, NULL,
794: NULL, stl_method_code,
795: X_stl_method_code),
796: stl_life_in_months = decode(X_Stl_Life_In_Months,
797: FND_API.G_MISS_NUM, NULL,
798: NULL, stl_life_in_months,
799: X_stl_life_in_months),
800: stl_deprn_amount = decode(X_Stl_Deprn_Amount,
801: FND_API.G_MISS_NUM, NULL,

Line 801: FND_API.G_MISS_NUM, NULL,

797: FND_API.G_MISS_NUM, NULL,
798: NULL, stl_life_in_months,
799: X_stl_life_in_months),
800: stl_deprn_amount = decode(X_Stl_Deprn_Amount,
801: FND_API.G_MISS_NUM, NULL,
802: NULL, stl_deprn_amount,
803: X_stl_deprn_amount),
804: last_update_login = decode(X_Last_Update_Login,
805: FND_API.G_MISS_NUM, NULL,

Line 805: FND_API.G_MISS_NUM, NULL,

801: FND_API.G_MISS_NUM, NULL,
802: NULL, stl_deprn_amount,
803: X_stl_deprn_amount),
804: last_update_login = decode(X_Last_Update_Login,
805: FND_API.G_MISS_NUM, NULL,
806: NULL, last_update_login,
807: X_last_update_login),
808: attribute1 = decode(X_Attribute1,
809: FND_API.G_MISS_CHAR, NULL,

Line 809: FND_API.G_MISS_CHAR, NULL,

805: FND_API.G_MISS_NUM, NULL,
806: NULL, last_update_login,
807: X_last_update_login),
808: attribute1 = decode(X_Attribute1,
809: FND_API.G_MISS_CHAR, NULL,
810: NULL, attribute1,
811: X_attribute1),
812: attribute2 = decode(X_Attribute2,
813: FND_API.G_MISS_CHAR, NULL,

Line 813: FND_API.G_MISS_CHAR, NULL,

809: FND_API.G_MISS_CHAR, NULL,
810: NULL, attribute1,
811: X_attribute1),
812: attribute2 = decode(X_Attribute2,
813: FND_API.G_MISS_CHAR, NULL,
814: NULL, attribute2,
815: X_attribute2),
816: attribute3 = decode(X_Attribute3,
817: FND_API.G_MISS_CHAR, NULL,

Line 817: FND_API.G_MISS_CHAR, NULL,

813: FND_API.G_MISS_CHAR, NULL,
814: NULL, attribute2,
815: X_attribute2),
816: attribute3 = decode(X_Attribute3,
817: FND_API.G_MISS_CHAR, NULL,
818: NULL, attribute3,
819: X_attribute3),
820: attribute4 = decode(X_Attribute4,
821: FND_API.G_MISS_CHAR, NULL,

Line 821: FND_API.G_MISS_CHAR, NULL,

817: FND_API.G_MISS_CHAR, NULL,
818: NULL, attribute3,
819: X_attribute3),
820: attribute4 = decode(X_Attribute4,
821: FND_API.G_MISS_CHAR, NULL,
822: NULL, attribute4,
823: X_attribute4),
824: attribute5 = decode(X_Attribute5,
825: FND_API.G_MISS_CHAR, NULL,

Line 825: FND_API.G_MISS_CHAR, NULL,

821: FND_API.G_MISS_CHAR, NULL,
822: NULL, attribute4,
823: X_attribute4),
824: attribute5 = decode(X_Attribute5,
825: FND_API.G_MISS_CHAR, NULL,
826: NULL, attribute5,
827: X_attribute5),
828: attribute6 = decode(X_Attribute6,
829: FND_API.G_MISS_CHAR, NULL,

Line 829: FND_API.G_MISS_CHAR, NULL,

825: FND_API.G_MISS_CHAR, NULL,
826: NULL, attribute5,
827: X_attribute5),
828: attribute6 = decode(X_Attribute6,
829: FND_API.G_MISS_CHAR, NULL,
830: NULL, attribute6,
831: X_attribute6),
832: attribute7 = decode(X_Attribute7,
833: FND_API.G_MISS_CHAR, NULL,

Line 833: FND_API.G_MISS_CHAR, NULL,

829: FND_API.G_MISS_CHAR, NULL,
830: NULL, attribute6,
831: X_attribute6),
832: attribute7 = decode(X_Attribute7,
833: FND_API.G_MISS_CHAR, NULL,
834: NULL, attribute7,
835: X_attribute7),
836: attribute8 = decode(X_Attribute8,
837: FND_API.G_MISS_CHAR, NULL,

Line 837: FND_API.G_MISS_CHAR, NULL,

833: FND_API.G_MISS_CHAR, NULL,
834: NULL, attribute7,
835: X_attribute7),
836: attribute8 = decode(X_Attribute8,
837: FND_API.G_MISS_CHAR, NULL,
838: NULL, attribute8,
839: X_attribute8),
840: attribute9 = decode(X_Attribute9,
841: FND_API.G_MISS_CHAR, NULL,

Line 841: FND_API.G_MISS_CHAR, NULL,

837: FND_API.G_MISS_CHAR, NULL,
838: NULL, attribute8,
839: X_attribute8),
840: attribute9 = decode(X_Attribute9,
841: FND_API.G_MISS_CHAR, NULL,
842: NULL, attribute9,
843: X_attribute9),
844: attribute10 = decode(X_Attribute10,
845: FND_API.G_MISS_CHAR, NULL,

Line 845: FND_API.G_MISS_CHAR, NULL,

841: FND_API.G_MISS_CHAR, NULL,
842: NULL, attribute9,
843: X_attribute9),
844: attribute10 = decode(X_Attribute10,
845: FND_API.G_MISS_CHAR, NULL,
846: NULL, attribute10,
847: X_attribute10),
848: attribute11 = decode(X_Attribute11,
849: FND_API.G_MISS_CHAR, NULL,

Line 849: FND_API.G_MISS_CHAR, NULL,

845: FND_API.G_MISS_CHAR, NULL,
846: NULL, attribute10,
847: X_attribute10),
848: attribute11 = decode(X_Attribute11,
849: FND_API.G_MISS_CHAR, NULL,
850: NULL, attribute11,
851: X_attribute11),
852: attribute12 = decode(X_Attribute12,
853: FND_API.G_MISS_CHAR, NULL,

Line 853: FND_API.G_MISS_CHAR, NULL,

849: FND_API.G_MISS_CHAR, NULL,
850: NULL, attribute11,
851: X_attribute11),
852: attribute12 = decode(X_Attribute12,
853: FND_API.G_MISS_CHAR, NULL,
854: NULL, attribute12,
855: X_attribute12),
856: attribute13 = decode(X_Attribute13,
857: FND_API.G_MISS_CHAR, NULL,

Line 857: FND_API.G_MISS_CHAR, NULL,

853: FND_API.G_MISS_CHAR, NULL,
854: NULL, attribute12,
855: X_attribute12),
856: attribute13 = decode(X_Attribute13,
857: FND_API.G_MISS_CHAR, NULL,
858: NULL, attribute13,
859: X_attribute13),
860: attribute14 = decode(X_Attribute14,
861: FND_API.G_MISS_CHAR, NULL,

Line 861: FND_API.G_MISS_CHAR, NULL,

857: FND_API.G_MISS_CHAR, NULL,
858: NULL, attribute13,
859: X_attribute13),
860: attribute14 = decode(X_Attribute14,
861: FND_API.G_MISS_CHAR, NULL,
862: NULL, attribute14,
863: X_attribute14),
864: attribute15 = decode(X_Attribute15,
865: FND_API.G_MISS_CHAR, NULL,

Line 865: FND_API.G_MISS_CHAR, NULL,

861: FND_API.G_MISS_CHAR, NULL,
862: NULL, attribute14,
863: X_attribute14),
864: attribute15 = decode(X_Attribute15,
865: FND_API.G_MISS_CHAR, NULL,
866: NULL, attribute15,
867: X_attribute15),
868: attribute_category_code = decode(X_Attribute_Category_Code,
869: FND_API.G_MISS_CHAR, NULL,

Line 869: FND_API.G_MISS_CHAR, NULL,

865: FND_API.G_MISS_CHAR, NULL,
866: NULL, attribute15,
867: X_attribute15),
868: attribute_category_code = decode(X_Attribute_Category_Code,
869: FND_API.G_MISS_CHAR, NULL,
870: NULL, attribute_category_code,
871: X_attribute_category_code),
872: reval_reserve_retired = decode(X_Reval_Reserve_Retired,
873: FND_API.G_MISS_NUM, NULL,

Line 873: FND_API.G_MISS_NUM, NULL,

869: FND_API.G_MISS_CHAR, NULL,
870: NULL, attribute_category_code,
871: X_attribute_category_code),
872: reval_reserve_retired = decode(X_Reval_Reserve_Retired,
873: FND_API.G_MISS_NUM, NULL,
874: NULL, reval_reserve_retired,
875: X_reval_reserve_retired),
876: unrevalued_cost_retired = decode(X_Unrevalued_Cost_Retired,
877: FND_API.G_MISS_NUM, NULL,

Line 877: FND_API.G_MISS_NUM, NULL,

873: FND_API.G_MISS_NUM, NULL,
874: NULL, reval_reserve_retired,
875: X_reval_reserve_retired),
876: unrevalued_cost_retired = decode(X_Unrevalued_Cost_Retired,
877: FND_API.G_MISS_NUM, NULL,
878: NULL, unrevalued_cost_retired,
879: X_unrevalued_cost_retired),
880: recognize_gain_loss = decode(X_Recognize_Gain_Loss,
881: FND_API.G_MISS_CHAR, NULL,

Line 881: FND_API.G_MISS_CHAR, NULL,

877: FND_API.G_MISS_NUM, NULL,
878: NULL, unrevalued_cost_retired,
879: X_unrevalued_cost_retired),
880: recognize_gain_loss = decode(X_Recognize_Gain_Loss,
881: FND_API.G_MISS_CHAR, NULL,
882: NULL, recognize_gain_loss,
883: X_Recognize_Gain_Loss),
884: recapture_reserve_flag = decode(X_Recapture_Reserve_Flag,
885: FND_API.G_MISS_CHAR, NULL,

Line 885: FND_API.G_MISS_CHAR, NULL,

881: FND_API.G_MISS_CHAR, NULL,
882: NULL, recognize_gain_loss,
883: X_Recognize_Gain_Loss),
884: recapture_reserve_flag = decode(X_Recapture_Reserve_Flag,
885: FND_API.G_MISS_CHAR, NULL,
886: NULL, recapture_reserve_flag,
887: X_Recapture_Reserve_Flag),
888: limit_proceeds_flag = decode(X_Limit_Proceeds_Flag,
889: FND_API.G_MISS_CHAR, NULL,

Line 889: FND_API.G_MISS_CHAR, NULL,

885: FND_API.G_MISS_CHAR, NULL,
886: NULL, recapture_reserve_flag,
887: X_Recapture_Reserve_Flag),
888: limit_proceeds_flag = decode(X_Limit_Proceeds_Flag,
889: FND_API.G_MISS_CHAR, NULL,
890: NULL, limit_proceeds_flag,
891: X_Limit_Proceeds_Flag),
892: terminal_gain_loss = decode(X_Terminal_Gain_Loss,
893: FND_API.G_MISS_CHAR, NULL,

Line 893: FND_API.G_MISS_CHAR, NULL,

889: FND_API.G_MISS_CHAR, NULL,
890: NULL, limit_proceeds_flag,
891: X_Limit_Proceeds_Flag),
892: terminal_gain_loss = decode(X_Terminal_Gain_Loss,
893: FND_API.G_MISS_CHAR, NULL,
894: NULL, terminal_gain_loss,
895: X_Terminal_Gain_Loss),
896: reserve_retired = decode(X_Reserve_Retired,
897: FND_API.G_MISS_NUM, NULL,

Line 897: FND_API.G_MISS_NUM, NULL,

893: FND_API.G_MISS_CHAR, NULL,
894: NULL, terminal_gain_loss,
895: X_Terminal_Gain_Loss),
896: reserve_retired = decode(X_Reserve_Retired,
897: FND_API.G_MISS_NUM, NULL,
898: NULL, reserve_retired,
899: X_Reserve_Retired),
900: reduction_rate = decode(X_Reduction_Rate,
901: FND_API.G_MISS_NUM, NULL,

Line 901: FND_API.G_MISS_NUM, NULL,

897: FND_API.G_MISS_NUM, NULL,
898: NULL, reserve_retired,
899: X_Reserve_Retired),
900: reduction_rate = decode(X_Reduction_Rate,
901: FND_API.G_MISS_NUM, NULL,
902: NULL, reduction_rate,
903: X_Reduction_Rate),
904: eofy_reserve = decode(X_Eofy_Reserve,
905: FND_API.G_MISS_NUM, NULL,

Line 905: FND_API.G_MISS_NUM, NULL,

901: FND_API.G_MISS_NUM, NULL,
902: NULL, reduction_rate,
903: X_Reduction_Rate),
904: eofy_reserve = decode(X_Eofy_Reserve,
905: FND_API.G_MISS_NUM, NULL,
906: NULL, eofy_reserve,
907: X_Eofy_Reserve),
908: recapture_amount = decode(X_Recapture_Amount,
909: FND_API.G_MISS_NUM, NULL,

Line 909: FND_API.G_MISS_NUM, NULL,

905: FND_API.G_MISS_NUM, NULL,
906: NULL, eofy_reserve,
907: X_Eofy_Reserve),
908: recapture_amount = decode(X_Recapture_Amount,
909: FND_API.G_MISS_NUM, NULL,
910: NULL, recapture_amount,
911: X_Recapture_Amount)
912: WHERE rowid = l_rowid;
913: else

Line 927: FND_API.G_MISS_NUM, NULL,

923:
924: UPDATE fa_retirements
925: SET
926: retirement_id = decode(X_Retirement_Id,
927: FND_API.G_MISS_NUM, NULL,
928: NULL, retirement_id,
929: X_retirement_id),
930: book_type_code = decode(X_Book_Type_Code,
931: FND_API.G_MISS_CHAR, NULL,

Line 931: FND_API.G_MISS_CHAR, NULL,

927: FND_API.G_MISS_NUM, NULL,
928: NULL, retirement_id,
929: X_retirement_id),
930: book_type_code = decode(X_Book_Type_Code,
931: FND_API.G_MISS_CHAR, NULL,
932: NULL, book_type_code,
933: X_book_type_code),
934: asset_id = decode(X_Asset_Id,
935: FND_API.G_MISS_NUM, NULL,

Line 935: FND_API.G_MISS_NUM, NULL,

931: FND_API.G_MISS_CHAR, NULL,
932: NULL, book_type_code,
933: X_book_type_code),
934: asset_id = decode(X_Asset_Id,
935: FND_API.G_MISS_NUM, NULL,
936: NULL, asset_id,
937: X_asset_id),
938: transaction_header_id_in = decode(X_Transaction_Header_Id_In,
939: FND_API.G_MISS_NUM, NULL,

Line 939: FND_API.G_MISS_NUM, NULL,

935: FND_API.G_MISS_NUM, NULL,
936: NULL, asset_id,
937: X_asset_id),
938: transaction_header_id_in = decode(X_Transaction_Header_Id_In,
939: FND_API.G_MISS_NUM, NULL,
940: NULL, transaction_header_id_in,
941: X_transaction_header_id_in),
942: /* removed G_MISS_DATE comparison */
943: date_retired = decode(X_Date_Retired,

Line 951: FND_API.G_MISS_NUM, NULL,

947: date_effective = decode(X_Date_Effective,
948: NULL, date_effective,
949: X_Date_Effective),
950: cost_retired = decode(X_Cost_Retired,
951: FND_API.G_MISS_NUM, NULL,
952: NULL, cost_retired,
953: X_cost_retired),
954: status = decode(X_Status,
955: FND_API.G_MISS_CHAR, NULL,

Line 955: FND_API.G_MISS_CHAR, NULL,

951: FND_API.G_MISS_NUM, NULL,
952: NULL, cost_retired,
953: X_cost_retired),
954: status = decode(X_Status,
955: FND_API.G_MISS_CHAR, NULL,
956: NULL, status,
957: X_status),
958: /* removed G_MISS_DATE comparison */
959: last_update_date = decode(X_Last_Update_Date,

Line 963: FND_API.G_MISS_NUM, NULL,

959: last_update_date = decode(X_Last_Update_Date,
960: NULL, last_update_date,
961: X_last_update_date),
962: last_updated_by = decode(X_Last_Updated_By,
963: FND_API.G_MISS_NUM, NULL,
964: NULL, last_updated_by,
965: X_last_updated_by),
966: retirement_prorate_convention = decode(X_Ret_Prorate_Convention,
967: FND_API.G_MISS_CHAR, NULL,

Line 967: FND_API.G_MISS_CHAR, NULL,

963: FND_API.G_MISS_NUM, NULL,
964: NULL, last_updated_by,
965: X_last_updated_by),
966: retirement_prorate_convention = decode(X_Ret_Prorate_Convention,
967: FND_API.G_MISS_CHAR, NULL,
968: NULL, retirement_prorate_convention,
969: X_ret_prorate_convention),
970: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
971: FND_API.G_MISS_NUM, NULL,

Line 971: FND_API.G_MISS_NUM, NULL,

967: FND_API.G_MISS_CHAR, NULL,
968: NULL, retirement_prorate_convention,
969: X_ret_prorate_convention),
970: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
971: FND_API.G_MISS_NUM, NULL,
972: NULL, transaction_header_id_out,
973: X_transaction_header_id_out),
974: units = decode(X_Units,
975: FND_API.G_MISS_NUM, NULL,

Line 975: FND_API.G_MISS_NUM, NULL,

971: FND_API.G_MISS_NUM, NULL,
972: NULL, transaction_header_id_out,
973: X_transaction_header_id_out),
974: units = decode(X_Units,
975: FND_API.G_MISS_NUM, NULL,
976: NULL, units,
977: X_units),
978: cost_of_removal = decode(X_Cost_Of_Removal,
979: FND_API.G_MISS_NUM, NULL,

Line 979: FND_API.G_MISS_NUM, NULL,

975: FND_API.G_MISS_NUM, NULL,
976: NULL, units,
977: X_units),
978: cost_of_removal = decode(X_Cost_Of_Removal,
979: FND_API.G_MISS_NUM, NULL,
980: NULL, cost_of_removal,
981: X_cost_of_removal),
982: nbv_retired = decode(X_Nbv_Retired,
983: FND_API.G_MISS_NUM, NULL,

Line 983: FND_API.G_MISS_NUM, NULL,

979: FND_API.G_MISS_NUM, NULL,
980: NULL, cost_of_removal,
981: X_cost_of_removal),
982: nbv_retired = decode(X_Nbv_Retired,
983: FND_API.G_MISS_NUM, NULL,
984: NULL, nbv_retired,
985: X_nbv_retired),
986: gain_loss_amount = decode(X_Gain_Loss_Amount,
987: FND_API.G_MISS_NUM, NULL,

Line 987: FND_API.G_MISS_NUM, NULL,

983: FND_API.G_MISS_NUM, NULL,
984: NULL, nbv_retired,
985: X_nbv_retired),
986: gain_loss_amount = decode(X_Gain_Loss_Amount,
987: FND_API.G_MISS_NUM, NULL,
988: NULL, gain_loss_amount,
989: X_gain_loss_amount),
990: proceeds_of_sale = decode(X_Proceeds_Of_Sale,
991: FND_API.G_MISS_NUM, NULL,

Line 991: FND_API.G_MISS_NUM, NULL,

987: FND_API.G_MISS_NUM, NULL,
988: NULL, gain_loss_amount,
989: X_gain_loss_amount),
990: proceeds_of_sale = decode(X_Proceeds_Of_Sale,
991: FND_API.G_MISS_NUM, NULL,
992: NULL, proceeds_of_sale,
993: X_proceeds_of_sale),
994: gain_loss_type_code = decode(X_Gain_Loss_Type_Code,
995: FND_API.G_MISS_CHAR, NULL,

Line 995: FND_API.G_MISS_CHAR, NULL,

991: FND_API.G_MISS_NUM, NULL,
992: NULL, proceeds_of_sale,
993: X_proceeds_of_sale),
994: gain_loss_type_code = decode(X_Gain_Loss_Type_Code,
995: FND_API.G_MISS_CHAR, NULL,
996: NULL, gain_loss_type_code,
997: X_gain_loss_type_code),
998: retirement_type_code = decode(X_Retirement_Type_Code,
999: FND_API.G_MISS_CHAR, NULL,

Line 999: FND_API.G_MISS_CHAR, NULL,

995: FND_API.G_MISS_CHAR, NULL,
996: NULL, gain_loss_type_code,
997: X_gain_loss_type_code),
998: retirement_type_code = decode(X_Retirement_Type_Code,
999: FND_API.G_MISS_CHAR, NULL,
1000: NULL, retirement_type_code,
1001: X_retirement_type_code),
1002: itc_recaptured = decode(X_Itc_Recaptured,
1003: FND_API.G_MISS_NUM, NULL,

Line 1003: FND_API.G_MISS_NUM, NULL,

999: FND_API.G_MISS_CHAR, NULL,
1000: NULL, retirement_type_code,
1001: X_retirement_type_code),
1002: itc_recaptured = decode(X_Itc_Recaptured,
1003: FND_API.G_MISS_NUM, NULL,
1004: NULL, itc_recaptured,
1005: X_itc_recaptured),
1006: itc_recapture_id = decode(X_Itc_Recapture_Id,
1007: FND_API.G_MISS_NUM, NULL,

Line 1007: FND_API.G_MISS_NUM, NULL,

1003: FND_API.G_MISS_NUM, NULL,
1004: NULL, itc_recaptured,
1005: X_itc_recaptured),
1006: itc_recapture_id = decode(X_Itc_Recapture_Id,
1007: FND_API.G_MISS_NUM, NULL,
1008: NULL, itc_recapture_id,
1009: X_itc_recapture_id),
1010: reference_num = decode(X_Reference_Num,
1011: FND_API.G_MISS_CHAR, NULL,

Line 1011: FND_API.G_MISS_CHAR, NULL,

1007: FND_API.G_MISS_NUM, NULL,
1008: NULL, itc_recapture_id,
1009: X_itc_recapture_id),
1010: reference_num = decode(X_Reference_Num,
1011: FND_API.G_MISS_CHAR, NULL,
1012: NULL, reference_num,
1013: X_reference_num),
1014: sold_to = decode(X_Sold_To,
1015: FND_API.G_MISS_CHAR, NULL,

Line 1015: FND_API.G_MISS_CHAR, NULL,

1011: FND_API.G_MISS_CHAR, NULL,
1012: NULL, reference_num,
1013: X_reference_num),
1014: sold_to = decode(X_Sold_To,
1015: FND_API.G_MISS_CHAR, NULL,
1016: NULL, sold_to,
1017: X_sold_to),
1018: trade_in_asset_id = decode(X_Trade_In_Asset_Id,
1019: FND_API.G_MISS_NUM, NULL,

Line 1019: FND_API.G_MISS_NUM, NULL,

1015: FND_API.G_MISS_CHAR, NULL,
1016: NULL, sold_to,
1017: X_sold_to),
1018: trade_in_asset_id = decode(X_Trade_In_Asset_Id,
1019: FND_API.G_MISS_NUM, NULL,
1020: NULL, trade_in_asset_id,
1021: X_trade_in_asset_id),
1022: stl_method_code = decode(X_Stl_Method_Code,
1023: FND_API.G_MISS_CHAR, NULL,

Line 1023: FND_API.G_MISS_CHAR, NULL,

1019: FND_API.G_MISS_NUM, NULL,
1020: NULL, trade_in_asset_id,
1021: X_trade_in_asset_id),
1022: stl_method_code = decode(X_Stl_Method_Code,
1023: FND_API.G_MISS_CHAR, NULL,
1024: NULL, stl_method_code,
1025: X_stl_method_code),
1026: stl_life_in_months = decode(X_Stl_Life_In_Months,
1027: FND_API.G_MISS_NUM, NULL,

Line 1027: FND_API.G_MISS_NUM, NULL,

1023: FND_API.G_MISS_CHAR, NULL,
1024: NULL, stl_method_code,
1025: X_stl_method_code),
1026: stl_life_in_months = decode(X_Stl_Life_In_Months,
1027: FND_API.G_MISS_NUM, NULL,
1028: NULL, stl_life_in_months,
1029: X_stl_life_in_months),
1030: stl_deprn_amount = decode(X_Stl_Deprn_Amount,
1031: FND_API.G_MISS_NUM, NULL,

Line 1031: FND_API.G_MISS_NUM, NULL,

1027: FND_API.G_MISS_NUM, NULL,
1028: NULL, stl_life_in_months,
1029: X_stl_life_in_months),
1030: stl_deprn_amount = decode(X_Stl_Deprn_Amount,
1031: FND_API.G_MISS_NUM, NULL,
1032: NULL, stl_deprn_amount,
1033: X_stl_deprn_amount),
1034: last_update_login = decode(X_Last_Update_Login,
1035: FND_API.G_MISS_NUM, NULL,

Line 1035: FND_API.G_MISS_NUM, NULL,

1031: FND_API.G_MISS_NUM, NULL,
1032: NULL, stl_deprn_amount,
1033: X_stl_deprn_amount),
1034: last_update_login = decode(X_Last_Update_Login,
1035: FND_API.G_MISS_NUM, NULL,
1036: NULL, last_update_login,
1037: X_last_update_login),
1038: attribute1 = decode(X_Attribute1,
1039: FND_API.G_MISS_CHAR, NULL,

Line 1039: FND_API.G_MISS_CHAR, NULL,

1035: FND_API.G_MISS_NUM, NULL,
1036: NULL, last_update_login,
1037: X_last_update_login),
1038: attribute1 = decode(X_Attribute1,
1039: FND_API.G_MISS_CHAR, NULL,
1040: NULL, attribute1,
1041: X_attribute1),
1042: attribute2 = decode(X_Attribute2,
1043: FND_API.G_MISS_CHAR, NULL,

Line 1043: FND_API.G_MISS_CHAR, NULL,

1039: FND_API.G_MISS_CHAR, NULL,
1040: NULL, attribute1,
1041: X_attribute1),
1042: attribute2 = decode(X_Attribute2,
1043: FND_API.G_MISS_CHAR, NULL,
1044: NULL, attribute2,
1045: X_attribute2),
1046: attribute3 = decode(X_Attribute3,
1047: FND_API.G_MISS_CHAR, NULL,

Line 1047: FND_API.G_MISS_CHAR, NULL,

1043: FND_API.G_MISS_CHAR, NULL,
1044: NULL, attribute2,
1045: X_attribute2),
1046: attribute3 = decode(X_Attribute3,
1047: FND_API.G_MISS_CHAR, NULL,
1048: NULL, attribute3,
1049: X_attribute3),
1050: attribute4 = decode(X_Attribute4,
1051: FND_API.G_MISS_CHAR, NULL,

Line 1051: FND_API.G_MISS_CHAR, NULL,

1047: FND_API.G_MISS_CHAR, NULL,
1048: NULL, attribute3,
1049: X_attribute3),
1050: attribute4 = decode(X_Attribute4,
1051: FND_API.G_MISS_CHAR, NULL,
1052: NULL, attribute4,
1053: X_attribute4),
1054: attribute5 = decode(X_Attribute5,
1055: FND_API.G_MISS_CHAR, NULL,

Line 1055: FND_API.G_MISS_CHAR, NULL,

1051: FND_API.G_MISS_CHAR, NULL,
1052: NULL, attribute4,
1053: X_attribute4),
1054: attribute5 = decode(X_Attribute5,
1055: FND_API.G_MISS_CHAR, NULL,
1056: NULL, attribute5,
1057: X_attribute5),
1058: attribute6 = decode(X_Attribute6,
1059: FND_API.G_MISS_CHAR, NULL,

Line 1059: FND_API.G_MISS_CHAR, NULL,

1055: FND_API.G_MISS_CHAR, NULL,
1056: NULL, attribute5,
1057: X_attribute5),
1058: attribute6 = decode(X_Attribute6,
1059: FND_API.G_MISS_CHAR, NULL,
1060: NULL, attribute6,
1061: X_attribute6),
1062: attribute7 = decode(X_Attribute7,
1063: FND_API.G_MISS_CHAR, NULL,

Line 1063: FND_API.G_MISS_CHAR, NULL,

1059: FND_API.G_MISS_CHAR, NULL,
1060: NULL, attribute6,
1061: X_attribute6),
1062: attribute7 = decode(X_Attribute7,
1063: FND_API.G_MISS_CHAR, NULL,
1064: NULL, attribute7,
1065: X_attribute7),
1066: attribute8 = decode(X_Attribute8,
1067: FND_API.G_MISS_CHAR, NULL,

Line 1067: FND_API.G_MISS_CHAR, NULL,

1063: FND_API.G_MISS_CHAR, NULL,
1064: NULL, attribute7,
1065: X_attribute7),
1066: attribute8 = decode(X_Attribute8,
1067: FND_API.G_MISS_CHAR, NULL,
1068: NULL, attribute8,
1069: X_attribute8),
1070: attribute9 = decode(X_Attribute9,
1071: FND_API.G_MISS_CHAR, NULL,

Line 1071: FND_API.G_MISS_CHAR, NULL,

1067: FND_API.G_MISS_CHAR, NULL,
1068: NULL, attribute8,
1069: X_attribute8),
1070: attribute9 = decode(X_Attribute9,
1071: FND_API.G_MISS_CHAR, NULL,
1072: NULL, attribute9,
1073: X_attribute9),
1074: attribute10 = decode(X_Attribute10,
1075: FND_API.G_MISS_CHAR, NULL,

Line 1075: FND_API.G_MISS_CHAR, NULL,

1071: FND_API.G_MISS_CHAR, NULL,
1072: NULL, attribute9,
1073: X_attribute9),
1074: attribute10 = decode(X_Attribute10,
1075: FND_API.G_MISS_CHAR, NULL,
1076: NULL, attribute10,
1077: X_attribute10),
1078: attribute11 = decode(X_Attribute11,
1079: FND_API.G_MISS_CHAR, NULL,

Line 1079: FND_API.G_MISS_CHAR, NULL,

1075: FND_API.G_MISS_CHAR, NULL,
1076: NULL, attribute10,
1077: X_attribute10),
1078: attribute11 = decode(X_Attribute11,
1079: FND_API.G_MISS_CHAR, NULL,
1080: NULL, attribute11,
1081: X_attribute11),
1082: attribute12 = decode(X_Attribute12,
1083: FND_API.G_MISS_CHAR, NULL,

Line 1083: FND_API.G_MISS_CHAR, NULL,

1079: FND_API.G_MISS_CHAR, NULL,
1080: NULL, attribute11,
1081: X_attribute11),
1082: attribute12 = decode(X_Attribute12,
1083: FND_API.G_MISS_CHAR, NULL,
1084: NULL, attribute12,
1085: X_attribute12),
1086: attribute13 = decode(X_Attribute13,
1087: FND_API.G_MISS_CHAR, NULL,

Line 1087: FND_API.G_MISS_CHAR, NULL,

1083: FND_API.G_MISS_CHAR, NULL,
1084: NULL, attribute12,
1085: X_attribute12),
1086: attribute13 = decode(X_Attribute13,
1087: FND_API.G_MISS_CHAR, NULL,
1088: NULL, attribute13,
1089: X_attribute13),
1090: attribute14 = decode(X_Attribute14,
1091: FND_API.G_MISS_CHAR, NULL,

Line 1091: FND_API.G_MISS_CHAR, NULL,

1087: FND_API.G_MISS_CHAR, NULL,
1088: NULL, attribute13,
1089: X_attribute13),
1090: attribute14 = decode(X_Attribute14,
1091: FND_API.G_MISS_CHAR, NULL,
1092: NULL, attribute14,
1093: X_attribute14),
1094: attribute15 = decode(X_Attribute15,
1095: FND_API.G_MISS_CHAR, NULL,

Line 1095: FND_API.G_MISS_CHAR, NULL,

1091: FND_API.G_MISS_CHAR, NULL,
1092: NULL, attribute14,
1093: X_attribute14),
1094: attribute15 = decode(X_Attribute15,
1095: FND_API.G_MISS_CHAR, NULL,
1096: NULL, attribute15,
1097: X_attribute15),
1098: attribute_category_code = decode(X_Attribute_Category_Code,
1099: FND_API.G_MISS_CHAR, NULL,

Line 1099: FND_API.G_MISS_CHAR, NULL,

1095: FND_API.G_MISS_CHAR, NULL,
1096: NULL, attribute15,
1097: X_attribute15),
1098: attribute_category_code = decode(X_Attribute_Category_Code,
1099: FND_API.G_MISS_CHAR, NULL,
1100: NULL, attribute_category_code,
1101: X_attribute_category_code),
1102: reval_reserve_retired = decode(X_Reval_Reserve_Retired,
1103: FND_API.G_MISS_NUM, NULL,

Line 1103: FND_API.G_MISS_NUM, NULL,

1099: FND_API.G_MISS_CHAR, NULL,
1100: NULL, attribute_category_code,
1101: X_attribute_category_code),
1102: reval_reserve_retired = decode(X_Reval_Reserve_Retired,
1103: FND_API.G_MISS_NUM, NULL,
1104: NULL, reval_reserve_retired,
1105: X_reval_reserve_retired),
1106: unrevalued_cost_retired = decode(X_Unrevalued_Cost_Retired,
1107: FND_API.G_MISS_NUM, NULL,

Line 1107: FND_API.G_MISS_NUM, NULL,

1103: FND_API.G_MISS_NUM, NULL,
1104: NULL, reval_reserve_retired,
1105: X_reval_reserve_retired),
1106: unrevalued_cost_retired = decode(X_Unrevalued_Cost_Retired,
1107: FND_API.G_MISS_NUM, NULL,
1108: NULL, unrevalued_cost_retired,
1109: X_unrevalued_cost_retired),
1110: recognize_gain_loss = decode(X_Recognize_Gain_Loss,
1111: FND_API.G_MISS_CHAR, NULL,

Line 1111: FND_API.G_MISS_CHAR, NULL,

1107: FND_API.G_MISS_NUM, NULL,
1108: NULL, unrevalued_cost_retired,
1109: X_unrevalued_cost_retired),
1110: recognize_gain_loss = decode(X_Recognize_Gain_Loss,
1111: FND_API.G_MISS_CHAR, NULL,
1112: NULL, recognize_gain_loss,
1113: X_Recognize_Gain_Loss),
1114: recapture_reserve_flag = decode(X_Recapture_Reserve_Flag,
1115: FND_API.G_MISS_CHAR, NULL,

Line 1115: FND_API.G_MISS_CHAR, NULL,

1111: FND_API.G_MISS_CHAR, NULL,
1112: NULL, recognize_gain_loss,
1113: X_Recognize_Gain_Loss),
1114: recapture_reserve_flag = decode(X_Recapture_Reserve_Flag,
1115: FND_API.G_MISS_CHAR, NULL,
1116: NULL, recapture_reserve_flag,
1117: X_Recapture_Reserve_Flag),
1118: limit_proceeds_flag = decode(X_Limit_Proceeds_Flag,
1119: FND_API.G_MISS_CHAR, NULL,

Line 1119: FND_API.G_MISS_CHAR, NULL,

1115: FND_API.G_MISS_CHAR, NULL,
1116: NULL, recapture_reserve_flag,
1117: X_Recapture_Reserve_Flag),
1118: limit_proceeds_flag = decode(X_Limit_Proceeds_Flag,
1119: FND_API.G_MISS_CHAR, NULL,
1120: NULL, limit_proceeds_flag,
1121: X_Limit_Proceeds_Flag),
1122: terminal_gain_loss = decode(X_Terminal_Gain_Loss,
1123: FND_API.G_MISS_CHAR, NULL,

Line 1123: FND_API.G_MISS_CHAR, NULL,

1119: FND_API.G_MISS_CHAR, NULL,
1120: NULL, limit_proceeds_flag,
1121: X_Limit_Proceeds_Flag),
1122: terminal_gain_loss = decode(X_Terminal_Gain_Loss,
1123: FND_API.G_MISS_CHAR, NULL,
1124: NULL, terminal_gain_loss,
1125: X_Terminal_Gain_Loss),
1126: reserve_retired = decode(X_Reserve_Retired,
1127: FND_API.G_MISS_NUM, NULL,

Line 1127: FND_API.G_MISS_NUM, NULL,

1123: FND_API.G_MISS_CHAR, NULL,
1124: NULL, terminal_gain_loss,
1125: X_Terminal_Gain_Loss),
1126: reserve_retired = decode(X_Reserve_Retired,
1127: FND_API.G_MISS_NUM, NULL,
1128: NULL, reserve_retired,
1129: X_Reserve_Retired),
1130: reduction_rate = decode(X_Reduction_Rate,
1131: FND_API.G_MISS_NUM, NULL,

Line 1131: FND_API.G_MISS_NUM, NULL,

1127: FND_API.G_MISS_NUM, NULL,
1128: NULL, reserve_retired,
1129: X_Reserve_Retired),
1130: reduction_rate = decode(X_Reduction_Rate,
1131: FND_API.G_MISS_NUM, NULL,
1132: NULL, reduction_rate,
1133: X_Reduction_Rate),
1134: eofy_reserve = decode(X_Eofy_Reserve,
1135: FND_API.G_MISS_NUM, NULL,

Line 1135: FND_API.G_MISS_NUM, NULL,

1131: FND_API.G_MISS_NUM, NULL,
1132: NULL, reduction_rate,
1133: X_Reduction_Rate),
1134: eofy_reserve = decode(X_Eofy_Reserve,
1135: FND_API.G_MISS_NUM, NULL,
1136: NULL, eofy_reserve,
1137: X_Eofy_Reserve),
1138: recapture_amount = decode(X_Recapture_Amount,
1139: FND_API.G_MISS_NUM, NULL,

Line 1139: FND_API.G_MISS_NUM, NULL,

1135: FND_API.G_MISS_NUM, NULL,
1136: NULL, eofy_reserve,
1137: X_Eofy_Reserve),
1138: recapture_amount = decode(X_Recapture_Amount,
1139: FND_API.G_MISS_NUM, NULL,
1140: NULL, recapture_amount,
1141: X_Recapture_Amount)
1142: WHERE rowid = l_rowid;
1143: end if;