744:
745: UPDATE fa_asset_invoices_mrc_v
746: SET
747: asset_id = decode(X_Asset_Id,
748: FND_API.G_MISS_NUM, NULL,
749: NULL, asset_id,
750: X_asset_id),
751: po_vendor_id = decode(X_Po_Vendor_Id,
752: FND_API.G_MISS_NUM, NULL,
748: FND_API.G_MISS_NUM, NULL,
749: NULL, asset_id,
750: X_asset_id),
751: po_vendor_id = decode(X_Po_Vendor_Id,
752: FND_API.G_MISS_NUM, NULL,
753: NULL, po_vendor_id,
754: X_po_vendor_id),
755: asset_invoice_id = decode(X_Asset_Invoice_Id,
756: FND_API.G_MISS_NUM, NULL,
752: FND_API.G_MISS_NUM, NULL,
753: NULL, po_vendor_id,
754: X_po_vendor_id),
755: asset_invoice_id = decode(X_Asset_Invoice_Id,
756: FND_API.G_MISS_NUM, NULL,
757: NULL, asset_invoice_id,
758: X_asset_invoice_id),
759: fixed_assets_cost = decode(X_Fixed_Assets_Cost,
760: FND_API.G_MISS_NUM, NULL,
756: FND_API.G_MISS_NUM, NULL,
757: NULL, asset_invoice_id,
758: X_asset_invoice_id),
759: fixed_assets_cost = decode(X_Fixed_Assets_Cost,
760: FND_API.G_MISS_NUM, NULL,
761: NULL, fixed_assets_cost,
762: X_fixed_assets_cost),
763: date_effective = decode(X_Date_Effective,
764: NULL, date_effective,
767: NULL, date_ineffective,
768: X_date_ineffective),
769: invoice_transaction_id_in
770: = decode(X_Invoice_Transaction_Id_In,
771: FND_API.G_MISS_NUM, NULL,
772: NULL, invoice_transaction_id_in,
773: X_invoice_transaction_id_in),
774: invoice_transaction_id_out
775: = decode(X_Invoice_Transaction_Id_Out,
772: NULL, invoice_transaction_id_in,
773: X_invoice_transaction_id_in),
774: invoice_transaction_id_out
775: = decode(X_Invoice_Transaction_Id_Out,
776: FND_API.G_MISS_NUM, NULL,
777: NULL, invoice_transaction_id_out,
778: X_invoice_transaction_id_out),
779: deleted_flag = decode(X_Deleted_Flag,
780: FND_API.G_MISS_CHAR, NULL,
776: FND_API.G_MISS_NUM, NULL,
777: NULL, invoice_transaction_id_out,
778: X_invoice_transaction_id_out),
779: deleted_flag = decode(X_Deleted_Flag,
780: FND_API.G_MISS_CHAR, NULL,
781: NULL, deleted_flag,
782: X_deleted_flag),
783: po_number = decode(X_Po_Number,
784: FND_API.G_MISS_CHAR, NULL,
780: FND_API.G_MISS_CHAR, NULL,
781: NULL, deleted_flag,
782: X_deleted_flag),
783: po_number = decode(X_Po_Number,
784: FND_API.G_MISS_CHAR, NULL,
785: NULL, po_number,
786: X_po_number),
787: invoice_number = decode(X_Invoice_Number,
788: FND_API.G_MISS_CHAR, NULL,
784: FND_API.G_MISS_CHAR, NULL,
785: NULL, po_number,
786: X_po_number),
787: invoice_number = decode(X_Invoice_Number,
788: FND_API.G_MISS_CHAR, NULL,
789: NULL, invoice_number,
790: X_invoice_number),
791: payables_batch_name = decode(X_Payables_Batch_Name,
792: FND_API.G_MISS_CHAR, NULL,
788: FND_API.G_MISS_CHAR, NULL,
789: NULL, invoice_number,
790: X_invoice_number),
791: payables_batch_name = decode(X_Payables_Batch_Name,
792: FND_API.G_MISS_CHAR, NULL,
793: NULL, payables_batch_name,
794: X_payables_batch_name),
795: payables_code_combination_id
796: = decode(X_Payables_Code_Combination_Id,
793: NULL, payables_batch_name,
794: X_payables_batch_name),
795: payables_code_combination_id
796: = decode(X_Payables_Code_Combination_Id,
797: FND_API.G_MISS_NUM, NULL,
798: NULL,
799: payables_code_combination_id,
800: X_payables_code_combination_id),
801: feeder_system_name = decode(X_Feeder_System_Name,
798: NULL,
799: payables_code_combination_id,
800: X_payables_code_combination_id),
801: feeder_system_name = decode(X_Feeder_System_Name,
802: FND_API.G_MISS_CHAR, NULL,
803: NULL, feeder_system_name,
804: X_feeder_system_name),
805: create_batch_date = decode(X_Create_Batch_Date,
806: NULL, create_batch_date,
805: create_batch_date = decode(X_Create_Batch_Date,
806: NULL, create_batch_date,
807: X_create_batch_date),
808: create_batch_id = decode(X_Create_Batch_Id,
809: FND_API.G_MISS_NUM, NULL,
810: NULL, create_batch_id,
811: X_create_batch_id),
812: invoice_date = decode(X_Invoice_Date,
813: NULL, invoice_date,
812: invoice_date = decode(X_Invoice_Date,
813: NULL, invoice_date,
814: X_invoice_date),
815: payables_cost = decode(X_Payables_Cost,
816: FND_API.G_MISS_NUM, NULL,
817: NULL, payables_cost,
818: X_payables_cost),
819: post_batch_id = decode(X_Post_Batch_Id,
820: FND_API.G_MISS_NUM, NULL,
816: FND_API.G_MISS_NUM, NULL,
817: NULL, payables_cost,
818: X_payables_cost),
819: post_batch_id = decode(X_Post_Batch_Id,
820: FND_API.G_MISS_NUM, NULL,
821: NULL, post_batch_id,
822: X_post_batch_id),
823: invoice_id = decode(X_Invoice_Id,
824: FND_API.G_MISS_NUM, NULL,
820: FND_API.G_MISS_NUM, NULL,
821: NULL, post_batch_id,
822: X_post_batch_id),
823: invoice_id = decode(X_Invoice_Id,
824: FND_API.G_MISS_NUM, NULL,
825: NULL, invoice_id,
826: X_invoice_id),
827: ap_distribution_line_number
828: = decode(X_Ap_Distribution_Line_Number,
825: NULL, invoice_id,
826: X_invoice_id),
827: ap_distribution_line_number
828: = decode(X_Ap_Distribution_Line_Number,
829: FND_API.G_MISS_NUM, NULL,
830: NULL, ap_distribution_line_number,
831: X_ap_distribution_line_number),
832: payables_units = decode(X_Payables_Units,
833: FND_API.G_MISS_NUM, NULL,
829: FND_API.G_MISS_NUM, NULL,
830: NULL, ap_distribution_line_number,
831: X_ap_distribution_line_number),
832: payables_units = decode(X_Payables_Units,
833: FND_API.G_MISS_NUM, NULL,
834: NULL, payables_units,
835: X_payables_units),
836: split_merged_code = decode(X_Split_Merged_Code,
837: FND_API.G_MISS_CHAR, NULL,
833: FND_API.G_MISS_NUM, NULL,
834: NULL, payables_units,
835: X_payables_units),
836: split_merged_code = decode(X_Split_Merged_Code,
837: FND_API.G_MISS_CHAR, NULL,
838: NULL, split_merged_code,
839: X_split_merged_code),
840: description = decode(X_Description,
841: FND_API.G_MISS_CHAR, NULL,
837: FND_API.G_MISS_CHAR, NULL,
838: NULL, split_merged_code,
839: X_split_merged_code),
840: description = decode(X_Description,
841: FND_API.G_MISS_CHAR, NULL,
842: NULL, description,
843: X_description),
844: parent_mass_addition_id = decode(X_Parent_Mass_Addition_Id,
845: FND_API.G_MISS_CHAR, NULL,
841: FND_API.G_MISS_CHAR, NULL,
842: NULL, description,
843: X_description),
844: parent_mass_addition_id = decode(X_Parent_Mass_Addition_Id,
845: FND_API.G_MISS_CHAR, NULL,
846: NULL, parent_mass_addition_id,
847: X_parent_mass_addition_id),
848: last_update_date = decode(X_Last_Update_Date,
849: NULL, last_update_date,
848: last_update_date = decode(X_Last_Update_Date,
849: NULL, last_update_date,
850: X_last_update_date),
851: last_updated_by = decode(X_Last_Updated_By,
852: FND_API.G_MISS_NUM, NULL,
853: NULL, last_updated_by,
854: X_last_updated_by),
855: last_update_login = decode(X_Last_Update_Login,
856: FND_API.G_MISS_NUM, NULL,
852: FND_API.G_MISS_NUM, NULL,
853: NULL, last_updated_by,
854: X_last_updated_by),
855: last_update_login = decode(X_Last_Update_Login,
856: FND_API.G_MISS_NUM, NULL,
857: NULL, last_update_login,
858: X_last_update_login),
859: attribute1 = decode(X_Attribute1,
860: FND_API.G_MISS_CHAR, NULL,
856: FND_API.G_MISS_NUM, NULL,
857: NULL, last_update_login,
858: X_last_update_login),
859: attribute1 = decode(X_Attribute1,
860: FND_API.G_MISS_CHAR, NULL,
861: NULL, attribute1,
862: X_attribute1),
863: attribute2 = decode(X_Attribute2,
864: FND_API.G_MISS_CHAR, NULL,
860: FND_API.G_MISS_CHAR, NULL,
861: NULL, attribute1,
862: X_attribute1),
863: attribute2 = decode(X_Attribute2,
864: FND_API.G_MISS_CHAR, NULL,
865: NULL, attribute2,
866: X_attribute2),
867: attribute3 = decode(X_Attribute3,
868: FND_API.G_MISS_CHAR, NULL,
864: FND_API.G_MISS_CHAR, NULL,
865: NULL, attribute2,
866: X_attribute2),
867: attribute3 = decode(X_Attribute3,
868: FND_API.G_MISS_CHAR, NULL,
869: NULL, attribute3,
870: X_attribute3),
871: attribute4 = decode(X_Attribute4,
872: FND_API.G_MISS_CHAR, NULL,
868: FND_API.G_MISS_CHAR, NULL,
869: NULL, attribute3,
870: X_attribute3),
871: attribute4 = decode(X_Attribute4,
872: FND_API.G_MISS_CHAR, NULL,
873: NULL, attribute4,
874: X_attribute4),
875: attribute5 = decode(X_Attribute5,
876: FND_API.G_MISS_CHAR, NULL,
872: FND_API.G_MISS_CHAR, NULL,
873: NULL, attribute4,
874: X_attribute4),
875: attribute5 = decode(X_Attribute5,
876: FND_API.G_MISS_CHAR, NULL,
877: NULL, attribute5,
878: X_attribute5),
879: attribute6 = decode(X_Attribute6,
880: FND_API.G_MISS_CHAR, NULL,
876: FND_API.G_MISS_CHAR, NULL,
877: NULL, attribute5,
878: X_attribute5),
879: attribute6 = decode(X_Attribute6,
880: FND_API.G_MISS_CHAR, NULL,
881: NULL, attribute6,
882: X_attribute6),
883: attribute7 = decode(X_Attribute7,
884: FND_API.G_MISS_CHAR, NULL,
880: FND_API.G_MISS_CHAR, NULL,
881: NULL, attribute6,
882: X_attribute6),
883: attribute7 = decode(X_Attribute7,
884: FND_API.G_MISS_CHAR, NULL,
885: NULL, attribute7,
886: X_attribute7),
887: attribute8 = decode(X_Attribute8,
888: FND_API.G_MISS_CHAR, NULL,
884: FND_API.G_MISS_CHAR, NULL,
885: NULL, attribute7,
886: X_attribute7),
887: attribute8 = decode(X_Attribute8,
888: FND_API.G_MISS_CHAR, NULL,
889: NULL, attribute8,
890: X_attribute8),
891: attribute9 = decode(X_Attribute9,
892: FND_API.G_MISS_CHAR, NULL,
888: FND_API.G_MISS_CHAR, NULL,
889: NULL, attribute8,
890: X_attribute8),
891: attribute9 = decode(X_Attribute9,
892: FND_API.G_MISS_CHAR, NULL,
893: NULL, attribute9,
894: X_attribute9),
895: attribute10 = decode(X_Attribute10,
896: FND_API.G_MISS_CHAR, NULL,
892: FND_API.G_MISS_CHAR, NULL,
893: NULL, attribute9,
894: X_attribute9),
895: attribute10 = decode(X_Attribute10,
896: FND_API.G_MISS_CHAR, NULL,
897: NULL, attribute10,
898: X_attribute10),
899: attribute11 = decode(X_Attribute11,
900: FND_API.G_MISS_CHAR, NULL,
896: FND_API.G_MISS_CHAR, NULL,
897: NULL, attribute10,
898: X_attribute10),
899: attribute11 = decode(X_Attribute11,
900: FND_API.G_MISS_CHAR, NULL,
901: NULL, attribute11,
902: X_attribute11),
903: attribute12 = decode(X_Attribute12,
904: FND_API.G_MISS_CHAR, NULL,
900: FND_API.G_MISS_CHAR, NULL,
901: NULL, attribute11,
902: X_attribute11),
903: attribute12 = decode(X_Attribute12,
904: FND_API.G_MISS_CHAR, NULL,
905: NULL, attribute12,
906: X_attribute12),
907: attribute13 = decode(X_Attribute13,
908: FND_API.G_MISS_CHAR, NULL,
904: FND_API.G_MISS_CHAR, NULL,
905: NULL, attribute12,
906: X_attribute12),
907: attribute13 = decode(X_Attribute13,
908: FND_API.G_MISS_CHAR, NULL,
909: NULL, attribute13,
910: X_attribute13),
911: attribute14 = decode(X_Attribute14,
912: FND_API.G_MISS_CHAR, NULL,
908: FND_API.G_MISS_CHAR, NULL,
909: NULL, attribute13,
910: X_attribute13),
911: attribute14 = decode(X_Attribute14,
912: FND_API.G_MISS_CHAR, NULL,
913: NULL, attribute14,
914: X_attribute14),
915: attribute15 = decode(X_attribute15,
916: FND_API.G_MISS_CHAR, NULL,
912: FND_API.G_MISS_CHAR, NULL,
913: NULL, attribute14,
914: X_attribute14),
915: attribute15 = decode(X_attribute15,
916: FND_API.G_MISS_CHAR, NULL,
917: NULL, attribute15,
918: X_attribute15),
919: attribute_category_code = decode(X_Attribute_Category_Code,
920: FND_API.G_MISS_CHAR, NULL,
916: FND_API.G_MISS_CHAR, NULL,
917: NULL, attribute15,
918: X_attribute15),
919: attribute_category_code = decode(X_Attribute_Category_Code,
920: FND_API.G_MISS_CHAR, NULL,
921: NULL, attribute_category_code,
922: X_attribute_category_code),
923: unrevalued_cost = decode(X_Unrevalued_Cost,
924: FND_API.G_MISS_NUM, NULL,
920: FND_API.G_MISS_CHAR, NULL,
921: NULL, attribute_category_code,
922: X_attribute_category_code),
923: unrevalued_cost = decode(X_Unrevalued_Cost,
924: FND_API.G_MISS_NUM, NULL,
925: NULL, unrevalued_cost,
926: X_unrevalued_cost),
927: merged_code = decode(X_Merged_Code,
928: FND_API.G_MISS_CHAR, NULL,
924: FND_API.G_MISS_NUM, NULL,
925: NULL, unrevalued_cost,
926: X_unrevalued_cost),
927: merged_code = decode(X_Merged_Code,
928: FND_API.G_MISS_CHAR, NULL,
929: NULL, merged_code,
930: X_merged_code),
931: split_code = decode(X_Split_Code,
932: FND_API.G_MISS_CHAR, NULL,
928: FND_API.G_MISS_CHAR, NULL,
929: NULL, merged_code,
930: X_merged_code),
931: split_code = decode(X_Split_Code,
932: FND_API.G_MISS_CHAR, NULL,
933: NULL, split_code,
934: X_split_code),
935: merge_parent_mass_additions_id
936: = decode(X_Merge_Parent_Mass_Add_Id,
933: NULL, split_code,
934: X_split_code),
935: merge_parent_mass_additions_id
936: = decode(X_Merge_Parent_Mass_Add_Id,
937: FND_API.G_MISS_NUM, NULL,
938: NULL,
939: merge_parent_mass_additions_id,
940: X_merge_parent_mass_add_id),
941: split_parent_mass_additions_id
939: merge_parent_mass_additions_id,
940: X_merge_parent_mass_add_id),
941: split_parent_mass_additions_id
942: = decode(X_Split_Parent_Mass_Add_Id,
943: FND_API.G_MISS_NUM, NULL,
944: NULL,
945: split_parent_mass_additions_id,
946: X_split_parent_mass_add_id),
947: project_asset_line_id = decode(X_Project_Asset_Line_Id,
944: NULL,
945: split_parent_mass_additions_id,
946: X_split_parent_mass_add_id),
947: project_asset_line_id = decode(X_Project_Asset_Line_Id,
948: FND_API.G_MISS_NUM, NULL,
949: NULL, project_asset_line_id,
950: X_project_asset_line_id),
951: project_id = decode(X_Project_Id,
952: FND_API.G_MISS_NUM, NULL,
948: FND_API.G_MISS_NUM, NULL,
949: NULL, project_asset_line_id,
950: X_project_asset_line_id),
951: project_id = decode(X_Project_Id,
952: FND_API.G_MISS_NUM, NULL,
953: NULL, project_id,
954: X_project_id),
955: task_id = decode(X_Task_Id,
956: FND_API.G_MISS_NUM, NULL,
952: FND_API.G_MISS_NUM, NULL,
953: NULL, project_id,
954: X_project_id),
955: task_id = decode(X_Task_Id,
956: FND_API.G_MISS_NUM, NULL,
957: NULL, task_id,
958: X_task_id),
959: exchange_rate = decode(X_Exchange_Rate,
960: FND_API.G_MISS_NUM, NULL,
956: FND_API.G_MISS_NUM, NULL,
957: NULL, task_id,
958: X_task_id),
959: exchange_rate = decode(X_Exchange_Rate,
960: FND_API.G_MISS_NUM, NULL,
961: NULL, exchange_rate,
962: X_exchange_rate),
963: depreciate_in_group_flag = decode(X_depreciate_in_group_flag,
964: FND_API.G_MISS_CHAR, NULL,
960: FND_API.G_MISS_NUM, NULL,
961: NULL, exchange_rate,
962: X_exchange_rate),
963: depreciate_in_group_flag = decode(X_depreciate_in_group_flag,
964: FND_API.G_MISS_CHAR, NULL,
965: NULL, depreciate_in_group_flag,
966: X_depreciate_in_group_flag),
967: material_indicator_flag = decode(X_material_indicator_flag,
968: FND_API.G_MISS_CHAR, NULL,
964: FND_API.G_MISS_CHAR, NULL,
965: NULL, depreciate_in_group_flag,
966: X_depreciate_in_group_flag),
967: material_indicator_flag = decode(X_material_indicator_flag,
968: FND_API.G_MISS_CHAR, NULL,
969: NULL, material_indicator_flag,
970: X_material_indicator_flag),
971: invoice_distribution_id = decode(X_invoice_distribution_id,
972: FND_API.G_MISS_NUM, NULL,
968: FND_API.G_MISS_CHAR, NULL,
969: NULL, material_indicator_flag,
970: X_material_indicator_flag),
971: invoice_distribution_id = decode(X_invoice_distribution_id,
972: FND_API.G_MISS_NUM, NULL,
973: NULL, invoice_distribution_id,
974: X_invoice_distribution_id),
975: invoice_line_number = decode(X_invoice_line_number,
976: FND_API.G_MISS_NUM, NULL,
972: FND_API.G_MISS_NUM, NULL,
973: NULL, invoice_distribution_id,
974: X_invoice_distribution_id),
975: invoice_line_number = decode(X_invoice_line_number,
976: FND_API.G_MISS_NUM, NULL,
977: NULL, invoice_line_number,
978: X_invoice_line_number),
979: po_distribution_id = decode(X_po_distribution_id,
980: FND_API.G_MISS_NUM, NULL,
976: FND_API.G_MISS_NUM, NULL,
977: NULL, invoice_line_number,
978: X_invoice_line_number),
979: po_distribution_id = decode(X_po_distribution_id,
980: FND_API.G_MISS_NUM, NULL,
981: NULL, po_distribution_id,
982: X_po_distribution_id)
983: WHERE rowid = l_rowid;
984:
998: end if;
999:
1000: UPDATE fa_asset_invoices
1001: SET asset_id = decode(X_Asset_Id,
1002: FND_API.G_MISS_NUM, NULL,
1003: NULL, asset_id,
1004: X_asset_id),
1005: po_vendor_id = decode(X_Po_Vendor_Id,
1006: FND_API.G_MISS_NUM, NULL,
1002: FND_API.G_MISS_NUM, NULL,
1003: NULL, asset_id,
1004: X_asset_id),
1005: po_vendor_id = decode(X_Po_Vendor_Id,
1006: FND_API.G_MISS_NUM, NULL,
1007: NULL, po_vendor_id,
1008: X_po_vendor_id),
1009: asset_invoice_id = decode(X_Asset_Invoice_Id,
1010: FND_API.G_MISS_NUM, NULL,
1006: FND_API.G_MISS_NUM, NULL,
1007: NULL, po_vendor_id,
1008: X_po_vendor_id),
1009: asset_invoice_id = decode(X_Asset_Invoice_Id,
1010: FND_API.G_MISS_NUM, NULL,
1011: NULL, asset_invoice_id,
1012: X_asset_invoice_id),
1013: fixed_assets_cost = decode(X_Fixed_Assets_Cost,
1014: FND_API.G_MISS_NUM, NULL,
1010: FND_API.G_MISS_NUM, NULL,
1011: NULL, asset_invoice_id,
1012: X_asset_invoice_id),
1013: fixed_assets_cost = decode(X_Fixed_Assets_Cost,
1014: FND_API.G_MISS_NUM, NULL,
1015: NULL, fixed_assets_cost,
1016: X_fixed_assets_cost),
1017: date_effective = decode(X_Date_Effective,
1018: NULL, date_effective,
1021: NULL, date_ineffective,
1022: X_date_ineffective),
1023: invoice_transaction_id_in
1024: = decode(X_Invoice_Transaction_Id_In,
1025: FND_API.G_MISS_NUM, NULL,
1026: NULL, invoice_transaction_id_in,
1027: X_invoice_transaction_id_in),
1028: invoice_transaction_id_out
1029: = decode(X_Invoice_Transaction_Id_Out,
1026: NULL, invoice_transaction_id_in,
1027: X_invoice_transaction_id_in),
1028: invoice_transaction_id_out
1029: = decode(X_Invoice_Transaction_Id_Out,
1030: FND_API.G_MISS_NUM, NULL,
1031: NULL, invoice_transaction_id_out,
1032: X_invoice_transaction_id_out),
1033: deleted_flag = decode(X_Deleted_Flag,
1034: FND_API.G_MISS_CHAR, NULL,
1030: FND_API.G_MISS_NUM, NULL,
1031: NULL, invoice_transaction_id_out,
1032: X_invoice_transaction_id_out),
1033: deleted_flag = decode(X_Deleted_Flag,
1034: FND_API.G_MISS_CHAR, NULL,
1035: NULL, deleted_flag,
1036: X_deleted_flag),
1037: po_number = decode(X_Po_Number,
1038: FND_API.G_MISS_CHAR, NULL,
1034: FND_API.G_MISS_CHAR, NULL,
1035: NULL, deleted_flag,
1036: X_deleted_flag),
1037: po_number = decode(X_Po_Number,
1038: FND_API.G_MISS_CHAR, NULL,
1039: NULL, po_number,
1040: X_po_number),
1041: invoice_number = decode(X_Invoice_Number,
1042: FND_API.G_MISS_CHAR, NULL,
1038: FND_API.G_MISS_CHAR, NULL,
1039: NULL, po_number,
1040: X_po_number),
1041: invoice_number = decode(X_Invoice_Number,
1042: FND_API.G_MISS_CHAR, NULL,
1043: NULL, invoice_number,
1044: X_invoice_number),
1045: payables_batch_name = decode(X_Payables_Batch_Name,
1046: FND_API.G_MISS_CHAR, NULL,
1042: FND_API.G_MISS_CHAR, NULL,
1043: NULL, invoice_number,
1044: X_invoice_number),
1045: payables_batch_name = decode(X_Payables_Batch_Name,
1046: FND_API.G_MISS_CHAR, NULL,
1047: NULL, payables_batch_name,
1048: X_payables_batch_name),
1049: payables_code_combination_id
1050: = decode(X_Payables_Code_Combination_Id,
1047: NULL, payables_batch_name,
1048: X_payables_batch_name),
1049: payables_code_combination_id
1050: = decode(X_Payables_Code_Combination_Id,
1051: FND_API.G_MISS_NUM, NULL,
1052: NULL,
1053: payables_code_combination_id,
1054: X_payables_code_combination_id),
1055: feeder_system_name = decode(X_Feeder_System_Name,
1052: NULL,
1053: payables_code_combination_id,
1054: X_payables_code_combination_id),
1055: feeder_system_name = decode(X_Feeder_System_Name,
1056: FND_API.G_MISS_CHAR, NULL,
1057: NULL, feeder_system_name,
1058: X_feeder_system_name),
1059: create_batch_date = decode(X_Create_Batch_Date,
1060: NULL, create_batch_date,
1059: create_batch_date = decode(X_Create_Batch_Date,
1060: NULL, create_batch_date,
1061: X_create_batch_date),
1062: create_batch_id = decode(X_Create_Batch_Id,
1063: FND_API.G_MISS_NUM, NULL,
1064: NULL, create_batch_id,
1065: X_create_batch_id),
1066: invoice_date = decode(X_Invoice_Date,
1067: NULL, invoice_date,
1066: invoice_date = decode(X_Invoice_Date,
1067: NULL, invoice_date,
1068: X_invoice_date),
1069: payables_cost = decode(X_Payables_Cost,
1070: FND_API.G_MISS_NUM, NULL,
1071: NULL, payables_cost,
1072: X_payables_cost),
1073: post_batch_id = decode(X_Post_Batch_Id,
1074: FND_API.G_MISS_NUM, NULL,
1070: FND_API.G_MISS_NUM, NULL,
1071: NULL, payables_cost,
1072: X_payables_cost),
1073: post_batch_id = decode(X_Post_Batch_Id,
1074: FND_API.G_MISS_NUM, NULL,
1075: NULL, post_batch_id,
1076: X_post_batch_id),
1077: invoice_id = decode(X_Invoice_Id,
1078: FND_API.G_MISS_NUM, NULL,
1074: FND_API.G_MISS_NUM, NULL,
1075: NULL, post_batch_id,
1076: X_post_batch_id),
1077: invoice_id = decode(X_Invoice_Id,
1078: FND_API.G_MISS_NUM, NULL,
1079: NULL, invoice_id,
1080: X_invoice_id),
1081: ap_distribution_line_number
1082: = decode(X_Ap_Distribution_Line_Number,
1079: NULL, invoice_id,
1080: X_invoice_id),
1081: ap_distribution_line_number
1082: = decode(X_Ap_Distribution_Line_Number,
1083: FND_API.G_MISS_NUM, NULL,
1084: NULL, ap_distribution_line_number,
1085: X_ap_distribution_line_number),
1086: payables_units = decode(X_Payables_Units,
1087: FND_API.G_MISS_NUM, NULL,
1083: FND_API.G_MISS_NUM, NULL,
1084: NULL, ap_distribution_line_number,
1085: X_ap_distribution_line_number),
1086: payables_units = decode(X_Payables_Units,
1087: FND_API.G_MISS_NUM, NULL,
1088: NULL, payables_units,
1089: X_payables_units),
1090: split_merged_code = decode(X_Split_Merged_Code,
1091: FND_API.G_MISS_CHAR, NULL,
1087: FND_API.G_MISS_NUM, NULL,
1088: NULL, payables_units,
1089: X_payables_units),
1090: split_merged_code = decode(X_Split_Merged_Code,
1091: FND_API.G_MISS_CHAR, NULL,
1092: NULL, split_merged_code,
1093: X_split_merged_code),
1094: description = decode(X_Description,
1095: FND_API.G_MISS_CHAR, NULL,
1091: FND_API.G_MISS_CHAR, NULL,
1092: NULL, split_merged_code,
1093: X_split_merged_code),
1094: description = decode(X_Description,
1095: FND_API.G_MISS_CHAR, NULL,
1096: NULL, description,
1097: X_description),
1098: parent_mass_addition_id = decode(X_Parent_Mass_Addition_Id,
1099: FND_API.G_MISS_CHAR, NULL,
1095: FND_API.G_MISS_CHAR, NULL,
1096: NULL, description,
1097: X_description),
1098: parent_mass_addition_id = decode(X_Parent_Mass_Addition_Id,
1099: FND_API.G_MISS_CHAR, NULL,
1100: NULL, parent_mass_addition_id,
1101: X_parent_mass_addition_id),
1102: last_update_date = decode(X_Last_Update_Date,
1103: NULL, last_update_date,
1102: last_update_date = decode(X_Last_Update_Date,
1103: NULL, last_update_date,
1104: X_last_update_date),
1105: last_updated_by = decode(X_Last_Updated_By,
1106: FND_API.G_MISS_NUM, NULL,
1107: NULL, last_updated_by,
1108: X_last_updated_by),
1109: last_update_login = decode(X_Last_Update_Login,
1110: FND_API.G_MISS_NUM, NULL,
1106: FND_API.G_MISS_NUM, NULL,
1107: NULL, last_updated_by,
1108: X_last_updated_by),
1109: last_update_login = decode(X_Last_Update_Login,
1110: FND_API.G_MISS_NUM, NULL,
1111: NULL, last_update_login,
1112: X_last_update_login),
1113: attribute1 = decode(X_Attribute1,
1114: FND_API.G_MISS_CHAR, NULL,
1110: FND_API.G_MISS_NUM, NULL,
1111: NULL, last_update_login,
1112: X_last_update_login),
1113: attribute1 = decode(X_Attribute1,
1114: FND_API.G_MISS_CHAR, NULL,
1115: NULL, attribute1,
1116: X_attribute1),
1117: attribute2 = decode(X_Attribute2,
1118: FND_API.G_MISS_CHAR, NULL,
1114: FND_API.G_MISS_CHAR, NULL,
1115: NULL, attribute1,
1116: X_attribute1),
1117: attribute2 = decode(X_Attribute2,
1118: FND_API.G_MISS_CHAR, NULL,
1119: NULL, attribute2,
1120: X_attribute2),
1121: attribute3 = decode(X_Attribute3,
1122: FND_API.G_MISS_CHAR, NULL,
1118: FND_API.G_MISS_CHAR, NULL,
1119: NULL, attribute2,
1120: X_attribute2),
1121: attribute3 = decode(X_Attribute3,
1122: FND_API.G_MISS_CHAR, NULL,
1123: NULL, attribute3,
1124: X_attribute3),
1125: attribute4 = decode(X_Attribute4,
1126: FND_API.G_MISS_CHAR, NULL,
1122: FND_API.G_MISS_CHAR, NULL,
1123: NULL, attribute3,
1124: X_attribute3),
1125: attribute4 = decode(X_Attribute4,
1126: FND_API.G_MISS_CHAR, NULL,
1127: NULL, attribute4,
1128: X_attribute4),
1129: attribute5 = decode(X_Attribute5,
1130: FND_API.G_MISS_CHAR, NULL,
1126: FND_API.G_MISS_CHAR, NULL,
1127: NULL, attribute4,
1128: X_attribute4),
1129: attribute5 = decode(X_Attribute5,
1130: FND_API.G_MISS_CHAR, NULL,
1131: NULL, attribute5,
1132: X_attribute5),
1133: attribute6 = decode(X_Attribute6,
1134: FND_API.G_MISS_CHAR, NULL,
1130: FND_API.G_MISS_CHAR, NULL,
1131: NULL, attribute5,
1132: X_attribute5),
1133: attribute6 = decode(X_Attribute6,
1134: FND_API.G_MISS_CHAR, NULL,
1135: NULL, attribute6,
1136: X_attribute6),
1137: attribute7 = decode(X_Attribute7,
1138: FND_API.G_MISS_CHAR, NULL,
1134: FND_API.G_MISS_CHAR, NULL,
1135: NULL, attribute6,
1136: X_attribute6),
1137: attribute7 = decode(X_Attribute7,
1138: FND_API.G_MISS_CHAR, NULL,
1139: NULL, attribute7,
1140: X_attribute7),
1141: attribute8 = decode(X_Attribute8,
1142: FND_API.G_MISS_CHAR, NULL,
1138: FND_API.G_MISS_CHAR, NULL,
1139: NULL, attribute7,
1140: X_attribute7),
1141: attribute8 = decode(X_Attribute8,
1142: FND_API.G_MISS_CHAR, NULL,
1143: NULL, attribute8,
1144: X_attribute8),
1145: attribute9 = decode(X_Attribute9,
1146: FND_API.G_MISS_CHAR, NULL,
1142: FND_API.G_MISS_CHAR, NULL,
1143: NULL, attribute8,
1144: X_attribute8),
1145: attribute9 = decode(X_Attribute9,
1146: FND_API.G_MISS_CHAR, NULL,
1147: NULL, attribute9,
1148: X_attribute9),
1149: attribute10 = decode(X_Attribute10,
1150: FND_API.G_MISS_CHAR, NULL,
1146: FND_API.G_MISS_CHAR, NULL,
1147: NULL, attribute9,
1148: X_attribute9),
1149: attribute10 = decode(X_Attribute10,
1150: FND_API.G_MISS_CHAR, NULL,
1151: NULL, attribute10,
1152: X_attribute10),
1153: attribute11 = decode(X_Attribute11,
1154: FND_API.G_MISS_CHAR, NULL,
1150: FND_API.G_MISS_CHAR, NULL,
1151: NULL, attribute10,
1152: X_attribute10),
1153: attribute11 = decode(X_Attribute11,
1154: FND_API.G_MISS_CHAR, NULL,
1155: NULL, attribute11,
1156: X_attribute11),
1157: attribute12 = decode(X_Attribute12,
1158: FND_API.G_MISS_CHAR, NULL,
1154: FND_API.G_MISS_CHAR, NULL,
1155: NULL, attribute11,
1156: X_attribute11),
1157: attribute12 = decode(X_Attribute12,
1158: FND_API.G_MISS_CHAR, NULL,
1159: NULL, attribute12,
1160: X_attribute12),
1161: attribute13 = decode(X_Attribute13,
1162: FND_API.G_MISS_CHAR, NULL,
1158: FND_API.G_MISS_CHAR, NULL,
1159: NULL, attribute12,
1160: X_attribute12),
1161: attribute13 = decode(X_Attribute13,
1162: FND_API.G_MISS_CHAR, NULL,
1163: NULL, attribute13,
1164: X_attribute13),
1165: attribute14 = decode(X_Attribute14,
1166: FND_API.G_MISS_CHAR, NULL,
1162: FND_API.G_MISS_CHAR, NULL,
1163: NULL, attribute13,
1164: X_attribute13),
1165: attribute14 = decode(X_Attribute14,
1166: FND_API.G_MISS_CHAR, NULL,
1167: NULL, attribute14,
1168: X_attribute14),
1169: attribute15 = decode(X_attribute15,
1170: FND_API.G_MISS_CHAR, NULL,
1166: FND_API.G_MISS_CHAR, NULL,
1167: NULL, attribute14,
1168: X_attribute14),
1169: attribute15 = decode(X_attribute15,
1170: FND_API.G_MISS_CHAR, NULL,
1171: NULL, attribute15,
1172: X_attribute15),
1173: attribute_category_code = decode(X_Attribute_Category_Code,
1174: FND_API.G_MISS_CHAR, NULL,
1170: FND_API.G_MISS_CHAR, NULL,
1171: NULL, attribute15,
1172: X_attribute15),
1173: attribute_category_code = decode(X_Attribute_Category_Code,
1174: FND_API.G_MISS_CHAR, NULL,
1175: NULL, attribute_category_code,
1176: X_attribute_category_code),
1177: unrevalued_cost = decode(X_Unrevalued_Cost,
1178: FND_API.G_MISS_NUM, NULL,
1174: FND_API.G_MISS_CHAR, NULL,
1175: NULL, attribute_category_code,
1176: X_attribute_category_code),
1177: unrevalued_cost = decode(X_Unrevalued_Cost,
1178: FND_API.G_MISS_NUM, NULL,
1179: NULL, unrevalued_cost,
1180: X_unrevalued_cost),
1181: merged_code = decode(X_Merged_Code,
1182: FND_API.G_MISS_CHAR, NULL,
1178: FND_API.G_MISS_NUM, NULL,
1179: NULL, unrevalued_cost,
1180: X_unrevalued_cost),
1181: merged_code = decode(X_Merged_Code,
1182: FND_API.G_MISS_CHAR, NULL,
1183: NULL, merged_code,
1184: X_merged_code),
1185: split_code = decode(X_Split_Code,
1186: FND_API.G_MISS_CHAR, NULL,
1182: FND_API.G_MISS_CHAR, NULL,
1183: NULL, merged_code,
1184: X_merged_code),
1185: split_code = decode(X_Split_Code,
1186: FND_API.G_MISS_CHAR, NULL,
1187: NULL, split_code,
1188: X_split_code),
1189: merge_parent_mass_additions_id
1190: = decode(X_Merge_Parent_Mass_Add_Id,
1187: NULL, split_code,
1188: X_split_code),
1189: merge_parent_mass_additions_id
1190: = decode(X_Merge_Parent_Mass_Add_Id,
1191: FND_API.G_MISS_NUM, NULL,
1192: NULL,
1193: merge_parent_mass_additions_id,
1194: X_merge_parent_mass_add_id),
1195: split_parent_mass_additions_id
1193: merge_parent_mass_additions_id,
1194: X_merge_parent_mass_add_id),
1195: split_parent_mass_additions_id
1196: = decode(X_Split_Parent_Mass_Add_Id,
1197: FND_API.G_MISS_NUM, NULL,
1198: NULL,
1199: split_parent_mass_additions_id,
1200: X_split_parent_mass_add_id),
1201: project_asset_line_id = decode(X_Project_Asset_Line_Id,
1198: NULL,
1199: split_parent_mass_additions_id,
1200: X_split_parent_mass_add_id),
1201: project_asset_line_id = decode(X_Project_Asset_Line_Id,
1202: FND_API.G_MISS_NUM, NULL,
1203: NULL, project_asset_line_id,
1204: X_project_asset_line_id),
1205: project_id = decode(X_Project_Id,
1206: FND_API.G_MISS_NUM, NULL,
1202: FND_API.G_MISS_NUM, NULL,
1203: NULL, project_asset_line_id,
1204: X_project_asset_line_id),
1205: project_id = decode(X_Project_Id,
1206: FND_API.G_MISS_NUM, NULL,
1207: NULL, project_id,
1208: X_project_id),
1209: task_id = decode(X_Task_Id,
1210: FND_API.G_MISS_NUM, NULL,
1206: FND_API.G_MISS_NUM, NULL,
1207: NULL, project_id,
1208: X_project_id),
1209: task_id = decode(X_Task_Id,
1210: FND_API.G_MISS_NUM, NULL,
1211: NULL, task_id,
1212: X_task_id),
1213: depreciate_in_group_flag = decode(X_depreciate_in_group_flag,
1214: FND_API.G_MISS_CHAR, NULL,
1210: FND_API.G_MISS_NUM, NULL,
1211: NULL, task_id,
1212: X_task_id),
1213: depreciate_in_group_flag = decode(X_depreciate_in_group_flag,
1214: FND_API.G_MISS_CHAR, NULL,
1215: NULL, depreciate_in_group_flag,
1216: X_depreciate_in_group_flag),
1217: material_indicator_flag = decode(X_material_indicator_flag,
1218: FND_API.G_MISS_CHAR, NULL,
1214: FND_API.G_MISS_CHAR, NULL,
1215: NULL, depreciate_in_group_flag,
1216: X_depreciate_in_group_flag),
1217: material_indicator_flag = decode(X_material_indicator_flag,
1218: FND_API.G_MISS_CHAR, NULL,
1219: NULL, material_indicator_flag,
1220: X_material_indicator_flag),
1221: invoice_distribution_id = decode(X_invoice_distribution_id,
1222: FND_API.G_MISS_NUM, NULL,
1218: FND_API.G_MISS_CHAR, NULL,
1219: NULL, material_indicator_flag,
1220: X_material_indicator_flag),
1221: invoice_distribution_id = decode(X_invoice_distribution_id,
1222: FND_API.G_MISS_NUM, NULL,
1223: NULL, invoice_distribution_id,
1224: X_invoice_distribution_id),
1225: invoice_line_number = decode(X_invoice_line_number,
1226: FND_API.G_MISS_NUM, NULL,
1222: FND_API.G_MISS_NUM, NULL,
1223: NULL, invoice_distribution_id,
1224: X_invoice_distribution_id),
1225: invoice_line_number = decode(X_invoice_line_number,
1226: FND_API.G_MISS_NUM, NULL,
1227: NULL, invoice_line_number,
1228: X_invoice_line_number),
1229: po_distribution_id = decode(X_po_distribution_id,
1230: FND_API.G_MISS_NUM, NULL,
1226: FND_API.G_MISS_NUM, NULL,
1227: NULL, invoice_line_number,
1228: X_invoice_line_number),
1229: po_distribution_id = decode(X_po_distribution_id,
1230: FND_API.G_MISS_NUM, NULL,
1231: NULL, po_distribution_id,
1232: X_po_distribution_id)
1233: WHERE rowid = l_rowid;
1234: