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_CORE_UTILS

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

1036: pay_balance_dimensions dim,
1037: pay_defined_balances def
1038: where bg.legislation_code = 'JP'
1039: and dim.business_group_id = bg.business_group_id
1040: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null
1041: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1042: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1043: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null
1044: and def.balance_dimension_id = dim.balance_dimension_id;

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

1037: pay_defined_balances def
1038: where bg.legislation_code = 'JP'
1039: and dim.business_group_id = bg.business_group_id
1040: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null
1041: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1042: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1043: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null
1044: and def.balance_dimension_id = dim.balance_dimension_id;
1045: --

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

1038: where bg.legislation_code = 'JP'
1039: and dim.business_group_id = bg.business_group_id
1040: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null
1041: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1042: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1043: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null
1044: and def.balance_dimension_id = dim.balance_dimension_id;
1045: --
1046: cursor csr_dim is

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

1039: and dim.business_group_id = bg.business_group_id
1040: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null
1041: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1042: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1043: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null
1044: and def.balance_dimension_id = dim.balance_dimension_id;
1045: --
1046: cursor csr_dim is
1047: select dim.balance_dimension_id,

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

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

Line 1054: and pay_core_utils.get_parameter('RESET_DATE', 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 pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null
1054: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1055: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1056: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null;
1057: --
1058: cursor csr_code is

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

1051: where bg.legislation_code = 'JP'
1052: and dim.business_group_id = bg.business_group_id
1053: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null
1054: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1055: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1056: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null;
1057: --
1058: cursor csr_code is
1059: --

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

1052: and dim.business_group_id = bg.business_group_id
1053: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null
1054: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1055: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1056: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null;
1057: --
1058: cursor csr_code is
1059: --
1060: -- Do not group by description because expiry_checking_code and

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

1068: pay_balance_dimensions dim
1069: where bg.legislation_code = 'JP'
1070: and dim.business_group_id = bg.business_group_id
1071: and (dim.expiry_checking_code is not null or dim.start_date_code is not null)
1072: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null
1073: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1074: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1075: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null
1076: group by

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

1069: where bg.legislation_code = 'JP'
1070: and dim.business_group_id = bg.business_group_id
1071: and (dim.expiry_checking_code is not null or dim.start_date_code is not null)
1072: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null
1073: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1074: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1075: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null
1076: group by
1077: dim.expiry_checking_code,

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

1070: and dim.business_group_id = bg.business_group_id
1071: and (dim.expiry_checking_code is not null or dim.start_date_code is not null)
1072: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null
1073: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1074: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1075: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null
1076: group by
1077: dim.expiry_checking_code,
1078: dim.start_date_code;

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

1071: and (dim.expiry_checking_code is not null or dim.start_date_code is not null)
1072: and pay_core_utils.get_parameter('DATE_TYPE', dim.description) is not null
1073: and pay_core_utils.get_parameter('RESET_DATE', dim.description) is not null
1074: and pay_core_utils.get_parameter('FREQUENCY_TYPE', dim.description) is not null
1075: and pay_core_utils.get_parameter('FREQUENCY', dim.description) is not null
1076: group by
1077: dim.expiry_checking_code,
1078: dim.start_date_code;
1079: --

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

1207: -- Rebuild Balance Dimension
1208: --
1209: update_balance_dimension(
1210: p_balance_dimension_id => l_rec.balance_dimension_id,
1211: p_date_type => pay_core_utils.get_parameter('DATE_TYPE', l_rec.description),
1212: p_reset_date => fnd_date.canonical_to_date(pay_core_utils.get_parameter('RESET_DATE', l_rec.description)),
1213: p_frequency_type => pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description),
1214: p_frequency => fnd_number.canonical_to_number(pay_core_utils.get_parameter('FREQUENCY', l_rec.description)),
1215: p_exclude_reversal => (pay_core_utils.get_parameter('EXCLUDE_REVERSAL', l_rec.description) = 'Y'),

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

1208: --
1209: update_balance_dimension(
1210: p_balance_dimension_id => l_rec.balance_dimension_id,
1211: p_date_type => pay_core_utils.get_parameter('DATE_TYPE', l_rec.description),
1212: p_reset_date => fnd_date.canonical_to_date(pay_core_utils.get_parameter('RESET_DATE', l_rec.description)),
1213: p_frequency_type => pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description),
1214: p_frequency => fnd_number.canonical_to_number(pay_core_utils.get_parameter('FREQUENCY', l_rec.description)),
1215: p_exclude_reversal => (pay_core_utils.get_parameter('EXCLUDE_REVERSAL', l_rec.description) = 'Y'),
1216: p_rebuild_package => false);

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

