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.BEN_PDW_MASS_UPD_RATES dependencies on HR_API

Line 20: if p_effective_end_date <> hr_api.g_eot then

16: hr_utility.set_location('p_effective_start_date '||p_effective_start_date,10);
17: hr_utility.set_location('p_effective_end_date '||p_effective_end_date,10);
18: hr_utility.set_location('p_effective_date '||p_effective_date,10);
19: --
20: if p_effective_end_date <> hr_api.g_eot then
21: --
22: if p_dml_operation = 'INSERT' then
23: --
24: l_datetrack_mode := hr_api.g_update;

Line 24: l_datetrack_mode := hr_api.g_update;

20: if p_effective_end_date <> hr_api.g_eot then
21: --
22: if p_dml_operation = 'INSERT' then
23: --
24: l_datetrack_mode := hr_api.g_update;
25: l_update := true;
26: --
27: elsif l_datetrack_mode in ('CORRECTION') then
28: --

Line 29: l_datetrack_mode := hr_api.g_correction ;

25: l_update := true;
26: --
27: elsif l_datetrack_mode in ('CORRECTION') then
28: --
29: l_datetrack_mode := hr_api.g_correction ;
30: l_update := true;
31: --
32: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
33: --

Line 35: l_datetrack_mode := hr_api.g_correction ;

31: --
32: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
33: --
34: if p_effective_date = p_effective_start_date then
35: l_datetrack_mode := hr_api.g_correction ;
36: l_update := true;
37: else
38: --
39: if l_datetrack_mode in ('UPDATE_OVERRIDE') then

Line 41: l_datetrack_mode := hr_api.g_update_override ;

37: else
38: --
39: if l_datetrack_mode in ('UPDATE_OVERRIDE') then
40: --
41: l_datetrack_mode := hr_api.g_update_override ;
42: l_update := false ;
43: --
44: elsif l_datetrack_mode in ('UPDATE') then
45: --

Line 46: l_datetrack_mode := hr_api.g_update;

42: l_update := false ;
43: --
44: elsif l_datetrack_mode in ('UPDATE') then
45: --
46: l_datetrack_mode := hr_api.g_update;
47: --
48: end if;
49: --
50: end if;

Line 55: l_datetrack_mode := hr_api.g_correction ;

51: --
52: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
53: --
54: if p_effective_date = p_effective_start_date then
55: l_datetrack_mode := hr_api.g_correction ;
56: l_update := true;
57: else
58: l_datetrack_mode := hr_api.g_update_change_insert ;
59: l_update := true;

Line 58: l_datetrack_mode := hr_api.g_update_change_insert ;

54: if p_effective_date = p_effective_start_date then
55: l_datetrack_mode := hr_api.g_correction ;
56: l_update := true;
57: else
58: l_datetrack_mode := hr_api.g_update_change_insert ;
59: l_update := true;
60: end if;
61: --
62: else

Line 64: l_datetrack_mode := hr_api.g_update;

60: end if;
61: --
62: else
63: --
64: l_datetrack_mode := hr_api.g_update;
65: l_update := false;
66: --
67: end if;
68: --

Line 72: l_datetrack_mode := hr_api.g_update;

68: --
69: else
70: if p_dml_operation = 'INSERT' then
71: --
72: l_datetrack_mode := hr_api.g_update;
73: l_update := false;
74: --
75: elsif l_datetrack_mode in ('CORRECTION') then
76: --

Line 77: l_datetrack_mode := hr_api.g_correction ;

73: l_update := false;
74: --
75: elsif l_datetrack_mode in ('CORRECTION') then
76: --
77: l_datetrack_mode := hr_api.g_correction ;
78: l_update := false;
79: --
80: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
81: --

Line 83: l_datetrack_mode := hr_api.g_correction ;

79: --
80: elsif l_datetrack_mode in ('UPDATE_OVERRIDE','UPDATE' ) then
81: --
82: if p_effective_date = p_effective_start_date then
83: l_datetrack_mode := hr_api.g_correction ;
84: l_update := true;
85: else
86: l_datetrack_mode := hr_api.g_update ;
87: l_update := false ;

Line 86: l_datetrack_mode := hr_api.g_update ;

82: if p_effective_date = p_effective_start_date then
83: l_datetrack_mode := hr_api.g_correction ;
84: l_update := true;
85: else
86: l_datetrack_mode := hr_api.g_update ;
87: l_update := false ;
88: end if;
89: --
90: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then

