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_PUMP_GET dependencies on HR_API

Line 13: HR_API_G_VARCHAR2 constant varchar2(128) := hr_api.g_varchar2;

9: /*----------------------- constant definitions ------------------------------*/
10: /*---------------------------------------------------------------------------*/
11: END_OF_TIME constant date := to_date('4712/12/31', 'YYYY/MM/DD');
12: START_OF_TIME constant date := to_date('0001/01/01', 'YYYY/MM/DD');
13: HR_API_G_VARCHAR2 constant varchar2(128) := hr_api.g_varchar2;
14: HR_API_G_NUMBER constant number := hr_api.g_number;
15: HR_API_G_DATE constant date := hr_api.g_date;
16: --
17: /* returns an acty_base_rt_id */

Line 14: HR_API_G_NUMBER constant number := hr_api.g_number;

10: /*---------------------------------------------------------------------------*/
11: END_OF_TIME constant date := to_date('4712/12/31', 'YYYY/MM/DD');
12: START_OF_TIME constant date := to_date('0001/01/01', 'YYYY/MM/DD');
13: HR_API_G_VARCHAR2 constant varchar2(128) := hr_api.g_varchar2;
14: HR_API_G_NUMBER constant number := hr_api.g_number;
15: HR_API_G_DATE constant date := hr_api.g_date;
16: --
17: /* returns an acty_base_rt_id */
18: function get_acty_base_rt_id1

Line 15: HR_API_G_DATE constant date := hr_api.g_date;

11: END_OF_TIME constant date := to_date('4712/12/31', 'YYYY/MM/DD');
12: START_OF_TIME constant date := to_date('0001/01/01', 'YYYY/MM/DD');
13: HR_API_G_VARCHAR2 constant varchar2(128) := hr_api.g_varchar2;
14: HR_API_G_NUMBER constant number := hr_api.g_number;
15: HR_API_G_DATE constant date := hr_api.g_date;
16: --
17: /* returns an acty_base_rt_id */
18: function get_acty_base_rt_id1
19: ( p_data_pump_always_call in varchar2,

Line 27: IF p_acty_base_rate_num1 IS NOT NULL and p_acty_base_rate_num1 <> HR_API_G_NUMBER THEN

23: p_effective_date in date
24: ) return number is
25: l_acty_base_rt_id number;
26: begin
27: IF p_acty_base_rate_num1 IS NOT NULL and p_acty_base_rate_num1 <> HR_API_G_NUMBER THEN
28: l_acty_base_rt_id := p_acty_base_rate_num1 ;
29: ELSIF p_acty_base_rate_name1 IS NOT NULL THEN
30: select abr.acty_base_rt_id
31: into l_acty_base_rt_id

Line 55: IF p_acty_base_rate_num2 IS NOT NULL and p_acty_base_rate_num2 <> HR_API_G_NUMBER THEN

51: p_effective_date in date
52: ) return number is
53: l_acty_base_rt_id number;
54: begin
55: IF p_acty_base_rate_num2 IS NOT NULL and p_acty_base_rate_num2 <> HR_API_G_NUMBER THEN
56: l_acty_base_rt_id := p_acty_base_rate_num2 ;
57: ELSIF p_acty_base_rate_name2 IS NOT NULL THEN
58: select abr.acty_base_rt_id
59: into l_acty_base_rt_id

Line 83: IF p_acty_base_rate_num3 IS NOT NULL and p_acty_base_rate_num3 <> HR_API_G_NUMBER THEN

79: p_effective_date in date
80: ) return number is
81: l_acty_base_rt_id number;
82: begin
83: IF p_acty_base_rate_num3 IS NOT NULL and p_acty_base_rate_num3 <> HR_API_G_NUMBER THEN
84: l_acty_base_rt_id := p_acty_base_rate_num3 ;
85: ELSIF p_acty_base_rate_name3 IS NOT NULL THEN
86: select abr.acty_base_rt_id
87: into l_acty_base_rt_id

Line 111: IF p_acty_base_rate_num4 IS NOT NULL and p_acty_base_rate_num4 <> HR_API_G_NUMBER THEN

107: p_effective_date in date
108: ) return number is
109: l_acty_base_rt_id number;
110: begin
111: IF p_acty_base_rate_num4 IS NOT NULL and p_acty_base_rate_num4 <> HR_API_G_NUMBER THEN
112: l_acty_base_rt_id := p_acty_base_rate_num4 ;
113: ELSIF p_acty_base_rate_name4 IS NOT NULL THEN
114: select abr.acty_base_rt_id
115: into l_acty_base_rt_id

