APPS.IGS_HE_IMPORT_POPDLHE dependencies on IGS_HE_POPDLHE_INTS

Line 5: popdlhe_id igs_he_popdlhe_ints.popdlhe_id%TYPE,

1: PACKAGE BODY igs_he_import_popdlhe AS
2: /* $Header: IGSHE26B.pls 120.1 2006/02/08 20:03:59 anwest noship $ */
3:
4: TYPE popdlhe_dtls IS RECORD (
5: popdlhe_id igs_he_popdlhe_ints.popdlhe_id%TYPE,
6: husid igs_he_popdlhe_ints.husid%TYPE,
7: ownstu igs_he_popdlhe_ints.ownstu%TYPE,
8: xqmode01 igs_he_popdlhe_ints.xqmode01%TYPE,
9: ttcid igs_he_popdlhe_ints.ttcid%TYPE);

Line 6: husid igs_he_popdlhe_ints.husid%TYPE,

2: /* $Header: IGSHE26B.pls 120.1 2006/02/08 20:03:59 anwest noship $ */
3:
4: TYPE popdlhe_dtls IS RECORD (
5: popdlhe_id igs_he_popdlhe_ints.popdlhe_id%TYPE,
6: husid igs_he_popdlhe_ints.husid%TYPE,
7: ownstu igs_he_popdlhe_ints.ownstu%TYPE,
8: xqmode01 igs_he_popdlhe_ints.xqmode01%TYPE,
9: ttcid igs_he_popdlhe_ints.ttcid%TYPE);
10:

Line 7: ownstu igs_he_popdlhe_ints.ownstu%TYPE,

3:
4: TYPE popdlhe_dtls IS RECORD (
5: popdlhe_id igs_he_popdlhe_ints.popdlhe_id%TYPE,
6: husid igs_he_popdlhe_ints.husid%TYPE,
7: ownstu igs_he_popdlhe_ints.ownstu%TYPE,
8: xqmode01 igs_he_popdlhe_ints.xqmode01%TYPE,
9: ttcid igs_he_popdlhe_ints.ttcid%TYPE);
10:
11: -- Function Declarations

Line 8: xqmode01 igs_he_popdlhe_ints.xqmode01%TYPE,

4: TYPE popdlhe_dtls IS RECORD (
5: popdlhe_id igs_he_popdlhe_ints.popdlhe_id%TYPE,
6: husid igs_he_popdlhe_ints.husid%TYPE,
7: ownstu igs_he_popdlhe_ints.ownstu%TYPE,
8: xqmode01 igs_he_popdlhe_ints.xqmode01%TYPE,
9: ttcid igs_he_popdlhe_ints.ttcid%TYPE);
10:
11: -- Function Declarations
12: FUNCTION validate_popdlhe(p_popdlhe_dtls IN popdlhe_dtls) RETURN BOOLEAN;

Line 9: ttcid igs_he_popdlhe_ints.ttcid%TYPE);

5: popdlhe_id igs_he_popdlhe_ints.popdlhe_id%TYPE,
6: husid igs_he_popdlhe_ints.husid%TYPE,
7: ownstu igs_he_popdlhe_ints.ownstu%TYPE,
8: xqmode01 igs_he_popdlhe_ints.xqmode01%TYPE,
9: ttcid igs_he_popdlhe_ints.ttcid%TYPE);
10:
11: -- Function Declarations
12: FUNCTION validate_popdlhe(p_popdlhe_dtls IN popdlhe_dtls) RETURN BOOLEAN;
13:

Line 34: Purpose : Processes records from IGS_HE_POPDLHE_INTS interface table and

30: p_census_date IN VARCHAR2 ) IS
31: /******************************************************************
32: Created By : Jonathan Baber
33: Date Created By : 24-Aug-05
34: Purpose : Processes records from IGS_HE_POPDLHE_INTS interface table and
35: updates or inserts corresponding records in igs_he_stdnt_dlhe table
36: Known limitations,enhancements,remarks:
37: Change History
38: Who When What

Line 130: 'FROM igs_he_popdlhe_ints ' ||

126: -- Construct and open POPDLHE query depending on qualification type
127: IF l_qual_dets.qual_period_type = 'L' THEN
128:
129: l_sql_stmt := 'SELECT popdlhe_id, husid, ownstu, xqmode01, ttcid ' ||
130: 'FROM igs_he_popdlhe_ints ' ||
131: 'WHERE popdlhe = ''1'' ' ||
132: 'AND census = :1' ;
133: OPEN c_popdlhe FOR l_sql_stmt USING p_census_date;
134:

Line 138: 'FROM igs_he_popdlhe_ints ' ||

134:
135: ELSIF l_qual_dets.qual_period_type = 'R' THEN
136:
137: l_sql_stmt := 'SELECT popdlhe_id, husid, ownstu, xqmode01, ttcid ' ||
138: 'FROM igs_he_popdlhe_ints ' ||
139: 'WHERE rcident IN (''1'',''2'',''3'',''4'',''5'',''6'',''7'') ';
140: OPEN c_popdlhe FOR l_sql_stmt;
141:
142: END IF;

Line 558: CURSOR c_ownstu (cp_ownstu igs_he_popdlhe_ints.ownstu%TYPE) IS

554: Change History
555: Who When What
556: *******************************************************************/
557: -- Determines PersonID from ownstu (party number)
558: CURSOR c_ownstu (cp_ownstu igs_he_popdlhe_ints.ownstu%TYPE) IS
559: SELECT party_id
560: FROM hz_parties
561: WHERE party_number = cp_ownstu;
562:

Line 564: CURSOR c_husid (cp_husid igs_he_popdlhe_ints.husid%TYPE) IS

560: FROM hz_parties
561: WHERE party_number = cp_ownstu;
562:
563: -- Determines PersonID from alternateID table using HUSID
564: CURSOR c_husid (cp_husid igs_he_popdlhe_ints.husid%TYPE) IS
565: SELECT pe_person_id
566: FROM igs_pe_alt_pers_id
567: WHERE api_person_id = cp_husid
568: AND person_id_type= 'HUSID'