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.

[Home] [Help]

APPS.PAY_JP_DIMENSION_GENERATOR_PKG dependencies on PAY_CORE_UTILS

Line 1022: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null

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
1023: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1024: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1025: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null
1026: and def.balance_dimension_id = dim.balance_dimension_id;

Line 1023: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null

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
1023: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1024: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1025: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null
1026: and def.balance_dimension_id = dim.balance_dimension_id;
1027: --

Line 1024: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null

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
1023: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1024: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1025: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null
1026: and def.balance_dimension_id = dim.balance_dimension_id;
1027: --
1028: cursor csr_dim is

Line 1025: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null

1021: and dim.business_group_id = bg.business_group_id
1022: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null
1023: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1024: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1025: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null
1026: and def.balance_dimension_id = dim.balance_dimension_id;
1027: --
1028: cursor csr_dim is
1029: select dim.balance_dimension_id,

Line 1035: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null

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
1037: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1038: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null;
1039: --

Line 1036: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null

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
1037: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1038: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null;
1039: --
1040: cursor csr_code is

Line 1037: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null

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
1037: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1038: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null;
1039: --
1040: cursor csr_code is
1041: --

Line 1038: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null;

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
1037: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1038: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null;
1039: --
1040: cursor csr_code is
1041: --
1042: -- Do not group by description because expiry_checking_code and

Line 1054: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null

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
1055: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1056: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1057: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null
1058: group by

Line 1055: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null

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
1055: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1056: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1057: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null
1058: group by
1059: dim.expiry_checking_code,

Line 1056: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null

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
1055: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1056: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1057: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null
1058: group by
1059: dim.expiry_checking_code,
1060: dim.start_date_code;

Line 1057: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null

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
1055: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1056: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1057: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null
1058: group by
1059: dim.expiry_checking_code,
1060: dim.start_date_code;
1061: --

Line 1193: p_date_type => pay_core_utils.get_parameter('DATE_TYPE', l_rec.description),

1189: -- Rebuild Balance Dimension
1190: --
1191: update_balance_dimension(
1192: p_balance_dimension_id => l_rec.balance_dimension_id,
1193: p_date_type => pay_core_utils.get_parameter('DATE_TYPE', l_rec.description),
1194: p_reset_date => fnd_date.canonical_to_date(pay_core_utils.get_parameter('RESET_DATE', l_rec.description)),
1195: p_frequency_type => pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description),
1196: p_frequency => fnd_number.canonical_to_number(pay_core_utils.get_parameter('FREQUENCY', l_rec.description)),
1197: p_exclude_reversal => (pay_core_utils.get_parameter('EXCLUDE_REVERSAL', l_rec.description) = 'Y'),

Line 1194: p_reset_date => fnd_date.canonical_to_date(pay_core_utils.get_parameter('RESET_DATE', l_rec.description)),

1190: --
1191: update_balance_dimension(
1192: p_balance_dimension_id => l_rec.balance_dimension_id,
1193: p_date_type => pay_core_utils.get_parameter('DATE_TYPE', l_rec.description),
1194: p_reset_date => fnd_date.canonical_to_date(pay_core_utils.get_parameter('RESET_DATE', l_rec.description)),
1195: p_frequency_type => pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description),
1196: p_frequency => fnd_number.canonical_to_number(pay_core_utils.get_parameter('FREQUENCY', l_rec.description)),
1197: p_exclude_reversal => (pay_core_utils.get_parameter('EXCLUDE_REVERSAL', l_rec.description) = 'Y'),
1198: p_rebuild_package => false);

Line 1195: p_frequency_type => pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description),

1191: update_balance_dimension(
1192: p_balance_dimension_id => l_rec.balance_dimension_id,
1193: p_date_type => pay_core_utils.get_parameter('DATE_TYPE', l_rec.description),
1194: p_reset_date => fnd_date.canonical_to_date(pay_core_utils.get_parameter('RESET_DATE', l_rec.description)),
1195: p_frequency_type => pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description),
1196: p_frequency => fnd_number.canonical_to_number(pay_core_utils.get_parameter('FREQUENCY', l_rec.description)),
1197: p_exclude_reversal => (pay_core_utils.get_parameter('EXCLUDE_REVERSAL', l_rec.description) = 'Y'),
1198: p_rebuild_package => false);
1199: end loop;

Line 1196: p_frequency => fnd_number.canonical_to_number(pay_core_utils.get_parameter('FREQUENCY', l_rec.description)),

1192: p_balance_dimension_id => l_rec.balance_dimension_id,
1193: p_date_type => pay_core_utils.get_parameter('DATE_TYPE', l_rec.description),
1194: p_reset_date => fnd_date.canonical_to_date(pay_core_utils.get_parameter('RESET_DATE', l_rec.description)),
1195: p_frequency_type => pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description),
1196: p_frequency => fnd_number.canonical_to_number(pay_core_utils.get_parameter('FREQUENCY', l_rec.description)),
1197: p_exclude_reversal => (pay_core_utils.get_parameter('EXCLUDE_REVERSAL', l_rec.description) = 'Y'),
1198: p_rebuild_package => false);
1199: end loop;
1200: end if;

Line 1197: p_exclude_reversal => (pay_core_utils.get_parameter('EXCLUDE_REVERSAL', l_rec.description) = 'Y'),

1193: p_date_type => pay_core_utils.get_parameter('DATE_TYPE', l_rec.description),
1194: p_reset_date => fnd_date.canonical_to_date(pay_core_utils.get_parameter('RESET_DATE', l_rec.description)),
1195: p_frequency_type => pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description),
1196: p_frequency => fnd_number.canonical_to_number(pay_core_utils.get_parameter('FREQUENCY', l_rec.description)),
1197: p_exclude_reversal => (pay_core_utils.get_parameter('EXCLUDE_REVERSAL', l_rec.description) = 'Y'),
1198: p_rebuild_package => false);
1199: end loop;
1200: end if;
1201: --

Line 1203: l_reset_date := pay_core_utils.get_parameter('RESET_DATE', l_rec.description);

1199: end loop;
1200: end if;
1201: --
1202: for l_rec in csr_code loop
1203: l_reset_date := pay_core_utils.get_parameter('RESET_DATE', l_rec.description);
1204: l_frequency_type := pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description);
1205: l_frequency := pay_core_utils.get_parameter('FREQUENCY', l_rec.description);
1206: --
1207: if l_rec.expiry_checking_code is not null then

Line 1204: l_frequency_type := pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description);

1200: end if;
1201: --
1202: for l_rec in csr_code loop
1203: l_reset_date := pay_core_utils.get_parameter('RESET_DATE', l_rec.description);
1204: l_frequency_type := pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description);
1205: l_frequency := pay_core_utils.get_parameter('FREQUENCY', l_rec.description);
1206: --
1207: if l_rec.expiry_checking_code is not null then
1208: l_rec.expiry_checking_code := substr(l_rec.expiry_checking_code, instr(l_rec.expiry_checking_code, '.') + 1);

Line 1205: l_frequency := pay_core_utils.get_parameter('FREQUENCY', l_rec.description);

1201: --
1202: for l_rec in csr_code loop
1203: l_reset_date := pay_core_utils.get_parameter('RESET_DATE', l_rec.description);
1204: l_frequency_type := pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description);
1205: l_frequency := pay_core_utils.get_parameter('FREQUENCY', l_rec.description);
1206: --
1207: if l_rec.expiry_checking_code is not null then
1208: l_rec.expiry_checking_code := substr(l_rec.expiry_checking_code, instr(l_rec.expiry_checking_code, '.') + 1);
1209: --