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

Line 7: g_rfm_effective_end_date date := hr_api.g_eot;

3:
4: g_package varchar2(33) := ' pay_loader_utils_pkg.';
5: --
6: g_rfm_old_rec PAY_RFM_SHD.G_REC_TYPE;
7: g_rfm_effective_end_date date := hr_api.g_eot;
8: --
9: g_rfi_old_rec PAY_RFI_SHD.G_REC_TYPE;
10: g_rfi_effective_end_date date := hr_api.g_eot;
11: --

Line 10: g_rfi_effective_end_date date := hr_api.g_eot;

6: g_rfm_old_rec PAY_RFM_SHD.G_REC_TYPE;
7: g_rfm_effective_end_date date := hr_api.g_eot;
8: --
9: g_rfi_old_rec PAY_RFI_SHD.G_REC_TYPE;
10: g_rfi_effective_end_date date := hr_api.g_eot;
11: --
12: g_ecu_old_rec PAY_ECU_SHD.G_REC_TYPE;
13: g_ecu_effective_end_date date := hr_api.g_eot;
14:

Line 13: g_ecu_effective_end_date date := hr_api.g_eot;

9: g_rfi_old_rec PAY_RFI_SHD.G_REC_TYPE;
10: g_rfi_effective_end_date date := hr_api.g_eot;
11: --
12: g_ecu_old_rec PAY_ECU_SHD.G_REC_TYPE;
13: g_ecu_effective_end_date date := hr_api.g_eot;
14:
15: g_usage_id number := -1;
16: -- ----------------------------------------------------------------------------
17: -- |-------------------------< enable_startup_mode >--------------------------|

Line 153: and nvl(evg.legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)

149: cursor csr_evg_grp_id is
150: select event_group_id
151: from pay_event_groups evg
152: where evg.event_group_name = p_event_group_name
153: and nvl(evg.legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)
154: and nvl(evg.business_group_id,hr_api.g_number) = nvl(p_business_group_id,hr_api.g_number);
155: --
156: l_proc varchar2(72) := g_package||'get_event_group_id';
157: l_event_group_id pay_event_groups.event_group_id%type;

Line 154: and nvl(evg.business_group_id,hr_api.g_number) = nvl(p_business_group_id,hr_api.g_number);

150: select event_group_id
151: from pay_event_groups evg
152: where evg.event_group_name = p_event_group_name
153: and nvl(evg.legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)
154: and nvl(evg.business_group_id,hr_api.g_number) = nvl(p_business_group_id,hr_api.g_number);
155: --
156: l_proc varchar2(72) := g_package||'get_event_group_id';
157: l_event_group_id pay_event_groups.event_group_id%type;
158: --

Line 198: and nvl(els.legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)

194: cursor csr_eset_id is
195: select element_set_id
196: from pay_element_sets els
197: where els.element_set_name = p_element_set_name
198: and nvl(els.legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)
199: and nvl(els.business_group_id,hr_api.g_number) = nvl(p_business_group_id,hr_api.g_number);
200: --
201: l_proc varchar2(72) := g_package||'get_element_set_id';
202: l_element_set_id pay_element_sets.element_set_id%type;

Line 199: and nvl(els.business_group_id,hr_api.g_number) = nvl(p_business_group_id,hr_api.g_number);

195: select element_set_id
196: from pay_element_sets els
197: where els.element_set_name = p_element_set_name
198: and nvl(els.legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)
199: and nvl(els.business_group_id,hr_api.g_number) = nvl(p_business_group_id,hr_api.g_number);
200: --
201: l_proc varchar2(72) := g_package||'get_element_set_id';
202: l_element_set_id pay_element_sets.element_set_id%type;
203: --

Line 245: and nvl(legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)

241: cursor csr_user_entity_id is
242: select user_entity_id
243: from ff_user_entities
244: where user_entity_name = p_user_entity_name
245: and nvl(legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)
246: and business_group_id is null;
247: --
248: l_proc varchar2(72) := g_package||'get_user_entity_id';
249: l_user_entity_id FF_USER_ENTITIES.USER_ENTITY_ID%TYPE;

Line 291: and nvl(ff.legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)

