APPS.JA_CN_PS_BI_EXPORT_PKG dependencies on JA_CN_UTILITY

Line 424: lv_income_cat_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CICA'

420: -- 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
421: -- 'pn_ledger_id=' || pn_ledger_id || ',' ||
422: -- 'pv_accounting_year=' || pv_accounting_year);
423:
424: lv_income_cat_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CICA'
425: ,pn_application_id => 101
426: ,pn_coa_id => pn_coa_id
427: );
428: lv_income_proj_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CIPR'

Line 428: lv_income_proj_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CIPR'

424: lv_income_cat_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CICA'
425: ,pn_application_id => 101
426: ,pn_coa_id => pn_coa_id
427: );
428: lv_income_proj_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CIPR'
429: ,pn_application_id => 101
430: ,pn_coa_id => pn_coa_id
431: );
432: lv_budget_type_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CBTY'

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

428: lv_income_proj_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CIPR'
429: ,pn_application_id => 101
430: ,pn_coa_id => pn_coa_id
431: );
432: lv_budget_type_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CBTY'
433: ,pn_application_id => 101
434: ,pn_coa_id => pn_coa_id
435: );
436: lv_budget_type_value := JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id

Line 436: lv_budget_type_value := JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id

432: lv_budget_type_seg_col := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CBTY'
433: ,pn_application_id => 101
434: ,pn_coa_id => pn_coa_id
435: );
436: lv_budget_type_value := JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
437: ,pv_flexfield_code => 'LYBA'
438: );
439:
440: --fixed bug 10316565 by ChuanLing Shao

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

493: END IF;
494: --2) BSV condition
495: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND EXISTS (SELECT llbg.Bal_Seg_Value ';
496: lv_bi_cursor_sql := lv_bi_cursor_sql || ' FROM ja_cn_ledger_le_bsv_gt llbg';
497: lv_bi_cursor_sql := lv_bi_cursor_sql || ' WHERE JA_CN_UTILITY.get_balancing_segment(gcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value';
498: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND llbg.Ledger_Id = ' || pn_ledger_id; --parameter: pn_ledger_id
499: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND llbg.Legal_Entity_Id = ' || pn_legal_entity_id || ')'; --parameter: pn_legal_entity_id
500: --4) Period condition
501: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND Gle.period_set_name = Gp.period_set_name';

Line 563: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'

559: --INTO lv_accounting_period_num,lv_accounting_period,lv_income_cat_seg_code,lv_income_proj_seg_code;
560: INTO lv_income_cat_seg_code,lv_income_proj_seg_code;
561: EXIT WHEN lc_budget_information%NOTFOUND;
562:
563: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'
564: ,Ja_Cn_Utility.GV_TAG_TYPE_START
565: );
566: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
567: ,pv_accounting_year

Line 564: ,Ja_Cn_Utility.GV_TAG_TYPE_START

560: INTO lv_income_cat_seg_code,lv_income_proj_seg_code;
561: EXIT WHEN lc_budget_information%NOTFOUND;
562:
563: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'
564: ,Ja_Cn_Utility.GV_TAG_TYPE_START
565: );
566: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
567: ,pv_accounting_year
568: );

Line 566: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'

562:
563: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'
564: ,Ja_Cn_Utility.GV_TAG_TYPE_START
565: );
566: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
567: ,pv_accounting_year
568: );
569: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
570: ,lv_accounting_period_num

Line 569: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'

565: );
566: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
567: ,pv_accounting_year
568: );
569: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
570: ,lv_accounting_period_num
571: );
572: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_CODE'
573: ,lv_income_cat_seg_code

Line 572: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_CODE'

568: );
569: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
570: ,lv_accounting_period_num
571: );
572: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_CODE'
573: ,lv_income_cat_seg_code
574: );
575: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_NAME'
576: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CICA'

Line 575: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_NAME'

