APPS.FA_RETIREMENTS_PKG dependencies on FND_API

Line 704: FND_API.G_MISS_NUM, NULL,

700:
701: UPDATE fa_mc_retirements
702: SET
703: retirement_id = decode(X_Retirement_Id,
704: FND_API.G_MISS_NUM, NULL,
705: NULL, retirement_id,
706: X_retirement_id),
707: book_type_code = decode(X_Book_Type_Code,
708: FND_API.G_MISS_CHAR, NULL,

Line 708: FND_API.G_MISS_CHAR, NULL,

704: FND_API.G_MISS_NUM, NULL,
705: NULL, retirement_id,
706: X_retirement_id),
707: book_type_code = decode(X_Book_Type_Code,
708: FND_API.G_MISS_CHAR, NULL,
709: NULL, book_type_code,
710: X_book_type_code),
711: asset_id = decode(X_Asset_Id,
712: FND_API.G_MISS_NUM, NULL,

Line 712: FND_API.G_MISS_NUM, NULL,

708: FND_API.G_MISS_CHAR, NULL,
709: NULL, book_type_code,
710: X_book_type_code),
711: asset_id = decode(X_Asset_Id,
712: FND_API.G_MISS_NUM, NULL,
713: NULL, asset_id,
714: X_asset_id),
715: transaction_header_id_in = decode(X_Transaction_Header_Id_In,
716: FND_API.G_MISS_NUM, NULL,

Line 716: FND_API.G_MISS_NUM, NULL,

712: FND_API.G_MISS_NUM, NULL,
713: NULL, asset_id,
714: X_asset_id),
715: transaction_header_id_in = decode(X_Transaction_Header_Id_In,
716: FND_API.G_MISS_NUM, NULL,
717: NULL, transaction_header_id_in,
718: X_transaction_header_id_in),
719: /* removed G_MISS_DATE comparison */
720: date_retired = decode(X_Date_Retired,

Line 728: FND_API.G_MISS_NUM, NULL,

724: NULL, date_effective,
725: X_date_effective),
726:
727: cost_retired = decode(X_Cost_Retired,
728: FND_API.G_MISS_NUM, NULL,
729: NULL, cost_retired,
730: X_cost_retired),
731: status = decode(X_Status,
732: FND_API.G_MISS_CHAR, NULL,

Line 732: FND_API.G_MISS_CHAR, NULL,

728: FND_API.G_MISS_NUM, NULL,
729: NULL, cost_retired,
730: X_cost_retired),
731: status = decode(X_Status,
732: FND_API.G_MISS_CHAR, NULL,
733: NULL, status,
734: X_status),
735: /* removed G_MISS_DATE comparison */
736: last_update_date = decode(X_Last_Update_Date,

Line 740: FND_API.G_MISS_NUM, NULL,

736: last_update_date = decode(X_Last_Update_Date,
737: NULL, last_update_date,
738: X_last_update_date),
739: last_updated_by = decode(X_Last_Updated_By,
740: FND_API.G_MISS_NUM, NULL,
741: NULL, last_updated_by,
742: X_last_updated_by),
743: retirement_prorate_convention = decode(X_Ret_Prorate_Convention,
744: FND_API.G_MISS_CHAR, NULL,

Line 744: FND_API.G_MISS_CHAR, NULL,

740: FND_API.G_MISS_NUM, NULL,
741: NULL, last_updated_by,
742: X_last_updated_by),
743: retirement_prorate_convention = decode(X_Ret_Prorate_Convention,
744: FND_API.G_MISS_CHAR, NULL,
745: NULL, retirement_prorate_convention,
746: X_ret_prorate_convention),
747: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
748: FND_API.G_MISS_NUM, NULL,

Line 748: FND_API.G_MISS_NUM, NULL,

744: FND_API.G_MISS_CHAR, NULL,
745: NULL, retirement_prorate_convention,
746: X_ret_prorate_convention),
747: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
748: FND_API.G_MISS_NUM, NULL,
749: NULL, transaction_header_id_out,
750: X_transaction_header_id_out),
751: units = decode(X_Units,
752: FND_API.G_MISS_NUM, NULL,

Line 752: FND_API.G_MISS_NUM, NULL,

748: FND_API.G_MISS_NUM, NULL,
749: NULL, transaction_header_id_out,
750: X_transaction_header_id_out),
751: units = decode(X_Units,
752: FND_API.G_MISS_NUM, NULL,
753: NULL, units,
754: X_units),
755: cost_of_removal = decode(X_Cost_Of_Removal,
756: FND_API.G_MISS_NUM, NULL,

Line 756: FND_API.G_MISS_NUM, NULL,

752: FND_API.G_MISS_NUM, NULL,
753: NULL, units,
754: X_units),
755: cost_of_removal = decode(X_Cost_Of_Removal,
756: FND_API.G_MISS_NUM, NULL,
757: NULL, cost_of_removal,
758: X_cost_of_removal),
759: nbv_retired = decode(X_Nbv_Retired,
760: FND_API.G_MISS_NUM, NULL,

Line 760: FND_API.G_MISS_NUM, NULL,

756: FND_API.G_MISS_NUM, NULL,
757: NULL, cost_of_removal,
758: X_cost_of_removal),
759: nbv_retired = decode(X_Nbv_Retired,
760: FND_API.G_MISS_NUM, NULL,
761: NULL, nbv_retired,
762: X_nbv_retired),
763: gain_loss_amount = decode(X_Gain_Loss_Amount,
764: FND_API.G_MISS_NUM, NULL,

Line 764: FND_API.G_MISS_NUM, NULL,

760: FND_API.G_MISS_NUM, NULL,
761: NULL, nbv_retired,
762: X_nbv_retired),
763: gain_loss_amount = decode(X_Gain_Loss_Amount,
764: FND_API.G_MISS_NUM, NULL,
765: NULL, gain_loss_amount,
766: X_gain_loss_amount),
767: proceeds_of_sale = decode(X_Proceeds_Of_Sale,
768: FND_API.G_MISS_NUM, NULL,

Line 768: FND_API.G_MISS_NUM, NULL,

764: FND_API.G_MISS_NUM, NULL,
765: NULL, gain_loss_amount,
766: X_gain_loss_amount),
767: proceeds_of_sale = decode(X_Proceeds_Of_Sale,
768: FND_API.G_MISS_NUM, NULL,
769: NULL, proceeds_of_sale,
770: X_proceeds_of_sale),
771: gain_loss_type_code = decode(X_Gain_Loss_Type_Code,
772: FND_API.G_MISS_CHAR, NULL,

Line 772: FND_API.G_MISS_CHAR, NULL,

768: FND_API.G_MISS_NUM, NULL,
769: NULL, proceeds_of_sale,
770: X_proceeds_of_sale),
771: gain_loss_type_code = decode(X_Gain_Loss_Type_Code,
772: FND_API.G_MISS_CHAR, NULL,
773: NULL, gain_loss_type_code,
774: X_gain_loss_type_code),
775: retirement_type_code = decode(X_Retirement_Type_Code,
776: FND_API.G_MISS_CHAR, NULL,

Line 776: FND_API.G_MISS_CHAR, NULL,

772: FND_API.G_MISS_CHAR, NULL,
773: NULL, gain_loss_type_code,
774: X_gain_loss_type_code),
775: retirement_type_code = decode(X_Retirement_Type_Code,
776: FND_API.G_MISS_CHAR, NULL,
777: NULL, retirement_type_code,
778: X_retirement_type_code),
779: itc_recaptured = decode(X_Itc_Recaptured,
780: FND_API.G_MISS_NUM, NULL,

Line 780: FND_API.G_MISS_NUM, NULL,

776: FND_API.G_MISS_CHAR, NULL,
777: NULL, retirement_type_code,
778: X_retirement_type_code),
779: itc_recaptured = decode(X_Itc_Recaptured,
780: FND_API.G_MISS_NUM, NULL,
781: NULL, itc_recaptured,
782: X_itc_recaptured),
783: itc_recapture_id = decode(X_Itc_Recapture_Id,
784: FND_API.G_MISS_NUM, NULL,

Line 784: FND_API.G_MISS_NUM, NULL,

780: FND_API.G_MISS_NUM, NULL,
781: NULL, itc_recaptured,
782: X_itc_recaptured),
783: itc_recapture_id = decode(X_Itc_Recapture_Id,
784: FND_API.G_MISS_NUM, NULL,
785: NULL, itc_recapture_id,
786: X_itc_recapture_id),
787: reference_num = decode(X_Reference_Num,
788: FND_API.G_MISS_CHAR, NULL,

Line 788: FND_API.G_MISS_CHAR, NULL,

784: FND_API.G_MISS_NUM, NULL,
785: NULL, itc_recapture_id,
786: X_itc_recapture_id),
787: reference_num = decode(X_Reference_Num,
788: FND_API.G_MISS_CHAR, NULL,
789: NULL, reference_num,
790: X_reference_num),
791: sold_to = decode(X_Sold_To,
792: FND_API.G_MISS_CHAR, NULL,

Line 792: FND_API.G_MISS_CHAR, NULL,

788: FND_API.G_MISS_CHAR, NULL,
789: NULL, reference_num,
790: X_reference_num),
791: sold_to = decode(X_Sold_To,
792: FND_API.G_MISS_CHAR, NULL,
793: NULL, sold_to,
794: X_sold_to),
795: trade_in_asset_id = decode(X_Trade_In_Asset_Id,
796: FND_API.G_MISS_NUM, NULL,

Line 796: FND_API.G_MISS_NUM, NULL,

792: FND_API.G_MISS_CHAR, NULL,
793: NULL, sold_to,
794: X_sold_to),
795: trade_in_asset_id = decode(X_Trade_In_Asset_Id,
796: FND_API.G_MISS_NUM, NULL,
797: NULL, trade_in_asset_id,
798: X_trade_in_asset_id),
799: stl_method_code = decode(X_Stl_Method_Code,
800: FND_API.G_MISS_CHAR, NULL,

Line 800: FND_API.G_MISS_CHAR, NULL,

796: FND_API.G_MISS_NUM, NULL,
797: NULL, trade_in_asset_id,
798: X_trade_in_asset_id),
799: stl_method_code = decode(X_Stl_Method_Code,
800: FND_API.G_MISS_CHAR, NULL,
801: NULL, stl_method_code,
802: X_stl_method_code),
803: stl_life_in_months = decode(X_Stl_Life_In_Months,
804: FND_API.G_MISS_NUM, NULL,

Line 804: FND_API.G_MISS_NUM, NULL,

800: FND_API.G_MISS_CHAR, NULL,
801: NULL, stl_method_code,
802: X_stl_method_code),
803: stl_life_in_months = decode(X_Stl_Life_In_Months,
804: FND_API.G_MISS_NUM, NULL,
805: NULL, stl_life_in_months,
806: X_stl_life_in_months),
807: stl_deprn_amount = decode(X_Stl_Deprn_Amount,
808: FND_API.G_MISS_NUM, NULL,

Line 808: FND_API.G_MISS_NUM, NULL,

804: FND_API.G_MISS_NUM, NULL,
805: NULL, stl_life_in_months,
806: X_stl_life_in_months),
807: stl_deprn_amount = decode(X_Stl_Deprn_Amount,
808: FND_API.G_MISS_NUM, NULL,
809: NULL, stl_deprn_amount,
810: X_stl_deprn_amount),
811: last_update_login = decode(X_Last_Update_Login,
812: FND_API.G_MISS_NUM, NULL,

Line 812: FND_API.G_MISS_NUM, NULL,

808: FND_API.G_MISS_NUM, NULL,
809: NULL, stl_deprn_amount,
810: X_stl_deprn_amount),
811: last_update_login = decode(X_Last_Update_Login,
812: FND_API.G_MISS_NUM, NULL,
813: NULL, last_update_login,
814: X_last_update_login),
815: attribute1 = decode(X_Attribute1,
816: FND_API.G_MISS_CHAR, NULL,

Line 816: FND_API.G_MISS_CHAR, NULL,

812: FND_API.G_MISS_NUM, NULL,
813: NULL, last_update_login,
814: X_last_update_login),
815: attribute1 = decode(X_Attribute1,
816: FND_API.G_MISS_CHAR, NULL,
817: NULL, attribute1,
818: X_attribute1),
819: attribute2 = decode(X_Attribute2,
820: FND_API.G_MISS_CHAR, NULL,

Line 820: FND_API.G_MISS_CHAR, NULL,

816: FND_API.G_MISS_CHAR, NULL,
817: NULL, attribute1,
818: X_attribute1),
819: attribute2 = decode(X_Attribute2,
820: FND_API.G_MISS_CHAR, NULL,
821: NULL, attribute2,
822: X_attribute2),
823: attribute3 = decode(X_Attribute3,
824: FND_API.G_MISS_CHAR, NULL,

Line 824: FND_API.G_MISS_CHAR, NULL,

820: FND_API.G_MISS_CHAR, NULL,
821: NULL, attribute2,
822: X_attribute2),
823: attribute3 = decode(X_Attribute3,
824: FND_API.G_MISS_CHAR, NULL,
825: NULL, attribute3,
826: X_attribute3),
827: attribute4 = decode(X_Attribute4,
828: FND_API.G_MISS_CHAR, NULL,

Line 828: FND_API.G_MISS_CHAR, NULL,

824: FND_API.G_MISS_CHAR, NULL,
825: NULL, attribute3,
826: X_attribute3),
827: attribute4 = decode(X_Attribute4,
828: FND_API.G_MISS_CHAR, NULL,
829: NULL, attribute4,
830: X_attribute4),
831: attribute5 = decode(X_Attribute5,
832: FND_API.G_MISS_CHAR, NULL,

Line 832: FND_API.G_MISS_CHAR, NULL,

828: FND_API.G_MISS_CHAR, NULL,
829: NULL, attribute4,
830: X_attribute4),
831: attribute5 = decode(X_Attribute5,
832: FND_API.G_MISS_CHAR, NULL,
833: NULL, attribute5,
834: X_attribute5),
835: attribute6 = decode(X_Attribute6,
836: FND_API.G_MISS_CHAR, NULL,

Line 836: FND_API.G_MISS_CHAR, NULL,

832: FND_API.G_MISS_CHAR, NULL,
833: NULL, attribute5,
834: X_attribute5),
835: attribute6 = decode(X_Attribute6,
836: FND_API.G_MISS_CHAR, NULL,
837: NULL, attribute6,
838: X_attribute6),
839: attribute7 = decode(X_Attribute7,
840: FND_API.G_MISS_CHAR, NULL,

Line 840: FND_API.G_MISS_CHAR, NULL,

836: FND_API.G_MISS_CHAR, NULL,
837: NULL, attribute6,
838: X_attribute6),
839: attribute7 = decode(X_Attribute7,
840: FND_API.G_MISS_CHAR, NULL,
841: NULL, attribute7,
842: X_attribute7),
843: attribute8 = decode(X_Attribute8,
844: FND_API.G_MISS_CHAR, NULL,

Line 844: FND_API.G_MISS_CHAR, NULL,

840: FND_API.G_MISS_CHAR, NULL,
841: NULL, attribute7,
842: X_attribute7),
843: attribute8 = decode(X_Attribute8,
844: FND_API.G_MISS_CHAR, NULL,
845: NULL, attribute8,
846: X_attribute8),
847: attribute9 = decode(X_Attribute9,
848: FND_API.G_MISS_CHAR, NULL,

Line 848: FND_API.G_MISS_CHAR, NULL,

844: FND_API.G_MISS_CHAR, NULL,
845: NULL, attribute8,
846: X_attribute8),
847: attribute9 = decode(X_Attribute9,
848: FND_API.G_MISS_CHAR, NULL,
849: NULL, attribute9,
850: X_attribute9),
851: attribute10 = decode(X_Attribute10,
852: FND_API.G_MISS_CHAR, NULL,

Line 852: FND_API.G_MISS_CHAR, NULL,

848: FND_API.G_MISS_CHAR, NULL,
849: NULL, attribute9,
850: X_attribute9),
851: attribute10 = decode(X_Attribute10,
852: FND_API.G_MISS_CHAR, NULL,
853: NULL, attribute10,
854: X_attribute10),
855: attribute11 = decode(X_Attribute11,
856: FND_API.G_MISS_CHAR, NULL,

Line 856: FND_API.G_MISS_CHAR, NULL,

852: FND_API.G_MISS_CHAR, NULL,
853: NULL, attribute10,
854: X_attribute10),
855: attribute11 = decode(X_Attribute11,
856: FND_API.G_MISS_CHAR, NULL,
857: NULL, attribute11,
858: X_attribute11),
859: attribute12 = decode(X_Attribute12,
860: FND_API.G_MISS_CHAR, NULL,

Line 860: FND_API.G_MISS_CHAR, NULL,

856: FND_API.G_MISS_CHAR, NULL,
857: NULL, attribute11,
858: X_attribute11),
859: attribute12 = decode(X_Attribute12,
860: FND_API.G_MISS_CHAR, NULL,
861: NULL, attribute12,
862: X_attribute12),
863: attribute13 = decode(X_Attribute13,
864: FND_API.G_MISS_CHAR, NULL,

Line 864: FND_API.G_MISS_CHAR, NULL,

860: FND_API.G_MISS_CHAR, NULL,
861: NULL, attribute12,
862: X_attribute12),
863: attribute13 = decode(X_Attribute13,
864: FND_API.G_MISS_CHAR, NULL,
865: NULL, attribute13,
866: X_attribute13),
867: attribute14 = decode(X_Attribute14,
868: FND_API.G_MISS_CHAR, NULL,

Line 868: FND_API.G_MISS_CHAR, NULL,

864: FND_API.G_MISS_CHAR, NULL,
865: NULL, attribute13,
866: X_attribute13),
867: attribute14 = decode(X_Attribute14,
868: FND_API.G_MISS_CHAR, NULL,
869: NULL, attribute14,
870: X_attribute14),
871: attribute15 = decode(X_Attribute15,
872: FND_API.G_MISS_CHAR, NULL,

Line 872: FND_API.G_MISS_CHAR, NULL,

868: FND_API.G_MISS_CHAR, NULL,
869: NULL, attribute14,
870: X_attribute14),
871: attribute15 = decode(X_Attribute15,
872: FND_API.G_MISS_CHAR, NULL,
873: NULL, attribute15,
874: X_attribute15),
875: attribute_category_code = decode(X_Attribute_Category_Code,
876: FND_API.G_MISS_CHAR, NULL,

Line 876: FND_API.G_MISS_CHAR, NULL,

872: FND_API.G_MISS_CHAR, NULL,
873: NULL, attribute15,
874: X_attribute15),
875: attribute_category_code = decode(X_Attribute_Category_Code,
876: FND_API.G_MISS_CHAR, NULL,
877: NULL, attribute_category_code,
878: X_attribute_category_code),
879: reval_reserve_retired = decode(X_Reval_Reserve_Retired,
880: FND_API.G_MISS_NUM, NULL,

Line 880: FND_API.G_MISS_NUM, NULL,

876: FND_API.G_MISS_CHAR, NULL,
877: NULL, attribute_category_code,
878: X_attribute_category_code),
879: reval_reserve_retired = decode(X_Reval_Reserve_Retired,
880: FND_API.G_MISS_NUM, NULL,
881: NULL, reval_reserve_retired,
882: X_reval_reserve_retired),
883: unrevalued_cost_retired = decode(X_Unrevalued_Cost_Retired,
884: FND_API.G_MISS_NUM, NULL,

Line 884: FND_API.G_MISS_NUM, NULL,

880: FND_API.G_MISS_NUM, NULL,
881: NULL, reval_reserve_retired,
882: X_reval_reserve_retired),
883: unrevalued_cost_retired = decode(X_Unrevalued_Cost_Retired,
884: FND_API.G_MISS_NUM, NULL,
885: NULL, unrevalued_cost_retired,
886: X_unrevalued_cost_retired),
887: recognize_gain_loss = decode(X_Recognize_Gain_Loss,
888: FND_API.G_MISS_CHAR, NULL,

Line 888: FND_API.G_MISS_CHAR, NULL,

884: FND_API.G_MISS_NUM, NULL,
885: NULL, unrevalued_cost_retired,
886: X_unrevalued_cost_retired),
887: recognize_gain_loss = decode(X_Recognize_Gain_Loss,
888: FND_API.G_MISS_CHAR, NULL,
889: NULL, recognize_gain_loss,
890: X_Recognize_Gain_Loss),
891: recapture_reserve_flag = decode(X_Recapture_Reserve_Flag,
892: FND_API.G_MISS_CHAR, NULL,

Line 892: FND_API.G_MISS_CHAR, NULL,

888: FND_API.G_MISS_CHAR, NULL,
889: NULL, recognize_gain_loss,
890: X_Recognize_Gain_Loss),
891: recapture_reserve_flag = decode(X_Recapture_Reserve_Flag,
892: FND_API.G_MISS_CHAR, NULL,
893: NULL, recapture_reserve_flag,
894: X_Recapture_Reserve_Flag),
895: limit_proceeds_flag = decode(X_Limit_Proceeds_Flag,
896: FND_API.G_MISS_CHAR, NULL,

Line 896: FND_API.G_MISS_CHAR, NULL,

892: FND_API.G_MISS_CHAR, NULL,
893: NULL, recapture_reserve_flag,
894: X_Recapture_Reserve_Flag),
895: limit_proceeds_flag = decode(X_Limit_Proceeds_Flag,
896: FND_API.G_MISS_CHAR, NULL,
897: NULL, limit_proceeds_flag,
898: X_Limit_Proceeds_Flag),
899: terminal_gain_loss = decode(X_Terminal_Gain_Loss,
900: FND_API.G_MISS_CHAR, NULL,

Line 900: FND_API.G_MISS_CHAR, NULL,

896: FND_API.G_MISS_CHAR, NULL,
897: NULL, limit_proceeds_flag,
898: X_Limit_Proceeds_Flag),
899: terminal_gain_loss = decode(X_Terminal_Gain_Loss,
900: FND_API.G_MISS_CHAR, NULL,
901: NULL, terminal_gain_loss,
902: X_Terminal_Gain_Loss),
903: reserve_retired = decode(X_Reserve_Retired,
904: FND_API.G_MISS_NUM, NULL,

Line 904: FND_API.G_MISS_NUM, NULL,

900: FND_API.G_MISS_CHAR, NULL,
901: NULL, terminal_gain_loss,
902: X_Terminal_Gain_Loss),
903: reserve_retired = decode(X_Reserve_Retired,
904: FND_API.G_MISS_NUM, NULL,
905: NULL, reserve_retired,
906: X_Reserve_Retired),
907: reduction_rate = decode(X_Reduction_Rate,
908: FND_API.G_MISS_NUM, NULL,

Line 908: FND_API.G_MISS_NUM, NULL,

904: FND_API.G_MISS_NUM, NULL,
905: NULL, reserve_retired,
906: X_Reserve_Retired),
907: reduction_rate = decode(X_Reduction_Rate,
908: FND_API.G_MISS_NUM, NULL,
909: NULL, reduction_rate,
910: X_Reduction_Rate),
911: eofy_reserve = decode(X_Eofy_Reserve,
912: FND_API.G_MISS_NUM, NULL,

Line 912: FND_API.G_MISS_NUM, NULL,

908: FND_API.G_MISS_NUM, NULL,
909: NULL, reduction_rate,
910: X_Reduction_Rate),
911: eofy_reserve = decode(X_Eofy_Reserve,
912: FND_API.G_MISS_NUM, NULL,
913: NULL, eofy_reserve,
914: X_Eofy_Reserve),
915: recapture_amount = decode(X_Recapture_Amount,
916: FND_API.G_MISS_NUM, NULL,

Line 916: FND_API.G_MISS_NUM, NULL,

912: FND_API.G_MISS_NUM, NULL,
913: NULL, eofy_reserve,
914: X_Eofy_Reserve),
915: recapture_amount = decode(X_Recapture_Amount,
916: FND_API.G_MISS_NUM, NULL,
917: NULL, recapture_amount,
918: X_Recapture_Amount)
919: WHERE rowid = l_rowid;
920: else

