4: /* ------------------------------------------------------------------------------------
5: -- Define Global Value, which are parameter values in HR_JP_PARAMETERS.
6: -- HR_JPBAL, HR_JPDRB call them.
7: -- ------------------------------------------------------------------------------------ */
8: g_asg_run PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RUN';
9: g_asg_proc_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_PTD';
10: g_asg_mtd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12';
11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
5: -- Define Global Value, which are parameter values in HR_JP_PARAMETERS.
6: -- HR_JPBAL, HR_JPDRB call them.
7: -- ------------------------------------------------------------------------------------ */
8: g_asg_run PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RUN';
9: g_asg_proc_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_PTD';
10: g_asg_mtd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12';
11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
6: -- HR_JPBAL, HR_JPDRB call them.
7: -- ------------------------------------------------------------------------------------ */
8: g_asg_run PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RUN';
9: g_asg_proc_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_PTD';
10: g_asg_mtd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12';
11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
7: -- ------------------------------------------------------------------------------------ */
8: g_asg_run PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RUN';
9: g_asg_proc_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_PTD';
10: g_asg_mtd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12';
11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
8: g_asg_run PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RUN';
9: g_asg_proc_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_PTD';
10: g_asg_mtd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12';
11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
9: g_asg_proc_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_PTD';
10: g_asg_mtd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12';
11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';
10: g_asg_mtd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12';
11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';
18: g_element_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_PTD';
11: g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';
18: g_element_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_PTD';
19: g_payment PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_PAYMENTS';
12: g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';
18: g_element_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_PTD';
19: g_payment PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_PAYMENTS';
20: g_asg_fytd2_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_BYTD';
13: g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';
18: g_element_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_PTD';
19: g_payment PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_PAYMENTS';
20: g_asg_fytd2_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_BYTD';
21: /* ------------------------------------------------------------------------------------ */
14: g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';
18: g_element_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_PTD';
19: g_payment PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_PAYMENTS';
20: g_asg_fytd2_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_BYTD';
21: /* ------------------------------------------------------------------------------------ */
22: FUNCTION span_start(
15: g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';
18: g_element_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_PTD';
19: g_payment PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_PAYMENTS';
20: g_asg_fytd2_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_BYTD';
21: /* ------------------------------------------------------------------------------------ */
22: FUNCTION span_start(
23: p_input_date IN DATE,
16: g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17: g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';
18: g_element_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_PTD';
19: g_payment PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_PAYMENTS';
20: g_asg_fytd2_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_BYTD';
21: /* ------------------------------------------------------------------------------------ */
22: FUNCTION span_start(
23: p_input_date IN DATE,
24: p_frequency IN NUMBER,