135: END LOOP;
136: CLOSE fa_export_period_cur;
137: --Add the IF statement and the logic by Jiancao Chi for bug 11847991 on 2011-03-09
138: IF (ln_row_count = 0) THEN
139: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_CARD_USAGE_INFO',
140: Ja_Cn_Utility.GV_MODULE_FA);
141:
142: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
143: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
136: CLOSE fa_export_period_cur;
137: --Add the IF statement and the logic by Jiancao Chi for bug 11847991 on 2011-03-09
138: IF (ln_row_count = 0) THEN
139: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_CARD_USAGE_INFO',
140: Ja_Cn_Utility.GV_MODULE_FA);
141:
142: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
143: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
144: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
138: IF (ln_row_count = 0) THEN
139: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_CARD_USAGE_INFO',
140: Ja_Cn_Utility.GV_MODULE_FA);
141:
142: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
143: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
144: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
145: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
146: pv_text_node_value => NULL,
139: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_CARD_USAGE_INFO',
140: Ja_Cn_Utility.GV_MODULE_FA);
141:
142: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
143: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
144: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
145: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
146: pv_text_node_value => NULL,
147: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
140: Ja_Cn_Utility.GV_MODULE_FA);
141:
142: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
143: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
144: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
145: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
146: pv_text_node_value => NULL,
147: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
148: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
141:
142: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
143: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
144: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
145: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
146: pv_text_node_value => NULL,
147: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
148: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
149: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
143: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
144: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
145: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
146: pv_text_node_value => NULL,
147: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
148: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
149: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
150: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
151: pv_text_node_value => NULL,
144: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
145: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
146: pv_text_node_value => NULL,
147: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
148: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
149: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
150: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
151: pv_text_node_value => NULL,
152: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
145: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
146: pv_text_node_value => NULL,
147: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
148: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
149: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
150: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
151: pv_text_node_value => NULL,
152: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
153: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
146: pv_text_node_value => NULL,
147: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
148: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
149: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
150: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
151: pv_text_node_value => NULL,
152: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
153: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
154: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
148: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
149: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
150: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
151: pv_text_node_value => NULL,
152: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
153: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
154: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
155: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
156: pv_text_node_value => NULL,
149: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
150: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
151: pv_text_node_value => NULL,
152: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
153: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
154: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
155: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
156: pv_text_node_value => NULL,
157: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
150: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
151: pv_text_node_value => NULL,
152: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
153: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
154: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
155: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
156: pv_text_node_value => NULL,
157: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
158: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
151: pv_text_node_value => NULL,
152: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
153: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
154: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
155: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
156: pv_text_node_value => NULL,
157: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
158: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
159: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
153: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
154: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
155: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
156: pv_text_node_value => NULL,
157: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
158: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
159: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
160: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
161: pv_text_node_value => NULL,
154: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
155: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
156: pv_text_node_value => NULL,
157: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
158: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
159: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
160: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
161: pv_text_node_value => NULL,
162: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
155: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
156: pv_text_node_value => NULL,
157: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
158: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
159: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
160: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
161: pv_text_node_value => NULL,
162: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
163: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
156: pv_text_node_value => NULL,
157: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
158: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
159: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
160: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
161: pv_text_node_value => NULL,
162: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
163: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
164: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
158: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
159: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
160: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
161: pv_text_node_value => NULL,
162: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
163: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
164: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
165: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
166: pv_text_node_value => NULL,
159: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
160: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
161: pv_text_node_value => NULL,
162: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
163: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
164: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
165: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
166: pv_text_node_value => NULL,
167: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
160: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
161: pv_text_node_value => NULL,
162: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
163: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
164: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
165: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
166: pv_text_node_value => NULL,
167: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
168: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
161: pv_text_node_value => NULL,
162: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
163: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
164: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
165: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
166: pv_text_node_value => NULL,
167: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
168: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
169: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
163: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
164: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
165: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
166: pv_text_node_value => NULL,
167: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
168: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
169: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
170: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
171: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
164: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
165: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
166: pv_text_node_value => NULL,
167: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
168: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
169: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
170: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
171: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
172: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
165: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
166: pv_text_node_value => NULL,
167: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
168: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
169: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
170: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
171: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
172: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
173: END IF; --IF (ln_row_count = 0)
166: pv_text_node_value => NULL,
167: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
168: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
169: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
170: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
171: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
172: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
173: END IF; --IF (ln_row_count = 0)
174: --logging for debug
167: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
168: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
169: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
170: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
171: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
172: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
173: END IF; --IF (ln_row_count = 0)
174: --logging for debug
175: IF (ln_proc_level >= ln_dbg_level) THEN
168: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
169: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
170: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
171: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
172: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
173: END IF; --IF (ln_row_count = 0)
174: --logging for debug
175: IF (ln_proc_level >= ln_dbg_level) THEN
176: FND_LOG.STRING(ln_proc_level,
624: ln_dep_prorate := ln_assignment_unit / ln_asset_unit;
625: ln_acc_dep_prorate := ln_acc_dep_prorate + ln_dep_prorate;
626: END IF;
627:
628: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
629: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
630: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
631: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
632: pv_text_node_value => lv_asset_number,
625: ln_acc_dep_prorate := ln_acc_dep_prorate + ln_dep_prorate;
626: END IF;
627:
628: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
629: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
630: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
631: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
632: pv_text_node_value => lv_asset_number,
633: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
626: END IF;
627:
628: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
629: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
630: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
631: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
632: pv_text_node_value => lv_asset_number,
633: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
634: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
627:
628: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
629: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
630: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
631: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
632: pv_text_node_value => lv_asset_number,
633: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
634: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
635: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
629: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
630: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
631: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
632: pv_text_node_value => lv_asset_number,
633: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
634: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
635: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
636: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
637: pv_text_node_value => lv_tag_number,
630: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
631: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
632: pv_text_node_value => lv_asset_number,
633: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
634: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
635: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
636: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
637: pv_text_node_value => lv_tag_number,
638: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
631: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
632: pv_text_node_value => lv_asset_number,
633: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
634: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
635: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
636: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
637: pv_text_node_value => lv_tag_number,
638: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
639: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
632: pv_text_node_value => lv_asset_number,
633: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
634: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
635: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
636: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
637: pv_text_node_value => lv_tag_number,
638: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
639: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
640: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
634: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
635: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
636: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
637: pv_text_node_value => lv_tag_number,
638: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
639: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
640: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
641: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
642: pv_text_node_value => lv_period_name,
635: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
636: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
637: pv_text_node_value => lv_tag_number,
638: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
639: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
640: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
641: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
642: pv_text_node_value => lv_period_name,
643: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
636: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
637: pv_text_node_value => lv_tag_number,
638: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
639: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
640: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
641: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
642: pv_text_node_value => lv_period_name,
643: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
644: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
637: pv_text_node_value => lv_tag_number,
638: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
639: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
640: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
641: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
642: pv_text_node_value => lv_period_name,
643: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
644: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
645: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
639: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
640: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
641: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
642: pv_text_node_value => lv_period_name,
643: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
644: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
645: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
646: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
647: pv_text_node_value => lv_organization,
640: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
641: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
642: pv_text_node_value => lv_period_name,
643: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
644: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
645: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
646: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
647: pv_text_node_value => lv_organization,
648: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
641: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
642: pv_text_node_value => lv_period_name,
643: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
644: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
645: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
646: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
647: pv_text_node_value => lv_organization,
648: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
649: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
642: pv_text_node_value => lv_period_name,
643: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
644: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
645: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
646: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
647: pv_text_node_value => lv_organization,
648: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
649: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
650: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
644: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
645: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
646: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
647: pv_text_node_value => lv_organization,
648: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
649: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
650: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
651: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
652: pv_text_node_value => ln_dep_prorate,
645: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
646: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
647: pv_text_node_value => lv_organization,
648: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
649: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
650: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
651: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
652: pv_text_node_value => ln_dep_prorate,
653: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
646: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
647: pv_text_node_value => lv_organization,
648: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
649: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
650: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
651: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
652: pv_text_node_value => ln_dep_prorate,
653: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
654: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
647: pv_text_node_value => lv_organization,
648: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
649: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
650: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
651: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
652: pv_text_node_value => ln_dep_prorate,
653: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
654: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
655: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
649: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
650: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
651: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
652: pv_text_node_value => ln_dep_prorate,
653: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
654: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
655: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
656: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
657: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
650: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
651: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
652: pv_text_node_value => ln_dep_prorate,
653: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
654: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
655: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
656: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
657: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
658: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
651: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
652: pv_text_node_value => ln_dep_prorate,
653: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
654: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
655: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
656: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
657: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
658: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
659: END LOOP;
652: pv_text_node_value => ln_dep_prorate,
653: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
654: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
655: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
656: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
657: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
658: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
659: END LOOP;
660: CLOSE fa_assignment_cur;
653: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
654: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
655: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
656: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
657: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
658: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
659: END LOOP;
660: CLOSE fa_assignment_cur;
661: END IF; -- (lb_retirement_flag = FALSE)
654: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
655: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
656: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
657: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
658: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
659: END LOOP;
660: CLOSE fa_assignment_cur;
661: END IF; -- (lb_retirement_flag = FALSE)
662: END LOOP;
663: CLOSE fa_usage_info_cur;
664:
665: /*IF (ln_row_count = 0) THEN --Commented by Jianchao Chi for bug 11847991
666:
667: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_CARD_USAGE_INFO',
668: Ja_Cn_Utility.GV_MODULE_FA);
669:
670: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
671: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
664:
665: /*IF (ln_row_count = 0) THEN --Commented by Jianchao Chi for bug 11847991
666:
667: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_CARD_USAGE_INFO',
668: Ja_Cn_Utility.GV_MODULE_FA);
669:
670: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
671: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
672: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
666:
667: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_CARD_USAGE_INFO',
668: Ja_Cn_Utility.GV_MODULE_FA);
669:
670: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
671: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
672: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
673: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
674: pv_text_node_value => NULL,
667: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_CARD_USAGE_INFO',
668: Ja_Cn_Utility.GV_MODULE_FA);
669:
670: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
671: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
672: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
673: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
674: pv_text_node_value => NULL,
675: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
668: Ja_Cn_Utility.GV_MODULE_FA);
669:
670: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
671: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
672: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
673: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
674: pv_text_node_value => NULL,
675: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
676: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
669:
670: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
671: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
672: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
673: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
674: pv_text_node_value => NULL,
675: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
676: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
677: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
671: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
672: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
673: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
674: pv_text_node_value => NULL,
675: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
676: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
677: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
678: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
679: pv_text_node_value => NULL,
672: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
673: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
674: pv_text_node_value => NULL,
675: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
676: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
677: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
678: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
679: pv_text_node_value => NULL,
680: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
673: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
674: pv_text_node_value => NULL,
675: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
676: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
677: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
678: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
679: pv_text_node_value => NULL,
680: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
681: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
674: pv_text_node_value => NULL,
675: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
676: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
677: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
678: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
679: pv_text_node_value => NULL,
680: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
681: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
682: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
676: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
677: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
678: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
679: pv_text_node_value => NULL,
680: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
681: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
682: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
683: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
684: pv_text_node_value => NULL,
677: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
678: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
679: pv_text_node_value => NULL,
680: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
681: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
682: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
683: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
684: pv_text_node_value => NULL,
685: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
678: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
679: pv_text_node_value => NULL,
680: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
681: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
682: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
683: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
684: pv_text_node_value => NULL,
685: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
686: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
679: pv_text_node_value => NULL,
680: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
681: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
682: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
683: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
684: pv_text_node_value => NULL,
685: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
686: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
687: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
681: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
682: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
683: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
684: pv_text_node_value => NULL,
685: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
686: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
687: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
688: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
689: pv_text_node_value => NULL,
682: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
683: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
684: pv_text_node_value => NULL,
685: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
686: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
687: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
688: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
689: pv_text_node_value => NULL,
690: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
683: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
684: pv_text_node_value => NULL,
685: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
686: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
687: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
688: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
689: pv_text_node_value => NULL,
690: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
691: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
684: pv_text_node_value => NULL,
685: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
686: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
687: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
688: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
689: pv_text_node_value => NULL,
690: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
691: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
692: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
686: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
687: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
688: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
689: pv_text_node_value => NULL,
690: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
691: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
692: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
693: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
694: pv_text_node_value => NULL,
687: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
688: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
689: pv_text_node_value => NULL,
690: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
691: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
692: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
693: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
694: pv_text_node_value => NULL,
695: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
688: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_DEPARTMENT',
689: pv_text_node_value => NULL,
690: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
691: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
692: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
693: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
694: pv_text_node_value => NULL,
695: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
696: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
689: pv_text_node_value => NULL,
690: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
691: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
692: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
693: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
694: pv_text_node_value => NULL,
695: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
696: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
697: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
691: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
692: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
693: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
694: pv_text_node_value => NULL,
695: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
696: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
697: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
698: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
699: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
692: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
693: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
694: pv_text_node_value => NULL,
695: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
696: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
697: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
698: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
699: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
700: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
693: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'DEPRECIATION_PRORATE',
694: pv_text_node_value => NULL,
695: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
696: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
697: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
698: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
699: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
700: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
701: END IF; --(ln_row_count = 0)*/
694: pv_text_node_value => NULL,
695: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
696: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
697: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
698: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
699: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
700: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
701: END IF; --(ln_row_count = 0)*/
702: IF (ln_row_count = 0) THEN
695: pv_data_type => Ja_Cn_Utility.GV_TYPE_NUMBER,
696: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
697: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
698: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
699: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
700: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
701: END IF; --(ln_row_count = 0)*/
702: IF (ln_row_count = 0) THEN
703: --Added by Jianchao Chi for bug 11847991
696: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
697: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
698: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO',
699: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
700: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
701: END IF; --(ln_row_count = 0)*/
702: IF (ln_row_count = 0) THEN
703: --Added by Jianchao Chi for bug 11847991
704: RETURN 0;