571: );
572: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_CODE'
573: ,lv_income_cat_seg_code
574: );
575: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_NAME'
576: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CICA'
577: ,pv_flex_value => lv_income_cat_seg_code
578: ,pn_coa_id => pn_coa_id)
579: );

Line 576: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CICA'

572: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_CODE'
573: ,lv_income_cat_seg_code
574: );
575: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_NAME'
576: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CICA'
577: ,pv_flex_value => lv_income_cat_seg_code
578: ,pn_coa_id => pn_coa_id)
579: );
580: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_CODE'

Line 580: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_CODE'

576: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CICA'
577: ,pv_flex_value => lv_income_cat_seg_code
578: ,pn_coa_id => pn_coa_id)
579: );
580: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_CODE'
581: ,lv_income_proj_seg_code
582: );
583: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_NAME'
584: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CIPR'

Line 583: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_NAME'

579: );
580: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_CODE'
581: ,lv_income_proj_seg_code
582: );
583: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_NAME'
584: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CIPR'
585: ,pv_flex_value => lv_income_proj_seg_code
586: ,pn_coa_id => pn_coa_id)
587: );

Line 584: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CIPR'

580: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_CODE'
581: ,lv_income_proj_seg_code
582: );
583: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_NAME'
584: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CIPR'
585: ,pv_flex_value => lv_income_proj_seg_code
586: ,pn_coa_id => pn_coa_id)
587: );
588: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'

Line 588: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'

584: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CIPR'
585: ,pv_flex_value => lv_income_proj_seg_code
586: ,pn_coa_id => pn_coa_id)
587: );
588: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
589: ,Get_Budget_Income_Amount(pn_ledger_id
590: ,lv_income_cat_seg_col
591: ,lv_income_cat_seg_code
592: ,lv_income_proj_seg_col

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

591: ,lv_income_cat_seg_code
592: ,lv_income_proj_seg_col
593: ,lv_income_proj_seg_code
594: ,lv_budget_type_seg_col
595: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
596: ,pv_flexfield_code => 'CYBA')
597: ,pv_accounting_year
598: ,NULL
599: ,NULL

Line 601: ,Ja_Cn_Utility.GV_TYPE_NUMBER

597: ,pv_accounting_year
598: ,NULL
599: ,NULL
600: )
601: ,Ja_Cn_Utility.GV_TYPE_NUMBER
602: ,Ja_Cn_Utility.GV_REQUIRED_YES
603: );
604: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'
605: ,Get_Budget_Income_Amount(pn_ledger_id

Line 602: ,Ja_Cn_Utility.GV_REQUIRED_YES

598: ,NULL
599: ,NULL
600: )
601: ,Ja_Cn_Utility.GV_TYPE_NUMBER
602: ,Ja_Cn_Utility.GV_REQUIRED_YES
603: );
604: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'
605: ,Get_Budget_Income_Amount(pn_ledger_id
606: ,lv_income_cat_seg_col

Line 604: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'

600: )
601: ,Ja_Cn_Utility.GV_TYPE_NUMBER
602: ,Ja_Cn_Utility.GV_REQUIRED_YES
603: );
604: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'
605: ,Get_Budget_Income_Amount(pn_ledger_id
606: ,lv_income_cat_seg_col
607: ,lv_income_cat_seg_code
608: ,lv_income_proj_seg_col

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

607: ,lv_income_cat_seg_code
608: ,lv_income_proj_seg_col
609: ,lv_income_proj_seg_code
610: ,lv_budget_type_seg_col
611: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
612: ,pv_flexfield_code => 'ICPA')
613: ,NULL
614: ,lv_accounting_period
615: ,lv_accounting_period

Line 617: ,Ja_Cn_Utility.GV_TYPE_NUMBER

