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.PER_BPR_BUS dependencies on PER_BF_PAYROLL_RUNS

Line 29: , per_bf_payroll_runs bpr

25: --
26: cursor csr_sec_grp is
27: select inf.org_information14
28: from hr_organization_information inf
29: , per_bf_payroll_runs bpr
30: where bpr.payroll_run_id = p_payroll_run_id
31: and inf.organization_id = bpr.business_group_id
32: and inf.org_information_context || '' = 'Business Group Information';
33: --

Line 86: , per_bf_payroll_runs bpr

82: --
83: cursor csr_leg_code is
84: select pbg.legislation_code
85: from per_business_groups pbg
86: , per_bf_payroll_runs bpr
87: where bpr.payroll_run_id = p_payroll_run_id
88: and pbg.business_group_id = bpr.business_group_id;
89: --
90: -- Declare local variables

Line 251: ,p_descflex_name => 'PER_BF_PAYROLL_RUNS'

247: -- b) During insert.
248: --
249: hr_dflex_utility.ins_or_upd_descflex_attribs
250: (p_appl_short_name => 'PER'
251: ,p_descflex_name => 'PER_BF_PAYROLL_RUNS'
252: ,p_attribute_category => p_rec.bpr_attribute_category
253: ,p_attribute1_name => 'BPR_ATTRIBUTE1'
254: ,p_attribute1_value => p_rec.bpr_attribute1
255: ,p_attribute2_name => 'BPR_ATTRIBUTE2'

Line 413: ( p_payroll_identifier in per_bf_payroll_runs.payroll_identifier%TYPE

409: -- An application error will be raised and processing terminated if the
410: -- payroll identifier is not unique within the constraints laid out above.
411: --
412: Procedure chk_identifier
413: ( p_payroll_identifier in per_bf_payroll_runs.payroll_identifier%TYPE
414: , p_business_group_id in per_bf_payroll_runs.business_group_id%TYPE
415: , p_payroll_run_id in per_bf_payroll_runs.payroll_run_id%TYPE
416: )
417: is

Line 414: , p_business_group_id in per_bf_payroll_runs.business_group_id%TYPE

410: -- payroll identifier is not unique within the constraints laid out above.
411: --
412: Procedure chk_identifier
413: ( p_payroll_identifier in per_bf_payroll_runs.payroll_identifier%TYPE
414: , p_business_group_id in per_bf_payroll_runs.business_group_id%TYPE
415: , p_payroll_run_id in per_bf_payroll_runs.payroll_run_id%TYPE
416: )
417: is
418: --

Line 415: , p_payroll_run_id in per_bf_payroll_runs.payroll_run_id%TYPE

411: --
412: Procedure chk_identifier
413: ( p_payroll_identifier in per_bf_payroll_runs.payroll_identifier%TYPE
414: , p_business_group_id in per_bf_payroll_runs.business_group_id%TYPE
415: , p_payroll_run_id in per_bf_payroll_runs.payroll_run_id%TYPE
416: )
417: is
418: --
419: l_proc varchar2(72) := g_package || 'chk_identifier';

Line 423: FROM per_bf_payroll_runs

419: l_proc varchar2(72) := g_package || 'chk_identifier';
420: --
421: CURSOR c_check_identifier IS
422: SELECT 1
423: FROM per_bf_payroll_runs
424: WHERE( (p_payroll_run_id IS NULL)
425: or (payroll_run_id <> p_payroll_run_id))
426: AND payroll_identifier = p_payroll_identifier
427: AND business_group_id = p_business_group_id ;

Line 452: per_bpr_shd.constraint_error('PER_BF_PAYROLL_RUNS_UK1');

448: -- so error.
449: --
450: close c_check_identifier;
451: --
452: per_bpr_shd.constraint_error('PER_BF_PAYROLL_RUNS_UK1');
453: --
454: END IF;
455: --
456: close c_check_identifier;

Line 486: ( p_period_start_date in per_bf_payroll_runs.period_start_date%TYPE

482: -- Post Failure
483: -- An application error will be raised and processing terminated.
484: --
485: PROCEDURE chk_run_dates
486: ( p_period_start_date in per_bf_payroll_runs.period_start_date%TYPE
487: , p_period_end_date in per_bf_payroll_runs.period_end_date%TYPE
488: , p_processing_date in per_bf_payroll_runs.processing_date%TYPE
489: , p_payroll_run_id in per_bf_payroll_runs.payroll_run_id%TYPE
490: , p_object_version_number in per_bf_payroll_runs.object_version_number%TYPE

Line 487: , p_period_end_date in per_bf_payroll_runs.period_end_date%TYPE

483: -- An application error will be raised and processing terminated.
484: --
485: PROCEDURE chk_run_dates
486: ( p_period_start_date in per_bf_payroll_runs.period_start_date%TYPE
487: , p_period_end_date in per_bf_payroll_runs.period_end_date%TYPE
488: , p_processing_date in per_bf_payroll_runs.processing_date%TYPE
489: , p_payroll_run_id in per_bf_payroll_runs.payroll_run_id%TYPE
490: , p_object_version_number in per_bf_payroll_runs.object_version_number%TYPE
491: ) IS

Line 488: , p_processing_date in per_bf_payroll_runs.processing_date%TYPE

484: --
485: PROCEDURE chk_run_dates
486: ( p_period_start_date in per_bf_payroll_runs.period_start_date%TYPE
487: , p_period_end_date in per_bf_payroll_runs.period_end_date%TYPE
488: , p_processing_date in per_bf_payroll_runs.processing_date%TYPE
489: , p_payroll_run_id in per_bf_payroll_runs.payroll_run_id%TYPE
490: , p_object_version_number in per_bf_payroll_runs.object_version_number%TYPE
491: ) IS
492: --

Line 489: , p_payroll_run_id in per_bf_payroll_runs.payroll_run_id%TYPE

485: PROCEDURE chk_run_dates
486: ( p_period_start_date in per_bf_payroll_runs.period_start_date%TYPE
487: , p_period_end_date in per_bf_payroll_runs.period_end_date%TYPE
488: , p_processing_date in per_bf_payroll_runs.processing_date%TYPE
489: , p_payroll_run_id in per_bf_payroll_runs.payroll_run_id%TYPE
490: , p_object_version_number in per_bf_payroll_runs.object_version_number%TYPE
491: ) IS
492: --
493: l_proc varchar2(72) := g_package||'chk_run_dates';

Line 490: , p_object_version_number in per_bf_payroll_runs.object_version_number%TYPE

486: ( p_period_start_date in per_bf_payroll_runs.period_start_date%TYPE
487: , p_period_end_date in per_bf_payroll_runs.period_end_date%TYPE
488: , p_processing_date in per_bf_payroll_runs.processing_date%TYPE
489: , p_payroll_run_id in per_bf_payroll_runs.payroll_run_id%TYPE
490: , p_object_version_number in per_bf_payroll_runs.object_version_number%TYPE
491: ) IS
492: --
493: l_proc varchar2(72) := g_package||'chk_run_dates';
494: --

Line 612: ( p_period_start_date in per_bf_payroll_runs.period_start_date%TYPE

608: -- Post Failure
609: -- An application error will be raised and processing terminated.
610: --
611: PROCEDURE chk_date_start_end
612: ( p_period_start_date in per_bf_payroll_runs.period_start_date%TYPE
613: , p_period_end_date in per_bf_payroll_runs.period_end_date%TYPE
614: , p_payroll_run_id in per_bf_payroll_runs.payroll_run_id%TYPE
615: , p_object_version_number in per_bf_payroll_runs.object_version_number%TYPE
616: ) IS

Line 613: , p_period_end_date in per_bf_payroll_runs.period_end_date%TYPE

609: -- An application error will be raised and processing terminated.
610: --
611: PROCEDURE chk_date_start_end
612: ( p_period_start_date in per_bf_payroll_runs.period_start_date%TYPE
613: , p_period_end_date in per_bf_payroll_runs.period_end_date%TYPE
614: , p_payroll_run_id in per_bf_payroll_runs.payroll_run_id%TYPE
615: , p_object_version_number in per_bf_payroll_runs.object_version_number%TYPE
616: ) IS
617: --

Line 614: , p_payroll_run_id in per_bf_payroll_runs.payroll_run_id%TYPE

610: --
611: PROCEDURE chk_date_start_end
612: ( p_period_start_date in per_bf_payroll_runs.period_start_date%TYPE
613: , p_period_end_date in per_bf_payroll_runs.period_end_date%TYPE
614: , p_payroll_run_id in per_bf_payroll_runs.payroll_run_id%TYPE
615: , p_object_version_number in per_bf_payroll_runs.object_version_number%TYPE
616: ) IS
617: --
618: l_start_date DATE;

Line 615: , p_object_version_number in per_bf_payroll_runs.object_version_number%TYPE

611: PROCEDURE chk_date_start_end
612: ( p_period_start_date in per_bf_payroll_runs.period_start_date%TYPE
613: , p_period_end_date in per_bf_payroll_runs.period_end_date%TYPE
614: , p_payroll_run_id in per_bf_payroll_runs.payroll_run_id%TYPE
615: , p_object_version_number in per_bf_payroll_runs.object_version_number%TYPE
616: ) IS
617: --
618: l_start_date DATE;
619: l_end_date DATE;

Line 718: per_bpr_shd.constraint_error('PER_BF_PAYROLL_RUNS_REX');

714: fetch csr_payroll_exists into l_exists;
715: if csr_payroll_exists%FOUND then
716: -- row exists - raise error by calling contraint error
717: close csr_payroll_exists;
718: per_bpr_shd.constraint_error('PER_BF_PAYROLL_RUNS_REX');
719: end if;
720: close csr_payroll_exists;
721: end if;
722: end chk_row_exists;