eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_PS_BE_EXPORT_PKG dependencies on JA_CN_UTILITY

Line 158: lv_sql_text := lv_sql_text || ' WHERE JA_CN_UTILITY.get_balancing_segment(gcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value';

154: END IF;
155: --3) BSV condition
156: lv_sql_text := lv_sql_text || ' AND EXISTS (SELECT llbg.Bal_Seg_Value';
157: lv_sql_text := lv_sql_text || ' FROM ja_cn_ledger_le_bsv_gt llbg';
158: lv_sql_text := lv_sql_text || ' WHERE JA_CN_UTILITY.get_balancing_segment(gcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value';
159: lv_sql_text := lv_sql_text || ' AND llbg.Ledger_Id = ' || pn_ledger_id; --parameter: pn_ledger_id
160: lv_sql_text := lv_sql_text || ' AND llbg.Legal_Entity_Id = ' || pn_legal_entity_id || ')'; --parameter: pn_legal_entity_id;
161:
162: --4) Period condition

Line 336: lv_sql_text := lv_sql_text || ' WHERE JA_CN_UTILITY.get_balancing_segment(gcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value';

332:
333: --3) BSV condition
334: lv_sql_text := lv_sql_text || ' AND EXISTS (SELECT llbg.Bal_Seg_Value';
335: lv_sql_text := lv_sql_text || ' FROM ja_cn_ledger_le_bsv_gt llbg';
336: lv_sql_text := lv_sql_text || ' WHERE JA_CN_UTILITY.get_balancing_segment(gcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value';
337: lv_sql_text := lv_sql_text || ' AND llbg.Ledger_Id = ' || pn_ledger_id; --parameter: pn_ledger_id
338: lv_sql_text := lv_sql_text || ' AND llbg.Legal_Entity_Id = ' || pn_legal_entity_id || ')'; --parameter: pn_legal_entity_id;
339:
340: --4) Period condition

Line 477: lv_exp_fun_cat_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CEFC'

473: -- 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
474: -- 'pn_ledger_id=' || pn_ledger_id || ',' ||
475: -- 'pv_accounting_year=' || pv_accounting_year);
476:
477: lv_exp_fun_cat_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CEFC'
478: ,pn_application_id => 101
479: ,pn_coa_id => pn_coa_id
480: );
481: lv_exp_eco_cat_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CEEC'

Line 481: lv_exp_eco_cat_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CEEC'

477: lv_exp_fun_cat_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CEFC'
478: ,pn_application_id => 101
479: ,pn_coa_id => pn_coa_id
480: );
481: lv_exp_eco_cat_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CEEC'
482: ,pn_application_id => 101
483: ,pn_coa_id => pn_coa_id
484: );
485: lv_project_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CPRO'

Line 485: lv_project_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CPRO'

481: lv_exp_eco_cat_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CEEC'
482: ,pn_application_id => 101
483: ,pn_coa_id => pn_coa_id
484: );
485: lv_project_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CPRO'
486: ,pn_application_id => 101
487: ,pn_coa_id => pn_coa_id
488: );
489: lv_budget_type_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CBTY'

Line 489: lv_budget_type_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CBTY'

485: lv_project_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CPRO'
486: ,pn_application_id => 101
487: ,pn_coa_id => pn_coa_id
488: );
489: lv_budget_type_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CBTY'
490: ,pn_application_id => 101
491: ,pn_coa_id => pn_coa_id
492: );
493: --fixed bug 10316565

Line 547: lv_bi_cursor_sql := lv_bi_cursor_sql || ' WHERE JA_CN_UTILITY.get_balancing_segment(gcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value';