287: select distinct ff.formula_id
288: from ff_formulas_f ff
289: ,ff_formula_types ft
290: where ff.formula_name = p_formula_name
291: and nvl(ff.legislation_code,hr_api.g_varchar2) = nvl(p_legislation_code,hr_api.g_varchar2)
292: and ft.formula_type_name = p_formula_type_name
293: and ft.formula_type_id = ff.formula_type_id
294: and ff.business_group_id is null;
295: --

Line 491: if l_rec.report_type <> nvl(g_rfm_old_rec.report_type,hr_api.g_varchar2) or

487: ( p_owner => p_owner );
488:
489: if p_eof = 1 then
490:
491: if l_rec.report_type <> nvl(g_rfm_old_rec.report_type,hr_api.g_varchar2) or
492: l_rec.report_qualifier <> nvl(g_rfm_old_rec.report_qualifier,hr_api.g_varchar2) or
493: l_rec.report_category <> nvl(g_rfm_old_rec.report_category,hr_api.g_varchar2) then
494:
495: -- A new record is being uploaded.

Line 492: l_rec.report_qualifier <> nvl(g_rfm_old_rec.report_qualifier,hr_api.g_varchar2) or

488:
489: if p_eof = 1 then
490:
491: if l_rec.report_type <> nvl(g_rfm_old_rec.report_type,hr_api.g_varchar2) or
492: l_rec.report_qualifier <> nvl(g_rfm_old_rec.report_qualifier,hr_api.g_varchar2) or
493: l_rec.report_category <> nvl(g_rfm_old_rec.report_category,hr_api.g_varchar2) then
494:
495: -- A new record is being uploaded.
496:

Line 493: l_rec.report_category <> nvl(g_rfm_old_rec.report_category,hr_api.g_varchar2) then

489: if p_eof = 1 then
490:
491: if l_rec.report_type <> nvl(g_rfm_old_rec.report_type,hr_api.g_varchar2) or
492: l_rec.report_qualifier <> nvl(g_rfm_old_rec.report_qualifier,hr_api.g_varchar2) or
493: l_rec.report_category <> nvl(g_rfm_old_rec.report_category,hr_api.g_varchar2) then
494:
495: -- A new record is being uploaded.
496:
497: -- End Date the previous record if necessary.

Line 499: if g_rfm_effective_end_date <> hr_api.g_eot then

495: -- A new record is being uploaded.
496:
497: -- End Date the previous record if necessary.
498:
499: if g_rfm_effective_end_date <> hr_api.g_eot then
500:
501: set_end_date;
502:
503: end if;

Line 591: if g_rfm_effective_end_date <> hr_api.g_eot then

587: end if;
588:
589: elsif p_eof = 2 then
590:
591: if g_rfm_effective_end_date <> hr_api.g_eot then
592:
593: set_end_date;
594:
595: end if;

Line 745: if l_rec.report_type <> nvl(g_rfi_old_rec.report_type,hr_api.g_varchar2) or

741: ( p_owner => p_owner );
742:
743: if p_eof = 1 then
744:
745: if l_rec.report_type <> nvl(g_rfi_old_rec.report_type,hr_api.g_varchar2) or
746: l_rec.report_qualifier <> nvl(g_rfi_old_rec.report_qualifier,hr_api.g_varchar2) or
747: l_rec.report_category <> nvl(g_rfi_old_rec.report_category,hr_api.g_varchar2) or
748: l_rec.user_entity_id <> nvl(g_rfi_old_rec.user_entity_id,hr_api.g_number) then
749:

Line 746: l_rec.report_qualifier <> nvl(g_rfi_old_rec.report_qualifier,hr_api.g_varchar2) or

742:
743: if p_eof = 1 then
744:
745: if l_rec.report_type <> nvl(g_rfi_old_rec.report_type,hr_api.g_varchar2) or
746: l_rec.report_qualifier <> nvl(g_rfi_old_rec.report_qualifier,hr_api.g_varchar2) or
747: l_rec.report_category <> nvl(g_rfi_old_rec.report_category,hr_api.g_varchar2) or
748: l_rec.user_entity_id <> nvl(g_rfi_old_rec.user_entity_id,hr_api.g_number) then
749:
750: -- It is a new record that is being uploaded.

Line 747: l_rec.report_category <> nvl(g_rfi_old_rec.report_category,hr_api.g_varchar2) or

