2: /* $Header: bepdwmrt.pkh 120.2 2006/05/16 11:29:29 sparimi noship $ */
3:
4: procedure UPLOAD_RATE(
5: P_RATE_ID in Number,
6: P_PL_TYP_ID in Number default hr_api.g_number,
7: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
8: P_PL_ID in Number default hr_api.g_number,
9: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
10: P_OPT_ID in Number default hr_api.g_number,
3:
4: procedure UPLOAD_RATE(
5: P_RATE_ID in Number,
6: P_PL_TYP_ID in Number default hr_api.g_number,
7: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
8: P_PL_ID in Number default hr_api.g_number,
9: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
10: P_OPT_ID in Number default hr_api.g_number,
11: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
4: procedure UPLOAD_RATE(
5: P_RATE_ID in Number,
6: P_PL_TYP_ID in Number default hr_api.g_number,
7: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
8: P_PL_ID in Number default hr_api.g_number,
9: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
10: P_OPT_ID in Number default hr_api.g_number,
11: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
12: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
5: P_RATE_ID in Number,
6: P_PL_TYP_ID in Number default hr_api.g_number,
7: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
8: P_PL_ID in Number default hr_api.g_number,
9: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
10: P_OPT_ID in Number default hr_api.g_number,
11: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
12: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
13: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
6: P_PL_TYP_ID in Number default hr_api.g_number,
7: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
8: P_PL_ID in Number default hr_api.g_number,
9: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
10: P_OPT_ID in Number default hr_api.g_number,
11: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
12: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
13: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
14: P_RATE_TYPE in varchar2,
7: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
8: P_PL_ID in Number default hr_api.g_number,
9: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
10: P_OPT_ID in Number default hr_api.g_number,
11: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
12: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
13: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
14: P_RATE_TYPE in varchar2,
15: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
8: P_PL_ID in Number default hr_api.g_number,
9: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
10: P_OPT_ID in Number default hr_api.g_number,
11: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
12: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
13: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
14: P_RATE_TYPE in varchar2,
15: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
16: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
9: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
10: P_OPT_ID in Number default hr_api.g_number,
11: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
12: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
13: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
14: P_RATE_TYPE in varchar2,
15: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
16: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
17: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
11: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
12: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
13: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
14: P_RATE_TYPE in varchar2,
15: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
16: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
17: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
18: P_OLD_VAL in number default hr_api.g_number,
19: P_NEW_VAL in number default hr_api.g_number,
12: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
13: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
14: P_RATE_TYPE in varchar2,
15: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
16: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
17: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
18: P_OLD_VAL in number default hr_api.g_number,
19: P_NEW_VAL in number default hr_api.g_number,
20: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
13: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
14: P_RATE_TYPE in varchar2,
15: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
16: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
17: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
18: P_OLD_VAL in number default hr_api.g_number,
19: P_NEW_VAL in number default hr_api.g_number,
20: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
21: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
14: P_RATE_TYPE in varchar2,
15: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
16: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
17: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
18: P_OLD_VAL in number default hr_api.g_number,
19: P_NEW_VAL in number default hr_api.g_number,
20: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
21: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
22: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
15: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
16: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
17: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
18: P_OLD_VAL in number default hr_api.g_number,
19: P_NEW_VAL in number default hr_api.g_number,
20: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
21: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
22: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
23: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2,
16: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
17: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
18: P_OLD_VAL in number default hr_api.g_number,
19: P_NEW_VAL in number default hr_api.g_number,
20: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
21: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
22: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
23: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2,
24: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2,
17: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
18: P_OLD_VAL in number default hr_api.g_number,
19: P_NEW_VAL in number default hr_api.g_number,
20: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
21: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
22: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
23: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2,
24: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2,
25: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2,
18: P_OLD_VAL in number default hr_api.g_number,
19: P_NEW_VAL in number default hr_api.g_number,
20: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
21: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
22: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
23: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2,
24: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2,
25: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2,
26: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,
19: P_NEW_VAL in number default hr_api.g_number,
20: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
21: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
22: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
23: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2,
24: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2,
25: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2,
26: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,
27: P_OBJECT_VERSION_NUMBER in number,
20: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
21: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
22: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
23: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2,
24: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2,
25: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2,
26: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,
27: P_OBJECT_VERSION_NUMBER in number,
28: P_EFFECTIVE_START_DATE in date,
21: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
22: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
23: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2,
24: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2,
25: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2,
26: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,
27: P_OBJECT_VERSION_NUMBER in number,
28: P_EFFECTIVE_START_DATE in date,
29: P_EFFECTIVE_END_DATE in date,
22: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
23: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2,
24: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2,
25: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2,
26: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,
27: P_OBJECT_VERSION_NUMBER in number,
28: P_EFFECTIVE_START_DATE in date,
29: P_EFFECTIVE_END_DATE in date,
30: P_DATETRACK_MODE in varchar2,