543: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND jeh.status = ''P''';
544: --2) BSV condition
545: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND EXISTS (SELECT llbg.Bal_Seg_Value ';
546: lv_bi_cursor_sql := lv_bi_cursor_sql || ' FROM ja_cn_ledger_le_bsv_gt llbg';
547: lv_bi_cursor_sql := lv_bi_cursor_sql || ' WHERE JA_CN_UTILITY.get_balancing_segment(gcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value';
548: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND llbg.Ledger_Id = ' || pn_ledger_id; --parameter: pn_ledger_id
549: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND llbg.Legal_Entity_Id = ' || pn_legal_entity_id || ')'; --parameter: pn_legal_entity_id;
550: --3) Period condition
551: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND Gle.period_set_name = Gp.period_set_name';

Line 614: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_EXPENDITURE'

610: --INTO lv_accounting_period_num,lv_accounting_period,lv_exp_fun_category_code,lv_exp_eco_category_code,lv_project_id;
611: INTO lv_exp_fun_category_code,lv_exp_eco_category_code,lv_project_id;
612: EXIT WHEN lc_budget_information%NOTFOUND;
613:
614: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_EXPENDITURE'
615: ,Ja_Cn_Utility.GV_TAG_TYPE_START
616: );
617: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
618: ,pv_accounting_year

Line 615: ,Ja_Cn_Utility.GV_TAG_TYPE_START

611: INTO lv_exp_fun_category_code,lv_exp_eco_category_code,lv_project_id;
612: EXIT WHEN lc_budget_information%NOTFOUND;
613:
614: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_EXPENDITURE'
615: ,Ja_Cn_Utility.GV_TAG_TYPE_START
616: );
617: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
618: ,pv_accounting_year
619: );

Line 617: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'

613:
614: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_EXPENDITURE'
615: ,Ja_Cn_Utility.GV_TAG_TYPE_START
616: );
617: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
618: ,pv_accounting_year
619: );
620: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
621: ,lv_accounting_period_num

Line 620: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'

616: );
617: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
618: ,pv_accounting_year
619: );
620: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
621: ,lv_accounting_period_num
622: );
623: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
624: ,lv_exp_fun_category_code

Line 623: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'

619: );
620: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
621: ,lv_accounting_period_num
622: );
623: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
624: ,lv_exp_fun_category_code
625: );
626: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'
627: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEFC'

Line 626: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'

622: );
623: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
624: ,lv_exp_fun_category_code
625: );
626: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'
627: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEFC'
628: ,pv_flex_value => lv_exp_fun_category_code
629: ,pn_coa_id => pn_coa_id)
630: );

Line 627: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEFC'

623: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
624: ,lv_exp_fun_category_code
625: );
626: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'
627: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEFC'
628: ,pv_flex_value => lv_exp_fun_category_code
629: ,pn_coa_id => pn_coa_id)
630: );
631: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'

Line 631: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'

627: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEFC'
628: ,pv_flex_value => lv_exp_fun_category_code
629: ,pn_coa_id => pn_coa_id)
630: );
631: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'
632: ,lv_exp_eco_category_code
633: );
634: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'
635: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEEC'

Line 634: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'

630: );
631: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'
632: ,lv_exp_eco_category_code
633: );
634: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'
635: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEEC'
636: ,pv_flex_value => lv_exp_eco_category_code
637: ,pn_coa_id => pn_coa_id)
638: );

Line 635: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEEC'

631: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'
632: ,lv_exp_eco_category_code
633: );
634: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'
635: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEEC'
636: ,pv_flex_value => lv_exp_eco_category_code
637: ,pn_coa_id => pn_coa_id)
638: );
639: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'

Line 639: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'

635: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEEC'
636: ,pv_flex_value => lv_exp_eco_category_code
637: ,pn_coa_id => pn_coa_id)
638: );
639: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'
640: ,lv_project_id
641: );
642: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'
643: ,JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'AFTY'

Line 642: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'

638: );
639: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'
640: ,lv_project_id
641: );
642: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'
643: ,JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'AFTY'
644: ,pv_project_id => lv_project_id
645: ,pn_coa_id => pn_coa_id)
646: );

Line 643: ,JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'AFTY'

639: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'
640: ,lv_project_id
641: );
642: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'
643: ,JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'AFTY'
644: ,pv_project_id => lv_project_id
645: ,pn_coa_id => pn_coa_id)
646: );
647: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'

Line 647: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'

643: ,JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'AFTY'
644: ,pv_project_id => lv_project_id
645: ,pn_coa_id => pn_coa_id)
646: );
647: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'
648: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'AFTY'
649: ,pv_flex_value => JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'AFTY'
650: ,pv_project_id => lv_project_id
651: ,pn_coa_id => pn_coa_id)

Line 648: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'AFTY'

644: ,pv_project_id => lv_project_id
645: ,pn_coa_id => pn_coa_id)
646: );
647: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'
648: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'AFTY'
649: ,pv_flex_value => JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'AFTY'
650: ,pv_project_id => lv_project_id
651: ,pn_coa_id => pn_coa_id)
652: ,pn_coa_id => pn_coa_id)

Line 649: ,pv_flex_value => JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'AFTY'

645: ,pn_coa_id => pn_coa_id)
646: );
647: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'
648: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'AFTY'
649: ,pv_flex_value => JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'AFTY'
650: ,pv_project_id => lv_project_id
651: ,pn_coa_id => pn_coa_id)
652: ,pn_coa_id => pn_coa_id)
653: );

Line 654: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'

650: ,pv_project_id => lv_project_id
651: ,pn_coa_id => pn_coa_id)
652: ,pn_coa_id => pn_coa_id)
653: );
654: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'
655: ,JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'ABSO'
656: ,pv_project_id => lv_project_id
657: ,pn_coa_id => pn_coa_id)
658: );

Line 655: ,JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'ABSO'

651: ,pn_coa_id => pn_coa_id)
652: ,pn_coa_id => pn_coa_id)
653: );
654: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'
655: ,JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'ABSO'
656: ,pv_project_id => lv_project_id
657: ,pn_coa_id => pn_coa_id)
658: );
659: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'

Line 659: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'

655: ,JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'ABSO'
656: ,pv_project_id => lv_project_id
657: ,pn_coa_id => pn_coa_id)
658: );
659: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'
660: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'ABSO'
661: ,pv_flex_value => JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'ABSO'
662: ,pv_project_id => lv_project_id
663: ,pn_coa_id => pn_coa_id)

Line 660: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'ABSO'

656: ,pv_project_id => lv_project_id
657: ,pn_coa_id => pn_coa_id)
658: );
659: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'
660: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'ABSO'
661: ,pv_flex_value => JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'ABSO'
662: ,pv_project_id => lv_project_id
663: ,pn_coa_id => pn_coa_id)
664: ,pn_coa_id => pn_coa_id)

Line 661: ,pv_flex_value => JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'ABSO'

657: ,pn_coa_id => pn_coa_id)
658: );
659: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'
660: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'ABSO'
661: ,pv_flex_value => JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'ABSO'
662: ,pv_project_id => lv_project_id
663: ,pn_coa_id => pn_coa_id)
664: ,pn_coa_id => pn_coa_id)
665: );

Line 666: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_CODE'

662: ,pv_project_id => lv_project_id
663: ,pn_coa_id => pn_coa_id)
664: ,pn_coa_id => pn_coa_id)
665: );
666: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_CODE'
667: ,JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'APME'
668: ,pv_project_id => lv_project_id
669: ,pn_coa_id => pn_coa_id)
670: );

Line 667: ,JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'APME'

663: ,pn_coa_id => pn_coa_id)
664: ,pn_coa_id => pn_coa_id)
665: );
666: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_CODE'
667: ,JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'APME'
668: ,pv_project_id => lv_project_id
669: ,pn_coa_id => pn_coa_id)
670: );
671: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_NAME'

Line 671: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_NAME'

667: ,JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'APME'
668: ,pv_project_id => lv_project_id
669: ,pn_coa_id => pn_coa_id)
670: );
671: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_NAME'
672: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'APME'
673: ,pv_flex_value => JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'APME'
674: ,pv_project_id => lv_project_id
675: ,pn_coa_id => pn_coa_id)

Line 672: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'APME'

668: ,pv_project_id => lv_project_id
669: ,pn_coa_id => pn_coa_id)
670: );
671: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_NAME'
672: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'APME'
673: ,pv_flex_value => JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'APME'
674: ,pv_project_id => lv_project_id
675: ,pn_coa_id => pn_coa_id)
676: ,pn_coa_id => pn_coa_id)

Line 673: ,pv_flex_value => JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'APME'

669: ,pn_coa_id => pn_coa_id)
670: );
671: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_NAME'
672: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'APME'
673: ,pv_flex_value => JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'APME'
674: ,pv_project_id => lv_project_id
675: ,pn_coa_id => pn_coa_id)
676: ,pn_coa_id => pn_coa_id)
677: );

Line 688: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id

684: ,lv_exp_eco_category_code
685: ,lv_project_seg_col
686: ,lv_project_id
687: ,lv_budget_type_seg_col
688: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
689: ,pv_flexfield_code => 'LYBA')
690: ,pv_accounting_year
691: ,NULL
692: ,NULL

Line 694: Ja_Cn_Utility.Add_Child_Node('LAST_YEAR_BALANCE_AMOUNT'

690: ,pv_accounting_year
691: ,NULL
692: ,NULL
693: );
694: Ja_Cn_Utility.Add_Child_Node('LAST_YEAR_BALANCE_AMOUNT'
695: ,ln_last_year_balance_amount --
696: ,Ja_Cn_Utility.GV_TYPE_NUMBER
697: ,Ja_Cn_Utility.GV_REQUIRED_YES
698: );

Line 696: ,Ja_Cn_Utility.GV_TYPE_NUMBER

692: ,NULL
693: );
694: Ja_Cn_Utility.Add_Child_Node('LAST_YEAR_BALANCE_AMOUNT'
695: ,ln_last_year_balance_amount --
696: ,Ja_Cn_Utility.GV_TYPE_NUMBER
697: ,Ja_Cn_Utility.GV_REQUIRED_YES
698: );
699: -- updated to fix bug#: 10111527 --END--
700: ln_current_year_budget_amount := Get_Budget_Expenditure_Amount(pn_legal_entity_id

Line 697: ,Ja_Cn_Utility.GV_REQUIRED_YES

693: );
694: Ja_Cn_Utility.Add_Child_Node('LAST_YEAR_BALANCE_AMOUNT'
695: ,ln_last_year_balance_amount --
696: ,Ja_Cn_Utility.GV_TYPE_NUMBER
697: ,Ja_Cn_Utility.GV_REQUIRED_YES
698: );
699: -- updated to fix bug#: 10111527 --END--
700: ln_current_year_budget_amount := Get_Budget_Expenditure_Amount(pn_legal_entity_id
701: ,pn_ledger_id

Line 709: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id

705: ,lv_exp_eco_category_code
706: ,lv_project_seg_col
707: ,lv_project_id
708: ,lv_budget_type_seg_col
709: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
710: ,pv_flexfield_code => 'CYBA')
711: ,pv_accounting_year
712: ,NULL
713: ,NULL

Line 715: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'

711: ,pv_accounting_year
712: ,NULL
713: ,NULL
714: );
715: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
716: ,ln_current_year_budget_amount
717: ,Ja_Cn_Utility.GV_TYPE_NUMBER
718: ,Ja_Cn_Utility.GV_REQUIRED_YES
719: );

Line 717: ,Ja_Cn_Utility.GV_TYPE_NUMBER

713: ,NULL
714: );
715: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
716: ,ln_current_year_budget_amount
717: ,Ja_Cn_Utility.GV_TYPE_NUMBER
718: ,Ja_Cn_Utility.GV_REQUIRED_YES
719: );
720:
721: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'

Line 718: ,Ja_Cn_Utility.GV_REQUIRED_YES

714: );
715: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
716: ,ln_current_year_budget_amount
717: ,Ja_Cn_Utility.GV_TYPE_NUMBER
718: ,Ja_Cn_Utility.GV_REQUIRED_YES
719: );
720:
721: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'
722: ,Get_Budget_Expenditure_Amount(pn_legal_entity_id

Line 721: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'

717: ,Ja_Cn_Utility.GV_TYPE_NUMBER
718: ,Ja_Cn_Utility.GV_REQUIRED_YES
719: );
720:
721: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'
722: ,Get_Budget_Expenditure_Amount(pn_legal_entity_id
723: ,pn_ledger_id
724: ,lv_exp_fun_cat_seg_col
725: ,lv_exp_fun_category_code

Line 731: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id

727: ,lv_exp_eco_category_code
728: ,lv_project_seg_col
729: ,lv_project_id
730: ,lv_budget_type_seg_col
731: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
732: ,pv_flexfield_code => 'ICPA')
733: ,NULL
734: ,lv_accounting_period
735: ,lv_accounting_period

Line 737: ,Ja_Cn_Utility.GV_TYPE_NUMBER

733: ,NULL
734: ,lv_accounting_period
735: ,lv_accounting_period
736: )
737: ,Ja_Cn_Utility.GV_TYPE_NUMBER
738: ,Ja_Cn_Utility.GV_REQUIRED_YES
739: );
740: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'
741: ,Get_Budget_Expenditure_Amount(pn_legal_entity_id

Line 738: ,Ja_Cn_Utility.GV_REQUIRED_YES

734: ,lv_accounting_period
735: ,lv_accounting_period
736: )
737: ,Ja_Cn_Utility.GV_TYPE_NUMBER
738: ,Ja_Cn_Utility.GV_REQUIRED_YES
739: );
740: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'
741: ,Get_Budget_Expenditure_Amount(pn_legal_entity_id
742: ,pn_ledger_id

Line 740: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'

736: )
737: ,Ja_Cn_Utility.GV_TYPE_NUMBER
738: ,Ja_Cn_Utility.GV_REQUIRED_YES
739: );
740: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'
741: ,Get_Budget_Expenditure_Amount(pn_legal_entity_id
742: ,pn_ledger_id
743: ,lv_exp_fun_cat_seg_col
744: ,lv_exp_fun_category_code

Line 750: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id

746: ,lv_exp_eco_category_code
747: ,lv_project_seg_col
748: ,lv_project_id
749: ,lv_budget_type_seg_col
750: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
751: ,pv_flexfield_code => 'DCPA')
752: ,NULL
753: ,lv_accounting_period
754: ,lv_accounting_period

Line 756: ,Ja_Cn_Utility.GV_TYPE_NUMBER

752: ,NULL
753: ,lv_accounting_period
754: ,lv_accounting_period
755: )
756: ,Ja_Cn_Utility.GV_TYPE_NUMBER
757: ,Ja_Cn_Utility.GV_REQUIRED_YES
758: );
759: ln_accumulated_inc_amount := Get_Budget_Expenditure_Amount(pn_legal_entity_id
760: ,pn_ledger_id

Line 757: ,Ja_Cn_Utility.GV_REQUIRED_YES

753: ,lv_accounting_period
754: ,lv_accounting_period
755: )
756: ,Ja_Cn_Utility.GV_TYPE_NUMBER
757: ,Ja_Cn_Utility.GV_REQUIRED_YES
758: );
759: ln_accumulated_inc_amount := Get_Budget_Expenditure_Amount(pn_legal_entity_id
760: ,pn_ledger_id
761: ,lv_exp_fun_cat_seg_col

Line 768: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id

764: ,lv_exp_eco_category_code
765: ,lv_project_seg_col
766: ,lv_project_id
767: ,lv_budget_type_seg_col
768: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
769: ,pv_flexfield_code => 'ICPA')
770: ,pv_accounting_year
771: ,NULL
772: ,lv_accounting_period

Line 774: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'

770: ,pv_accounting_year
771: ,NULL
772: ,lv_accounting_period
773: );
774: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
775: ,ln_accumulated_inc_amount
776: ,Ja_Cn_Utility.GV_TYPE_NUMBER
777: ,Ja_Cn_Utility.GV_REQUIRED_YES
778: );

Line 776: ,Ja_Cn_Utility.GV_TYPE_NUMBER

772: ,lv_accounting_period
773: );
774: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
775: ,ln_accumulated_inc_amount
776: ,Ja_Cn_Utility.GV_TYPE_NUMBER
777: ,Ja_Cn_Utility.GV_REQUIRED_YES
778: );
779: ln_accumulated_dec_amount := Get_Budget_Expenditure_Amount(pn_legal_entity_id
780: ,pn_ledger_id

Line 777: ,Ja_Cn_Utility.GV_REQUIRED_YES

773: );
774: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
775: ,ln_accumulated_inc_amount
776: ,Ja_Cn_Utility.GV_TYPE_NUMBER
777: ,Ja_Cn_Utility.GV_REQUIRED_YES
778: );
779: ln_accumulated_dec_amount := Get_Budget_Expenditure_Amount(pn_legal_entity_id
780: ,pn_ledger_id
781: ,lv_exp_fun_cat_seg_col

Line 788: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id

784: ,lv_exp_eco_category_code
785: ,lv_project_seg_col
786: ,lv_project_id
787: ,lv_budget_type_seg_col
788: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
789: ,pv_flexfield_code => 'DCPA')
790: ,pv_accounting_year
791: ,NULL
792: ,lv_accounting_period

Line 794: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'

790: ,pv_accounting_year
791: ,NULL
792: ,lv_accounting_period
793: );
794: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
795: ,ln_accumulated_dec_amount
796: ,Ja_Cn_Utility.GV_TYPE_NUMBER
797: ,Ja_Cn_Utility.GV_REQUIRED_YES
798: );

Line 796: ,Ja_Cn_Utility.GV_TYPE_NUMBER

792: ,lv_accounting_period
793: );
794: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
795: ,ln_accumulated_dec_amount
796: ,Ja_Cn_Utility.GV_TYPE_NUMBER
797: ,Ja_Cn_Utility.GV_REQUIRED_YES
798: );
799: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_ACT_EXP_AMOUNT'
800: ,Get_Actual_Expenditure_Amount(pn_legal_entity_id

Line 797: ,Ja_Cn_Utility.GV_REQUIRED_YES

793: );
794: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
795: ,ln_accumulated_dec_amount
796: ,Ja_Cn_Utility.GV_TYPE_NUMBER
797: ,Ja_Cn_Utility.GV_REQUIRED_YES
798: );
799: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_ACT_EXP_AMOUNT'
800: ,Get_Actual_Expenditure_Amount(pn_legal_entity_id
801: ,pn_ledger_id

Line 799: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_ACT_EXP_AMOUNT'

795: ,ln_accumulated_dec_amount
796: ,Ja_Cn_Utility.GV_TYPE_NUMBER
797: ,Ja_Cn_Utility.GV_REQUIRED_YES
798: );
799: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_ACT_EXP_AMOUNT'
800: ,Get_Actual_Expenditure_Amount(pn_legal_entity_id
801: ,pn_ledger_id
802: ,lv_exp_fun_cat_seg_col
803: ,lv_exp_fun_category_code

Line 814: ,Ja_Cn_Utility.GV_TYPE_NUMBER

810: ,NULL
811: ,lv_accounting_period
812: ,lv_accounting_period
813: )
814: ,Ja_Cn_Utility.GV_TYPE_NUMBER
815: ,Ja_Cn_Utility.GV_REQUIRED_YES
816: );
817: ln_accumulated_act_exp_amount := Get_Actual_Expenditure_Amount(pn_legal_entity_id
818: ,pn_ledger_id

Line 815: ,Ja_Cn_Utility.GV_REQUIRED_YES

811: ,lv_accounting_period
812: ,lv_accounting_period
813: )
814: ,Ja_Cn_Utility.GV_TYPE_NUMBER
815: ,Ja_Cn_Utility.GV_REQUIRED_YES
816: );
817: ln_accumulated_act_exp_amount := Get_Actual_Expenditure_Amount(pn_legal_entity_id
818: ,pn_ledger_id
819: ,lv_exp_fun_cat_seg_col

Line 831: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACT_EXP_AMOUNT'

827: ,pv_accounting_year
828: ,NULL
829: ,lv_accounting_period
830: );
831: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACT_EXP_AMOUNT'
832: ,ln_accumulated_act_exp_amount
833: ,Ja_Cn_Utility.GV_TYPE_NUMBER
834: ,Ja_Cn_Utility.GV_REQUIRED_YES
835: );

Line 833: ,Ja_Cn_Utility.GV_TYPE_NUMBER

829: ,lv_accounting_period
830: );
831: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACT_EXP_AMOUNT'
832: ,ln_accumulated_act_exp_amount
833: ,Ja_Cn_Utility.GV_TYPE_NUMBER
834: ,Ja_Cn_Utility.GV_REQUIRED_YES
835: );
836: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_BAL_AMOUNT'
837: ,NVL(ln_last_year_balance_amount,0) -- added to fix bug# 10111527

Line 834: ,Ja_Cn_Utility.GV_REQUIRED_YES

830: );
831: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACT_EXP_AMOUNT'
832: ,ln_accumulated_act_exp_amount
833: ,Ja_Cn_Utility.GV_TYPE_NUMBER
834: ,Ja_Cn_Utility.GV_REQUIRED_YES
835: );
836: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_BAL_AMOUNT'
837: ,NVL(ln_last_year_balance_amount,0) -- added to fix bug# 10111527
838: +NVL(ln_current_year_budget_amount,0)

Line 836: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_BAL_AMOUNT'

832: ,ln_accumulated_act_exp_amount
833: ,Ja_Cn_Utility.GV_TYPE_NUMBER
834: ,Ja_Cn_Utility.GV_REQUIRED_YES
835: );
836: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_BAL_AMOUNT'
837: ,NVL(ln_last_year_balance_amount,0) -- added to fix bug# 10111527
838: +NVL(ln_current_year_budget_amount,0)
839: +NVL(ln_accumulated_inc_amount,0)
840: -NVL(ln_accumulated_dec_amount,0)

Line 843: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_EXPENDITURE'

839: +NVL(ln_accumulated_inc_amount,0)
840: -NVL(ln_accumulated_dec_amount,0)
841: -NVL(ln_accumulated_act_exp_amount,0)
842: );
843: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_EXPENDITURE'
844: ,Ja_Cn_Utility.GV_TAG_TYPE_END
845: );
846: ln_rec_count := ln_rec_count + 1;
847:

Line 844: ,Ja_Cn_Utility.GV_TAG_TYPE_END

840: -NVL(ln_accumulated_dec_amount,0)
841: -NVL(ln_accumulated_act_exp_amount,0)
842: );
843: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_EXPENDITURE'
844: ,Ja_Cn_Utility.GV_TAG_TYPE_END
845: );
846: ln_rec_count := ln_rec_count + 1;
847:
848: END LOOP;

Line 869: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_EXPENDITURE'

865:
866: -- There is no data found for employee record
867: IF ln_rec_count = 0
868: THEN
869: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_EXPENDITURE'
870: ,Ja_Cn_Utility.GV_TAG_TYPE_START
871: );
872: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
873: ,pv_accounting_year

Line 870: ,Ja_Cn_Utility.GV_TAG_TYPE_START

866: -- There is no data found for employee record
867: IF ln_rec_count = 0
868: THEN
869: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_EXPENDITURE'
870: ,Ja_Cn_Utility.GV_TAG_TYPE_START
871: );
872: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
873: ,pv_accounting_year
874: ,4

Line 872: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'

868: THEN
869: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_EXPENDITURE'
870: ,Ja_Cn_Utility.GV_TAG_TYPE_START
871: );
872: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
873: ,pv_accounting_year
874: ,4
875: ,Ja_Cn_Utility.GV_REQUIRED_YES
876: ,Ja_Cn_Utility.GV_MODULE_GLSI

Line 875: ,Ja_Cn_Utility.GV_REQUIRED_YES

871: );
872: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
873: ,pv_accounting_year
874: ,4
875: ,Ja_Cn_Utility.GV_REQUIRED_YES
876: ,Ja_Cn_Utility.GV_MODULE_GLSI
877: );
878: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
879: ,NULL

Line 876: ,Ja_Cn_Utility.GV_MODULE_GLSI

872: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
873: ,pv_accounting_year
874: ,4
875: ,Ja_Cn_Utility.GV_REQUIRED_YES
876: ,Ja_Cn_Utility.GV_MODULE_GLSI
877: );
878: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
879: ,NULL
880: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 878: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'

874: ,4
875: ,Ja_Cn_Utility.GV_REQUIRED_YES
876: ,Ja_Cn_Utility.GV_MODULE_GLSI
877: );
878: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
879: ,NULL
880: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
881: ,Ja_Cn_Utility.GV_REQUIRED_YES
882: );

Line 880: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

876: ,Ja_Cn_Utility.GV_MODULE_GLSI
877: );
878: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
879: ,NULL
880: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
881: ,Ja_Cn_Utility.GV_REQUIRED_YES
882: );
883: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
884: ,NULL

Line 881: ,Ja_Cn_Utility.GV_REQUIRED_YES

877: );
878: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
879: ,NULL
880: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
881: ,Ja_Cn_Utility.GV_REQUIRED_YES
882: );
883: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
884: ,NULL
885: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 883: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'

879: ,NULL
880: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
881: ,Ja_Cn_Utility.GV_REQUIRED_YES
882: );
883: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
884: ,NULL
885: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
886: ,Ja_Cn_Utility.GV_REQUIRED_YES
887: );

Line 885: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

881: ,Ja_Cn_Utility.GV_REQUIRED_YES
882: );
883: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
884: ,NULL
885: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
886: ,Ja_Cn_Utility.GV_REQUIRED_YES
887: );
888: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'
889: ,NULL

Line 886: ,Ja_Cn_Utility.GV_REQUIRED_YES

882: );
883: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
884: ,NULL
885: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
886: ,Ja_Cn_Utility.GV_REQUIRED_YES
887: );
888: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'
889: ,NULL
890: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 888: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'

884: ,NULL
885: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
886: ,Ja_Cn_Utility.GV_REQUIRED_YES
887: );
888: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'
889: ,NULL
890: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
891: ,Ja_Cn_Utility.GV_REQUIRED_YES
892: );

Line 890: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

886: ,Ja_Cn_Utility.GV_REQUIRED_YES
887: );
888: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'
889: ,NULL
890: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
891: ,Ja_Cn_Utility.GV_REQUIRED_YES
892: );
893: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'
894: ,NULL

Line 891: ,Ja_Cn_Utility.GV_REQUIRED_YES

887: );
888: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'
889: ,NULL
890: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
891: ,Ja_Cn_Utility.GV_REQUIRED_YES
892: );
893: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'
894: ,NULL
895: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 893: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'

889: ,NULL
890: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
891: ,Ja_Cn_Utility.GV_REQUIRED_YES
892: );
893: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'
894: ,NULL
895: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
896: ,Ja_Cn_Utility.GV_REQUIRED_YES
897: );

Line 895: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

891: ,Ja_Cn_Utility.GV_REQUIRED_YES
892: );
893: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'
894: ,NULL
895: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
896: ,Ja_Cn_Utility.GV_REQUIRED_YES
897: );
898: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'
899: ,NULL

Line 896: ,Ja_Cn_Utility.GV_REQUIRED_YES

892: );
893: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'
894: ,NULL
895: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
896: ,Ja_Cn_Utility.GV_REQUIRED_YES
897: );
898: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'
899: ,NULL
900: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 898: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'

894: ,NULL
895: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
896: ,Ja_Cn_Utility.GV_REQUIRED_YES
897: );
898: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'
899: ,NULL
900: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
901: ,Ja_Cn_Utility.GV_REQUIRED_YES
902: );

Line 900: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

896: ,Ja_Cn_Utility.GV_REQUIRED_YES
897: );
898: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'
899: ,NULL
900: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
901: ,Ja_Cn_Utility.GV_REQUIRED_YES
902: );
903: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'
904: ,NULL

Line 901: ,Ja_Cn_Utility.GV_REQUIRED_YES

897: );
898: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'
899: ,NULL
900: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
901: ,Ja_Cn_Utility.GV_REQUIRED_YES
902: );
903: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'
904: ,NULL
905: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 903: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'

899: ,NULL
900: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
901: ,Ja_Cn_Utility.GV_REQUIRED_YES
902: );
903: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'
904: ,NULL
905: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
906: ,Ja_Cn_Utility.GV_REQUIRED_YES
907: );

Line 905: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

901: ,Ja_Cn_Utility.GV_REQUIRED_YES
902: );
903: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'
904: ,NULL
905: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
906: ,Ja_Cn_Utility.GV_REQUIRED_YES
907: );
908: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'
909: ,NULL

Line 906: ,Ja_Cn_Utility.GV_REQUIRED_YES

902: );
903: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'
904: ,NULL
905: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
906: ,Ja_Cn_Utility.GV_REQUIRED_YES
907: );
908: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'
909: ,NULL
910: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 908: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'

904: ,NULL
905: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
906: ,Ja_Cn_Utility.GV_REQUIRED_YES
907: );
908: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'
909: ,NULL
910: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
911: ,Ja_Cn_Utility.GV_REQUIRED_YES
912: );

Line 910: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

906: ,Ja_Cn_Utility.GV_REQUIRED_YES
907: );
908: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'
909: ,NULL
910: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
911: ,Ja_Cn_Utility.GV_REQUIRED_YES
912: );
913: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'
914: ,NULL

Line 911: ,Ja_Cn_Utility.GV_REQUIRED_YES

907: );
908: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'
909: ,NULL
910: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
911: ,Ja_Cn_Utility.GV_REQUIRED_YES
912: );
913: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'
914: ,NULL
915: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 913: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'

909: ,NULL
910: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
911: ,Ja_Cn_Utility.GV_REQUIRED_YES
912: );
913: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'
914: ,NULL
915: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
916: ,Ja_Cn_Utility.GV_REQUIRED_YES
917: );

Line 915: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

911: ,Ja_Cn_Utility.GV_REQUIRED_YES
912: );
913: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'
914: ,NULL
915: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
916: ,Ja_Cn_Utility.GV_REQUIRED_YES
917: );
918: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'
919: ,NULL

Line 916: ,Ja_Cn_Utility.GV_REQUIRED_YES

912: );
913: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'
914: ,NULL
915: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
916: ,Ja_Cn_Utility.GV_REQUIRED_YES
917: );
918: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'
919: ,NULL
920: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 918: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'

914: ,NULL
915: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
916: ,Ja_Cn_Utility.GV_REQUIRED_YES
917: );
918: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'
919: ,NULL
920: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
921: ,Ja_Cn_Utility.GV_REQUIRED_YES
922: );

Line 920: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

916: ,Ja_Cn_Utility.GV_REQUIRED_YES
917: );
918: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'
919: ,NULL
920: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
921: ,Ja_Cn_Utility.GV_REQUIRED_YES
922: );
923: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'
924: ,NULL

Line 921: ,Ja_Cn_Utility.GV_REQUIRED_YES

917: );
918: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'
919: ,NULL
920: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
921: ,Ja_Cn_Utility.GV_REQUIRED_YES
922: );
923: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'
924: ,NULL
925: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 923: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'

919: ,NULL
920: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
921: ,Ja_Cn_Utility.GV_REQUIRED_YES
922: );
923: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'
924: ,NULL
925: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
926: ,Ja_Cn_Utility.GV_REQUIRED_YES
927: );

Line 925: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

921: ,Ja_Cn_Utility.GV_REQUIRED_YES
922: );
923: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'
924: ,NULL
925: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
926: ,Ja_Cn_Utility.GV_REQUIRED_YES
927: );
928: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_CODE'
929: ,NULL

Line 926: ,Ja_Cn_Utility.GV_REQUIRED_YES

922: );
923: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'
924: ,NULL
925: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
926: ,Ja_Cn_Utility.GV_REQUIRED_YES
927: );
928: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_CODE'
929: ,NULL
930: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 928: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_CODE'

924: ,NULL
925: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
926: ,Ja_Cn_Utility.GV_REQUIRED_YES
927: );
928: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_CODE'
929: ,NULL
930: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
931: ,Ja_Cn_Utility.GV_REQUIRED_YES
932: );

Line 930: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

926: ,Ja_Cn_Utility.GV_REQUIRED_YES
927: );
928: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_CODE'
929: ,NULL
930: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
931: ,Ja_Cn_Utility.GV_REQUIRED_YES
932: );
933: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_NAME'
934: ,NULL

Line 931: ,Ja_Cn_Utility.GV_REQUIRED_YES

927: );
928: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_CODE'
929: ,NULL
930: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
931: ,Ja_Cn_Utility.GV_REQUIRED_YES
932: );
933: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_NAME'
934: ,NULL
935: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 933: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_NAME'

929: ,NULL
930: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
931: ,Ja_Cn_Utility.GV_REQUIRED_YES
932: );
933: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_NAME'
934: ,NULL
935: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
936: ,Ja_Cn_Utility.GV_REQUIRED_YES
937: );

Line 935: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

931: ,Ja_Cn_Utility.GV_REQUIRED_YES
932: );
933: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_NAME'
934: ,NULL
935: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
936: ,Ja_Cn_Utility.GV_REQUIRED_YES
937: );
938: Ja_Cn_Utility.Add_Child_Node('LAST_YEAR_BALANCE_AMOUNT'
939: ,NULL

Line 936: ,Ja_Cn_Utility.GV_REQUIRED_YES

932: );
933: Ja_Cn_Utility.Add_Child_Node('PAYMENT_METHOD_NAME'
934: ,NULL
935: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
936: ,Ja_Cn_Utility.GV_REQUIRED_YES
937: );
938: Ja_Cn_Utility.Add_Child_Node('LAST_YEAR_BALANCE_AMOUNT'
939: ,NULL
940: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 938: Ja_Cn_Utility.Add_Child_Node('LAST_YEAR_BALANCE_AMOUNT'

934: ,NULL
935: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
936: ,Ja_Cn_Utility.GV_REQUIRED_YES
937: );
938: Ja_Cn_Utility.Add_Child_Node('LAST_YEAR_BALANCE_AMOUNT'
939: ,NULL
940: ,Ja_Cn_Utility.GV_TYPE_NUMBER
941: ,Ja_Cn_Utility.GV_REQUIRED_YES
942: );

Line 940: ,Ja_Cn_Utility.GV_TYPE_NUMBER

936: ,Ja_Cn_Utility.GV_REQUIRED_YES
937: );
938: Ja_Cn_Utility.Add_Child_Node('LAST_YEAR_BALANCE_AMOUNT'
939: ,NULL
940: ,Ja_Cn_Utility.GV_TYPE_NUMBER
941: ,Ja_Cn_Utility.GV_REQUIRED_YES
942: );
943: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
944: ,NULL

Line 941: ,Ja_Cn_Utility.GV_REQUIRED_YES

937: );
938: Ja_Cn_Utility.Add_Child_Node('LAST_YEAR_BALANCE_AMOUNT'
939: ,NULL
940: ,Ja_Cn_Utility.GV_TYPE_NUMBER
941: ,Ja_Cn_Utility.GV_REQUIRED_YES
942: );
943: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
944: ,NULL
945: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 943: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'

939: ,NULL
940: ,Ja_Cn_Utility.GV_TYPE_NUMBER
941: ,Ja_Cn_Utility.GV_REQUIRED_YES
942: );
943: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
944: ,NULL
945: ,Ja_Cn_Utility.GV_TYPE_NUMBER
946: ,Ja_Cn_Utility.GV_REQUIRED_YES
947: );

Line 945: ,Ja_Cn_Utility.GV_TYPE_NUMBER

941: ,Ja_Cn_Utility.GV_REQUIRED_YES
942: );
943: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
944: ,NULL
945: ,Ja_Cn_Utility.GV_TYPE_NUMBER
946: ,Ja_Cn_Utility.GV_REQUIRED_YES
947: );
948:
949: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'

Line 946: ,Ja_Cn_Utility.GV_REQUIRED_YES

942: );
943: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
944: ,NULL
945: ,Ja_Cn_Utility.GV_TYPE_NUMBER
946: ,Ja_Cn_Utility.GV_REQUIRED_YES
947: );
948:
949: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'
950: ,NULL

Line 949: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'

945: ,Ja_Cn_Utility.GV_TYPE_NUMBER
946: ,Ja_Cn_Utility.GV_REQUIRED_YES
947: );
948:
949: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'
950: ,NULL
951: ,Ja_Cn_Utility.GV_TYPE_NUMBER
952: ,Ja_Cn_Utility.GV_REQUIRED_YES
953: );

Line 951: ,Ja_Cn_Utility.GV_TYPE_NUMBER

947: );
948:
949: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'
950: ,NULL
951: ,Ja_Cn_Utility.GV_TYPE_NUMBER
952: ,Ja_Cn_Utility.GV_REQUIRED_YES
953: );
954: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'
955: ,NULL

Line 952: ,Ja_Cn_Utility.GV_REQUIRED_YES

948:
949: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'
950: ,NULL
951: ,Ja_Cn_Utility.GV_TYPE_NUMBER
952: ,Ja_Cn_Utility.GV_REQUIRED_YES
953: );
954: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'
955: ,NULL
956: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 954: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'

950: ,NULL
951: ,Ja_Cn_Utility.GV_TYPE_NUMBER
952: ,Ja_Cn_Utility.GV_REQUIRED_YES
953: );
954: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'
955: ,NULL
956: ,Ja_Cn_Utility.GV_TYPE_NUMBER
957: ,Ja_Cn_Utility.GV_REQUIRED_YES
958: );

Line 956: ,Ja_Cn_Utility.GV_TYPE_NUMBER

952: ,Ja_Cn_Utility.GV_REQUIRED_YES
953: );
954: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'
955: ,NULL
956: ,Ja_Cn_Utility.GV_TYPE_NUMBER
957: ,Ja_Cn_Utility.GV_REQUIRED_YES
958: );
959: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
960: ,NULL

Line 957: ,Ja_Cn_Utility.GV_REQUIRED_YES

953: );
954: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'
955: ,NULL
956: ,Ja_Cn_Utility.GV_TYPE_NUMBER
957: ,Ja_Cn_Utility.GV_REQUIRED_YES
958: );
959: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
960: ,NULL
961: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 959: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'

955: ,NULL
956: ,Ja_Cn_Utility.GV_TYPE_NUMBER
957: ,Ja_Cn_Utility.GV_REQUIRED_YES
958: );
959: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
960: ,NULL
961: ,Ja_Cn_Utility.GV_TYPE_NUMBER
962: ,Ja_Cn_Utility.GV_REQUIRED_YES
963: );

Line 961: ,Ja_Cn_Utility.GV_TYPE_NUMBER

957: ,Ja_Cn_Utility.GV_REQUIRED_YES
958: );
959: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
960: ,NULL
961: ,Ja_Cn_Utility.GV_TYPE_NUMBER
962: ,Ja_Cn_Utility.GV_REQUIRED_YES
963: );
964: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
965: ,NULL

Line 962: ,Ja_Cn_Utility.GV_REQUIRED_YES

958: );
959: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
960: ,NULL
961: ,Ja_Cn_Utility.GV_TYPE_NUMBER
962: ,Ja_Cn_Utility.GV_REQUIRED_YES
963: );
964: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
965: ,NULL
966: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 964: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'

960: ,NULL
961: ,Ja_Cn_Utility.GV_TYPE_NUMBER
962: ,Ja_Cn_Utility.GV_REQUIRED_YES
963: );
964: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
965: ,NULL
966: ,Ja_Cn_Utility.GV_TYPE_NUMBER
967: ,Ja_Cn_Utility.GV_REQUIRED_YES
968: );

Line 966: ,Ja_Cn_Utility.GV_TYPE_NUMBER

962: ,Ja_Cn_Utility.GV_REQUIRED_YES
963: );
964: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
965: ,NULL
966: ,Ja_Cn_Utility.GV_TYPE_NUMBER
967: ,Ja_Cn_Utility.GV_REQUIRED_YES
968: );
969: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_ACT_EXP_AMOUNT'
970: ,NULL

Line 967: ,Ja_Cn_Utility.GV_REQUIRED_YES

963: );
964: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
965: ,NULL
966: ,Ja_Cn_Utility.GV_TYPE_NUMBER
967: ,Ja_Cn_Utility.GV_REQUIRED_YES
968: );
969: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_ACT_EXP_AMOUNT'
970: ,NULL
971: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 969: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_ACT_EXP_AMOUNT'

965: ,NULL
966: ,Ja_Cn_Utility.GV_TYPE_NUMBER
967: ,Ja_Cn_Utility.GV_REQUIRED_YES
968: );
969: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_ACT_EXP_AMOUNT'
970: ,NULL
971: ,Ja_Cn_Utility.GV_TYPE_NUMBER
972: ,Ja_Cn_Utility.GV_REQUIRED_YES
973: );

Line 971: ,Ja_Cn_Utility.GV_TYPE_NUMBER

967: ,Ja_Cn_Utility.GV_REQUIRED_YES
968: );
969: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_ACT_EXP_AMOUNT'
970: ,NULL
971: ,Ja_Cn_Utility.GV_TYPE_NUMBER
972: ,Ja_Cn_Utility.GV_REQUIRED_YES
973: );
974: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACT_EXP_AMOUNT'
975: ,NULL

Line 972: ,Ja_Cn_Utility.GV_REQUIRED_YES

968: );
969: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_ACT_EXP_AMOUNT'
970: ,NULL
971: ,Ja_Cn_Utility.GV_TYPE_NUMBER
972: ,Ja_Cn_Utility.GV_REQUIRED_YES
973: );
974: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACT_EXP_AMOUNT'
975: ,NULL
976: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 974: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACT_EXP_AMOUNT'

970: ,NULL
971: ,Ja_Cn_Utility.GV_TYPE_NUMBER
972: ,Ja_Cn_Utility.GV_REQUIRED_YES
973: );
974: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACT_EXP_AMOUNT'
975: ,NULL
976: ,Ja_Cn_Utility.GV_TYPE_NUMBER
977: ,Ja_Cn_Utility.GV_REQUIRED_YES
978: );

Line 976: ,Ja_Cn_Utility.GV_TYPE_NUMBER

972: ,Ja_Cn_Utility.GV_REQUIRED_YES
973: );
974: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACT_EXP_AMOUNT'
975: ,NULL
976: ,Ja_Cn_Utility.GV_TYPE_NUMBER
977: ,Ja_Cn_Utility.GV_REQUIRED_YES
978: );
979: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_BAL_AMOUNT'
980: ,NULL

Line 977: ,Ja_Cn_Utility.GV_REQUIRED_YES

973: );
974: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACT_EXP_AMOUNT'
975: ,NULL
976: ,Ja_Cn_Utility.GV_TYPE_NUMBER
977: ,Ja_Cn_Utility.GV_REQUIRED_YES
978: );
979: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_BAL_AMOUNT'
980: ,NULL
981: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 979: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_BAL_AMOUNT'

975: ,NULL
976: ,Ja_Cn_Utility.GV_TYPE_NUMBER
977: ,Ja_Cn_Utility.GV_REQUIRED_YES
978: );
979: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_BAL_AMOUNT'
980: ,NULL
981: ,Ja_Cn_Utility.GV_TYPE_NUMBER
982: ,Ja_Cn_Utility.GV_REQUIRED_YES
983: );

Line 981: ,Ja_Cn_Utility.GV_TYPE_NUMBER

977: ,Ja_Cn_Utility.GV_REQUIRED_YES
978: );
979: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_BAL_AMOUNT'
980: ,NULL
981: ,Ja_Cn_Utility.GV_TYPE_NUMBER
982: ,Ja_Cn_Utility.GV_REQUIRED_YES
983: );
984: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_EXPENDITURE'
985: ,Ja_Cn_Utility.GV_TAG_TYPE_END

Line 982: ,Ja_Cn_Utility.GV_REQUIRED_YES

978: );
979: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_BAL_AMOUNT'
980: ,NULL
981: ,Ja_Cn_Utility.GV_TYPE_NUMBER
982: ,Ja_Cn_Utility.GV_REQUIRED_YES
983: );
984: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_EXPENDITURE'
985: ,Ja_Cn_Utility.GV_TAG_TYPE_END
986: );

Line 984: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_EXPENDITURE'

980: ,NULL
981: ,Ja_Cn_Utility.GV_TYPE_NUMBER
982: ,Ja_Cn_Utility.GV_REQUIRED_YES
983: );
984: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_EXPENDITURE'
985: ,Ja_Cn_Utility.GV_TAG_TYPE_END
986: );
987: END IF; --ln_rec_count = 0
988:

Line 985: ,Ja_Cn_Utility.GV_TAG_TYPE_END

981: ,Ja_Cn_Utility.GV_TYPE_NUMBER
982: ,Ja_Cn_Utility.GV_REQUIRED_YES
983: );
984: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_EXPENDITURE'
985: ,Ja_Cn_Utility.GV_TAG_TYPE_END
986: );
987: END IF; --ln_rec_count = 0
988:
989: --logging for debug