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_DIS_BUS dependencies on PER_DISABILITIES_F

Line 29: , per_disabilities_f dis

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , per_disabilities_f dis
30: , per_people_f per
31: where dis.disability_id = p_disability_id
32: and dis.person_id = per.person_id
33: and pbg.business_group_id = per.business_group_id;

Line 91: , per_disabilities_f dis

87: --
88: cursor csr_leg_code is
89: select pbg.legislation_code
90: from per_business_groups pbg
91: , per_disabilities_f dis
92: , per_people_f per
93: where dis.disability_id = p_disability_id
94: and dis.person_id = per.person_id
95: and pbg.business_group_id = per.business_group_id;

Line 183: (p_person_id in per_disabilities_f.person_id%TYPE

179: -- {End of Comments}
180: --
181: -- ---------------------------------------------------------------------------
182: procedure chk_person_id
183: (p_person_id in per_disabilities_f.person_id%TYPE
184: ,p_effective_date in per_disabilities_f.effective_start_date%TYPE
185: )
186: is
187: --

Line 184: ,p_effective_date in per_disabilities_f.effective_start_date%TYPE

180: --
181: -- ---------------------------------------------------------------------------
182: procedure chk_person_id
183: (p_person_id in per_disabilities_f.person_id%TYPE
184: ,p_effective_date in per_disabilities_f.effective_start_date%TYPE
185: )
186: is
187: --
188: cursor csr_person is

Line 267: (p_disability_id in per_disabilities_f.disability_id%TYPE

263: -- {End of Comments}
264: --
265: -- ---------------------------------------------------------------------------
266: procedure chk_incident_id
267: (p_disability_id in per_disabilities_f.disability_id%TYPE
268: ,p_person_id in per_disabilities_f.person_id%TYPE
269: ,p_effective_date in per_disabilities_f.effective_start_date%TYPE
270: ,p_incident_id in per_disabilities_f.incident_id%TYPE
271: )

Line 268: ,p_person_id in per_disabilities_f.person_id%TYPE

264: --
265: -- ---------------------------------------------------------------------------
266: procedure chk_incident_id
267: (p_disability_id in per_disabilities_f.disability_id%TYPE
268: ,p_person_id in per_disabilities_f.person_id%TYPE
269: ,p_effective_date in per_disabilities_f.effective_start_date%TYPE
270: ,p_incident_id in per_disabilities_f.incident_id%TYPE
271: )
272: is

Line 269: ,p_effective_date in per_disabilities_f.effective_start_date%TYPE

265: -- ---------------------------------------------------------------------------
266: procedure chk_incident_id
267: (p_disability_id in per_disabilities_f.disability_id%TYPE
268: ,p_person_id in per_disabilities_f.person_id%TYPE
269: ,p_effective_date in per_disabilities_f.effective_start_date%TYPE
270: ,p_incident_id in per_disabilities_f.incident_id%TYPE
271: )
272: is
273: --

Line 270: ,p_incident_id in per_disabilities_f.incident_id%TYPE

266: procedure chk_incident_id
267: (p_disability_id in per_disabilities_f.disability_id%TYPE
268: ,p_person_id in per_disabilities_f.person_id%TYPE
269: ,p_effective_date in per_disabilities_f.effective_start_date%TYPE
270: ,p_incident_id in per_disabilities_f.incident_id%TYPE
271: )
272: is
273: --
274: cursor csr_inc is

Line 392: (p_disability_id in per_disabilities_f.disability_id%TYPE

388: -- {End of Comments}
389: --
390: -- ---------------------------------------------------------------------------
391: procedure chk_category
392: (p_disability_id in per_disabilities_f.disability_id%TYPE
393: ,p_category in per_disabilities_f.category%TYPE
394: ,p_effective_date in date
395: ,p_validation_start_date in date
396: ,p_validation_end_date in date

Line 393: ,p_category in per_disabilities_f.category%TYPE

389: --
390: -- ---------------------------------------------------------------------------
391: procedure chk_category
392: (p_disability_id in per_disabilities_f.disability_id%TYPE
393: ,p_category in per_disabilities_f.category%TYPE
394: ,p_effective_date in date
395: ,p_validation_start_date in date
396: ,p_validation_end_date in date
397: )

Line 492: (p_disability_id in per_disabilities_f.disability_id%TYPE

488: -- Access Status:
489: -- Internal Row Handler Use Only.
490: --
491: procedure chk_status
492: (p_disability_id in per_disabilities_f.disability_id%TYPE
493: ,p_status in per_disabilities_f.status%TYPE
494: ,p_effective_date in date
495: ,p_validation_start_date in date
496: ,p_validation_end_date in date

Line 493: ,p_status in per_disabilities_f.status%TYPE

489: -- Internal Row Handler Use Only.
490: --
491: procedure chk_status
492: (p_disability_id in per_disabilities_f.disability_id%TYPE
493: ,p_status in per_disabilities_f.status%TYPE
494: ,p_effective_date in date
495: ,p_validation_start_date in date
496: ,p_validation_end_date in date
497: )

Line 592: (p_quota_fte in per_disabilities_f.quota_fte%TYPE) is

588: -- {End of Comments}
589: --
590: -- ---------------------------------------------------------------------------
591: procedure chk_quota_fte
592: (p_quota_fte in per_disabilities_f.quota_fte%TYPE) is
593: --
594: l_proc varchar2(72) := g_package||'chk_quota_fte';
595: --
596: begin

Line 646: (p_disability_id in per_disabilities_f.disability_id%TYPE

642: -- {End of Comments}
643: --
644: -- ---------------------------------------------------------------------------
645: procedure chk_reason
646: (p_disability_id in per_disabilities_f.disability_id%TYPE
647: ,p_reason in per_disabilities_f.reason%TYPE
648: ,p_effective_date in date
649: ,p_validation_start_date in date
650: ,p_validation_end_date in date

Line 647: ,p_reason in per_disabilities_f.reason%TYPE

643: --
644: -- ---------------------------------------------------------------------------
645: procedure chk_reason
646: (p_disability_id in per_disabilities_f.disability_id%TYPE
647: ,p_reason in per_disabilities_f.reason%TYPE
648: ,p_effective_date in date
649: ,p_validation_start_date in date
650: ,p_validation_end_date in date
651: )

Line 740: (p_degree in per_disabilities_f.degree%TYPE) is

736: -- {End of Comments}
737: --
738: -- ---------------------------------------------------------------------------
739: procedure chk_degree
740: (p_degree in per_disabilities_f.degree%TYPE) is
741: --
742: l_proc varchar2(72) := g_package||'chk_degree';
743: --
744: begin

Line 790: (p_disability_id in per_disabilities_f.disability_id%TYPE

786: --
787: -- {End of Comments}
788: --
789: procedure chk_organization_id
790: (p_disability_id in per_disabilities_f.disability_id%TYPE
791: ,p_organization_id in per_disabilities_f.organization_id%TYPE
792: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
793: ,p_validation_start_date in per_disabilities_f.effective_start_date%TYPE
794: )

Line 791: ,p_organization_id in per_disabilities_f.organization_id%TYPE

787: -- {End of Comments}
788: --
789: procedure chk_organization_id
790: (p_disability_id in per_disabilities_f.disability_id%TYPE
791: ,p_organization_id in per_disabilities_f.organization_id%TYPE
792: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
793: ,p_validation_start_date in per_disabilities_f.effective_start_date%TYPE
794: )
795: is

Line 793: ,p_validation_start_date in per_disabilities_f.effective_start_date%TYPE

789: procedure chk_organization_id
790: (p_disability_id in per_disabilities_f.disability_id%TYPE
791: ,p_organization_id in per_disabilities_f.organization_id%TYPE
792: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
793: ,p_validation_start_date in per_disabilities_f.effective_start_date%TYPE
794: )
795: is
796: --
797: cursor csr_org is

Line 912: (p_organization_id in per_disabilities_f.organization_id%TYPE

908: --
909: -- {End of Comments}
910: --
911: procedure chk_registration_details
912: (p_organization_id in per_disabilities_f.organization_id%TYPE
913: ,p_registration_id in per_disabilities_f.registration_id%TYPE
914: ,p_registration_date in per_disabilities_f.registration_date%TYPE
915: ,p_registration_exp_date in per_disabilities_f.registration_exp_date%TYPE
916: ) IS

Line 913: ,p_registration_id in per_disabilities_f.registration_id%TYPE

909: -- {End of Comments}
910: --
911: procedure chk_registration_details
912: (p_organization_id in per_disabilities_f.organization_id%TYPE
913: ,p_registration_id in per_disabilities_f.registration_id%TYPE
914: ,p_registration_date in per_disabilities_f.registration_date%TYPE
915: ,p_registration_exp_date in per_disabilities_f.registration_exp_date%TYPE
916: ) IS
917: --

Line 914: ,p_registration_date in per_disabilities_f.registration_date%TYPE

910: --
911: procedure chk_registration_details
912: (p_organization_id in per_disabilities_f.organization_id%TYPE
913: ,p_registration_id in per_disabilities_f.registration_id%TYPE
914: ,p_registration_date in per_disabilities_f.registration_date%TYPE
915: ,p_registration_exp_date in per_disabilities_f.registration_exp_date%TYPE
916: ) IS
917: --
918: l_proc varchar2(72) := g_package||'chk_registration_details';

Line 915: ,p_registration_exp_date in per_disabilities_f.registration_exp_date%TYPE

911: procedure chk_registration_details
912: (p_organization_id in per_disabilities_f.organization_id%TYPE
913: ,p_registration_id in per_disabilities_f.registration_id%TYPE
914: ,p_registration_date in per_disabilities_f.registration_date%TYPE
915: ,p_registration_exp_date in per_disabilities_f.registration_exp_date%TYPE
916: ) IS
917: --
918: l_proc varchar2(72) := g_package||'chk_registration_details';
919: --