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.HR_PUMP_META_MAPPER dependencies on HR_PUMP_MODULE_PARAMETERS

Line 28: mapping_type hr_pump_module_parameters.mapping_type%type,

24: in_out number,
25: defaultable boolean,
26: default_value varchar2(256),
27: call_default_value varchar2(256),
28: mapping_type hr_pump_module_parameters.mapping_type%type,
29: mapping_definition hr_pump_module_parameters.mapping_definition%type
30: );
31:
32: type t_parameter_tbl is table of t_parameter index by binary_integer;

Line 29: mapping_definition hr_pump_module_parameters.mapping_definition%type

25: defaultable boolean,
26: default_value varchar2(256),
27: call_default_value varchar2(256),
28: mapping_type hr_pump_module_parameters.mapping_type%type,
29: mapping_definition hr_pump_module_parameters.mapping_definition%type
30: );
31:
32: type t_parameter_tbl is table of t_parameter index by binary_integer;
33:

Line 43: parameter_name hr_pump_module_parameters.api_parameter_name%type,

39: -- Parameter seed data structure.
40: --
41: type t_seed_parameter is record
42: (
43: parameter_name hr_pump_module_parameters.api_parameter_name%type,
44: mapping_type hr_pump_module_parameters.mapping_type%type,
45: mapping_definition hr_pump_module_parameters.mapping_definition%type,
46: default_value hr_pump_module_parameters.default_value%type,
47: matched boolean

Line 44: mapping_type hr_pump_module_parameters.mapping_type%type,

40: --
41: type t_seed_parameter is record
42: (
43: parameter_name hr_pump_module_parameters.api_parameter_name%type,
44: mapping_type hr_pump_module_parameters.mapping_type%type,
45: mapping_definition hr_pump_module_parameters.mapping_definition%type,
46: default_value hr_pump_module_parameters.default_value%type,
47: matched boolean
48: );

Line 45: mapping_definition hr_pump_module_parameters.mapping_definition%type,

41: type t_seed_parameter is record
42: (
43: parameter_name hr_pump_module_parameters.api_parameter_name%type,
44: mapping_type hr_pump_module_parameters.mapping_type%type,
45: mapping_definition hr_pump_module_parameters.mapping_definition%type,
46: default_value hr_pump_module_parameters.default_value%type,
47: matched boolean
48: );
49:

Line 46: default_value hr_pump_module_parameters.default_value%type,

42: (
43: parameter_name hr_pump_module_parameters.api_parameter_name%type,
44: mapping_type hr_pump_module_parameters.mapping_type%type,
45: mapping_definition hr_pump_module_parameters.mapping_definition%type,
46: default_value hr_pump_module_parameters.default_value%type,
47: matched boolean
48: );
49:
50: type t_seed_parameter_tbl is table of t_seed_parameter index by binary_integer;

Line 78: package_name hr_pump_module_parameters.mapping_definition%type,

74: -- all its parameters are NOT NULL and not defaulted with HR_API
75: -- default values.
76: --
77: always_call boolean default false,
78: package_name hr_pump_module_parameters.mapping_definition%type,
79: function_name hr_pump_module_parameters.mapping_definition%type,
80: ret_type number, -- Return type.
81: seqno number, -- Sequence in parameter list.
82: index1 number, -- Start index in function call list.

Line 79: function_name hr_pump_module_parameters.mapping_definition%type,

75: -- default values.
76: --
77: always_call boolean default false,
78: package_name hr_pump_module_parameters.mapping_definition%type,
79: function_name hr_pump_module_parameters.mapping_definition%type,
80: ret_type number, -- Return type.
81: seqno number, -- Sequence in parameter list.
82: index1 number, -- Start index in function call list.
83: index2 number -- End index in function call list.

Line 111: -- Use hr_pump_module_parameters.mapping_definition%type as it's larger

107: --
108: type t_mapping_package is record
109: (
110: --
111: -- Use hr_pump_module_parameters.mapping_definition%type as it's larger
112: -- than hr_pump_mapping_packages.mapping_package%type, and it can be
113: -- the source of a package name.
114: --
115: mapping_package hr_pump_module_parameters.mapping_definition%type

Line 115: mapping_package hr_pump_module_parameters.mapping_definition%type

111: -- Use hr_pump_module_parameters.mapping_definition%type as it's larger
112: -- than hr_pump_mapping_packages.mapping_package%type, and it can be
113: -- the source of a package name.
114: --
115: mapping_package hr_pump_module_parameters.mapping_definition%type
116: );
117:
118: type t_mapping_package_tbl is table of t_mapping_package index by
119: binary_integer;

Line 353: -- Fetches the seeded parameter information from HR_PUMP_MODULE_PARAMETERS.

349: end match_seed_parameter;
350:
351: -- ------------------------ get_seed_parameters ---------------------------
352: -- Description:
353: -- Fetches the seeded parameter information from HR_PUMP_MODULE_PARAMETERS.
354: -- ------------------------------------------------------------------------
355: procedure get_seed_parameters( p_module_package in varchar2,
356: p_module_name in varchar2,
357: p_seed_parameter_tbl out nocopy t_seed_parameter_tbl,

Line 367: hr_pump_module_parameters hrpmp

363: upper(hrpmp.mapping_type),
364: upper(hrpmp.mapping_definition),
365: hrpmp.default_value
366: from hr_api_modules ham,
367: hr_pump_module_parameters hrpmp
368: where upper(ham.module_package) = upper(p_module_package)
369: and upper(ham.module_name) = upper(p_module_name)
370: and upper(ham.api_module_type) in ( 'AI', 'BP','DM' )
371: and upper(hrpmp.module_name) = upper(p_module_name)

Line 376: l_parameter_name hr_pump_module_parameters.api_parameter_name%type;

372: and upper(hrpmp.api_module_type) = upper(ham.api_module_type);
373: --
374: l_seqno number;
375: --
376: l_parameter_name hr_pump_module_parameters.api_parameter_name%type;
377: l_mapping_type hr_pump_module_parameters.mapping_type%type;
378: l_mapping_definition hr_pump_module_parameters.mapping_definition%type;
379: l_default_value hr_pump_module_parameters.default_value%type;
380: begin

Line 377: l_mapping_type hr_pump_module_parameters.mapping_type%type;

373: --
374: l_seqno number;
375: --
376: l_parameter_name hr_pump_module_parameters.api_parameter_name%type;
377: l_mapping_type hr_pump_module_parameters.mapping_type%type;
378: l_mapping_definition hr_pump_module_parameters.mapping_definition%type;
379: l_default_value hr_pump_module_parameters.default_value%type;
380: begin
381: l_seqno := 0;

Line 378: l_mapping_definition hr_pump_module_parameters.mapping_definition%type;

374: l_seqno number;
375: --
376: l_parameter_name hr_pump_module_parameters.api_parameter_name%type;
377: l_mapping_type hr_pump_module_parameters.mapping_type%type;
378: l_mapping_definition hr_pump_module_parameters.mapping_definition%type;
379: l_default_value hr_pump_module_parameters.default_value%type;
380: begin
381: l_seqno := 0;
382: open csr_seed_parameters( p_module_package, p_module_name );

Line 379: l_default_value hr_pump_module_parameters.default_value%type;

375: --
376: l_parameter_name hr_pump_module_parameters.api_parameter_name%type;
377: l_mapping_type hr_pump_module_parameters.mapping_type%type;
378: l_mapping_definition hr_pump_module_parameters.mapping_definition%type;
379: l_default_value hr_pump_module_parameters.default_value%type;
380: begin
381: l_seqno := 0;
382: open csr_seed_parameters( p_module_package, p_module_name );
383: loop

Line 1017: l_package_name hr_pump_module_parameters.mapping_definition%type;

1013: )
1014: is
1015: l_seed_parameter t_seed_parameter;
1016: l_match boolean;
1017: l_package_name hr_pump_module_parameters.mapping_definition%type;
1018: l_function_name hr_pump_module_parameters.mapping_definition%type;
1019: l_dotpos number;
1020:
1021: l_parameter_tbl t_parameter_tbl;

Line 1018: l_function_name hr_pump_module_parameters.mapping_definition%type;

1014: is
1015: l_seed_parameter t_seed_parameter;
1016: l_match boolean;
1017: l_package_name hr_pump_module_parameters.mapping_definition%type;
1018: l_function_name hr_pump_module_parameters.mapping_definition%type;
1019: l_dotpos number;
1020:
1021: l_parameter_tbl t_parameter_tbl;
1022: l_seed_parameter_tbl t_seed_parameter_tbl;

Line 1025: l_upper_defval hr_pump_module_parameters.default_value%type;

1021: l_parameter_tbl t_parameter_tbl;
1022: l_seed_parameter_tbl t_seed_parameter_tbl;
1023: l_parameter_counts t_parameter_counts;
1024: --
1025: l_upper_defval hr_pump_module_parameters.default_value%type;
1026: begin
1027: -- Remember IN OUT parameters.
1028: l_parameter_tbl := p_parameter_tbl;
1029: l_seed_parameter_tbl := p_seed_parameter_tbl;

Line 1245: l_package hr_pump_module_parameters.mapping_definition%type;

1241: l_first_overload binary_integer;
1242: l_seqno binary_integer;
1243: l_currpos binary_integer;
1244: -- Package for the mapping function.
1245: l_package hr_pump_module_parameters.mapping_definition%type;
1246: --
1247: l_match boolean;
1248: l_call_params number; -- Index into function call parameters list.
1249: l_distinct_params number; -- Index into distinct parameters list.