743: if p_eof = 1 then
744:
745: if l_rec.report_type <> nvl(g_rfi_old_rec.report_type,hr_api.g_varchar2) or
746: l_rec.report_qualifier <> nvl(g_rfi_old_rec.report_qualifier,hr_api.g_varchar2) or
747: l_rec.report_category <> nvl(g_rfi_old_rec.report_category,hr_api.g_varchar2) or
748: l_rec.user_entity_id <> nvl(g_rfi_old_rec.user_entity_id,hr_api.g_number) then
749:
750: -- It is a new record that is being uploaded.
751:

Line 748: l_rec.user_entity_id <> nvl(g_rfi_old_rec.user_entity_id,hr_api.g_number) then

744:
745: if l_rec.report_type <> nvl(g_rfi_old_rec.report_type,hr_api.g_varchar2) or
746: l_rec.report_qualifier <> nvl(g_rfi_old_rec.report_qualifier,hr_api.g_varchar2) or
747: l_rec.report_category <> nvl(g_rfi_old_rec.report_category,hr_api.g_varchar2) or
748: l_rec.user_entity_id <> nvl(g_rfi_old_rec.user_entity_id,hr_api.g_number) then
749:
750: -- It is a new record that is being uploaded.
751:
752: -- End Date the previous record if necessary.

Line 1120: egu.legislation_code = hr_api.return_legislation_code(l_business_group_id )))

1116: or ( l_business_group_id is not null and l_business_group_id = egu.business_group_id )
1117: or ( l_business_group_id is not null and
1118: egu.legislation_code is null and egu.business_group_id is null )
1119: or ( l_business_group_id is not null and
1120: egu.legislation_code = hr_api.return_legislation_code(l_business_group_id )))
1121: and ( l_legislation_code is null
1122: or ( l_legislation_code is not null and l_legislation_code = egu.legislation_code )
1123: or ( l_legislation_code is not null and
1124: egu.legislation_code is null and egu.business_group_id is null)

Line 1126: l_legislation_code = hr_api.return_legislation_code(egu.business_group_id )));

1122: or ( l_legislation_code is not null and l_legislation_code = egu.legislation_code )
1123: or ( l_legislation_code is not null and
1124: egu.legislation_code is null and egu.business_group_id is null)
1125: or ( l_legislation_code is not null and
1126: l_legislation_code = hr_api.return_legislation_code(egu.business_group_id )));
1127: --
1128: BEGIN
1129: --
1130:

Line 1259: and NVL(business_group_id, hr_api.g_number) = NVL(l_business_group_id, hr_api.g_number)

1255: select element_class_usage_id, object_version_number
1256: from pay_element_class_usages_f
1257: where run_type_id = l_run_type_id
1258: and classification_id = l_classification_id
1259: and NVL(business_group_id, hr_api.g_number) = NVL(l_business_group_id, hr_api.g_number)
1260: and NVL(legislation_code, hr_api.g_varchar2) = NVL(p_legislation_code, hr_api.g_varchar2)
1261: and p_effective_start_date between effective_start_date and effective_end_date;
1262: --
1263: PROCEDURE set_end_date IS

Line 1260: and NVL(legislation_code, hr_api.g_varchar2) = NVL(p_legislation_code, hr_api.g_varchar2)

1256: from pay_element_class_usages_f
1257: where run_type_id = l_run_type_id
1258: and classification_id = l_classification_id
1259: and NVL(business_group_id, hr_api.g_number) = NVL(l_business_group_id, hr_api.g_number)
1260: and NVL(legislation_code, hr_api.g_varchar2) = NVL(p_legislation_code, hr_api.g_varchar2)
1261: and p_effective_start_date between effective_start_date and effective_end_date;
1262: --
1263: PROCEDURE set_end_date IS
1264: --

Line 1335: if g_ecu_effective_end_date <> hr_api.g_eot then

1331:
1332: -- A new record is being uploaded.
1333:
1334: -- End Date the previous record if necessary.
1335: if g_ecu_effective_end_date <> hr_api.g_eot then
1336: --
1337: set_end_date;
1338: --
1339: end if;

Line 1395: if g_ecu_effective_end_date <> hr_api.g_eot then

1391: g_usage_id := p_usage_id;
1392:
1393: elsif p_eof_number = 2 then
1394:
1395: if g_ecu_effective_end_date <> hr_api.g_eot then
1396: --
1397: set_end_date;
1398: --
1399: end if;