Line 147: IF p_program_num IS NOT NULL and p_program_num <> HR_API_G_NUMBER THEN

143: p_effective_date in date
144: ) return number is
145: l_pgm_id number;
146: begin
147: IF p_program_num IS NOT NULL and p_program_num <> HR_API_G_NUMBER THEN
148: l_pgm_id := p_program_num ;
149: ELSIF p_program IS NOT NULL and p_program <> HR_API_G_VARCHAR2 THEN--Bug : 6652591
150: select pgm.pgm_id
151: into l_pgm_id

Line 149: ELSIF p_program IS NOT NULL and p_program <> HR_API_G_VARCHAR2 THEN--Bug : 6652591

145: l_pgm_id number;
146: begin
147: IF p_program_num IS NOT NULL and p_program_num <> HR_API_G_NUMBER THEN
148: l_pgm_id := p_program_num ;
149: ELSIF p_program IS NOT NULL and p_program <> HR_API_G_VARCHAR2 THEN--Bug : 6652591
150: select pgm.pgm_id
151: into l_pgm_id
152: from ben_pgm_f pgm
153: where pgm.name = p_program

Line 176: IF p_plan_num IS NOT NULL and p_plan_num <> HR_API_G_NUMBER THEN

172: p_effective_date in date
173: ) return number is
174: l_pl_id number;
175: begin
176: IF p_plan_num IS NOT NULL and p_plan_num <> HR_API_G_NUMBER THEN
177: l_pl_id := p_plan_num ;
178: ELSIF p_plan IS NOT NULL THEN
179: select pln.pl_id
180: into l_pl_id

Line 204: IF p_ended_plan_num IS NOT NULL and p_ended_plan_num <> HR_API_G_NUMBER THEN

200: p_effective_date in date
201: ) return number is
202: l_pl_id number;
203: begin
204: IF p_ended_plan_num IS NOT NULL and p_ended_plan_num <> HR_API_G_NUMBER THEN
205: l_pl_id := p_ended_plan_num ;
206: ELSIF p_ended_plan IS NOT NULL THEN
207: select pln.pl_id
208: into l_pl_id

Line 232: IF p_option_num IS NOT NULL and p_option_num <> HR_API_G_NUMBER THEN

228: p_effective_date in date
229: ) return number is
230: l_opt_id number;
231: begin
232: IF p_option_num IS NOT NULL and p_option_num <> HR_API_G_NUMBER THEN
233: l_opt_id := p_option_num ;
234: ELSIF p_option IS NOT NULL and p_option <> HR_API_G_VARCHAR2 THEN --BUG 6148609
235: select opt.opt_id
236: into l_opt_id

Line 234: ELSIF p_option IS NOT NULL and p_option <> HR_API_G_VARCHAR2 THEN --BUG 6148609

230: l_opt_id number;
231: begin
232: IF p_option_num IS NOT NULL and p_option_num <> HR_API_G_NUMBER THEN
233: l_opt_id := p_option_num ;
234: ELSIF p_option IS NOT NULL and p_option <> HR_API_G_VARCHAR2 THEN --BUG 6148609
235: select opt.opt_id
236: into l_opt_id
237: from ben_opt_f opt
238: where opt.name = p_option

Line 261: IF p_ended_option_num IS NOT NULL and p_ended_option_num <> HR_API_G_NUMBER THEN

257: ) return number is
258: l_opt_id number;
259: begin
260: --
261: IF p_ended_option_num IS NOT NULL and p_ended_option_num <> HR_API_G_NUMBER THEN
262: l_opt_id := p_ended_option_num ;
263: ELSIF p_ended_option IS NOT NULL THEN
264: select opt.opt_id
265: into l_opt_id

Line 305: IF p_person_num IS NOT NULL and p_person_num <> HR_API_G_NUMBER THEN

301: l_person_id NUMBER;
302: value_error exception ;
303: begin
304: --
305: IF p_person_num IS NOT NULL and p_person_num <> HR_API_G_NUMBER THEN
306: --
307: l_person_id := p_person_num ;
308: --
309: ELSIF p_employee_number IS NOT NULL THEN

Line 372: IF p_con_person_num IS NOT NULL and p_con_person_num <> HR_API_G_NUMBER THEN

368: l_person_id NUMBER;
369: value_error exception ;
370: begin
371: --
372: IF p_con_person_num IS NOT NULL and p_con_person_num <> HR_API_G_NUMBER THEN
373: --
374: l_person_id := p_con_person_num ;
375: --
376: ELSIF p_con_employee_number IS NOT NULL THEN