DBA Data[Home] [Help]

APPS.JA_CN_PS_FA_ACUI_EXP_PKG dependencies on JA_CN_UTILITY

Line 279: WHERE JA_CN_UTILITY.get_balancing_segment

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

Line 358: WHERE JA_CN_UTILITY.get_balancing_segment(fdh.code_combination_id) =

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

Line 403: WHERE JA_CN_UTILITY.get_balancing_segment(fdh.code_combination_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;

Line 658: Ja_Cn_Utility.Add_Sub_Root_Node

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: );

Line 660: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START

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'

Line 661: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 663: Ja_Cn_Utility.Add_Child_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
666: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
667: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES

Line 666: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2

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

Line 667: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES

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'

Line 668: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 670: Ja_Cn_Utility.Add_Child_Node

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

Line 673: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2

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

Line 674: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES

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'

Line 675: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 677: Ja_Cn_Utility.Add_Child_Node

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

Line 680: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2

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

Line 681: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES

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'

Line 682: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 684: Ja_Cn_Utility.Add_Child_Node

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

Line 687: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2

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

Line 688: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES

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'

Line 689: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 691: Ja_Cn_Utility.Add_Sub_Root_Node

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: );

Line 693: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END

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;

Line 694: , 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;
698: END IF;-- (lb_retirement_flag = FALSE)

Line 704: Ja_Cn_Utility.Print_No_Data_Found_For_Log( 'FIXED_ASSET_CARD_USAGE_INFO'

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'

Line 705: , Ja_Cn_Utility.GV_MODULE_FA);

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

Line 707: Ja_Cn_Utility.Add_Sub_Root_Node

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: );

Line 709: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_START

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'

Line 710: , pv_module_name => 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'
714: , pv_text_node_value => NULL

Line 712: Ja_Cn_Utility.Add_Child_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
715: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2
716: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES

Line 715: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2

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

Line 716: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES

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'

Line 717: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 719: Ja_Cn_Utility.Add_Child_Node

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

Line 722: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2

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

Line 723: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES

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'

Line 724: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 726: Ja_Cn_Utility.Add_Child_Node

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

Line 729: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2

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

Line 730: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES

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'

Line 731: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 733: Ja_Cn_Utility.Add_Child_Node

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

Line 736: , pv_data_type => Ja_Cn_Utility.GV_TYPE_VARCHAR2

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

Line 737: , pv_required => Ja_Cn_Utility.GV_REQUIRED_YES

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'

Line 738: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 740: Ja_Cn_Utility.Add_Sub_Root_Node

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: );

Line 742: , pv_tag_type => Ja_Cn_Utility.GV_TAG_TYPE_END

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

Line 743: , 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
747: WHEN OTHERS THEN