613: ,NULL
614: ,lv_accounting_period
615: ,lv_accounting_period
616: )
617: ,Ja_Cn_Utility.GV_TYPE_NUMBER
618: ,Ja_Cn_Utility.GV_REQUIRED_YES
619: );
620: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'
621: ,Get_Budget_Income_Amount(pn_ledger_id

Line 618: ,Ja_Cn_Utility.GV_REQUIRED_YES

614: ,lv_accounting_period
615: ,lv_accounting_period
616: )
617: ,Ja_Cn_Utility.GV_TYPE_NUMBER
618: ,Ja_Cn_Utility.GV_REQUIRED_YES
619: );
620: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'
621: ,Get_Budget_Income_Amount(pn_ledger_id
622: ,lv_income_cat_seg_col

Line 620: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'

616: )
617: ,Ja_Cn_Utility.GV_TYPE_NUMBER
618: ,Ja_Cn_Utility.GV_REQUIRED_YES
619: );
620: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'
621: ,Get_Budget_Income_Amount(pn_ledger_id
622: ,lv_income_cat_seg_col
623: ,lv_income_cat_seg_code
624: ,lv_income_proj_seg_col

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

623: ,lv_income_cat_seg_code
624: ,lv_income_proj_seg_col
625: ,lv_income_proj_seg_code
626: ,lv_budget_type_seg_col
627: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
628: ,pv_flexfield_code => 'DCPA')
629: ,NULL
630: ,lv_accounting_period
631: ,lv_accounting_period

Line 633: ,Ja_Cn_Utility.GV_TYPE_NUMBER

629: ,NULL
630: ,lv_accounting_period
631: ,lv_accounting_period
632: )
633: ,Ja_Cn_Utility.GV_TYPE_NUMBER
634: ,Ja_Cn_Utility.GV_REQUIRED_YES
635: );
636: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
637: ,Get_Budget_Income_Amount(pn_ledger_id

Line 634: ,Ja_Cn_Utility.GV_REQUIRED_YES

630: ,lv_accounting_period
631: ,lv_accounting_period
632: )
633: ,Ja_Cn_Utility.GV_TYPE_NUMBER
634: ,Ja_Cn_Utility.GV_REQUIRED_YES
635: );
636: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
637: ,Get_Budget_Income_Amount(pn_ledger_id
638: ,lv_income_cat_seg_col

Line 636: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'

632: )
633: ,Ja_Cn_Utility.GV_TYPE_NUMBER
634: ,Ja_Cn_Utility.GV_REQUIRED_YES
635: );
636: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
637: ,Get_Budget_Income_Amount(pn_ledger_id
638: ,lv_income_cat_seg_col
639: ,lv_income_cat_seg_code
640: ,lv_income_proj_seg_col

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

639: ,lv_income_cat_seg_code
640: ,lv_income_proj_seg_col
641: ,lv_income_proj_seg_code
642: ,lv_budget_type_seg_col
643: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
644: ,pv_flexfield_code => 'ICPA')
645: ,pv_accounting_year
646: ,NULL
647: ,lv_accounting_period

Line 649: ,Ja_Cn_Utility.GV_TYPE_NUMBER

645: ,pv_accounting_year
646: ,NULL
647: ,lv_accounting_period
648: )
649: ,Ja_Cn_Utility.GV_TYPE_NUMBER
650: ,Ja_Cn_Utility.GV_REQUIRED_YES
651: );
652: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
653: ,Get_Budget_Income_Amount(pn_ledger_id

Line 650: ,Ja_Cn_Utility.GV_REQUIRED_YES

646: ,NULL
647: ,lv_accounting_period
648: )
649: ,Ja_Cn_Utility.GV_TYPE_NUMBER
650: ,Ja_Cn_Utility.GV_REQUIRED_YES
651: );
652: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
653: ,Get_Budget_Income_Amount(pn_ledger_id
654: ,lv_income_cat_seg_col

Line 652: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'

648: )
649: ,Ja_Cn_Utility.GV_TYPE_NUMBER
650: ,Ja_Cn_Utility.GV_REQUIRED_YES
651: );
652: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
653: ,Get_Budget_Income_Amount(pn_ledger_id
654: ,lv_income_cat_seg_col
655: ,lv_income_cat_seg_code
656: ,lv_income_proj_seg_col

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

655: ,lv_income_cat_seg_code
656: ,lv_income_proj_seg_col
657: ,lv_income_proj_seg_code
658: ,lv_budget_type_seg_col
659: ,JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
660: ,pv_flexfield_code => 'DCPA')
661: ,pv_accounting_year
662: ,NULL
663: ,lv_accounting_period

