796: OR fdh.date_ineffective IS NULL)
797: AND EXISTS
798: (SELECT jclllbg.bal_seg_value
799: FROM ja_cn_ledger_le_bsv_gt jclllbg
800: WHERE JA_CN_UTILITY.get_balancing_segment(fdh.code_combination_id)
801: = jclllbg.bal_seg_value
802: AND jclllbg.Ledger_Id = pn_ledger_id
803: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id)
804:
910: OR fdh.date_ineffective IS NULL)
911: AND EXISTS
912: (SELECT jclllbg.bal_seg_value
913: FROM ja_cn_ledger_le_bsv_gt jclllbg
914: WHERE JA_CN_UTILITY
915: .get_balancing_segment(fdh.code_combination_id) =
916: jclllbg.bal_seg_value
917: AND jclllbg.Ledger_Id = pn_ledger_id
918: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id)
1003: FROM fa_asset_keywords faak
1004: WHERE faak.code_combination_id = ln_asset_key_ccid;
1005: END IF; --( IF(ln_asset_key_ccid IS NOT NULL))
1006: ln_row_count := ln_row_count + 1;
1007: Ja_Cn_Utility.Add_Sub_Root_Node
1008: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1009: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
1010: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1011: );
1005: END IF; --( IF(ln_asset_key_ccid IS NOT NULL))
1006: ln_row_count := ln_row_count + 1;
1007: Ja_Cn_Utility.Add_Sub_Root_Node
1008: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1009: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
1010: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1011: );
1012: Ja_Cn_Utility.Add_Child_Node
1013: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
1006: ln_row_count := ln_row_count + 1;
1007: Ja_Cn_Utility.Add_Sub_Root_Node
1008: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1009: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
1010: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1011: );
1012: Ja_Cn_Utility.Add_Child_Node
1013: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
1014: , pv_text_node_value => lv_asset_number
1008: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1009: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
1010: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1011: );
1012: Ja_Cn_Utility.Add_Child_Node
1013: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
1014: , pv_text_node_value => lv_asset_number
1015: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1016: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1011: );
1012: Ja_Cn_Utility.Add_Child_Node
1013: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
1014: , pv_text_node_value => lv_asset_number
1015: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1016: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1017: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1018: );
1019: Ja_Cn_Utility.Add_Child_Node
1012: Ja_Cn_Utility.Add_Child_Node
1013: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
1014: , pv_text_node_value => lv_asset_number
1015: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1016: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1017: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1018: );
1019: Ja_Cn_Utility.Add_Child_Node
1020: ( pv_child_tag_name => 'FIXED_ASSET_CATEGORY_CODE'
1013: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
1014: , pv_text_node_value => lv_asset_number
1015: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1016: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1017: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1018: );
1019: Ja_Cn_Utility.Add_Child_Node
1020: ( pv_child_tag_name => 'FIXED_ASSET_CATEGORY_CODE'
1021: , pv_text_node_value => lv_category_code
1015: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1016: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1017: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1018: );
1019: Ja_Cn_Utility.Add_Child_Node
1020: ( pv_child_tag_name => 'FIXED_ASSET_CATEGORY_CODE'
1021: , pv_text_node_value => lv_category_code
1022: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1023: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1018: );
1019: Ja_Cn_Utility.Add_Child_Node
1020: ( pv_child_tag_name => 'FIXED_ASSET_CATEGORY_CODE'
1021: , pv_text_node_value => lv_category_code
1022: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1023: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1024: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1025: );
1026: Ja_Cn_Utility.Add_Child_Node
1019: Ja_Cn_Utility.Add_Child_Node
1020: ( pv_child_tag_name => 'FIXED_ASSET_CATEGORY_CODE'
1021: , pv_text_node_value => lv_category_code
1022: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1023: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1024: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1025: );
1026: Ja_Cn_Utility.Add_Child_Node
1027: ( pv_child_tag_name => 'FIXED_ASSET_NUMBER'
1020: ( pv_child_tag_name => 'FIXED_ASSET_CATEGORY_CODE'
1021: , pv_text_node_value => lv_category_code
1022: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1023: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1024: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1025: );
1026: Ja_Cn_Utility.Add_Child_Node
1027: ( pv_child_tag_name => 'FIXED_ASSET_NUMBER'
1028: , pv_text_node_value => lv_asset_number
1022: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1023: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1024: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1025: );
1026: Ja_Cn_Utility.Add_Child_Node
1027: ( pv_child_tag_name => 'FIXED_ASSET_NUMBER'
1028: , pv_text_node_value => lv_asset_number
1029: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1030: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1025: );
1026: Ja_Cn_Utility.Add_Child_Node
1027: ( pv_child_tag_name => 'FIXED_ASSET_NUMBER'
1028: , pv_text_node_value => lv_asset_number
1029: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1030: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1031: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1032: );
1033: Ja_Cn_Utility.Add_Child_Node
1026: Ja_Cn_Utility.Add_Child_Node
1027: ( pv_child_tag_name => 'FIXED_ASSET_NUMBER'
1028: , pv_text_node_value => lv_asset_number
1029: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1030: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1031: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1032: );
1033: Ja_Cn_Utility.Add_Child_Node
1034: ( pv_child_tag_name => 'FIXED_ASSET_NAME'
1027: ( pv_child_tag_name => 'FIXED_ASSET_NUMBER'
1028: , pv_text_node_value => lv_asset_number
1029: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1030: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1031: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1032: );
1033: Ja_Cn_Utility.Add_Child_Node
1034: ( pv_child_tag_name => 'FIXED_ASSET_NAME'
1035: , pv_text_node_value => lv_asset_name
1029: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1030: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1031: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1032: );
1033: Ja_Cn_Utility.Add_Child_Node
1034: ( pv_child_tag_name => 'FIXED_ASSET_NAME'
1035: , pv_text_node_value => lv_asset_name
1036: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1037: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1032: );
1033: Ja_Cn_Utility.Add_Child_Node
1034: ( pv_child_tag_name => 'FIXED_ASSET_NAME'
1035: , pv_text_node_value => lv_asset_name
1036: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1037: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1038: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1039: );
1040: Ja_Cn_Utility.Add_Fixed_Child_Node
1033: Ja_Cn_Utility.Add_Child_Node
1034: ( pv_child_tag_name => 'FIXED_ASSET_NAME'
1035: , pv_text_node_value => lv_asset_name
1036: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1037: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1038: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1039: );
1040: Ja_Cn_Utility.Add_Fixed_Child_Node
1041: ( pv_child_tag_name => 'DATE_IN_SERVICE'
1034: ( pv_child_tag_name => 'FIXED_ASSET_NAME'
1035: , pv_text_node_value => lv_asset_name
1036: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1037: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1038: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1039: );
1040: Ja_Cn_Utility.Add_Fixed_Child_Node
1041: ( pv_child_tag_name => 'DATE_IN_SERVICE'
1042: , pv_text_node_value => TO_CHAR(ld_in_service_date, 'YYYYMMDD')
1036: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1037: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1038: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1039: );
1040: Ja_Cn_Utility.Add_Fixed_Child_Node
1041: ( pv_child_tag_name => 'DATE_IN_SERVICE'
1042: , pv_text_node_value => TO_CHAR(ld_in_service_date, 'YYYYMMDD')
1043: , pn_fixed_length => 8
1044: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1040: Ja_Cn_Utility.Add_Fixed_Child_Node
1041: ( pv_child_tag_name => 'DATE_IN_SERVICE'
1042: , pv_text_node_value => TO_CHAR(ld_in_service_date, 'YYYYMMDD')
1043: , pn_fixed_length => 8
1044: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1045: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1046: );
1047: Ja_Cn_Utility.Add_Child_Node
1048: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
1041: ( pv_child_tag_name => 'DATE_IN_SERVICE'
1042: , pv_text_node_value => TO_CHAR(ld_in_service_date, 'YYYYMMDD')
1043: , pn_fixed_length => 8
1044: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1045: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1046: );
1047: Ja_Cn_Utility.Add_Child_Node
1048: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
1049: , pv_text_node_value => lv_accounting_period
1043: , pn_fixed_length => 8
1044: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1045: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1046: );
1047: Ja_Cn_Utility.Add_Child_Node
1048: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
1049: , pv_text_node_value => lv_accounting_period
1050: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1051: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1046: );
1047: Ja_Cn_Utility.Add_Child_Node
1048: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
1049: , pv_text_node_value => lv_accounting_period
1050: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1051: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1052: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1053: );
1054: Ja_Cn_Utility.Add_Child_Node
1047: Ja_Cn_Utility.Add_Child_Node
1048: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
1049: , pv_text_node_value => lv_accounting_period
1050: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1051: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1052: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1053: );
1054: Ja_Cn_Utility.Add_Child_Node
1055: ( pv_child_tag_name => 'FIXED_ASSET_UNIT_OF_MEASURE'
1048: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
1049: , pv_text_node_value => lv_accounting_period
1050: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1051: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1052: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1053: );
1054: Ja_Cn_Utility.Add_Child_Node
1055: ( pv_child_tag_name => 'FIXED_ASSET_UNIT_OF_MEASURE'
1056: , pv_text_node_value => lv_asset_measure
1050: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1051: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1052: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1053: );
1054: Ja_Cn_Utility.Add_Child_Node
1055: ( pv_child_tag_name => 'FIXED_ASSET_UNIT_OF_MEASURE'
1056: , pv_text_node_value => lv_asset_measure
1057: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1058: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1053: );
1054: Ja_Cn_Utility.Add_Child_Node
1055: ( pv_child_tag_name => 'FIXED_ASSET_UNIT_OF_MEASURE'
1056: , pv_text_node_value => lv_asset_measure
1057: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1058: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1059: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1060: );
1061: Ja_Cn_Utility.Add_Child_Node
1054: Ja_Cn_Utility.Add_Child_Node
1055: ( pv_child_tag_name => 'FIXED_ASSET_UNIT_OF_MEASURE'
1056: , pv_text_node_value => lv_asset_measure
1057: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1058: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1059: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1060: );
1061: Ja_Cn_Utility.Add_Child_Node
1062: ( pv_child_tag_name => 'UNIT'
1055: ( pv_child_tag_name => 'FIXED_ASSET_UNIT_OF_MEASURE'
1056: , pv_text_node_value => lv_asset_measure
1057: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1058: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1059: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1060: );
1061: Ja_Cn_Utility.Add_Child_Node
1062: ( pv_child_tag_name => 'UNIT'
1063: , pv_text_node_value => ln_assigned_unit
1057: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1058: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1059: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1060: );
1061: Ja_Cn_Utility.Add_Child_Node
1062: ( pv_child_tag_name => 'UNIT'
1063: , pv_text_node_value => ln_assigned_unit
1064: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1065: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1060: );
1061: Ja_Cn_Utility.Add_Child_Node
1062: ( pv_child_tag_name => 'UNIT'
1063: , pv_text_node_value => ln_assigned_unit
1064: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1065: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1066: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1067: );
1068: Ja_Cn_Utility.Add_Child_Node
1061: Ja_Cn_Utility.Add_Child_Node
1062: ( pv_child_tag_name => 'UNIT'
1063: , pv_text_node_value => ln_assigned_unit
1064: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1065: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1066: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1067: );
1068: Ja_Cn_Utility.Add_Child_Node
1069: ( pv_child_tag_name => 'MODIFICATION_METHOD_CODE'
1062: ( pv_child_tag_name => 'UNIT'
1063: , pv_text_node_value => ln_assigned_unit
1064: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1065: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1066: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1067: );
1068: Ja_Cn_Utility.Add_Child_Node
1069: ( pv_child_tag_name => 'MODIFICATION_METHOD_CODE'
1070: , pv_text_node_value => 'Addition'
1064: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1065: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1066: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1067: );
1068: Ja_Cn_Utility.Add_Child_Node
1069: ( pv_child_tag_name => 'MODIFICATION_METHOD_CODE'
1070: , pv_text_node_value => 'Addition'
1071: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1072: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1067: );
1068: Ja_Cn_Utility.Add_Child_Node
1069: ( pv_child_tag_name => 'MODIFICATION_METHOD_CODE'
1070: , pv_text_node_value => 'Addition'
1071: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1072: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1073: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1074: );
1075: Ja_Cn_Utility.Add_Child_Node
1068: Ja_Cn_Utility.Add_Child_Node
1069: ( pv_child_tag_name => 'MODIFICATION_METHOD_CODE'
1070: , pv_text_node_value => 'Addition'
1071: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1072: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1073: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1074: );
1075: Ja_Cn_Utility.Add_Child_Node
1076: ( pv_child_tag_name => 'USAGE_STATUS_CODE'
1069: ( pv_child_tag_name => 'MODIFICATION_METHOD_CODE'
1070: , pv_text_node_value => 'Addition'
1071: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1072: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1073: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1074: );
1075: Ja_Cn_Utility.Add_Child_Node
1076: ( pv_child_tag_name => 'USAGE_STATUS_CODE'
1077: , pv_text_node_value => lv_asset_usage
1071: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1072: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1073: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1074: );
1075: Ja_Cn_Utility.Add_Child_Node
1076: ( pv_child_tag_name => 'USAGE_STATUS_CODE'
1077: , pv_text_node_value => lv_asset_usage
1078: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1079: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1074: );
1075: Ja_Cn_Utility.Add_Child_Node
1076: ( pv_child_tag_name => 'USAGE_STATUS_CODE'
1077: , pv_text_node_value => lv_asset_usage
1078: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1079: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1080: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1081: );
1082: Ja_Cn_Utility.Add_Child_Node
1075: Ja_Cn_Utility.Add_Child_Node
1076: ( pv_child_tag_name => 'USAGE_STATUS_CODE'
1077: , pv_text_node_value => lv_asset_usage
1078: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1079: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1080: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1081: );
1082: Ja_Cn_Utility.Add_Child_Node
1083: ( pv_child_tag_name => 'FUNCTIONAL_CURRENCY'
1076: ( pv_child_tag_name => 'USAGE_STATUS_CODE'
1077: , pv_text_node_value => lv_asset_usage
1078: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1079: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1080: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1081: );
1082: Ja_Cn_Utility.Add_Child_Node
1083: ( pv_child_tag_name => 'FUNCTIONAL_CURRENCY'
1084: , pv_text_node_value => lv_currency
1078: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1079: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1080: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1081: );
1082: Ja_Cn_Utility.Add_Child_Node
1083: ( pv_child_tag_name => 'FUNCTIONAL_CURRENCY'
1084: , pv_text_node_value => lv_currency
1085: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1086: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1081: );
1082: Ja_Cn_Utility.Add_Child_Node
1083: ( pv_child_tag_name => 'FUNCTIONAL_CURRENCY'
1084: , pv_text_node_value => lv_currency
1085: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1086: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1087: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1088: );
1089: Ja_Cn_Utility.Add_Child_Node
1082: Ja_Cn_Utility.Add_Child_Node
1083: ( pv_child_tag_name => 'FUNCTIONAL_CURRENCY'
1084: , pv_text_node_value => lv_currency
1085: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1086: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1087: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1088: );
1089: Ja_Cn_Utility.Add_Child_Node
1090: ( pv_child_tag_name => 'ORIGINAL_VALUE'
1083: ( pv_child_tag_name => 'FUNCTIONAL_CURRENCY'
1084: , pv_text_node_value => lv_currency
1085: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1086: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1087: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1088: );
1089: Ja_Cn_Utility.Add_Child_Node
1090: ( pv_child_tag_name => 'ORIGINAL_VALUE'
1091: , pv_text_node_value => Ja_Cn_Utility.get_rounding_value
1085: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1086: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1087: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1088: );
1089: Ja_Cn_Utility.Add_Child_Node
1090: ( pv_child_tag_name => 'ORIGINAL_VALUE'
1091: , pv_text_node_value => Ja_Cn_Utility.get_rounding_value
1092: ( pn_original_value =>
1093: ln_original_value * ln_assigned_rate
1087: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1088: );
1089: Ja_Cn_Utility.Add_Child_Node
1090: ( pv_child_tag_name => 'ORIGINAL_VALUE'
1091: , pv_text_node_value => Ja_Cn_Utility.get_rounding_value
1092: ( pn_original_value =>
1093: ln_original_value * ln_assigned_rate
1094: , pn_legal_entity_id => pn_legal_entity_id
1095: )
1092: ( pn_original_value =>
1093: ln_original_value * ln_assigned_rate
1094: , pn_legal_entity_id => pn_legal_entity_id
1095: )
1096: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1097: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1098: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1099: );
1100: Ja_Cn_Utility.Add_Child_Node
1093: ln_original_value * ln_assigned_rate
1094: , pn_legal_entity_id => pn_legal_entity_id
1095: )
1096: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1097: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1098: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1099: );
1100: Ja_Cn_Utility.Add_Child_Node
1101: ( pv_child_tag_name => 'NET_BOOK_VALUE'
1094: , pn_legal_entity_id => pn_legal_entity_id
1095: )
1096: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1097: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1098: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1099: );
1100: Ja_Cn_Utility.Add_Child_Node
1101: ( pv_child_tag_name => 'NET_BOOK_VALUE'
1102: , pv_text_node_value => Ja_Cn_Utility.get_rounding_value
1096: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1097: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1098: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1099: );
1100: Ja_Cn_Utility.Add_Child_Node
1101: ( pv_child_tag_name => 'NET_BOOK_VALUE'
1102: , pv_text_node_value => Ja_Cn_Utility.get_rounding_value
1103: ( pn_original_value =>
1104: ln_net_book_value * ln_assigned_rate
1098: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1099: );
1100: Ja_Cn_Utility.Add_Child_Node
1101: ( pv_child_tag_name => 'NET_BOOK_VALUE'
1102: , pv_text_node_value => Ja_Cn_Utility.get_rounding_value
1103: ( pn_original_value =>
1104: ln_net_book_value * ln_assigned_rate
1105: , pn_legal_entity_id => pn_legal_entity_id
1106: )
1103: ( pn_original_value =>
1104: ln_net_book_value * ln_assigned_rate
1105: , pn_legal_entity_id => pn_legal_entity_id
1106: )
1107: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1108: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1109: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1110: );
1111: JA_CN_UTILITY.Add_Child_Node
1104: ln_net_book_value * ln_assigned_rate
1105: , pn_legal_entity_id => pn_legal_entity_id
1106: )
1107: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1108: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1109: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1110: );
1111: JA_CN_UTILITY.Add_Child_Node
1112: ( pv_child_tag_name => 'FIXED_ASSET_VOUCHER_NUMBER'
1105: , pn_legal_entity_id => pn_legal_entity_id
1106: )
1107: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1108: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1109: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1110: );
1111: JA_CN_UTILITY.Add_Child_Node
1112: ( pv_child_tag_name => 'FIXED_ASSET_VOUCHER_NUMBER'
1113: , pv_text_node_value => NULL
1107: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1108: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1109: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1110: );
1111: JA_CN_UTILITY.Add_Child_Node
1112: ( pv_child_tag_name => 'FIXED_ASSET_VOUCHER_NUMBER'
1113: , pv_text_node_value => NULL
1114: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1115: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1110: );
1111: JA_CN_UTILITY.Add_Child_Node
1112: ( pv_child_tag_name => 'FIXED_ASSET_VOUCHER_NUMBER'
1113: , pv_text_node_value => NULL
1114: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1115: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1116: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1117: );
1118: Ja_Cn_Utility.Add_Sub_Root_Node
1111: JA_CN_UTILITY.Add_Child_Node
1112: ( pv_child_tag_name => 'FIXED_ASSET_VOUCHER_NUMBER'
1113: , pv_text_node_value => NULL
1114: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1115: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1116: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1117: );
1118: Ja_Cn_Utility.Add_Sub_Root_Node
1119: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1112: ( pv_child_tag_name => 'FIXED_ASSET_VOUCHER_NUMBER'
1113: , pv_text_node_value => NULL
1114: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1115: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1116: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1117: );
1118: Ja_Cn_Utility.Add_Sub_Root_Node
1119: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1120: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
1114: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1115: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1116: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1117: );
1118: Ja_Cn_Utility.Add_Sub_Root_Node
1119: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1120: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
1121: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1122: );
1116: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1117: );
1118: Ja_Cn_Utility.Add_Sub_Root_Node
1119: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1120: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
1121: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1122: );
1123: END IF;-- (lb_retirement_flag = FALSE)
1124: EXCEPTION
1117: );
1118: Ja_Cn_Utility.Add_Sub_Root_Node
1119: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1120: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
1121: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1122: );
1123: END IF;-- (lb_retirement_flag = FALSE)
1124: EXCEPTION
1125: WHEN OTHERS THEN
1136: END LOOP;
1137: CLOSE asset_card_cur;
1138: IF (ln_row_count = 0)
1139: THEN
1140: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'FIXED_ASSET_CARD'
1141: , Ja_Cn_Utility.GV_MODULE_FA);
1142: Ja_Cn_Utility.Add_Sub_Root_Node
1143: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1144: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
1137: CLOSE asset_card_cur;
1138: IF (ln_row_count = 0)
1139: THEN
1140: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'FIXED_ASSET_CARD'
1141: , Ja_Cn_Utility.GV_MODULE_FA);
1142: Ja_Cn_Utility.Add_Sub_Root_Node
1143: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1144: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
1145: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1138: IF (ln_row_count = 0)
1139: THEN
1140: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'FIXED_ASSET_CARD'
1141: , Ja_Cn_Utility.GV_MODULE_FA);
1142: Ja_Cn_Utility.Add_Sub_Root_Node
1143: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1144: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
1145: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1146: );
1140: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'FIXED_ASSET_CARD'
1141: , Ja_Cn_Utility.GV_MODULE_FA);
1142: Ja_Cn_Utility.Add_Sub_Root_Node
1143: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1144: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
1145: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1146: );
1147: Ja_Cn_Utility.Add_Child_Node
1148: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
1141: , Ja_Cn_Utility.GV_MODULE_FA);
1142: Ja_Cn_Utility.Add_Sub_Root_Node
1143: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1144: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
1145: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1146: );
1147: Ja_Cn_Utility.Add_Child_Node
1148: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
1149: , pv_text_node_value => NULL
1143: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1144: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
1145: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1146: );
1147: Ja_Cn_Utility.Add_Child_Node
1148: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
1149: , pv_text_node_value => NULL
1150: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1151: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1146: );
1147: Ja_Cn_Utility.Add_Child_Node
1148: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
1149: , pv_text_node_value => NULL
1150: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1151: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1152: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1153: );
1154: Ja_Cn_Utility.Add_Child_Node
1147: Ja_Cn_Utility.Add_Child_Node
1148: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
1149: , pv_text_node_value => NULL
1150: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1151: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1152: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1153: );
1154: Ja_Cn_Utility.Add_Child_Node
1155: ( pv_child_tag_name => 'FIXED_ASSET_CATEGORY_CODE'
1148: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
1149: , pv_text_node_value => NULL
1150: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1151: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1152: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1153: );
1154: Ja_Cn_Utility.Add_Child_Node
1155: ( pv_child_tag_name => 'FIXED_ASSET_CATEGORY_CODE'
1156: , pv_text_node_value => NULL
1150: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1151: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1152: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1153: );
1154: Ja_Cn_Utility.Add_Child_Node
1155: ( pv_child_tag_name => 'FIXED_ASSET_CATEGORY_CODE'
1156: , pv_text_node_value => NULL
1157: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1158: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1153: );
1154: Ja_Cn_Utility.Add_Child_Node
1155: ( pv_child_tag_name => 'FIXED_ASSET_CATEGORY_CODE'
1156: , pv_text_node_value => NULL
1157: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1158: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1159: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1160: );
1161: Ja_Cn_Utility.Add_Child_Node
1154: Ja_Cn_Utility.Add_Child_Node
1155: ( pv_child_tag_name => 'FIXED_ASSET_CATEGORY_CODE'
1156: , pv_text_node_value => NULL
1157: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1158: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1159: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1160: );
1161: Ja_Cn_Utility.Add_Child_Node
1162: ( pv_child_tag_name => 'FIXED_ASSET_NUMBER'
1155: ( pv_child_tag_name => 'FIXED_ASSET_CATEGORY_CODE'
1156: , pv_text_node_value => NULL
1157: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1158: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1159: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1160: );
1161: Ja_Cn_Utility.Add_Child_Node
1162: ( pv_child_tag_name => 'FIXED_ASSET_NUMBER'
1163: , pv_text_node_value => NULL
1157: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1158: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1159: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1160: );
1161: Ja_Cn_Utility.Add_Child_Node
1162: ( pv_child_tag_name => 'FIXED_ASSET_NUMBER'
1163: , pv_text_node_value => NULL
1164: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1165: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1160: );
1161: Ja_Cn_Utility.Add_Child_Node
1162: ( pv_child_tag_name => 'FIXED_ASSET_NUMBER'
1163: , pv_text_node_value => NULL
1164: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1165: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1166: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1167: );
1168: Ja_Cn_Utility.Add_Child_Node
1161: Ja_Cn_Utility.Add_Child_Node
1162: ( pv_child_tag_name => 'FIXED_ASSET_NUMBER'
1163: , pv_text_node_value => NULL
1164: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1165: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1166: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1167: );
1168: Ja_Cn_Utility.Add_Child_Node
1169: ( pv_child_tag_name => 'FIXED_ASSET_NAME'
1162: ( pv_child_tag_name => 'FIXED_ASSET_NUMBER'
1163: , pv_text_node_value => NULL
1164: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1165: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1166: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1167: );
1168: Ja_Cn_Utility.Add_Child_Node
1169: ( pv_child_tag_name => 'FIXED_ASSET_NAME'
1170: , pv_text_node_value => NULL
1164: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1165: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1166: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1167: );
1168: Ja_Cn_Utility.Add_Child_Node
1169: ( pv_child_tag_name => 'FIXED_ASSET_NAME'
1170: , pv_text_node_value => NULL
1171: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1172: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1167: );
1168: Ja_Cn_Utility.Add_Child_Node
1169: ( pv_child_tag_name => 'FIXED_ASSET_NAME'
1170: , pv_text_node_value => NULL
1171: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1172: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1173: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1174: );
1175: Ja_Cn_Utility.Add_Fixed_Child_Node
1168: Ja_Cn_Utility.Add_Child_Node
1169: ( pv_child_tag_name => 'FIXED_ASSET_NAME'
1170: , pv_text_node_value => NULL
1171: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1172: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1173: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1174: );
1175: Ja_Cn_Utility.Add_Fixed_Child_Node
1176: ( pv_child_tag_name => 'DATE_IN_SERVICE'
1169: ( pv_child_tag_name => 'FIXED_ASSET_NAME'
1170: , pv_text_node_value => NULL
1171: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1172: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1173: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1174: );
1175: Ja_Cn_Utility.Add_Fixed_Child_Node
1176: ( pv_child_tag_name => 'DATE_IN_SERVICE'
1177: , pv_text_node_value => NULL
1171: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1172: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1173: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1174: );
1175: Ja_Cn_Utility.Add_Fixed_Child_Node
1176: ( pv_child_tag_name => 'DATE_IN_SERVICE'
1177: , pv_text_node_value => NULL
1178: , pn_fixed_length => 8
1179: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1175: Ja_Cn_Utility.Add_Fixed_Child_Node
1176: ( pv_child_tag_name => 'DATE_IN_SERVICE'
1177: , pv_text_node_value => NULL
1178: , pn_fixed_length => 8
1179: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1180: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1181: );
1182: Ja_Cn_Utility.Add_Child_Node
1183: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
1176: ( pv_child_tag_name => 'DATE_IN_SERVICE'
1177: , pv_text_node_value => NULL
1178: , pn_fixed_length => 8
1179: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1180: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1181: );
1182: Ja_Cn_Utility.Add_Child_Node
1183: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
1184: , pv_text_node_value => NULL
1178: , pn_fixed_length => 8
1179: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1180: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1181: );
1182: Ja_Cn_Utility.Add_Child_Node
1183: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
1184: , pv_text_node_value => NULL
1185: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1186: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1181: );
1182: Ja_Cn_Utility.Add_Child_Node
1183: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
1184: , pv_text_node_value => NULL
1185: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1186: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1187: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1188: );
1189: Ja_Cn_Utility.Add_Child_Node
1182: Ja_Cn_Utility.Add_Child_Node
1183: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
1184: , pv_text_node_value => NULL
1185: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1186: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1187: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1188: );
1189: Ja_Cn_Utility.Add_Child_Node
1190: ( pv_child_tag_name => 'FIXED_ASSET_UNIT_OF_MEASURE'
1183: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
1184: , pv_text_node_value => NULL
1185: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1186: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1187: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1188: );
1189: Ja_Cn_Utility.Add_Child_Node
1190: ( pv_child_tag_name => 'FIXED_ASSET_UNIT_OF_MEASURE'
1191: , pv_text_node_value => NULL
1185: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1186: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1187: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1188: );
1189: Ja_Cn_Utility.Add_Child_Node
1190: ( pv_child_tag_name => 'FIXED_ASSET_UNIT_OF_MEASURE'
1191: , pv_text_node_value => NULL
1192: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1193: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1188: );
1189: Ja_Cn_Utility.Add_Child_Node
1190: ( pv_child_tag_name => 'FIXED_ASSET_UNIT_OF_MEASURE'
1191: , pv_text_node_value => NULL
1192: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1193: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1194: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1195: );
1196: Ja_Cn_Utility.Add_Child_Node
1189: Ja_Cn_Utility.Add_Child_Node
1190: ( pv_child_tag_name => 'FIXED_ASSET_UNIT_OF_MEASURE'
1191: , pv_text_node_value => NULL
1192: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1193: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1194: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1195: );
1196: Ja_Cn_Utility.Add_Child_Node
1197: ( pv_child_tag_name => 'UNIT'
1190: ( pv_child_tag_name => 'FIXED_ASSET_UNIT_OF_MEASURE'
1191: , pv_text_node_value => NULL
1192: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1193: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1194: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1195: );
1196: Ja_Cn_Utility.Add_Child_Node
1197: ( pv_child_tag_name => 'UNIT'
1198: , pv_text_node_value => NULL
1192: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1193: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1194: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1195: );
1196: Ja_Cn_Utility.Add_Child_Node
1197: ( pv_child_tag_name => 'UNIT'
1198: , pv_text_node_value => NULL
1199: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1200: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1195: );
1196: Ja_Cn_Utility.Add_Child_Node
1197: ( pv_child_tag_name => 'UNIT'
1198: , pv_text_node_value => NULL
1199: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1200: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1201: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1202: );
1203: Ja_Cn_Utility.Add_Child_Node
1196: Ja_Cn_Utility.Add_Child_Node
1197: ( pv_child_tag_name => 'UNIT'
1198: , pv_text_node_value => NULL
1199: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1200: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1201: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1202: );
1203: Ja_Cn_Utility.Add_Child_Node
1204: ( pv_child_tag_name => 'MODIFICATION_METHOD_CODE'
1197: ( pv_child_tag_name => 'UNIT'
1198: , pv_text_node_value => NULL
1199: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1200: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1201: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1202: );
1203: Ja_Cn_Utility.Add_Child_Node
1204: ( pv_child_tag_name => 'MODIFICATION_METHOD_CODE'
1205: , pv_text_node_value => NULL
1199: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1200: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1201: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1202: );
1203: Ja_Cn_Utility.Add_Child_Node
1204: ( pv_child_tag_name => 'MODIFICATION_METHOD_CODE'
1205: , pv_text_node_value => NULL
1206: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1207: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1202: );
1203: Ja_Cn_Utility.Add_Child_Node
1204: ( pv_child_tag_name => 'MODIFICATION_METHOD_CODE'
1205: , pv_text_node_value => NULL
1206: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1207: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1208: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1209: );
1210: Ja_Cn_Utility.Add_Child_Node
1203: Ja_Cn_Utility.Add_Child_Node
1204: ( pv_child_tag_name => 'MODIFICATION_METHOD_CODE'
1205: , pv_text_node_value => NULL
1206: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1207: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1208: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1209: );
1210: Ja_Cn_Utility.Add_Child_Node
1211: ( pv_child_tag_name => 'USAGE_STATUS_CODE'
1204: ( pv_child_tag_name => 'MODIFICATION_METHOD_CODE'
1205: , pv_text_node_value => NULL
1206: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1207: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1208: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1209: );
1210: Ja_Cn_Utility.Add_Child_Node
1211: ( pv_child_tag_name => 'USAGE_STATUS_CODE'
1212: , pv_text_node_value => NULL
1206: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1207: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1208: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1209: );
1210: Ja_Cn_Utility.Add_Child_Node
1211: ( pv_child_tag_name => 'USAGE_STATUS_CODE'
1212: , pv_text_node_value => NULL
1213: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1214: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1209: );
1210: Ja_Cn_Utility.Add_Child_Node
1211: ( pv_child_tag_name => 'USAGE_STATUS_CODE'
1212: , pv_text_node_value => NULL
1213: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1214: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1215: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1216: );
1217: Ja_Cn_Utility.Add_Child_Node
1210: Ja_Cn_Utility.Add_Child_Node
1211: ( pv_child_tag_name => 'USAGE_STATUS_CODE'
1212: , pv_text_node_value => NULL
1213: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1214: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1215: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1216: );
1217: Ja_Cn_Utility.Add_Child_Node
1218: ( pv_child_tag_name => 'FUNCTIONAL_CURRENCY'
1211: ( pv_child_tag_name => 'USAGE_STATUS_CODE'
1212: , pv_text_node_value => NULL
1213: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1214: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1215: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1216: );
1217: Ja_Cn_Utility.Add_Child_Node
1218: ( pv_child_tag_name => 'FUNCTIONAL_CURRENCY'
1219: , pv_text_node_value => NULL
1213: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1214: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1215: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1216: );
1217: Ja_Cn_Utility.Add_Child_Node
1218: ( pv_child_tag_name => 'FUNCTIONAL_CURRENCY'
1219: , pv_text_node_value => NULL
1220: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1221: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1216: );
1217: Ja_Cn_Utility.Add_Child_Node
1218: ( pv_child_tag_name => 'FUNCTIONAL_CURRENCY'
1219: , pv_text_node_value => NULL
1220: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1221: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1222: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1223: );
1224: Ja_Cn_Utility.Add_Child_Node
1217: Ja_Cn_Utility.Add_Child_Node
1218: ( pv_child_tag_name => 'FUNCTIONAL_CURRENCY'
1219: , pv_text_node_value => NULL
1220: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1221: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1222: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1223: );
1224: Ja_Cn_Utility.Add_Child_Node
1225: ( pv_child_tag_name => 'ORIGINAL_VALUE'
1218: ( pv_child_tag_name => 'FUNCTIONAL_CURRENCY'
1219: , pv_text_node_value => NULL
1220: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1221: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1222: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1223: );
1224: Ja_Cn_Utility.Add_Child_Node
1225: ( pv_child_tag_name => 'ORIGINAL_VALUE'
1226: , pv_text_node_value => NULL
1220: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1221: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1222: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1223: );
1224: Ja_Cn_Utility.Add_Child_Node
1225: ( pv_child_tag_name => 'ORIGINAL_VALUE'
1226: , pv_text_node_value => NULL
1227: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1228: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1223: );
1224: Ja_Cn_Utility.Add_Child_Node
1225: ( pv_child_tag_name => 'ORIGINAL_VALUE'
1226: , pv_text_node_value => NULL
1227: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1228: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1229: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1230: );
1231: Ja_Cn_Utility.Add_Child_Node
1224: Ja_Cn_Utility.Add_Child_Node
1225: ( pv_child_tag_name => 'ORIGINAL_VALUE'
1226: , pv_text_node_value => NULL
1227: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1228: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1229: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1230: );
1231: Ja_Cn_Utility.Add_Child_Node
1232: ( pv_child_tag_name => 'NET_BOOK_VALUE'
1225: ( pv_child_tag_name => 'ORIGINAL_VALUE'
1226: , pv_text_node_value => NULL
1227: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1228: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1229: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1230: );
1231: Ja_Cn_Utility.Add_Child_Node
1232: ( pv_child_tag_name => 'NET_BOOK_VALUE'
1233: , pv_text_node_value => NULL
1227: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1228: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1229: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1230: );
1231: Ja_Cn_Utility.Add_Child_Node
1232: ( pv_child_tag_name => 'NET_BOOK_VALUE'
1233: , pv_text_node_value => NULL
1234: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1235: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1230: );
1231: Ja_Cn_Utility.Add_Child_Node
1232: ( pv_child_tag_name => 'NET_BOOK_VALUE'
1233: , pv_text_node_value => NULL
1234: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1235: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1236: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1237: );
1238: JA_CN_UTILITY.Add_Child_Node
1231: Ja_Cn_Utility.Add_Child_Node
1232: ( pv_child_tag_name => 'NET_BOOK_VALUE'
1233: , pv_text_node_value => NULL
1234: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1235: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1236: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1237: );
1238: JA_CN_UTILITY.Add_Child_Node
1239: ( pv_child_tag_name => 'FIXED_ASSET_VOUCHER_NUMBER'
1232: ( pv_child_tag_name => 'NET_BOOK_VALUE'
1233: , pv_text_node_value => NULL
1234: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1235: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1236: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1237: );
1238: JA_CN_UTILITY.Add_Child_Node
1239: ( pv_child_tag_name => 'FIXED_ASSET_VOUCHER_NUMBER'
1240: , pv_text_node_value => NULL
1234: , pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER
1235: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1236: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1237: );
1238: JA_CN_UTILITY.Add_Child_Node
1239: ( pv_child_tag_name => 'FIXED_ASSET_VOUCHER_NUMBER'
1240: , pv_text_node_value => NULL
1241: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1242: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1237: );
1238: JA_CN_UTILITY.Add_Child_Node
1239: ( pv_child_tag_name => 'FIXED_ASSET_VOUCHER_NUMBER'
1240: , pv_text_node_value => NULL
1241: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1242: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1243: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1244: );
1245: Ja_Cn_Utility.Add_Sub_Root_Node
1238: JA_CN_UTILITY.Add_Child_Node
1239: ( pv_child_tag_name => 'FIXED_ASSET_VOUCHER_NUMBER'
1240: , pv_text_node_value => NULL
1241: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1242: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1243: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1244: );
1245: Ja_Cn_Utility.Add_Sub_Root_Node
1246: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1239: ( pv_child_tag_name => 'FIXED_ASSET_VOUCHER_NUMBER'
1240: , pv_text_node_value => NULL
1241: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1242: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1243: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1244: );
1245: Ja_Cn_Utility.Add_Sub_Root_Node
1246: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1247: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
1241: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
1242: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
1243: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1244: );
1245: Ja_Cn_Utility.Add_Sub_Root_Node
1246: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1247: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
1248: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1249: );
1243: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1244: );
1245: Ja_Cn_Utility.Add_Sub_Root_Node
1246: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1247: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
1248: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1249: );
1250: END IF; --(ln_row_count = 0)
1251: --logging for debug
1244: );
1245: Ja_Cn_Utility.Add_Sub_Root_Node
1246: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD'
1247: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
1248: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
1249: );
1250: END IF; --(ln_row_count = 0)
1251: --logging for debug
1252: IF (ln_proc_level>=ln_dbg_level)