Line 934: FND_API.G_MISS_NUM, NULL,

930:
931: UPDATE fa_retirements
932: SET
933: retirement_id = decode(X_Retirement_Id,
934: FND_API.G_MISS_NUM, NULL,
935: NULL, retirement_id,
936: X_retirement_id),
937: book_type_code = decode(X_Book_Type_Code,
938: FND_API.G_MISS_CHAR, NULL,

Line 938: FND_API.G_MISS_CHAR, NULL,

934: FND_API.G_MISS_NUM, NULL,
935: NULL, retirement_id,
936: X_retirement_id),
937: book_type_code = decode(X_Book_Type_Code,
938: FND_API.G_MISS_CHAR, NULL,
939: NULL, book_type_code,
940: X_book_type_code),
941: asset_id = decode(X_Asset_Id,
942: FND_API.G_MISS_NUM, NULL,

Line 942: FND_API.G_MISS_NUM, NULL,

938: FND_API.G_MISS_CHAR, NULL,
939: NULL, book_type_code,
940: X_book_type_code),
941: asset_id = decode(X_Asset_Id,
942: FND_API.G_MISS_NUM, NULL,
943: NULL, asset_id,
944: X_asset_id),
945: transaction_header_id_in = decode(X_Transaction_Header_Id_In,
946: FND_API.G_MISS_NUM, NULL,

Line 946: FND_API.G_MISS_NUM, NULL,

942: FND_API.G_MISS_NUM, NULL,
943: NULL, asset_id,
944: X_asset_id),
945: transaction_header_id_in = decode(X_Transaction_Header_Id_In,
946: FND_API.G_MISS_NUM, NULL,
947: NULL, transaction_header_id_in,
948: X_transaction_header_id_in),
949: /* removed G_MISS_DATE comparison */
950: date_retired = decode(X_Date_Retired,

Line 958: FND_API.G_MISS_NUM, NULL,

954: date_effective = decode(X_Date_Effective,
955: NULL, date_effective,
956: X_Date_Effective),
957: cost_retired = decode(X_Cost_Retired,
958: FND_API.G_MISS_NUM, NULL,
959: NULL, cost_retired,
960: X_cost_retired),
961: status = decode(X_Status,
962: FND_API.G_MISS_CHAR, NULL,

Line 962: FND_API.G_MISS_CHAR, NULL,

958: FND_API.G_MISS_NUM, NULL,
959: NULL, cost_retired,
960: X_cost_retired),
961: status = decode(X_Status,
962: FND_API.G_MISS_CHAR, NULL,
963: NULL, status,
964: X_status),
965: /* removed G_MISS_DATE comparison */
966: last_update_date = decode(X_Last_Update_Date,

Line 970: FND_API.G_MISS_NUM, NULL,

966: last_update_date = decode(X_Last_Update_Date,
967: NULL, last_update_date,
968: X_last_update_date),
969: last_updated_by = decode(X_Last_Updated_By,
970: FND_API.G_MISS_NUM, NULL,
971: NULL, last_updated_by,
972: X_last_updated_by),
973: retirement_prorate_convention = decode(X_Ret_Prorate_Convention,
974: FND_API.G_MISS_CHAR, NULL,

Line 974: FND_API.G_MISS_CHAR, NULL,

970: FND_API.G_MISS_NUM, NULL,
971: NULL, last_updated_by,
972: X_last_updated_by),
973: retirement_prorate_convention = decode(X_Ret_Prorate_Convention,
974: FND_API.G_MISS_CHAR, NULL,
975: NULL, retirement_prorate_convention,
976: X_ret_prorate_convention),
977: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
978: FND_API.G_MISS_NUM, NULL,

Line 978: FND_API.G_MISS_NUM, NULL,

974: FND_API.G_MISS_CHAR, NULL,
975: NULL, retirement_prorate_convention,
976: X_ret_prorate_convention),
977: transaction_header_id_out = decode(X_Transaction_Header_Id_Out,
978: FND_API.G_MISS_NUM, NULL,
979: NULL, transaction_header_id_out,
980: X_transaction_header_id_out),
981: units = decode(X_Units,
982: FND_API.G_MISS_NUM, NULL,

Line 982: FND_API.G_MISS_NUM, NULL,

978: FND_API.G_MISS_NUM, NULL,
979: NULL, transaction_header_id_out,
980: X_transaction_header_id_out),
981: units = decode(X_Units,
982: FND_API.G_MISS_NUM, NULL,
983: NULL, units,
984: X_units),
985: cost_of_removal = decode(X_Cost_Of_Removal,
986: FND_API.G_MISS_NUM, NULL,

Line 986: FND_API.G_MISS_NUM, NULL,

982: FND_API.G_MISS_NUM, NULL,
983: NULL, units,
984: X_units),
985: cost_of_removal = decode(X_Cost_Of_Removal,
986: FND_API.G_MISS_NUM, NULL,
987: NULL, cost_of_removal,
988: X_cost_of_removal),
989: nbv_retired = decode(X_Nbv_Retired,
990: FND_API.G_MISS_NUM, NULL,

Line 990: FND_API.G_MISS_NUM, NULL,

986: FND_API.G_MISS_NUM, NULL,
987: NULL, cost_of_removal,
988: X_cost_of_removal),
989: nbv_retired = decode(X_Nbv_Retired,
990: FND_API.G_MISS_NUM, NULL,
991: NULL, nbv_retired,
992: X_nbv_retired),
993: gain_loss_amount = decode(X_Gain_Loss_Amount,
994: FND_API.G_MISS_NUM, NULL,

Line 994: FND_API.G_MISS_NUM, NULL,

990: FND_API.G_MISS_NUM, NULL,
991: NULL, nbv_retired,
992: X_nbv_retired),
993: gain_loss_amount = decode(X_Gain_Loss_Amount,
994: FND_API.G_MISS_NUM, NULL,
995: NULL, gain_loss_amount,
996: X_gain_loss_amount),
997: proceeds_of_sale = decode(X_Proceeds_Of_Sale,
998: FND_API.G_MISS_NUM, NULL,

Line 998: FND_API.G_MISS_NUM, NULL,

994: FND_API.G_MISS_NUM, NULL,
995: NULL, gain_loss_amount,
996: X_gain_loss_amount),
997: proceeds_of_sale = decode(X_Proceeds_Of_Sale,
998: FND_API.G_MISS_NUM, NULL,
999: NULL, proceeds_of_sale,
1000: X_proceeds_of_sale),
1001: gain_loss_type_code = decode(X_Gain_Loss_Type_Code,
1002: FND_API.G_MISS_CHAR, NULL,

Line 1002: FND_API.G_MISS_CHAR, NULL,

998: FND_API.G_MISS_NUM, NULL,
999: NULL, proceeds_of_sale,
1000: X_proceeds_of_sale),
1001: gain_loss_type_code = decode(X_Gain_Loss_Type_Code,
1002: FND_API.G_MISS_CHAR, NULL,
1003: NULL, gain_loss_type_code,
1004: X_gain_loss_type_code),
1005: retirement_type_code = decode(X_Retirement_Type_Code,
1006: FND_API.G_MISS_CHAR, NULL,

Line 1006: FND_API.G_MISS_CHAR, NULL,

1002: FND_API.G_MISS_CHAR, NULL,
1003: NULL, gain_loss_type_code,
1004: X_gain_loss_type_code),
1005: retirement_type_code = decode(X_Retirement_Type_Code,
1006: FND_API.G_MISS_CHAR, NULL,
1007: NULL, retirement_type_code,
1008: X_retirement_type_code),
1009: itc_recaptured = decode(X_Itc_Recaptured,
1010: FND_API.G_MISS_NUM, NULL,

Line 1010: FND_API.G_MISS_NUM, NULL,

1006: FND_API.G_MISS_CHAR, NULL,
1007: NULL, retirement_type_code,
1008: X_retirement_type_code),
1009: itc_recaptured = decode(X_Itc_Recaptured,
1010: FND_API.G_MISS_NUM, NULL,
1011: NULL, itc_recaptured,
1012: X_itc_recaptured),
1013: itc_recapture_id = decode(X_Itc_Recapture_Id,
1014: FND_API.G_MISS_NUM, NULL,

Line 1014: FND_API.G_MISS_NUM, NULL,

1010: FND_API.G_MISS_NUM, NULL,
1011: NULL, itc_recaptured,
1012: X_itc_recaptured),
1013: itc_recapture_id = decode(X_Itc_Recapture_Id,
1014: FND_API.G_MISS_NUM, NULL,
1015: NULL, itc_recapture_id,
1016: X_itc_recapture_id),
1017: reference_num = decode(X_Reference_Num,
1018: FND_API.G_MISS_CHAR, NULL,

Line 1018: FND_API.G_MISS_CHAR, NULL,

1014: FND_API.G_MISS_NUM, NULL,
1015: NULL, itc_recapture_id,
1016: X_itc_recapture_id),
1017: reference_num = decode(X_Reference_Num,
1018: FND_API.G_MISS_CHAR, NULL,
1019: NULL, reference_num,
1020: X_reference_num),
1021: sold_to = decode(X_Sold_To,
1022: FND_API.G_MISS_CHAR, NULL,

Line 1022: FND_API.G_MISS_CHAR, NULL,

1018: FND_API.G_MISS_CHAR, NULL,
1019: NULL, reference_num,
1020: X_reference_num),
1021: sold_to = decode(X_Sold_To,
1022: FND_API.G_MISS_CHAR, NULL,
1023: NULL, sold_to,
1024: X_sold_to),
1025: trade_in_asset_id = decode(X_Trade_In_Asset_Id,
1026: FND_API.G_MISS_NUM, NULL,

Line 1026: FND_API.G_MISS_NUM, NULL,

1022: FND_API.G_MISS_CHAR, NULL,
1023: NULL, sold_to,
1024: X_sold_to),
1025: trade_in_asset_id = decode(X_Trade_In_Asset_Id,
1026: FND_API.G_MISS_NUM, NULL,
1027: NULL, trade_in_asset_id,
1028: X_trade_in_asset_id),
1029: stl_method_code = decode(X_Stl_Method_Code,
1030: FND_API.G_MISS_CHAR, NULL,

Line 1030: FND_API.G_MISS_CHAR, NULL,

1026: FND_API.G_MISS_NUM, NULL,
1027: NULL, trade_in_asset_id,
1028: X_trade_in_asset_id),
1029: stl_method_code = decode(X_Stl_Method_Code,
1030: FND_API.G_MISS_CHAR, NULL,
1031: NULL, stl_method_code,
1032: X_stl_method_code),
1033: stl_life_in_months = decode(X_Stl_Life_In_Months,
1034: FND_API.G_MISS_NUM, NULL,

Line 1034: FND_API.G_MISS_NUM, NULL,

1030: FND_API.G_MISS_CHAR, NULL,
1031: NULL, stl_method_code,
1032: X_stl_method_code),
1033: stl_life_in_months = decode(X_Stl_Life_In_Months,
1034: FND_API.G_MISS_NUM, NULL,
1035: NULL, stl_life_in_months,
1036: X_stl_life_in_months),
1037: stl_deprn_amount = decode(X_Stl_Deprn_Amount,
1038: FND_API.G_MISS_NUM, NULL,

Line 1038: FND_API.G_MISS_NUM, NULL,

1034: FND_API.G_MISS_NUM, NULL,
1035: NULL, stl_life_in_months,
1036: X_stl_life_in_months),
1037: stl_deprn_amount = decode(X_Stl_Deprn_Amount,
1038: FND_API.G_MISS_NUM, NULL,
1039: NULL, stl_deprn_amount,
1040: X_stl_deprn_amount),
1041: last_update_login = decode(X_Last_Update_Login,
1042: FND_API.G_MISS_NUM, NULL,

Line 1042: FND_API.G_MISS_NUM, NULL,

1038: FND_API.G_MISS_NUM, NULL,
1039: NULL, stl_deprn_amount,
1040: X_stl_deprn_amount),
1041: last_update_login = decode(X_Last_Update_Login,
1042: FND_API.G_MISS_NUM, NULL,
1043: NULL, last_update_login,
1044: X_last_update_login),
1045: attribute1 = decode(X_Attribute1,
1046: FND_API.G_MISS_CHAR, NULL,

Line 1046: FND_API.G_MISS_CHAR, NULL,

1042: FND_API.G_MISS_NUM, NULL,
1043: NULL, last_update_login,
1044: X_last_update_login),
1045: attribute1 = decode(X_Attribute1,
1046: FND_API.G_MISS_CHAR, NULL,
1047: NULL, attribute1,
1048: X_attribute1),
1049: attribute2 = decode(X_Attribute2,
1050: FND_API.G_MISS_CHAR, NULL,

Line 1050: FND_API.G_MISS_CHAR, NULL,

1046: FND_API.G_MISS_CHAR, NULL,
1047: NULL, attribute1,
1048: X_attribute1),
1049: attribute2 = decode(X_Attribute2,
1050: FND_API.G_MISS_CHAR, NULL,
1051: NULL, attribute2,
1052: X_attribute2),
1053: attribute3 = decode(X_Attribute3,
1054: FND_API.G_MISS_CHAR, NULL,

Line 1054: FND_API.G_MISS_CHAR, NULL,

1050: FND_API.G_MISS_CHAR, NULL,
1051: NULL, attribute2,
1052: X_attribute2),
1053: attribute3 = decode(X_Attribute3,
1054: FND_API.G_MISS_CHAR, NULL,
1055: NULL, attribute3,
1056: X_attribute3),
1057: attribute4 = decode(X_Attribute4,
1058: FND_API.G_MISS_CHAR, NULL,

Line 1058: FND_API.G_MISS_CHAR, NULL,

1054: FND_API.G_MISS_CHAR, NULL,
1055: NULL, attribute3,
1056: X_attribute3),
1057: attribute4 = decode(X_Attribute4,
1058: FND_API.G_MISS_CHAR, NULL,
1059: NULL, attribute4,
1060: X_attribute4),
1061: attribute5 = decode(X_Attribute5,
1062: FND_API.G_MISS_CHAR, NULL,

Line 1062: FND_API.G_MISS_CHAR, NULL,

1058: FND_API.G_MISS_CHAR, NULL,
1059: NULL, attribute4,
1060: X_attribute4),
1061: attribute5 = decode(X_Attribute5,
1062: FND_API.G_MISS_CHAR, NULL,
1063: NULL, attribute5,
1064: X_attribute5),
1065: attribute6 = decode(X_Attribute6,
1066: FND_API.G_MISS_CHAR, NULL,

Line 1066: FND_API.G_MISS_CHAR, NULL,

1062: FND_API.G_MISS_CHAR, NULL,
1063: NULL, attribute5,
1064: X_attribute5),
1065: attribute6 = decode(X_Attribute6,
1066: FND_API.G_MISS_CHAR, NULL,
1067: NULL, attribute6,
1068: X_attribute6),
1069: attribute7 = decode(X_Attribute7,
1070: FND_API.G_MISS_CHAR, NULL,

Line 1070: FND_API.G_MISS_CHAR, NULL,

1066: FND_API.G_MISS_CHAR, NULL,
1067: NULL, attribute6,
1068: X_attribute6),
1069: attribute7 = decode(X_Attribute7,
1070: FND_API.G_MISS_CHAR, NULL,
1071: NULL, attribute7,
1072: X_attribute7),
1073: attribute8 = decode(X_Attribute8,
1074: FND_API.G_MISS_CHAR, NULL,

Line 1074: FND_API.G_MISS_CHAR, NULL,

1070: FND_API.G_MISS_CHAR, NULL,
1071: NULL, attribute7,
1072: X_attribute7),
1073: attribute8 = decode(X_Attribute8,
1074: FND_API.G_MISS_CHAR, NULL,
1075: NULL, attribute8,
1076: X_attribute8),
1077: attribute9 = decode(X_Attribute9,
1078: FND_API.G_MISS_CHAR, NULL,

Line 1078: FND_API.G_MISS_CHAR, NULL,

1074: FND_API.G_MISS_CHAR, NULL,
1075: NULL, attribute8,
1076: X_attribute8),
1077: attribute9 = decode(X_Attribute9,
1078: FND_API.G_MISS_CHAR, NULL,
1079: NULL, attribute9,
1080: X_attribute9),
1081: attribute10 = decode(X_Attribute10,
1082: FND_API.G_MISS_CHAR, NULL,

Line 1082: FND_API.G_MISS_CHAR, NULL,

1078: FND_API.G_MISS_CHAR, NULL,
1079: NULL, attribute9,
1080: X_attribute9),
1081: attribute10 = decode(X_Attribute10,
1082: FND_API.G_MISS_CHAR, NULL,
1083: NULL, attribute10,
1084: X_attribute10),
1085: attribute11 = decode(X_Attribute11,
1086: FND_API.G_MISS_CHAR, NULL,

Line 1086: FND_API.G_MISS_CHAR, NULL,

1082: FND_API.G_MISS_CHAR, NULL,
1083: NULL, attribute10,
1084: X_attribute10),
1085: attribute11 = decode(X_Attribute11,
1086: FND_API.G_MISS_CHAR, NULL,
1087: NULL, attribute11,
1088: X_attribute11),
1089: attribute12 = decode(X_Attribute12,
1090: FND_API.G_MISS_CHAR, NULL,

Line 1090: FND_API.G_MISS_CHAR, NULL,

1086: FND_API.G_MISS_CHAR, NULL,
1087: NULL, attribute11,
1088: X_attribute11),
1089: attribute12 = decode(X_Attribute12,
1090: FND_API.G_MISS_CHAR, NULL,
1091: NULL, attribute12,
1092: X_attribute12),
1093: attribute13 = decode(X_Attribute13,
1094: FND_API.G_MISS_CHAR, NULL,

Line 1094: FND_API.G_MISS_CHAR, NULL,

1090: FND_API.G_MISS_CHAR, NULL,
1091: NULL, attribute12,
1092: X_attribute12),
1093: attribute13 = decode(X_Attribute13,
1094: FND_API.G_MISS_CHAR, NULL,
1095: NULL, attribute13,
1096: X_attribute13),
1097: attribute14 = decode(X_Attribute14,
1098: FND_API.G_MISS_CHAR, NULL,

Line 1098: FND_API.G_MISS_CHAR, NULL,

1094: FND_API.G_MISS_CHAR, NULL,
1095: NULL, attribute13,
1096: X_attribute13),
1097: attribute14 = decode(X_Attribute14,
1098: FND_API.G_MISS_CHAR, NULL,
1099: NULL, attribute14,
1100: X_attribute14),
1101: attribute15 = decode(X_Attribute15,
1102: FND_API.G_MISS_CHAR, NULL,

Line 1102: FND_API.G_MISS_CHAR, NULL,

1098: FND_API.G_MISS_CHAR, NULL,
1099: NULL, attribute14,
1100: X_attribute14),
1101: attribute15 = decode(X_Attribute15,
1102: FND_API.G_MISS_CHAR, NULL,
1103: NULL, attribute15,
1104: X_attribute15),
1105: attribute_category_code = decode(X_Attribute_Category_Code,
1106: FND_API.G_MISS_CHAR, NULL,

Line 1106: FND_API.G_MISS_CHAR, NULL,

1102: FND_API.G_MISS_CHAR, NULL,
1103: NULL, attribute15,
1104: X_attribute15),
1105: attribute_category_code = decode(X_Attribute_Category_Code,
1106: FND_API.G_MISS_CHAR, NULL,
1107: NULL, attribute_category_code,
1108: X_attribute_category_code),
1109: reval_reserve_retired = decode(X_Reval_Reserve_Retired,
1110: FND_API.G_MISS_NUM, NULL,

Line 1110: FND_API.G_MISS_NUM, NULL,

1106: FND_API.G_MISS_CHAR, NULL,
1107: NULL, attribute_category_code,
1108: X_attribute_category_code),
1109: reval_reserve_retired = decode(X_Reval_Reserve_Retired,
1110: FND_API.G_MISS_NUM, NULL,
1111: NULL, reval_reserve_retired,
1112: X_reval_reserve_retired),
1113: unrevalued_cost_retired = decode(X_Unrevalued_Cost_Retired,
1114: FND_API.G_MISS_NUM, NULL,

Line 1114: FND_API.G_MISS_NUM, NULL,

1110: FND_API.G_MISS_NUM, NULL,
1111: NULL, reval_reserve_retired,
1112: X_reval_reserve_retired),
1113: unrevalued_cost_retired = decode(X_Unrevalued_Cost_Retired,
1114: FND_API.G_MISS_NUM, NULL,
1115: NULL, unrevalued_cost_retired,
1116: X_unrevalued_cost_retired),
1117: recognize_gain_loss = decode(X_Recognize_Gain_Loss,
1118: FND_API.G_MISS_CHAR, NULL,

Line 1118: FND_API.G_MISS_CHAR, NULL,

1114: FND_API.G_MISS_NUM, NULL,
1115: NULL, unrevalued_cost_retired,
1116: X_unrevalued_cost_retired),
1117: recognize_gain_loss = decode(X_Recognize_Gain_Loss,
1118: FND_API.G_MISS_CHAR, NULL,
1119: NULL, recognize_gain_loss,
1120: X_Recognize_Gain_Loss),
1121: recapture_reserve_flag = decode(X_Recapture_Reserve_Flag,
1122: FND_API.G_MISS_CHAR, NULL,

Line 1122: FND_API.G_MISS_CHAR, NULL,

1118: FND_API.G_MISS_CHAR, NULL,
1119: NULL, recognize_gain_loss,
1120: X_Recognize_Gain_Loss),
1121: recapture_reserve_flag = decode(X_Recapture_Reserve_Flag,
1122: FND_API.G_MISS_CHAR, NULL,
1123: NULL, recapture_reserve_flag,
1124: X_Recapture_Reserve_Flag),
1125: limit_proceeds_flag = decode(X_Limit_Proceeds_Flag,
1126: FND_API.G_MISS_CHAR, NULL,

Line 1126: FND_API.G_MISS_CHAR, NULL,

1122: FND_API.G_MISS_CHAR, NULL,
1123: NULL, recapture_reserve_flag,
1124: X_Recapture_Reserve_Flag),
1125: limit_proceeds_flag = decode(X_Limit_Proceeds_Flag,
1126: FND_API.G_MISS_CHAR, NULL,
1127: NULL, limit_proceeds_flag,
1128: X_Limit_Proceeds_Flag),
1129: terminal_gain_loss = decode(X_Terminal_Gain_Loss,
1130: FND_API.G_MISS_CHAR, NULL,

Line 1130: FND_API.G_MISS_CHAR, NULL,

1126: FND_API.G_MISS_CHAR, NULL,
1127: NULL, limit_proceeds_flag,
1128: X_Limit_Proceeds_Flag),
1129: terminal_gain_loss = decode(X_Terminal_Gain_Loss,
1130: FND_API.G_MISS_CHAR, NULL,
1131: NULL, terminal_gain_loss,
1132: X_Terminal_Gain_Loss),
1133: reserve_retired = decode(X_Reserve_Retired,
1134: FND_API.G_MISS_NUM, NULL,

Line 1134: FND_API.G_MISS_NUM, NULL,

1130: FND_API.G_MISS_CHAR, NULL,
1131: NULL, terminal_gain_loss,
1132: X_Terminal_Gain_Loss),
1133: reserve_retired = decode(X_Reserve_Retired,
1134: FND_API.G_MISS_NUM, NULL,
1135: NULL, reserve_retired,
1136: X_Reserve_Retired),
1137: reduction_rate = decode(X_Reduction_Rate,
1138: FND_API.G_MISS_NUM, NULL,

Line 1138: FND_API.G_MISS_NUM, NULL,

1134: FND_API.G_MISS_NUM, NULL,
1135: NULL, reserve_retired,
1136: X_Reserve_Retired),
1137: reduction_rate = decode(X_Reduction_Rate,
1138: FND_API.G_MISS_NUM, NULL,
1139: NULL, reduction_rate,
1140: X_Reduction_Rate),
1141: eofy_reserve = decode(X_Eofy_Reserve,
1142: FND_API.G_MISS_NUM, NULL,

Line 1142: FND_API.G_MISS_NUM, NULL,

1138: FND_API.G_MISS_NUM, NULL,
1139: NULL, reduction_rate,
1140: X_Reduction_Rate),
1141: eofy_reserve = decode(X_Eofy_Reserve,
1142: FND_API.G_MISS_NUM, NULL,
1143: NULL, eofy_reserve,
1144: X_Eofy_Reserve),
1145: recapture_amount = decode(X_Recapture_Amount,
1146: FND_API.G_MISS_NUM, NULL,

Line 1146: FND_API.G_MISS_NUM, NULL,

1142: FND_API.G_MISS_NUM, NULL,
1143: NULL, eofy_reserve,
1144: X_Eofy_Reserve),
1145: recapture_amount = decode(X_Recapture_Amount,
1146: FND_API.G_MISS_NUM, NULL,
1147: NULL, recapture_amount,
1148: X_Recapture_Amount)
1149: WHERE rowid = l_rowid;
1150: end if;