Line 665: ,Ja_Cn_Utility.GV_TYPE_NUMBER

661: ,pv_accounting_year
662: ,NULL
663: ,lv_accounting_period
664: )
665: ,Ja_Cn_Utility.GV_TYPE_NUMBER
666: ,Ja_Cn_Utility.GV_REQUIRED_YES
667: );
668: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INCOME_AMOUNT'
669: ,Get_Actual_Income_Amount(pn_ledger_id

Line 666: ,Ja_Cn_Utility.GV_REQUIRED_YES

662: ,NULL
663: ,lv_accounting_period
664: )
665: ,Ja_Cn_Utility.GV_TYPE_NUMBER
666: ,Ja_Cn_Utility.GV_REQUIRED_YES
667: );
668: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INCOME_AMOUNT'
669: ,Get_Actual_Income_Amount(pn_ledger_id
670: ,lv_income_cat_seg_col

Line 668: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INCOME_AMOUNT'

664: )
665: ,Ja_Cn_Utility.GV_TYPE_NUMBER
666: ,Ja_Cn_Utility.GV_REQUIRED_YES
667: );
668: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INCOME_AMOUNT'
669: ,Get_Actual_Income_Amount(pn_ledger_id
670: ,lv_income_cat_seg_col
671: ,lv_income_cat_seg_code
672: ,lv_income_proj_seg_col

Line 678: ,Ja_Cn_Utility.GV_TYPE_NUMBER

674: ,NULL
675: ,lv_accounting_period
676: ,lv_accounting_period
677: )
678: ,Ja_Cn_Utility.GV_TYPE_NUMBER
679: ,Ja_Cn_Utility.GV_REQUIRED_YES
680: );
681: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACTUAL_INCOME_AMT'
682: ,Get_Actual_Income_Amount(pn_ledger_id

Line 679: ,Ja_Cn_Utility.GV_REQUIRED_YES

675: ,lv_accounting_period
676: ,lv_accounting_period
677: )
678: ,Ja_Cn_Utility.GV_TYPE_NUMBER
679: ,Ja_Cn_Utility.GV_REQUIRED_YES
680: );
681: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACTUAL_INCOME_AMT'
682: ,Get_Actual_Income_Amount(pn_ledger_id
683: ,lv_income_cat_seg_col

Line 681: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACTUAL_INCOME_AMT'

677: )
678: ,Ja_Cn_Utility.GV_TYPE_NUMBER
679: ,Ja_Cn_Utility.GV_REQUIRED_YES
680: );
681: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACTUAL_INCOME_AMT'
682: ,Get_Actual_Income_Amount(pn_ledger_id
683: ,lv_income_cat_seg_col
684: ,lv_income_cat_seg_code
685: ,lv_income_proj_seg_col

Line 691: ,Ja_Cn_Utility.GV_TYPE_NUMBER

687: ,pv_accounting_year
688: ,NULL
689: ,lv_accounting_period
690: )
691: ,Ja_Cn_Utility.GV_TYPE_NUMBER
692: ,Ja_Cn_Utility.GV_REQUIRED_YES
693: );
694: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'
695: ,Ja_Cn_Utility.GV_TAG_TYPE_END

Line 692: ,Ja_Cn_Utility.GV_REQUIRED_YES

