199: || 'ld_end_date=' || ld_end_date
200: );
201:
202: --add to XML
203: JA_CN_UTILITY.Add_Sub_Root_Node( 'BASIC_INFO_OF_FIXED_ASSET'
204: , JA_CN_UTILITY.GV_TAG_TYPE_START
205: , JA_CN_UTILITY.GV_MODULE_FA
206: );
207: FOR v_row IN fixed_asset_account_cur( pn_legal_entity_id
200: );
201:
202: --add to XML
203: JA_CN_UTILITY.Add_Sub_Root_Node( 'BASIC_INFO_OF_FIXED_ASSET'
204: , JA_CN_UTILITY.GV_TAG_TYPE_START
205: , JA_CN_UTILITY.GV_MODULE_FA
206: );
207: FOR v_row IN fixed_asset_account_cur( pn_legal_entity_id
208: , pn_ledger_id
201:
202: --add to XML
203: JA_CN_UTILITY.Add_Sub_Root_Node( 'BASIC_INFO_OF_FIXED_ASSET'
204: , JA_CN_UTILITY.GV_TAG_TYPE_START
205: , JA_CN_UTILITY.GV_MODULE_FA
206: );
207: FOR v_row IN fixed_asset_account_cur( pn_legal_entity_id
208: , pn_ledger_id
209: , ld_start_date
212: LOOP
213: ln_cost_row_count := ln_cost_row_count + 1;
214: IF(v_row.asset_cost_acct IS NOT NULL)
215: THEN
216: JA_CN_UTILITY.Add_Child_Node( 'FIXED_ASSET_ACCOUNT'
217: , v_row.asset_cost_acct
218: , JA_CN_UTILITY.GV_TYPE_VARCHAR2
219: , JA_CN_UTILITY.GV_REQUIRED_YES
220: , JA_CN_UTILITY.GV_MODULE_FA
214: IF(v_row.asset_cost_acct IS NOT NULL)
215: THEN
216: JA_CN_UTILITY.Add_Child_Node( 'FIXED_ASSET_ACCOUNT'
217: , v_row.asset_cost_acct
218: , JA_CN_UTILITY.GV_TYPE_VARCHAR2
219: , JA_CN_UTILITY.GV_REQUIRED_YES
220: , JA_CN_UTILITY.GV_MODULE_FA
221: );
222: END IF; --(fixed_asset_account_row.asset_cost_acct IS NOT NULL)
215: THEN
216: JA_CN_UTILITY.Add_Child_Node( 'FIXED_ASSET_ACCOUNT'
217: , v_row.asset_cost_acct
218: , JA_CN_UTILITY.GV_TYPE_VARCHAR2
219: , JA_CN_UTILITY.GV_REQUIRED_YES
220: , JA_CN_UTILITY.GV_MODULE_FA
221: );
222: END IF; --(fixed_asset_account_row.asset_cost_acct IS NOT NULL)
223: END LOOP; --fixed_asset_account_row IN fixed_asset_account_cur
216: JA_CN_UTILITY.Add_Child_Node( 'FIXED_ASSET_ACCOUNT'
217: , v_row.asset_cost_acct
218: , JA_CN_UTILITY.GV_TYPE_VARCHAR2
219: , JA_CN_UTILITY.GV_REQUIRED_YES
220: , JA_CN_UTILITY.GV_MODULE_FA
221: );
222: END IF; --(fixed_asset_account_row.asset_cost_acct IS NOT NULL)
223: END LOOP; --fixed_asset_account_row IN fixed_asset_account_cur
224:
223: END LOOP; --fixed_asset_account_row IN fixed_asset_account_cur
224:
225: IF(ln_cost_row_count = 0)
226: THEN
227: JA_CN_UTILITY.Add_Child_Node( 'FIXED_ASSET_ACCOUNT'
228: , NULL
229: , JA_CN_UTILITY.GV_TYPE_VARCHAR2
230: , JA_CN_UTILITY.GV_REQUIRED_YES
231: , JA_CN_UTILITY.GV_MODULE_FA
225: IF(ln_cost_row_count = 0)
226: THEN
227: JA_CN_UTILITY.Add_Child_Node( 'FIXED_ASSET_ACCOUNT'
228: , NULL
229: , JA_CN_UTILITY.GV_TYPE_VARCHAR2
230: , JA_CN_UTILITY.GV_REQUIRED_YES
231: , JA_CN_UTILITY.GV_MODULE_FA
232: );
233: END IF; --(ln_cost_row_count = 0)
226: THEN
227: JA_CN_UTILITY.Add_Child_Node( 'FIXED_ASSET_ACCOUNT'
228: , NULL
229: , JA_CN_UTILITY.GV_TYPE_VARCHAR2
230: , JA_CN_UTILITY.GV_REQUIRED_YES
231: , JA_CN_UTILITY.GV_MODULE_FA
232: );
233: END IF; --(ln_cost_row_count = 0)
234: JA_CN_UTILITY.Add_Sub_Root_Node( 'BASIC_INFO_OF_FIXED_ASSET'
227: JA_CN_UTILITY.Add_Child_Node( 'FIXED_ASSET_ACCOUNT'
228: , NULL
229: , JA_CN_UTILITY.GV_TYPE_VARCHAR2
230: , JA_CN_UTILITY.GV_REQUIRED_YES
231: , JA_CN_UTILITY.GV_MODULE_FA
232: );
233: END IF; --(ln_cost_row_count = 0)
234: JA_CN_UTILITY.Add_Sub_Root_Node( 'BASIC_INFO_OF_FIXED_ASSET'
235: , JA_CN_UTILITY.GV_TAG_TYPE_END
230: , JA_CN_UTILITY.GV_REQUIRED_YES
231: , JA_CN_UTILITY.GV_MODULE_FA
232: );
233: END IF; --(ln_cost_row_count = 0)
234: JA_CN_UTILITY.Add_Sub_Root_Node( 'BASIC_INFO_OF_FIXED_ASSET'
235: , JA_CN_UTILITY.GV_TAG_TYPE_END
236: , JA_CN_UTILITY.GV_MODULE_FA
237: );
238:
231: , JA_CN_UTILITY.GV_MODULE_FA
232: );
233: END IF; --(ln_cost_row_count = 0)
234: JA_CN_UTILITY.Add_Sub_Root_Node( 'BASIC_INFO_OF_FIXED_ASSET'
235: , JA_CN_UTILITY.GV_TAG_TYPE_END
236: , JA_CN_UTILITY.GV_MODULE_FA
237: );
238:
239:
232: );
233: END IF; --(ln_cost_row_count = 0)
234: JA_CN_UTILITY.Add_Sub_Root_Node( 'BASIC_INFO_OF_FIXED_ASSET'
235: , JA_CN_UTILITY.GV_TAG_TYPE_END
236: , JA_CN_UTILITY.GV_MODULE_FA
237: );
238:
239:
240: --logging for debug