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.PAY_JP_DIMENSION_GENERATOR_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 307: l_description pay_balance_dimensions.description%type;

303: p_frequency in number,
304: p_exclude_reversal in boolean)
305: is
306: l_route_id number;
307: l_description pay_balance_dimensions.description%type;
308: l_dimension_type pay_balance_dimensions.dimension_type%type;
309: l_expiry_checking_level pay_balance_dimensions.expiry_checking_level%type;
310: l_expiry_checking_code pay_balance_dimensions.expiry_checking_code%type;
311: l_period_type pay_balance_dimensions.period_type%type;

Line 308: l_dimension_type pay_balance_dimensions.dimension_type%type;

304: p_exclude_reversal in boolean)
305: is
306: l_route_id number;
307: l_description pay_balance_dimensions.description%type;
308: l_dimension_type pay_balance_dimensions.dimension_type%type;
309: l_expiry_checking_level pay_balance_dimensions.expiry_checking_level%type;
310: l_expiry_checking_code pay_balance_dimensions.expiry_checking_code%type;
311: l_period_type pay_balance_dimensions.period_type%type;
312: l_start_date_code pay_balance_dimensions.start_date_code%type;

Line 309: l_expiry_checking_level pay_balance_dimensions.expiry_checking_level%type;

305: is
306: l_route_id number;
307: l_description pay_balance_dimensions.description%type;
308: l_dimension_type pay_balance_dimensions.dimension_type%type;
309: l_expiry_checking_level pay_balance_dimensions.expiry_checking_level%type;
310: l_expiry_checking_code pay_balance_dimensions.expiry_checking_code%type;
311: l_period_type pay_balance_dimensions.period_type%type;
312: l_start_date_code pay_balance_dimensions.start_date_code%type;
313: begin

Line 310: l_expiry_checking_code pay_balance_dimensions.expiry_checking_code%type;

306: l_route_id number;
307: l_description pay_balance_dimensions.description%type;
308: l_dimension_type pay_balance_dimensions.dimension_type%type;
309: l_expiry_checking_level pay_balance_dimensions.expiry_checking_level%type;
310: l_expiry_checking_code pay_balance_dimensions.expiry_checking_code%type;
311: l_period_type pay_balance_dimensions.period_type%type;
312: l_start_date_code pay_balance_dimensions.start_date_code%type;
313: begin
314: l_route_id := get_route_id('Core Balance Route No Contexts');

Line 311: l_period_type pay_balance_dimensions.period_type%type;

307: l_description pay_balance_dimensions.description%type;
308: l_dimension_type pay_balance_dimensions.dimension_type%type;
309: l_expiry_checking_level pay_balance_dimensions.expiry_checking_level%type;
310: l_expiry_checking_code pay_balance_dimensions.expiry_checking_code%type;
311: l_period_type pay_balance_dimensions.period_type%type;
312: l_start_date_code pay_balance_dimensions.start_date_code%type;
313: begin
314: l_route_id := get_route_id('Core Balance Route No Contexts');
315: l_description := get_description(p_date_type, p_reset_date, p_frequency_type, p_frequency, p_exclude_reversal);

Line 312: l_start_date_code pay_balance_dimensions.start_date_code%type;

308: l_dimension_type pay_balance_dimensions.dimension_type%type;
309: l_expiry_checking_level pay_balance_dimensions.expiry_checking_level%type;
310: l_expiry_checking_code pay_balance_dimensions.expiry_checking_code%type;
311: l_period_type pay_balance_dimensions.period_type%type;
312: l_start_date_code pay_balance_dimensions.start_date_code%type;
313: begin
314: l_route_id := get_route_id('Core Balance Route No Contexts');
315: l_description := get_description(p_date_type, p_reset_date, p_frequency_type, p_frequency, p_exclude_reversal);
316: --

Line 359: select pay_balance_dimensions_s.nextval