Line 93: l_datetrack_mode := hr_api.g_correction ;

89: --
90: elsif l_datetrack_mode in ('UPDATE_CHANGE_INSERT') then
91: --
92: if p_effective_date = p_effective_start_date then
93: l_datetrack_mode := hr_api.g_correction ;
94: l_update := false;
95: else
96: l_datetrack_mode := hr_api.g_update ;
97: l_update := false;

Line 96: l_datetrack_mode := hr_api.g_update ;

92: if p_effective_date = p_effective_start_date then
93: l_datetrack_mode := hr_api.g_correction ;
94: l_update := false;
95: else
96: l_datetrack_mode := hr_api.g_update ;
97: l_update := false;
98: end if;
99: --
100: else

Line 102: l_datetrack_mode := hr_api.g_update;

98: end if;
99: --
100: else
101: --
102: l_datetrack_mode := hr_api.g_update;
103: l_update := false;
104: --
105: end if;
106: --

Line 118: P_PL_TYP_ID in Number default hr_api.g_number,

114: end get_dt_modes ;
115:
116: procedure UPLOAD_RATE(
117: P_RATE_ID in Number,
118: P_PL_TYP_ID in Number default hr_api.g_number,
119: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
120: P_PL_ID in Number default hr_api.g_number,
121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
122: P_OPT_ID in Number default hr_api.g_number,

Line 119: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,

115:
116: procedure UPLOAD_RATE(
117: P_RATE_ID in Number,
118: P_PL_TYP_ID in Number default hr_api.g_number,
119: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
120: P_PL_ID in Number default hr_api.g_number,
121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
122: P_OPT_ID in Number default hr_api.g_number,
123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,

Line 120: P_PL_ID in Number default hr_api.g_number,

116: procedure UPLOAD_RATE(
117: P_RATE_ID in Number,
118: P_PL_TYP_ID in Number default hr_api.g_number,
119: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
120: P_PL_ID in Number default hr_api.g_number,
121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
122: P_OPT_ID in Number default hr_api.g_number,
123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,

Line 121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,

117: P_RATE_ID in Number,
118: P_PL_TYP_ID in Number default hr_api.g_number,
119: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
120: P_PL_ID in Number default hr_api.g_number,
121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
122: P_OPT_ID in Number default hr_api.g_number,
123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,

Line 122: P_OPT_ID in Number default hr_api.g_number,

118: P_PL_TYP_ID in Number default hr_api.g_number,
119: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
120: P_PL_ID in Number default hr_api.g_number,
121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
122: P_OPT_ID in Number default hr_api.g_number,
123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
126: P_RATE_TYPE in varchar2,

Line 123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,

119: P_PLAN_TYPE_NAME in varchar2 default hr_api.g_varchar2,
120: P_PL_ID in Number default hr_api.g_number,
121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
122: P_OPT_ID in Number default hr_api.g_number,
123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
126: P_RATE_TYPE in varchar2,
127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,

Line 124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,

120: P_PL_ID in Number default hr_api.g_number,
121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
122: P_OPT_ID in Number default hr_api.g_number,
123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
126: P_RATE_TYPE in varchar2,
127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,

Line 125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,

121: P_PLAN_NAME in varchar2 default hr_api.g_varchar2,
122: P_OPT_ID in Number default hr_api.g_number,
123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
126: P_RATE_TYPE in varchar2,
127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,

Line 127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,

123: P_OPTION_NAME in varchar2 default hr_api.g_varchar2,
124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
126: P_RATE_TYPE in varchar2,
127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
130: P_OLD_VAL in number default hr_api.g_number,
131: P_NEW_VAL in number default hr_api.g_number,

Line 128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,

124: P_ABR_LEVEL in varchar2 default hr_api.g_varchar2,
125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
126: P_RATE_TYPE in varchar2,
127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
130: P_OLD_VAL in number default hr_api.g_number,
131: P_NEW_VAL in number default hr_api.g_number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,

Line 129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,

125: P_RT_MLT_CD in varchar2 default hr_api.g_varchar2,
126: P_RATE_TYPE in varchar2,
127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
130: P_OLD_VAL in number default hr_api.g_number,
131: P_NEW_VAL in number default hr_api.g_number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,

Line 130: P_OLD_VAL in number default hr_api.g_number,

126: P_RATE_TYPE in varchar2,
127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
130: P_OLD_VAL in number default hr_api.g_number,
131: P_NEW_VAL in number default hr_api.g_number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,

Line 131: P_NEW_VAL in number default hr_api.g_number,

127: P_RATE_NAME in varchar2 default hr_api.g_varchar2,
128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
130: P_OLD_VAL in number default hr_api.g_number,
131: P_NEW_VAL in number default hr_api.g_number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.

Line 132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,

128: P_VARIABLE_RATE_NAME in varchar2 default hr_api.g_varchar2,
129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
130: P_OLD_VAL in number default hr_api.g_number,
131: P_NEW_VAL in number default hr_api.g_number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.
136: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2, --NOTE: this P_ELEMENT_TYPE_ID is VARCHAR2 and NOT NUMBER as it suggests.

Line 133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,

129: P_ACTY_TYP_CD in varchar2 default hr_api.g_varchar2,
130: P_OLD_VAL in number default hr_api.g_number,
131: P_NEW_VAL in number default hr_api.g_number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.
136: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2, --NOTE: this P_ELEMENT_TYPE_ID is VARCHAR2 and NOT NUMBER as it suggests.
137: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2, --NOTE: this P_INPUT_VALUE_ID is VARCHAR2 and NOT NUMBER as it suggests.

Line 134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,

130: P_OLD_VAL in number default hr_api.g_number,
131: P_NEW_VAL in number default hr_api.g_number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.
136: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2, --NOTE: this P_ELEMENT_TYPE_ID is VARCHAR2 and NOT NUMBER as it suggests.
137: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2, --NOTE: this P_INPUT_VALUE_ID is VARCHAR2 and NOT NUMBER as it suggests.
138: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,

Line 135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.

131: P_NEW_VAL in number default hr_api.g_number,
132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.
136: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2, --NOTE: this P_ELEMENT_TYPE_ID is VARCHAR2 and NOT NUMBER as it suggests.
137: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2, --NOTE: this P_INPUT_VALUE_ID is VARCHAR2 and NOT NUMBER as it suggests.
138: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,
139: P_OBJECT_VERSION_NUMBER in number,

Line 136: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2, --NOTE: this P_ELEMENT_TYPE_ID is VARCHAR2 and NOT NUMBER as it suggests.

132: P_RNDG_CD in varchar2 default hr_api.g_varchar2,
133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.
136: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2, --NOTE: this P_ELEMENT_TYPE_ID is VARCHAR2 and NOT NUMBER as it suggests.
137: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2, --NOTE: this P_INPUT_VALUE_ID is VARCHAR2 and NOT NUMBER as it suggests.
138: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,
139: P_OBJECT_VERSION_NUMBER in number,
140: P_EFFECTIVE_START_DATE in date,

Line 137: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2, --NOTE: this P_INPUT_VALUE_ID is VARCHAR2 and NOT NUMBER as it suggests.

133: P_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.
136: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2, --NOTE: this P_ELEMENT_TYPE_ID is VARCHAR2 and NOT NUMBER as it suggests.
137: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2, --NOTE: this P_INPUT_VALUE_ID is VARCHAR2 and NOT NUMBER as it suggests.
138: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,
139: P_OBJECT_VERSION_NUMBER in number,
140: P_EFFECTIVE_START_DATE in date,
141: P_EFFECTIVE_END_DATE in date,

Line 138: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,

134: P_BNFT_RT_TYP_CD in varchar2 default hr_api.g_varchar2,
135: P_COMP_LVL_FCTR_ID in number default hr_api.g_varchar2, --NOTE: this P_COMP_LVL_FCTR_ID is VARCHAR2 and NOT NUMBER as it suggests.
136: P_ELEMENT_TYPE_ID in number default hr_api.g_varchar2, --NOTE: this P_ELEMENT_TYPE_ID is VARCHAR2 and NOT NUMBER as it suggests.
137: P_INPUT_VALUE_ID in varchar2 default hr_api.g_varchar2, --NOTE: this P_INPUT_VALUE_ID is VARCHAR2 and NOT NUMBER as it suggests.
138: P_ELE_ENTRY_VAL_CD in varchar2 default hr_api.g_varchar2,
139: P_OBJECT_VERSION_NUMBER in number,
140: P_EFFECTIVE_START_DATE in date,
141: P_EFFECTIVE_END_DATE in date,
142: P_DATETRACK_MODE in varchar2,