688: ,NULL
689: ,lv_accounting_period
690: )
691: ,Ja_Cn_Utility.GV_TYPE_NUMBER
692: ,Ja_Cn_Utility.GV_REQUIRED_YES
693: );
694: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'
695: ,Ja_Cn_Utility.GV_TAG_TYPE_END
696: );

Line 694: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'

690: )
691: ,Ja_Cn_Utility.GV_TYPE_NUMBER
692: ,Ja_Cn_Utility.GV_REQUIRED_YES
693: );
694: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'
695: ,Ja_Cn_Utility.GV_TAG_TYPE_END
696: );
697: ln_rec_count := ln_rec_count + 1;
698:

Line 695: ,Ja_Cn_Utility.GV_TAG_TYPE_END

691: ,Ja_Cn_Utility.GV_TYPE_NUMBER
692: ,Ja_Cn_Utility.GV_REQUIRED_YES
693: );
694: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'
695: ,Ja_Cn_Utility.GV_TAG_TYPE_END
696: );
697: ln_rec_count := ln_rec_count + 1;
698:
699: END LOOP;

Line 720: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'

716:
717: -- There is no data found for employee record
718: IF ln_rec_count = 0
719: THEN
720: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'
721: ,Ja_Cn_Utility.GV_TAG_TYPE_START
722: );
723: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
724: ,pv_accounting_year

Line 721: ,Ja_Cn_Utility.GV_TAG_TYPE_START

717: -- There is no data found for employee record
718: IF ln_rec_count = 0
719: THEN
720: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'
721: ,Ja_Cn_Utility.GV_TAG_TYPE_START
722: );
723: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
724: ,pv_accounting_year
725: ,4

Line 723: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'

719: THEN
720: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'
721: ,Ja_Cn_Utility.GV_TAG_TYPE_START
722: );
723: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
724: ,pv_accounting_year
725: ,4
726: ,Ja_Cn_Utility.GV_REQUIRED_YES
727: ,Ja_Cn_Utility.GV_MODULE_GLSI

Line 726: ,Ja_Cn_Utility.GV_REQUIRED_YES

722: );
723: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
724: ,pv_accounting_year
725: ,4
726: ,Ja_Cn_Utility.GV_REQUIRED_YES
727: ,Ja_Cn_Utility.GV_MODULE_GLSI
728: );
729: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
730: ,NULL

Line 727: ,Ja_Cn_Utility.GV_MODULE_GLSI

723: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
724: ,pv_accounting_year
725: ,4
726: ,Ja_Cn_Utility.GV_REQUIRED_YES
727: ,Ja_Cn_Utility.GV_MODULE_GLSI
728: );
729: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
730: ,NULL
731: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 729: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'

725: ,4
726: ,Ja_Cn_Utility.GV_REQUIRED_YES
727: ,Ja_Cn_Utility.GV_MODULE_GLSI
728: );
729: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
730: ,NULL
731: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
732: ,Ja_Cn_Utility.GV_REQUIRED_YES
733: );

Line 731: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

727: ,Ja_Cn_Utility.GV_MODULE_GLSI
728: );
729: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
730: ,NULL
731: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
732: ,Ja_Cn_Utility.GV_REQUIRED_YES
733: );
734: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_CODE'
735: ,NULL

Line 732: ,Ja_Cn_Utility.GV_REQUIRED_YES

728: );
729: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
730: ,NULL
731: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
732: ,Ja_Cn_Utility.GV_REQUIRED_YES
733: );
734: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_CODE'
735: ,NULL
736: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 734: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_CODE'

730: ,NULL
731: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
732: ,Ja_Cn_Utility.GV_REQUIRED_YES
733: );
734: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_CODE'
735: ,NULL
736: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
737: ,Ja_Cn_Utility.GV_REQUIRED_YES
738: );

Line 736: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

732: ,Ja_Cn_Utility.GV_REQUIRED_YES
733: );
734: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_CODE'
735: ,NULL
736: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
737: ,Ja_Cn_Utility.GV_REQUIRED_YES
738: );
739: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_NAME'
740: ,NULL