355: l_period_type := 'DYNAMIC';
356: l_start_date_code := get_start_date_code(p_date_type, p_reset_date, p_frequency_type, p_frequency);
357: --
358: if p_balance_dimension_id is null then
359: select pay_balance_dimensions_s.nextval
360: into p_balance_dimension_id
361: from dual;
362: --
363: insert into pay_balance_dimensions(

Line 363: insert into pay_balance_dimensions(

359: select pay_balance_dimensions_s.nextval
360: into p_balance_dimension_id
361: from dual;
362: --
363: insert into pay_balance_dimensions(
364: BALANCE_DIMENSION_ID,
365: DIMENSION_NAME,
366: DATABASE_ITEM_SUFFIX,
367: BUSINESS_GROUP_ID,

Line 403: update pay_balance_dimensions

399: 'N',
400: l_period_type,
401: l_start_date_code);
402: else
403: update pay_balance_dimensions
404: set description = l_description,
405: payments_flag = 'N',
406: dimension_type = l_dimension_type,
407: expiry_checking_level = l_expiry_checking_level,

Line 549: from pay_balance_dimensions

545: l_balance_type_column := 'FEED.balance_type_id';
546: else
547: select balance_dimension_id
548: into l_run_dimension_id
549: from pay_balance_dimensions
550: where dimension_name = '_ASG_RUN'
551: and legislation_code = 'JP';
552: end if;
553: --

Line 587: from pay_balance_dimensions

583: p_argument_value => p_dimension_name);
584: --
585: select count(*)
586: into l_count
587: from pay_balance_dimensions
588: where replace(upper(dimension_name), ' ', '_') = replace(upper(p_dimension_name), ' ', '_')
589: and nvl(business_group_id, p_business_group_id) = p_business_group_id
590: and nvl(legislation_code, 'JP') = 'JP';
591: --

Line 606: l_database_item_suffix pay_balance_dimensions.database_item_suffix%type;

602: p_database_item_suffix in varchar2,
603: p_business_group_id in number)
604: is
605: c_proc constant varchar2(61) := c_package || 'chk_database_item_suffix';
606: l_database_item_suffix pay_balance_dimensions.database_item_suffix%type;
607: l_dummy varchar2(1);
608: l_count number;
609: begin
610: hr_api.mandatory_arg_error(

Line 632: from pay_balance_dimensions

628: curcode => null);
629: --
630: select count(*)
631: into l_count
632: from pay_balance_dimensions
633: where replace(upper(database_item_suffix), ' ', '_') = replace(upper(p_database_item_suffix), ' ', '_')
634: and nvl(business_group_id, p_business_group_id) = p_business_group_id
635: and nvl(legislation_code, 'JP') = 'JP';
636: --

Line 854: l_dimension_name pay_balance_dimensions.dimension_name%type;

850: p_rebuild_package in boolean default true)
851: is
852: l_balance_dimension_id number := p_balance_dimension_id;
853: l_business_group_id number;
854: l_dimension_name pay_balance_dimensions.dimension_name%type;
855: l_database_item_suffix pay_balance_dimensions.database_item_suffix%type;
856: --
857: type t_number_tbl is table of number index by binary_integer;
858: l_defined_balance_ids t_number_tbl;

Line 855: l_database_item_suffix pay_balance_dimensions.database_item_suffix%type;

851: is
852: l_balance_dimension_id number := p_balance_dimension_id;
853: l_business_group_id number;
854: l_dimension_name pay_balance_dimensions.dimension_name%type;
855: l_database_item_suffix pay_balance_dimensions.database_item_suffix%type;
856: --
857: type t_number_tbl is table of number index by binary_integer;
858: l_defined_balance_ids t_number_tbl;
859: l_balance_type_ids t_number_tbl;

Line 868: from pay_balance_dimensions

864: database_item_suffix
865: into l_business_group_id,
866: l_dimension_name,
867: l_database_item_suffix
868: from pay_balance_dimensions
869: where balance_dimension_id = p_balance_dimension_id;
870: --
871: -- Only user defined dimension is allowed to be updated.
872: --

Line 1018: pay_balance_dimensions dim,

1014: cursor csr_def is
1015: select def.defined_balance_id,
1016: def.business_group_id
1017: from per_business_groups_perf bg,
1018: pay_balance_dimensions dim,
1019: pay_defined_balances def
1020: where bg.legislation_code = 'JP'
1021: and dim.business_group_id = bg.business_group_id
1022: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null

Line 1032: pay_balance_dimensions dim

1028: cursor csr_dim is
1029: select dim.balance_dimension_id,
1030: dim.description
1031: from per_business_groups_perf bg,
1032: pay_balance_dimensions dim
1033: where bg.legislation_code = 'JP'
1034: and dim.business_group_id = bg.business_group_id
1035: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null
1036: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null

Line 1050: pay_balance_dimensions dim

1046: select upper(dim.expiry_checking_code) expiry_checking_code,
1047: upper(dim.start_date_code) start_date_code,
1048: min(dim.description) description
1049: from per_business_groups_perf bg,
1050: pay_balance_dimensions dim
1051: where bg.legislation_code = 'JP'
1052: and dim.business_group_id = bg.business_group_id
1053: and (dim.expiry_checking_code is not null or dim.start_date_code is not null)
1054: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null