136: CLOSE fa_export_period_cur;
137:
138: --Add the IF statement and the logic by Jiancao Chi for bug 11847991 on 2011-03-09
139: IF (ln_row_count = 0) THEN
140: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_CARD-REAL_ASE_INFO',
141: Ja_Cn_Utility.GV_MODULE_FA);
142:
143: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
144: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
137:
138: --Add the IF statement and the logic by Jiancao Chi for bug 11847991 on 2011-03-09
139: IF (ln_row_count = 0) THEN
140: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_CARD-REAL_ASE_INFO',
141: Ja_Cn_Utility.GV_MODULE_FA);
142:
143: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
144: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
145: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
139: IF (ln_row_count = 0) THEN
140: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_CARD-REAL_ASE_INFO',
141: Ja_Cn_Utility.GV_MODULE_FA);
142:
143: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
144: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
145: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
146: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
147: pv_text_node_value => NULL,
140: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_CARD-REAL_ASE_INFO',
141: Ja_Cn_Utility.GV_MODULE_FA);
142:
143: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
144: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
145: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
146: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
147: pv_text_node_value => NULL,
148: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
141: Ja_Cn_Utility.GV_MODULE_FA);
142:
143: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
144: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
145: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
146: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
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,
142:
143: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
144: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
145: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
146: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
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_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
145: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
146: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
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: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
152: pv_text_node_value => NULL,
145: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
146: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
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: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
152: pv_text_node_value => NULL,
153: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
146: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
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: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
152: pv_text_node_value => NULL,
153: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
154: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
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: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
152: pv_text_node_value => NULL,
153: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
154: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
155: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
149: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
150: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
151: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
152: pv_text_node_value => NULL,
153: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
154: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
155: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
156: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
157: pv_text_node_value => NULL,
150: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
151: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
152: pv_text_node_value => NULL,
153: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
154: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
155: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
156: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
157: pv_text_node_value => NULL,
158: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
151: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
152: pv_text_node_value => NULL,
153: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
154: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
155: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
156: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
157: pv_text_node_value => NULL,
158: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
159: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
152: pv_text_node_value => NULL,
153: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
154: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
155: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
156: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
157: pv_text_node_value => NULL,
158: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
159: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
160: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
154: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
155: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
156: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
157: pv_text_node_value => NULL,
158: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
159: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
160: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
161: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_LOCATION',
162: pv_text_node_value => NULL,
155: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
156: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
157: pv_text_node_value => NULL,
158: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
159: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
160: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
161: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_LOCATION',
162: pv_text_node_value => NULL,
163: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
156: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
157: pv_text_node_value => NULL,
158: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
159: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
160: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
161: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_LOCATION',
162: pv_text_node_value => NULL,
163: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
164: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO,
157: pv_text_node_value => NULL,
158: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
159: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
160: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
161: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_LOCATION',
162: pv_text_node_value => NULL,
163: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
164: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO,
165: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
159: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
160: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
161: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_LOCATION',
162: pv_text_node_value => NULL,
163: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
164: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO,
165: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
166: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_MODEL',
167: pv_text_node_value => NULL,
160: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
161: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_LOCATION',
162: pv_text_node_value => NULL,
163: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
164: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO,
165: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
166: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_MODEL',
167: pv_text_node_value => NULL,
168: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
161: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_LOCATION',
162: pv_text_node_value => NULL,
163: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
164: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO,
165: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
166: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_MODEL',
167: pv_text_node_value => NULL,
168: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
169: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
162: pv_text_node_value => NULL,
163: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
164: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO,
165: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
166: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_MODEL',
167: pv_text_node_value => NULL,
168: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
169: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
170: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
164: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO,
165: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
166: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_MODEL',
167: pv_text_node_value => NULL,
168: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
169: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
170: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
171: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
172: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
165: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
166: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_MODEL',
167: pv_text_node_value => NULL,
168: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
169: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
170: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
171: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
172: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
173: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
166: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_MODEL',
167: pv_text_node_value => NULL,
168: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
169: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
170: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
171: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
172: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
173: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
174: END IF; --IF (ln_row_count = 0)
167: pv_text_node_value => NULL,
168: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
169: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
170: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
171: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
172: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
173: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
174: END IF; --IF (ln_row_count = 0)
175: --logging for debug
168: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
169: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
170: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
171: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
172: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
173: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
174: END IF; --IF (ln_row_count = 0)
175: --logging for debug
176: IF (ln_proc_level >= ln_dbg_level) THEN
169: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
170: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
171: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
172: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
173: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
174: END IF; --IF (ln_row_count = 0)
175: --logging for debug
176: IF (ln_proc_level >= ln_dbg_level) THEN
177: FND_LOG.STRING(ln_proc_level,
479:
480: IF (lb_retirement_flag = FALSE) THEN
481: ln_row_count := ln_row_count + 1;
482:
483: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
484: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
485: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
486: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
487: pv_text_node_value => lv_asset_number,
480: IF (lb_retirement_flag = FALSE) THEN
481: ln_row_count := ln_row_count + 1;
482:
483: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
484: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
485: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
486: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
487: pv_text_node_value => lv_asset_number,
488: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
481: ln_row_count := ln_row_count + 1;
482:
483: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
484: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
485: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
486: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
487: pv_text_node_value => lv_asset_number,
488: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
489: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
482:
483: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
484: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
485: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
486: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
487: pv_text_node_value => lv_asset_number,
488: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
489: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
490: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
484: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START,
485: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
486: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
487: pv_text_node_value => lv_asset_number,
488: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
489: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
490: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
491: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
492: pv_text_node_value => ln_period_num,
485: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
486: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
487: pv_text_node_value => lv_asset_number,
488: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
489: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
490: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
491: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
492: pv_text_node_value => ln_period_num,
493: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
486: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER',
487: pv_text_node_value => lv_asset_number,
488: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
489: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
490: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
491: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
492: pv_text_node_value => ln_period_num,
493: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
494: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
487: pv_text_node_value => lv_asset_number,
488: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
489: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
490: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
491: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
492: pv_text_node_value => ln_period_num,
493: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
494: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
495: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
489: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
490: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
491: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
492: pv_text_node_value => ln_period_num,
493: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
494: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
495: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
496: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
497: pv_text_node_value => lv_tag_number,
490: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
491: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
492: pv_text_node_value => ln_period_num,
493: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
494: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
495: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
496: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
497: pv_text_node_value => lv_tag_number,
498: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
491: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'ACCOUNTING_PERIOD',
492: pv_text_node_value => ln_period_num,
493: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
494: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
495: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
496: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
497: pv_text_node_value => lv_tag_number,
498: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
499: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
492: pv_text_node_value => ln_period_num,
493: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
494: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
495: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
496: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
497: pv_text_node_value => lv_tag_number,
498: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
499: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
500: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
494: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
495: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
496: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
497: pv_text_node_value => lv_tag_number,
498: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
499: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
500: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
501: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_LOCATION',
502: pv_text_node_value => lv_location,
495: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
496: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
497: pv_text_node_value => lv_tag_number,
498: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
499: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
500: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
501: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_LOCATION',
502: pv_text_node_value => lv_location,
503: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
496: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER',
497: pv_text_node_value => lv_tag_number,
498: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
499: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
500: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
501: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_LOCATION',
502: pv_text_node_value => lv_location,
503: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
504: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO,
497: pv_text_node_value => lv_tag_number,
498: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
499: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
500: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
501: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_LOCATION',
502: pv_text_node_value => lv_location,
503: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
504: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO,
505: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
499: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
500: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
501: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_LOCATION',
502: pv_text_node_value => lv_location,
503: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
504: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO,
505: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
506: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_MODEL',
507: pv_text_node_value => lv_model_number,
500: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
501: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_LOCATION',
502: pv_text_node_value => lv_location,
503: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
504: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO,
505: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
506: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_MODEL',
507: pv_text_node_value => lv_model_number,
508: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
501: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_LOCATION',
502: pv_text_node_value => lv_location,
503: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
504: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO,
505: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
506: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_MODEL',
507: pv_text_node_value => lv_model_number,
508: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
509: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
502: pv_text_node_value => lv_location,
503: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
504: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO,
505: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
506: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_MODEL',
507: pv_text_node_value => lv_model_number,
508: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
509: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
510: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
504: pv_required => Ja_Cn_Utility.GV_REQUIRED_NO,
505: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
506: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_MODEL',
507: pv_text_node_value => lv_model_number,
508: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
509: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
510: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
511: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
512: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
505: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
506: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_MODEL',
507: pv_text_node_value => lv_model_number,
508: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
509: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
510: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
511: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
512: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
513: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
506: Ja_Cn_Utility.Add_Child_Node(pv_child_tag_name => 'FIXED_ASSET_MODEL',
507: pv_text_node_value => lv_model_number,
508: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
509: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
510: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
511: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
512: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
513: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
514: END IF; -- (lb_retirement_flag = FALSE)
507: pv_text_node_value => lv_model_number,
508: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
509: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
510: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
511: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
512: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
513: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
514: END IF; -- (lb_retirement_flag = FALSE)
515: END LOOP;
508: pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2,
509: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
510: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
511: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
512: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
513: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
514: END IF; -- (lb_retirement_flag = FALSE)
515: END LOOP;
516: CLOSE fa_usage_information_cur;
509: pv_required => Ja_Cn_Utility.GV_REQUIRED_YES,
510: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
511: Ja_Cn_Utility.Add_Sub_Root_Node(pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO',
512: pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END,
513: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
514: END IF; -- (lb_retirement_flag = FALSE)
515: END LOOP;
516: CLOSE fa_usage_information_cur;
517:
517:
518: /*IF (ln_row_count = 0)--Commented by Jianchao Chi for bug 11847991
519: THEN
520:
521: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_CARD-REAL_ASE_INFO',
522: Ja_Cn_Utility.GV_MODULE_FA);
523:
524: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO'
525: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
518: /*IF (ln_row_count = 0)--Commented by Jianchao Chi for bug 11847991
519: THEN
520:
521: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_CARD-REAL_ASE_INFO',
522: Ja_Cn_Utility.GV_MODULE_FA);
523:
524: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO'
525: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
526: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
520:
521: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_CARD-REAL_ASE_INFO',
522: Ja_Cn_Utility.GV_MODULE_FA);
523:
524: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO'
525: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
526: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
527: );
528: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
521: Ja_Cn_Utility.Print_No_Data_Found_For_Log('FIXED_ASSET_CARD-REAL_ASE_INFO',
522: Ja_Cn_Utility.GV_MODULE_FA);
523:
524: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO'
525: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
526: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
527: );
528: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
529: , pv_text_node_value => NULL
522: Ja_Cn_Utility.GV_MODULE_FA);
523:
524: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO'
525: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
526: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
527: );
528: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
529: , pv_text_node_value => NULL
530: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
524: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO'
525: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
526: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
527: );
528: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
529: , pv_text_node_value => NULL
530: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
531: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
532: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
526: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
527: );
528: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
529: , pv_text_node_value => NULL
530: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
531: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
532: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
533: );
534: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'ACCOUNTING_PERIOD'
527: );
528: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
529: , pv_text_node_value => NULL
530: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
531: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
532: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
533: );
534: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'ACCOUNTING_PERIOD'
535: , pv_text_node_value => NULL
528: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
529: , pv_text_node_value => NULL
530: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
531: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
532: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
533: );
534: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'ACCOUNTING_PERIOD'
535: , pv_text_node_value => NULL
536: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
530: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
531: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
532: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
533: );
534: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'ACCOUNTING_PERIOD'
535: , pv_text_node_value => NULL
536: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
537: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
538: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
532: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
533: );
534: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'ACCOUNTING_PERIOD'
535: , pv_text_node_value => NULL
536: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
537: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
538: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
539: );
540: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
533: );
534: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'ACCOUNTING_PERIOD'
535: , pv_text_node_value => NULL
536: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
537: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
538: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
539: );
540: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
541: , pv_text_node_value => NULL
534: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'ACCOUNTING_PERIOD'
535: , pv_text_node_value => NULL
536: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
537: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
538: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
539: );
540: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
541: , pv_text_node_value => NULL
542: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
536: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
537: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
538: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
539: );
540: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
541: , pv_text_node_value => NULL
542: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
543: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
544: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
538: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
539: );
540: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
541: , pv_text_node_value => NULL
542: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
543: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
544: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
545: );
546: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_LOCATION'
539: );
540: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
541: , pv_text_node_value => NULL
542: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
543: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
544: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
545: );
546: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_LOCATION'
547: , pv_text_node_value => NULL
540: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
541: , pv_text_node_value => NULL
542: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
543: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
544: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
545: );
546: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_LOCATION'
547: , pv_text_node_value => NULL
548: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
542: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
543: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
544: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
545: );
546: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_LOCATION'
547: , pv_text_node_value => NULL
548: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
549: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
550: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
544: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
545: );
546: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_LOCATION'
547: , pv_text_node_value => NULL
548: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
549: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
550: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
551: );
552: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_MODEL'
545: );
546: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_LOCATION'
547: , pv_text_node_value => NULL
548: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
549: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
550: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
551: );
552: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_MODEL'
553: , pv_text_node_value => NULL
546: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_LOCATION'
547: , pv_text_node_value => NULL
548: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
549: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
550: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
551: );
552: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_MODEL'
553: , pv_text_node_value => NULL
554: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
548: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
549: , pv_required => Ja_Cn_Utility.GV_REQUIRED_NO
550: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
551: );
552: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_MODEL'
553: , pv_text_node_value => NULL
554: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
555: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
556: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
550: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
551: );
552: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_MODEL'
553: , pv_text_node_value => NULL
554: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
555: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
556: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
557: );
558: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO'
551: );
552: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_MODEL'
553: , pv_text_node_value => NULL
554: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
555: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
556: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
557: );
558: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO'
559: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
552: Ja_Cn_Utility.Add_Child_Node( pv_child_tag_name => 'FIXED_ASSET_MODEL'
553: , pv_text_node_value => NULL
554: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
555: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
556: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
557: );
558: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO'
559: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
560: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
554: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
555: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
556: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
557: );
558: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO'
559: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
560: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
561: );
562: END IF; --(ln_row_count = 0)*/
555: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
556: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
557: );
558: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO'
559: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
560: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
561: );
562: END IF; --(ln_row_count = 0)*/
563:
556: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
557: );
558: Ja_Cn_Utility.Add_Sub_Root_Node( pv_sub_root_tag_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO'
559: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
560: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
561: );
562: END IF; --(ln_row_count = 0)*/
563:
564: --logging for debug