Line 737: ,Ja_Cn_Utility.GV_REQUIRED_YES

733: );
734: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_CODE'
735: ,NULL
736: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
737: ,Ja_Cn_Utility.GV_REQUIRED_YES
738: );
739: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_NAME'
740: ,NULL
741: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 739: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_NAME'

735: ,NULL
736: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
737: ,Ja_Cn_Utility.GV_REQUIRED_YES
738: );
739: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_NAME'
740: ,NULL
741: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
742: ,Ja_Cn_Utility.GV_REQUIRED_YES
743: );

Line 741: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

737: ,Ja_Cn_Utility.GV_REQUIRED_YES
738: );
739: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_NAME'
740: ,NULL
741: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
742: ,Ja_Cn_Utility.GV_REQUIRED_YES
743: );
744: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_CODE'
745: ,NULL

Line 742: ,Ja_Cn_Utility.GV_REQUIRED_YES

738: );
739: Ja_Cn_Utility.Add_Child_Node('INCOME_CATEGORY_NAME'
740: ,NULL
741: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
742: ,Ja_Cn_Utility.GV_REQUIRED_YES
743: );
744: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_CODE'
745: ,NULL
746: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 744: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_CODE'

740: ,NULL
741: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
742: ,Ja_Cn_Utility.GV_REQUIRED_YES
743: );
744: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_CODE'
745: ,NULL
746: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
747: ,Ja_Cn_Utility.GV_REQUIRED_YES
748: );

Line 746: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

742: ,Ja_Cn_Utility.GV_REQUIRED_YES
743: );
744: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_CODE'
745: ,NULL
746: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
747: ,Ja_Cn_Utility.GV_REQUIRED_YES
748: );
749: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_NAME'
750: ,NULL

Line 747: ,Ja_Cn_Utility.GV_REQUIRED_YES

743: );
744: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_CODE'
745: ,NULL
746: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
747: ,Ja_Cn_Utility.GV_REQUIRED_YES
748: );
749: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_NAME'
750: ,NULL
751: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 749: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_NAME'

745: ,NULL
746: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
747: ,Ja_Cn_Utility.GV_REQUIRED_YES
748: );
749: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_NAME'
750: ,NULL
751: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
752: ,Ja_Cn_Utility.GV_REQUIRED_YES
753: );

Line 751: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

747: ,Ja_Cn_Utility.GV_REQUIRED_YES
748: );
749: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_NAME'
750: ,NULL
751: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
752: ,Ja_Cn_Utility.GV_REQUIRED_YES
753: );
754: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
755: ,NULL

Line 752: ,Ja_Cn_Utility.GV_REQUIRED_YES

748: );
749: Ja_Cn_Utility.Add_Child_Node('INCOME_PROJECT_NAME'
750: ,NULL
751: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
752: ,Ja_Cn_Utility.GV_REQUIRED_YES
753: );
754: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
755: ,NULL
756: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 754: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'

750: ,NULL
751: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
752: ,Ja_Cn_Utility.GV_REQUIRED_YES
753: );
754: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
755: ,NULL
756: ,Ja_Cn_Utility.GV_TYPE_NUMBER
757: ,Ja_Cn_Utility.GV_REQUIRED_YES
758: );

Line 756: ,Ja_Cn_Utility.GV_TYPE_NUMBER

752: ,Ja_Cn_Utility.GV_REQUIRED_YES
753: );
754: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
755: ,NULL
756: ,Ja_Cn_Utility.GV_TYPE_NUMBER
757: ,Ja_Cn_Utility.GV_REQUIRED_YES
758: );
759: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'
760: ,NULL

Line 757: ,Ja_Cn_Utility.GV_REQUIRED_YES

753: );
754: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
755: ,NULL
756: ,Ja_Cn_Utility.GV_TYPE_NUMBER
757: ,Ja_Cn_Utility.GV_REQUIRED_YES
758: );
759: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'
760: ,NULL
761: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 759: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'

