DBA Data[Home] [Help]

APPS.BEN_PDW_MASS_UPD_RATES dependencies on HR_API

Line 6: P_PL_TYP_ID in Number default hr_api.g_number,

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,

Line 7: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,

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,

Line 8: P_PL_ID in Number default hr_api.g_number,

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,

Line 9: P_PLAN_NAME 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,

Line 10: P_OPT_ID in Number default hr_api.g_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,
14: P_RATE_TYPE in varchar2,

Line 11: P_OPTION_NAME in varchar2 default hr_api.g_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,

Line 12: P_ABR_LEVEL 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,

Line 13: P_RT_MLT_CD 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,

Line 15: P_RATE_NAME 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,

Line 16: P_VARIABLE_RATE_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,
20: P_RNDG_CD in varchar2 default hr_api.g_varchar2,

Line 17: P_ACTY_TYP_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,

Line 18: P_OLD_VAL in number default hr_api.g_number,

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,

Line 19: P_NEW_VAL in number default hr_api.g_number,

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,

Line 20: P_RNDG_CD 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,
24: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2,

Line 21: P_RT_TYP_CD 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,
25: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2,

Line 22: P_BNFT_RT_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,
26: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,

Line 23: P_COMP_LVL_FCTR_ID in number 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,

Line 24: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2,

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,

Line 25: P_INPUT_VALUE_ID 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,
29: P_EFFECTIVE_END_DATE in date,

Line 26: P_ELE_ENTRY_VAL_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,
30: P_DATETRACK_MODE in varchar2,