95: , lv_depr_method_name
96: , lv_depr_method_formular;
97: EXIT WHEN depreciation_history_cur%NOTFOUND;
98: ln_row_count := ln_row_count + 1;
99: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
100: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
101: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
102: );
103: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_CODE'
96: , lv_depr_method_formular;
97: EXIT WHEN depreciation_history_cur%NOTFOUND;
98: ln_row_count := ln_row_count + 1;
99: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
100: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
101: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
102: );
103: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_CODE'
104: , pv_text_node_value => lv_depr_method_code
97: EXIT WHEN depreciation_history_cur%NOTFOUND;
98: ln_row_count := ln_row_count + 1;
99: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
100: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
101: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
102: );
103: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_CODE'
104: , pv_text_node_value => lv_depr_method_code
105: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
99: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
100: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
101: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
102: );
103: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_CODE'
104: , pv_text_node_value => lv_depr_method_code
105: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
106: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
107: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
101: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
102: );
103: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_CODE'
104: , pv_text_node_value => lv_depr_method_code
105: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
106: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
107: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
108: );
109: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_NAME'
102: );
103: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_CODE'
104: , pv_text_node_value => lv_depr_method_code
105: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
106: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
107: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
108: );
109: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_NAME'
110: , pv_text_node_value => lv_depr_method_name
103: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_CODE'
104: , pv_text_node_value => lv_depr_method_code
105: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
106: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
107: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
108: );
109: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_NAME'
110: , pv_text_node_value => lv_depr_method_name
111: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
105: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
106: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
107: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
108: );
109: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_NAME'
110: , pv_text_node_value => lv_depr_method_name
111: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
112: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
113: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
107: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
108: );
109: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_NAME'
110: , pv_text_node_value => lv_depr_method_name
111: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
112: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
113: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
114: );
115:
108: );
109: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_NAME'
110: , pv_text_node_value => lv_depr_method_name
111: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
112: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
113: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
114: );
115:
116: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_FORMULA'
109: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_NAME'
110: , pv_text_node_value => lv_depr_method_name
111: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
112: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
113: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
114: );
115:
116: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_FORMULA'
117: , pv_text_node_value => lv_depr_method_formular
112: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
113: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
114: );
115:
116: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_FORMULA'
117: , pv_text_node_value => lv_depr_method_formular
118: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
119: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
120: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
114: );
115:
116: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_FORMULA'
117: , pv_text_node_value => lv_depr_method_formular
118: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
119: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
120: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
121: );
122: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
115:
116: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_FORMULA'
117: , pv_text_node_value => lv_depr_method_formular
118: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
119: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
120: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
121: );
122: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
123: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
116: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_FORMULA'
117: , pv_text_node_value => lv_depr_method_formular
118: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
119: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
120: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
121: );
122: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
123: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
124: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
118: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
119: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
120: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
121: );
122: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
123: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
124: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
125: );
126:
119: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
120: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
121: );
122: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
123: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
124: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
125: );
126:
127: END LOOP;
120: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
121: );
122: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
123: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
124: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
125: );
126:
127: END LOOP;
128: CLOSE depreciation_history_cur;
129:
130: IF (ln_row_count = 0)
131: THEN
132:
133: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_DEPRN_METHOD',
134: Ja_Cn_Utility.GV_MODULE_FA);
135:
136: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
137: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
130: IF (ln_row_count = 0)
131: THEN
132:
133: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_DEPRN_METHOD',
134: Ja_Cn_Utility.GV_MODULE_FA);
135:
136: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
137: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
138: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
132:
133: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_DEPRN_METHOD',
134: Ja_Cn_Utility.GV_MODULE_FA);
135:
136: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
137: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
138: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
139: );
140: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_CODE'
133: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_DEPRN_METHOD',
134: Ja_Cn_Utility.GV_MODULE_FA);
135:
136: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
137: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
138: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
139: );
140: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_CODE'
141: , pv_text_node_value => NULL
134: Ja_Cn_Utility.GV_MODULE_FA);
135:
136: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
137: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
138: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
139: );
140: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_CODE'
141: , pv_text_node_value => NULL
142: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
136: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
137: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
138: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
139: );
140: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_CODE'
141: , pv_text_node_value => NULL
142: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
143: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
144: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
138: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
139: );
140: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_CODE'
141: , pv_text_node_value => NULL
142: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
143: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
144: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
145: );
146: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_NAME'
139: );
140: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_CODE'
141: , pv_text_node_value => NULL
142: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
143: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
144: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
145: );
146: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_NAME'
147: , pv_text_node_value => NULL
140: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_CODE'
141: , pv_text_node_value => NULL
142: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
143: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
144: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
145: );
146: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_NAME'
147: , pv_text_node_value => NULL
148: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
142: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
143: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
144: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
145: );
146: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_NAME'
147: , pv_text_node_value => NULL
148: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
149: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
150: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
144: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
145: );
146: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_NAME'
147: , pv_text_node_value => NULL
148: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
149: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
150: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
151: );
152:
145: );
146: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_NAME'
147: , pv_text_node_value => NULL
148: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
149: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
150: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
151: );
152:
153: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_FORMULA'
146: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_METHOD_NAME'
147: , pv_text_node_value => NULL
148: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
149: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
150: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
151: );
152:
153: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_FORMULA'
154: , pv_text_node_value => NULL
149: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
150: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
151: );
152:
153: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_FORMULA'
154: , pv_text_node_value => NULL
155: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
156: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
157: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
151: );
152:
153: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_FORMULA'
154: , pv_text_node_value => NULL
155: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
156: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
157: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
158: );
159: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
152:
153: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_FORMULA'
154: , pv_text_node_value => NULL
155: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
156: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
157: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
158: );
159: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
160: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
153: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'DEPRECIATION_FORMULA'
154: , pv_text_node_value => NULL
155: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
156: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
157: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
158: );
159: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
160: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
161: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
155: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
156: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
157: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
158: );
159: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
160: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
161: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
162: );
163: END IF; --(ln_row_count = 0)
156: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
157: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
158: );
159: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
160: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
161: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
162: );
163: END IF; --(ln_row_count = 0)
164:
157: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
158: );
159: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_DEPRN_METHOD'
160: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
161: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
162: );
163: END IF; --(ln_row_count = 0)
164:
165: --logging for debug