755: ,NULL
756: ,Ja_Cn_Utility.GV_TYPE_NUMBER
757: ,Ja_Cn_Utility.GV_REQUIRED_YES
758: );
759: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'
760: ,NULL
761: ,Ja_Cn_Utility.GV_TYPE_NUMBER
762: ,Ja_Cn_Utility.GV_REQUIRED_YES
763: );

Line 761: ,Ja_Cn_Utility.GV_TYPE_NUMBER

757: ,Ja_Cn_Utility.GV_REQUIRED_YES
758: );
759: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'
760: ,NULL
761: ,Ja_Cn_Utility.GV_TYPE_NUMBER
762: ,Ja_Cn_Utility.GV_REQUIRED_YES
763: );
764: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'
765: ,NULL

Line 762: ,Ja_Cn_Utility.GV_REQUIRED_YES

758: );
759: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INC_AMOUNT'
760: ,NULL
761: ,Ja_Cn_Utility.GV_TYPE_NUMBER
762: ,Ja_Cn_Utility.GV_REQUIRED_YES
763: );
764: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'
765: ,NULL
766: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 764: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'

760: ,NULL
761: ,Ja_Cn_Utility.GV_TYPE_NUMBER
762: ,Ja_Cn_Utility.GV_REQUIRED_YES
763: );
764: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'
765: ,NULL
766: ,Ja_Cn_Utility.GV_TYPE_NUMBER
767: ,Ja_Cn_Utility.GV_REQUIRED_YES
768: );

Line 766: ,Ja_Cn_Utility.GV_TYPE_NUMBER

762: ,Ja_Cn_Utility.GV_REQUIRED_YES
763: );
764: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'
765: ,NULL
766: ,Ja_Cn_Utility.GV_TYPE_NUMBER
767: ,Ja_Cn_Utility.GV_REQUIRED_YES
768: );
769: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
770: ,NULL

Line 767: ,Ja_Cn_Utility.GV_REQUIRED_YES

763: );
764: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_DEC_AMOUNT'
765: ,NULL
766: ,Ja_Cn_Utility.GV_TYPE_NUMBER
767: ,Ja_Cn_Utility.GV_REQUIRED_YES
768: );
769: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
770: ,NULL
771: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 769: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'

765: ,NULL
766: ,Ja_Cn_Utility.GV_TYPE_NUMBER
767: ,Ja_Cn_Utility.GV_REQUIRED_YES
768: );
769: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
770: ,NULL
771: ,Ja_Cn_Utility.GV_TYPE_NUMBER
772: ,Ja_Cn_Utility.GV_REQUIRED_YES
773: );

Line 771: ,Ja_Cn_Utility.GV_TYPE_NUMBER

767: ,Ja_Cn_Utility.GV_REQUIRED_YES
768: );
769: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
770: ,NULL
771: ,Ja_Cn_Utility.GV_TYPE_NUMBER
772: ,Ja_Cn_Utility.GV_REQUIRED_YES
773: );
774: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
775: ,NULL

Line 772: ,Ja_Cn_Utility.GV_REQUIRED_YES

768: );
769: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
770: ,NULL
771: ,Ja_Cn_Utility.GV_TYPE_NUMBER
772: ,Ja_Cn_Utility.GV_REQUIRED_YES
773: );
774: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
775: ,NULL
776: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 774: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'

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

Line 776: ,Ja_Cn_Utility.GV_TYPE_NUMBER

772: ,Ja_Cn_Utility.GV_REQUIRED_YES
773: );
774: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
775: ,NULL
776: ,Ja_Cn_Utility.GV_TYPE_NUMBER
777: ,Ja_Cn_Utility.GV_REQUIRED_YES
778: );
779: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INCOME_AMOUNT'
780: ,NULL

