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.IGS_HE_IMPORT_POPDLHE dependencies on IGS_HE_SUB_RTN_QUAL

Line 16: PROCEDURE log_results(p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,

12: FUNCTION validate_popdlhe(p_popdlhe_dtls IN popdlhe_dtls) RETURN BOOLEAN;
13:
14: FUNCTION get_person_id(p_popdlhe_dtls IN popdlhe_dtls) RETURN NUMBER;
15:
16: PROCEDURE log_results(p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
17: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
18: p_total_dlhe_cnt IN NUMBER,
19: p_new_dlhe_cnt IN NUMBER,
20: p_upd_dlhe_cnt IN NUMBER,

Line 17: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,

13:
14: FUNCTION get_person_id(p_popdlhe_dtls IN popdlhe_dtls) RETURN NUMBER;
15:
16: PROCEDURE log_results(p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
17: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
18: p_total_dlhe_cnt IN NUMBER,
19: p_new_dlhe_cnt IN NUMBER,
20: p_upd_dlhe_cnt IN NUMBER,
21: p_fail_dlhe_cnt IN NUMBER,

Line 27: p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,

23:
24:
25: PROCEDURE import_popdlhe_to_oss (errbuf OUT NOCOPY VARCHAR2,
26: retcode OUT NOCOPY NUMBER,
27: p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
28: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
29: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
30: p_census_date IN VARCHAR2 ) IS
31: /******************************************************************

Line 28: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,

24:
25: PROCEDURE import_popdlhe_to_oss (errbuf OUT NOCOPY VARCHAR2,
26: retcode OUT NOCOPY NUMBER,
27: p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
28: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
29: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
30: p_census_date IN VARCHAR2 ) IS
31: /******************************************************************
32: Created By : Jonathan Baber

Line 29: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,

25: PROCEDURE import_popdlhe_to_oss (errbuf OUT NOCOPY VARCHAR2,
26: retcode OUT NOCOPY NUMBER,
27: p_submission_name IN igs_he_sub_rtn_qual.submission_name%TYPE,
28: p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
29: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
30: p_census_date IN VARCHAR2 ) IS
31: /******************************************************************
32: Created By : Jonathan Baber
33: Date Created By : 24-Aug-05

Line 58: CURSOR c_qual_dets (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,

54: AND submission_name = p_submission_name
55: AND return_name = p_return_name;
56:
57: -- cursor to retrieve qualification period details
58: CURSOR c_qual_dets (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,
59: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,
60: cp_qual_period igs_he_sub_rtn_qual.qual_period_code%TYPE) IS
61: SELECT qual_period_type, qual_period_desc, user_return_subclass, closed_ind
62: FROM igs_he_sub_rtn_qual qual

Line 59: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,

55: AND return_name = p_return_name;
56:
57: -- cursor to retrieve qualification period details
58: CURSOR c_qual_dets (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,
59: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,
60: cp_qual_period igs_he_sub_rtn_qual.qual_period_code%TYPE) IS
61: SELECT qual_period_type, qual_period_desc, user_return_subclass, closed_ind
62: FROM igs_he_sub_rtn_qual qual
63: WHERE qual.submission_name = cp_submission_name

Line 60: cp_qual_period igs_he_sub_rtn_qual.qual_period_code%TYPE) IS

56:
57: -- cursor to retrieve qualification period details
58: CURSOR c_qual_dets (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,
59: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,
60: cp_qual_period igs_he_sub_rtn_qual.qual_period_code%TYPE) IS
61: SELECT qual_period_type, qual_period_desc, user_return_subclass, closed_ind
62: FROM igs_he_sub_rtn_qual qual
63: WHERE qual.submission_name = cp_submission_name
64: AND qual.return_name = cp_return_name

Line 62: FROM igs_he_sub_rtn_qual qual

58: CURSOR c_qual_dets (cp_submission_name igs_he_sub_rtn_qual.submission_name%TYPE,
59: cp_return_name igs_he_sub_rtn_qual.return_name%TYPE,
60: cp_qual_period igs_he_sub_rtn_qual.qual_period_code%TYPE) IS
61: SELECT qual_period_type, qual_period_desc, user_return_subclass, closed_ind
62: FROM igs_he_sub_rtn_qual qual
63: WHERE qual.submission_name = cp_submission_name
64: AND qual.return_name = cp_return_name
65: AND qual.qual_period_code = cp_qual_period;
66:

Line 618: PROCEDURE log_results(p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,

614:
615: END get_person_id;
616:
617:
618: PROCEDURE log_results(p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
619: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
620: p_total_dlhe_cnt IN NUMBER,
621: p_new_dlhe_cnt IN NUMBER,
622: p_upd_dlhe_cnt IN NUMBER,

Line 619: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,

615: END get_person_id;
616:
617:
618: PROCEDURE log_results(p_return_name IN igs_he_sub_rtn_qual.return_name%TYPE,
619: p_qual_period IN igs_he_sub_rtn_qual.qual_period_code%TYPE,
620: p_total_dlhe_cnt IN NUMBER,
621: p_new_dlhe_cnt IN NUMBER,
622: p_upd_dlhe_cnt IN NUMBER,
623: p_fail_dlhe_cnt IN NUMBER,