APPS.GHR_COMPLAINTS2_PKG dependencies on GHR_COMPLAINTS2

Line 1: PACKAGE BODY ghr_complaints2_pkg AS

1: PACKAGE BODY ghr_complaints2_pkg AS
2: /* $Header: ghrcomp2.pkb 115.9 2004/06/09 00:31:26 sumarimu noship $ */
3:
4: -- Get Fullname and SSN
5: PROCEDURE get_fullname_ssn (p_complainant_person_id IN NUMBER

Line 608: FROM ghr_complaints2 cmp

604: RETURN NUMBER IS
605: --
606: CURSOR cur_cmp IS
607: SELECT count(*) rec_count
608: FROM ghr_complaints2 cmp
609: WHERE cmp.consolidated_complaint_id = p_consolidated_complaint_id
610: AND (cmp.complaint_id <> p_complaint_id OR p_complaint_id IS NULL);
611:
612: BEGIN

Line 628: FROM ghr_complaints2 cmp

624: RETURN VARCHAR2 IS
625: --
626: CURSOR cur_cmp IS
627: SELECT docket_number
628: FROM ghr_complaints2 cmp
629: WHERE cmp.consolidated_complaint_id = p_consolidated_complaint_id;
630:
631: BEGIN
632: FOR cur_cmp_rec IN cur_cmp LOOP

Line 692: l_complainant_person_id ghr_complaints2.complainant_person_id%TYPE := NULL;

688: RETURN VARCHAR2 IS
689: --
690: l_full_name per_people_f.full_name%TYPE := NULL;
691: l_ssn per_people_f.national_identifier%TYPE := NULL;
692: l_complainant_person_id ghr_complaints2.complainant_person_id%TYPE := NULL;
693: l_docket_number ghr_complaints2.docket_number%TYPE := NULL;
694:
695: CURSOR cur_cmp IS
696: SELECT complainant_person_id,docket_number

Line 693: l_docket_number ghr_complaints2.docket_number%TYPE := NULL;

689: --
690: l_full_name per_people_f.full_name%TYPE := NULL;
691: l_ssn per_people_f.national_identifier%TYPE := NULL;
692: l_complainant_person_id ghr_complaints2.complainant_person_id%TYPE := NULL;
693: l_docket_number ghr_complaints2.docket_number%TYPE := NULL;
694:
695: CURSOR cur_cmp IS
696: SELECT complainant_person_id,docket_number
697: FROM ghr_complaints2 cmp

Line 697: FROM ghr_complaints2 cmp

693: l_docket_number ghr_complaints2.docket_number%TYPE := NULL;
694:
695: CURSOR cur_cmp IS
696: SELECT complainant_person_id,docket_number
697: FROM ghr_complaints2 cmp
698: WHERE cmp.complaint_id = p_complaint_id;
699: --
700: BEGIN
701:

Line 707: ghr_complaints2_pkg.get_fullname_ssn(l_complainant_person_id

703: l_complainant_person_id := cur_cmp_rec.complainant_person_id;
704: l_docket_number := cur_cmp_rec.docket_number;
705: END LOOP;
706: --
707: ghr_complaints2_pkg.get_fullname_ssn(l_complainant_person_id
708: ,p_effective_date
709: ,l_full_name
710: ,l_ssn);
711:

Line 845: FROM ghr_complaints2 cmp

841: --
842: --
843: CURSOR cur_cmp IS
844: SELECT 1
845: FROM ghr_complaints2 cmp
846: WHERE cmp.complaint_id = p_complaint_id
847: AND cmp.pcom_init is NOT NULL;
848: --
849: BEGIN

Line 897: END ghr_complaints2_pkg;

893: --
894: END claim_exists;
895:
896:
897: END ghr_complaints2_pkg;