Line 777: ,Ja_Cn_Utility.GV_REQUIRED_YES

773: );
774: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
775: ,NULL
776: ,Ja_Cn_Utility.GV_TYPE_NUMBER
777: ,Ja_Cn_Utility.GV_REQUIRED_YES
778: );
779: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INCOME_AMOUNT'
780: ,NULL
781: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 779: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INCOME_AMOUNT'

775: ,NULL
776: ,Ja_Cn_Utility.GV_TYPE_NUMBER
777: ,Ja_Cn_Utility.GV_REQUIRED_YES
778: );
779: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INCOME_AMOUNT'
780: ,NULL
781: ,Ja_Cn_Utility.GV_TYPE_NUMBER
782: ,Ja_Cn_Utility.GV_REQUIRED_YES
783: );

Line 781: ,Ja_Cn_Utility.GV_TYPE_NUMBER

777: ,Ja_Cn_Utility.GV_REQUIRED_YES
778: );
779: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INCOME_AMOUNT'
780: ,NULL
781: ,Ja_Cn_Utility.GV_TYPE_NUMBER
782: ,Ja_Cn_Utility.GV_REQUIRED_YES
783: );
784: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACTUAL_INCOME_AMT'
785: ,NULL

Line 782: ,Ja_Cn_Utility.GV_REQUIRED_YES

778: );
779: Ja_Cn_Utility.Add_Child_Node('CURRENT_PERIOD_INCOME_AMOUNT'
780: ,NULL
781: ,Ja_Cn_Utility.GV_TYPE_NUMBER
782: ,Ja_Cn_Utility.GV_REQUIRED_YES
783: );
784: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACTUAL_INCOME_AMT'
785: ,NULL
786: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 784: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACTUAL_INCOME_AMT'

780: ,NULL
781: ,Ja_Cn_Utility.GV_TYPE_NUMBER
782: ,Ja_Cn_Utility.GV_REQUIRED_YES
783: );
784: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACTUAL_INCOME_AMT'
785: ,NULL
786: ,Ja_Cn_Utility.GV_TYPE_NUMBER
787: ,Ja_Cn_Utility.GV_REQUIRED_YES
788: );

Line 786: ,Ja_Cn_Utility.GV_TYPE_NUMBER

782: ,Ja_Cn_Utility.GV_REQUIRED_YES
783: );
784: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACTUAL_INCOME_AMT'
785: ,NULL
786: ,Ja_Cn_Utility.GV_TYPE_NUMBER
787: ,Ja_Cn_Utility.GV_REQUIRED_YES
788: );
789: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'
790: ,Ja_Cn_Utility.GV_TAG_TYPE_END

Line 787: ,Ja_Cn_Utility.GV_REQUIRED_YES

783: );
784: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_ACTUAL_INCOME_AMT'
785: ,NULL
786: ,Ja_Cn_Utility.GV_TYPE_NUMBER
787: ,Ja_Cn_Utility.GV_REQUIRED_YES
788: );
789: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'
790: ,Ja_Cn_Utility.GV_TAG_TYPE_END
791: );

Line 789: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'

785: ,NULL
786: ,Ja_Cn_Utility.GV_TYPE_NUMBER
787: ,Ja_Cn_Utility.GV_REQUIRED_YES
788: );
789: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'
790: ,Ja_Cn_Utility.GV_TAG_TYPE_END
791: );
792: END IF; --ln_rec_count = 0
793:

Line 790: ,Ja_Cn_Utility.GV_TAG_TYPE_END

786: ,Ja_Cn_Utility.GV_TYPE_NUMBER
787: ,Ja_Cn_Utility.GV_REQUIRED_YES
788: );
789: Ja_Cn_Utility.Add_Sub_Root_Node('BUDGET_INCOME'
790: ,Ja_Cn_Utility.GV_TAG_TYPE_END
791: );
792: END IF; --ln_rec_count = 0
793:
794: --logging for debug