275: OR fdh.date_ineffective IS NULL)
276: AND EXISTS
277: (SELECT jclllbg.bal_seg_value
278: FROM ja_cn_ledger_le_bsv_gt jclllbg
279: WHERE JA_CN_UTILITY.get_balancing_segment
280: (fdh.code_combination_id) = jclllbg.bal_seg_value
281: AND jclllbg.Ledger_Id = pn_ledger_id
282: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id)
283: -- Check the asset type
354: AND fdh.assigned_to IS NOT NULL
355: AND EXISTS
356: (SELECT jclllbg.bal_seg_value
357: FROM ja_cn_ledger_le_bsv_gt jclllbg
358: WHERE JA_CN_UTILITY.get_balancing_segment(fdh.code_combination_id) =
359: jclllbg.bal_seg_value
360: AND jclllbg.Ledger_Id = pn_ledger_id
361: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id)
362: AND ppf.business_group_id = paf.business_group_id
399: AND fdh.assigned_to IS NULL
400: AND EXISTS
401: (SELECT jclllbg.bal_seg_value
402: FROM ja_cn_ledger_le_bsv_gt jclllbg
403: WHERE JA_CN_UTILITY.get_balancing_segment(fdh.code_combination_id) =
404: jclllbg.bal_seg_value
405: AND jclllbg.Ledger_Id = pn_ledger_id
406: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id)
407: GROUP BY assigned_to;
654: END IF;
655: **/
656: ln_row_count := ln_row_count + 1;
657:
658: Ja_Cn_Utility.Add_Sub_Root_Node
659: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
660: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
661: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
662: );
656: ln_row_count := ln_row_count + 1;
657:
658: Ja_Cn_Utility.Add_Sub_Root_Node
659: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
660: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
661: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
662: );
663: Ja_Cn_Utility.Add_Child_Node
664: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
657:
658: Ja_Cn_Utility.Add_Sub_Root_Node
659: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
660: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
661: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
662: );
663: Ja_Cn_Utility.Add_Child_Node
664: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
665: , pv_text_node_value => lv_asset_number
659: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
660: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
661: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
662: );
663: Ja_Cn_Utility.Add_Child_Node
664: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
665: , pv_text_node_value => lv_asset_number
666: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
667: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
662: );
663: Ja_Cn_Utility.Add_Child_Node
664: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
665: , pv_text_node_value => lv_asset_number
666: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
667: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
668: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
669: );
670: Ja_Cn_Utility.Add_Child_Node
663: Ja_Cn_Utility.Add_Child_Node
664: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
665: , pv_text_node_value => lv_asset_number
666: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
667: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
668: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
669: );
670: Ja_Cn_Utility.Add_Child_Node
671: ( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
664: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
665: , pv_text_node_value => lv_asset_number
666: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
667: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
668: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
669: );
670: Ja_Cn_Utility.Add_Child_Node
671: ( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
672: , pv_text_node_value => lv_tag_number
666: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
667: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
668: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
669: );
670: Ja_Cn_Utility.Add_Child_Node
671: ( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
672: , pv_text_node_value => lv_tag_number
673: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
674: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
669: );
670: Ja_Cn_Utility.Add_Child_Node
671: ( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
672: , pv_text_node_value => lv_tag_number
673: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
674: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
675: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
676: );
677: Ja_Cn_Utility.Add_Child_Node
670: Ja_Cn_Utility.Add_Child_Node
671: ( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
672: , pv_text_node_value => lv_tag_number
673: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
674: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
675: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
676: );
677: Ja_Cn_Utility.Add_Child_Node
678: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
671: ( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
672: , pv_text_node_value => lv_tag_number
673: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
674: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
675: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
676: );
677: Ja_Cn_Utility.Add_Child_Node
678: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
679: , pv_text_node_value => lv_period_name
673: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
674: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
675: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
676: );
677: Ja_Cn_Utility.Add_Child_Node
678: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
679: , pv_text_node_value => lv_period_name
680: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
681: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
676: );
677: Ja_Cn_Utility.Add_Child_Node
678: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
679: , pv_text_node_value => lv_period_name
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: );
684: Ja_Cn_Utility.Add_Child_Node
677: Ja_Cn_Utility.Add_Child_Node
678: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
679: , pv_text_node_value => lv_period_name
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: );
684: Ja_Cn_Utility.Add_Child_Node
685: ( pv_child_tag_name => 'INNER_ORGANIZATION_ID'
678: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
679: , pv_text_node_value => lv_period_name
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: );
684: Ja_Cn_Utility.Add_Child_Node
685: ( pv_child_tag_name => 'INNER_ORGANIZATION_ID'
686: , pv_text_node_value => lv_organization
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: );
684: Ja_Cn_Utility.Add_Child_Node
685: ( pv_child_tag_name => 'INNER_ORGANIZATION_ID'
686: , pv_text_node_value => lv_organization
687: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
688: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
683: );
684: Ja_Cn_Utility.Add_Child_Node
685: ( pv_child_tag_name => 'INNER_ORGANIZATION_ID'
686: , pv_text_node_value => lv_organization
687: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
688: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
689: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
690: );
691: Ja_Cn_Utility.Add_Sub_Root_Node
684: Ja_Cn_Utility.Add_Child_Node
685: ( pv_child_tag_name => 'INNER_ORGANIZATION_ID'
686: , pv_text_node_value => lv_organization
687: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
688: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
689: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
690: );
691: Ja_Cn_Utility.Add_Sub_Root_Node
692: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
685: ( pv_child_tag_name => 'INNER_ORGANIZATION_ID'
686: , pv_text_node_value => lv_organization
687: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
688: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
689: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
690: );
691: Ja_Cn_Utility.Add_Sub_Root_Node
692: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
693: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
687: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
688: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
689: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
690: );
691: Ja_Cn_Utility.Add_Sub_Root_Node
692: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
693: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
694: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
695: );
689: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
690: );
691: Ja_Cn_Utility.Add_Sub_Root_Node
692: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
693: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
694: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
695: );
696: END LOOP;
697: CLOSE fa_assignment_cur;
690: );
691: Ja_Cn_Utility.Add_Sub_Root_Node
692: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
693: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
694: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
695: );
696: END LOOP;
697: CLOSE fa_assignment_cur;
698: END IF;-- (lb_retirement_flag = FALSE)
700: CLOSE fa_usage_info_cur;
701:
702: IF (ln_row_count = 0)
703: THEN
704: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'FIXED_ASSET_CARD_USAGE_INFO'
705: , Ja_Cn_Utility.GV_MODULE_FA);
706:
707: Ja_Cn_Utility.Add_Sub_Root_Node
708: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
701:
702: IF (ln_row_count = 0)
703: THEN
704: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'FIXED_ASSET_CARD_USAGE_INFO'
705: , Ja_Cn_Utility.GV_MODULE_FA);
706:
707: Ja_Cn_Utility.Add_Sub_Root_Node
708: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
709: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
703: THEN
704: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'FIXED_ASSET_CARD_USAGE_INFO'
705: , Ja_Cn_Utility.GV_MODULE_FA);
706:
707: Ja_Cn_Utility.Add_Sub_Root_Node
708: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
709: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
710: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
711: );
705: , Ja_Cn_Utility.GV_MODULE_FA);
706:
707: Ja_Cn_Utility.Add_Sub_Root_Node
708: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
709: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
710: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
711: );
712: Ja_Cn_Utility.Add_Child_Node
713: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
706:
707: Ja_Cn_Utility.Add_Sub_Root_Node
708: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
709: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
710: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
711: );
712: Ja_Cn_Utility.Add_Child_Node
713: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
714: , pv_text_node_value => NULL
708: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
709: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START
710: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
711: );
712: Ja_Cn_Utility.Add_Child_Node
713: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
714: , pv_text_node_value => NULL
715: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
716: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
711: );
712: Ja_Cn_Utility.Add_Child_Node
713: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
714: , pv_text_node_value => NULL
715: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
716: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
717: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
718: );
719: Ja_Cn_Utility.Add_Child_Node
712: Ja_Cn_Utility.Add_Child_Node
713: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
714: , pv_text_node_value => NULL
715: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
716: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
717: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
718: );
719: Ja_Cn_Utility.Add_Child_Node
720: ( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
713: ( pv_child_tag_name => 'FIXED_ASSET_CARD_NUMBER'
714: , pv_text_node_value => NULL
715: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
716: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
717: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
718: );
719: Ja_Cn_Utility.Add_Child_Node
720: ( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
721: , pv_text_node_value => NULL
715: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
716: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
717: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
718: );
719: Ja_Cn_Utility.Add_Child_Node
720: ( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
721: , pv_text_node_value => NULL
722: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
723: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
718: );
719: Ja_Cn_Utility.Add_Child_Node
720: ( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
721: , pv_text_node_value => NULL
722: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
723: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
724: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
725: );
726: Ja_Cn_Utility.Add_Child_Node
719: Ja_Cn_Utility.Add_Child_Node
720: ( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
721: , pv_text_node_value => NULL
722: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
723: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
724: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
725: );
726: Ja_Cn_Utility.Add_Child_Node
727: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
720: ( pv_child_tag_name => 'FIXED_ASSET_TAG_NUMBER'
721: , pv_text_node_value => NULL
722: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
723: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
724: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
725: );
726: Ja_Cn_Utility.Add_Child_Node
727: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
728: , pv_text_node_value => NULL
722: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
723: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
724: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
725: );
726: Ja_Cn_Utility.Add_Child_Node
727: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
728: , pv_text_node_value => NULL
729: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
730: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
725: );
726: Ja_Cn_Utility.Add_Child_Node
727: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
728: , pv_text_node_value => NULL
729: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
730: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
731: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
732: );
733: Ja_Cn_Utility.Add_Child_Node
726: Ja_Cn_Utility.Add_Child_Node
727: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
728: , pv_text_node_value => NULL
729: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
730: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
731: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
732: );
733: Ja_Cn_Utility.Add_Child_Node
734: ( pv_child_tag_name => 'INNER_ORGANIZATION_ID'
727: ( pv_child_tag_name => 'ACCOUNTING_PERIOD'
728: , pv_text_node_value => NULL
729: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
730: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
731: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
732: );
733: Ja_Cn_Utility.Add_Child_Node
734: ( pv_child_tag_name => 'INNER_ORGANIZATION_ID'
735: , pv_text_node_value => NULL
729: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
730: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
731: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
732: );
733: Ja_Cn_Utility.Add_Child_Node
734: ( pv_child_tag_name => 'INNER_ORGANIZATION_ID'
735: , pv_text_node_value => NULL
736: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
737: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
732: );
733: Ja_Cn_Utility.Add_Child_Node
734: ( pv_child_tag_name => 'INNER_ORGANIZATION_ID'
735: , pv_text_node_value => NULL
736: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
737: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
738: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
739: );
740: Ja_Cn_Utility.Add_Sub_Root_Node
733: Ja_Cn_Utility.Add_Child_Node
734: ( pv_child_tag_name => 'INNER_ORGANIZATION_ID'
735: , pv_text_node_value => NULL
736: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
737: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
738: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
739: );
740: Ja_Cn_Utility.Add_Sub_Root_Node
741: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
734: ( pv_child_tag_name => 'INNER_ORGANIZATION_ID'
735: , pv_text_node_value => NULL
736: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
737: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
738: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
739: );
740: Ja_Cn_Utility.Add_Sub_Root_Node
741: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
742: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
736: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
737: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES
738: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
739: );
740: Ja_Cn_Utility.Add_Sub_Root_Node
741: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
742: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
743: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
744: );
738: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
739: );
740: Ja_Cn_Utility.Add_Sub_Root_Node
741: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
742: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
743: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
744: );
745: END IF; --(ln_row_count = 0)
746: EXCEPTION
739: );
740: Ja_Cn_Utility.Add_Sub_Root_Node
741: ( pv_sub_root_tag_name => 'FIXED_ASSET_CARD_USAGE_INFO'
742: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END
743: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
744: );
745: END IF; --(ln_row_count = 0)
746: EXCEPTION
747: WHEN OTHERS THEN