1209: update_balance_dimension(
1210: p_balance_dimension_id => l_rec.balance_dimension_id,
1211: p_date_type => pay_core_utils.get_parameter('DATE_TYPE', l_rec.description),
1212: p_reset_date => fnd_date.canonical_to_date(pay_core_utils.get_parameter('RESET_DATE', l_rec.description)),
1213: p_frequency_type => pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description),
1214: p_frequency => fnd_number.canonical_to_number(pay_core_utils.get_parameter('FREQUENCY', l_rec.description)),
1215: p_exclude_reversal => (pay_core_utils.get_parameter('EXCLUDE_REVERSAL', l_rec.description) = 'Y'),
1216: p_rebuild_package => false);
1217: end loop;

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

1210: p_balance_dimension_id => l_rec.balance_dimension_id,
1211: p_date_type => pay_core_utils.get_parameter('DATE_TYPE', l_rec.description),
1212: p_reset_date => fnd_date.canonical_to_date(pay_core_utils.get_parameter('RESET_DATE', l_rec.description)),
1213: p_frequency_type => pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description),
1214: p_frequency => fnd_number.canonical_to_number(pay_core_utils.get_parameter('FREQUENCY', l_rec.description)),
1215: p_exclude_reversal => (pay_core_utils.get_parameter('EXCLUDE_REVERSAL', l_rec.description) = 'Y'),
1216: p_rebuild_package => false);
1217: end loop;
1218: end if;

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

1211: p_date_type => pay_core_utils.get_parameter('DATE_TYPE', l_rec.description),
1212: p_reset_date => fnd_date.canonical_to_date(pay_core_utils.get_parameter('RESET_DATE', l_rec.description)),
1213: p_frequency_type => pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description),
1214: p_frequency => fnd_number.canonical_to_number(pay_core_utils.get_parameter('FREQUENCY', l_rec.description)),
1215: p_exclude_reversal => (pay_core_utils.get_parameter('EXCLUDE_REVERSAL', l_rec.description) = 'Y'),
1216: p_rebuild_package => false);
1217: end loop;
1218: end if;
1219: --

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

1217: end loop;
1218: end if;
1219: --
1220: for l_rec in csr_code loop
1221: l_reset_date := pay_core_utils.get_parameter('RESET_DATE', l_rec.description);
1222: l_frequency_type := pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description);
1223: l_frequency := pay_core_utils.get_parameter('FREQUENCY', l_rec.description);
1224: --
1225: if l_rec.expiry_checking_code is not null then

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

1218: end if;
1219: --
1220: for l_rec in csr_code loop
1221: l_reset_date := pay_core_utils.get_parameter('RESET_DATE', l_rec.description);
1222: l_frequency_type := pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description);
1223: l_frequency := pay_core_utils.get_parameter('FREQUENCY', l_rec.description);
1224: --
1225: if l_rec.expiry_checking_code is not null then
1226: l_rec.expiry_checking_code := substr(l_rec.expiry_checking_code, instr(l_rec.expiry_checking_code, '.') + 1);

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

1219: --
1220: for l_rec in csr_code loop
1221: l_reset_date := pay_core_utils.get_parameter('RESET_DATE', l_rec.description);
1222: l_frequency_type := pay_core_utils.get_parameter('FREQUENCY_TYPE', l_rec.description);
1223: l_frequency := pay_core_utils.get_parameter('FREQUENCY', l_rec.description);
1224: --
1225: if l_rec.expiry_checking_code is not null then
1226: l_rec.expiry_checking_code := substr(l_rec.expiry_checking_code, instr(l_rec.expiry_checking_code, '.') + 1);
1227: --