DBA Data[Home] [Help]

APPS.FA_ASSET_INVOICES_PKG dependencies on FND_API

Line 748: FND_API.G_MISS_NUM, NULL,

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,

Line 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,

Line 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,

Line 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,

Line 771: FND_API.G_MISS_NUM, NULL,

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,

Line 776: 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,
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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 797: FND_API.G_MISS_NUM, NULL,

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,

Line 802: FND_API.G_MISS_CHAR, NULL,

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,

Line 809: FND_API.G_MISS_NUM, NULL,

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,

Line 816: FND_API.G_MISS_NUM, NULL,

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,

Line 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,

Line 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,

Line 829: 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,
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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 852: FND_API.G_MISS_NUM, NULL,

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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 937: FND_API.G_MISS_NUM, NULL,

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

Line 943: FND_API.G_MISS_NUM, NULL,

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,

Line 948: 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,
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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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:

Line 1002: FND_API.G_MISS_NUM, NULL,

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,

Line 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,

Line 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,

Line 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,

Line 1025: FND_API.G_MISS_NUM, NULL,

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,

Line 1030: 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,
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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 1051: FND_API.G_MISS_NUM, NULL,

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,

Line 1056: FND_API.G_MISS_CHAR, NULL,

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,

Line 1063: FND_API.G_MISS_NUM, NULL,

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,

Line 1070: FND_API.G_MISS_NUM, NULL,

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,

Line 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,

Line 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,

Line 1083: 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,
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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 1106: FND_API.G_MISS_NUM, NULL,

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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 1191: FND_API.G_MISS_NUM, NULL,

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

Line 1197: FND_API.G_MISS_NUM, NULL,

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,

Line 1202: 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,
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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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,

Line 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: