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_EN_GET_SUAEH_DTL dependencies on IGS_EN_SU_ATTEMPT

Line 20: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)

16: p_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
17: p_ci_seq_num IN IGS_CA_INST_ALL.sequence_number%TYPE ,
18: p_hist_start_dt IN DATE ,
19: p_unit_attempt_status IN VARCHAR2,
20: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
21: RETURN VARCHAR2;
22:
23: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SUAEH_COL,WNDS);
24: --

Line 27: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,

23: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SUAEH_COL,WNDS);
24: --
25: -- Routine to get the effective end date for a SUA history
26: FUNCTION enrp_get_suaeh_eff_end(
27: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
28: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
29: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
30: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
31: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,

Line 28: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,

24: --
25: -- Routine to get the effective end date for a SUA history
26: FUNCTION enrp_get_suaeh_eff_end(
27: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
28: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
29: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
30: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
31: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
32: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,

Line 29: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,

25: -- Routine to get the effective end date for a SUA history
26: FUNCTION enrp_get_suaeh_eff_end(
27: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
28: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
29: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
30: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
31: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
32: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
33: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,

Line 30: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,

26: FUNCTION enrp_get_suaeh_eff_end(
27: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
28: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
29: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
30: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
31: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
32: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
33: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
34: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)

Line 31: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,

27: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
28: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
29: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
30: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
31: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
32: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
33: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
34: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
35: RETURN DATE;

Line 32: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,

28: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
29: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
30: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
31: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
32: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
33: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
34: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
35: RETURN DATE;
36: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SUAEH_EFF_END,WNDS);

Line 33: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,

29: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
30: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
31: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
32: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
33: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
34: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
35: RETURN DATE;
36: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SUAEH_EFF_END,WNDS);
37:

Line 34: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)

30: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
31: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
32: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE ,
33: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
34: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
35: RETURN DATE;
36: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SUAEH_EFF_END,WNDS);
37:
38: -- Routine to get the effective start date for a SUA history

Line 40: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,

36: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SUAEH_EFF_END,WNDS);
37:
38: -- Routine to get the effective start date for a SUA history
39: FUNCTION enrp_get_suaeh_eff_st(
40: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
41: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
42: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
43: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
44: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,

Line 41: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,

37:
38: -- Routine to get the effective start date for a SUA history
39: FUNCTION enrp_get_suaeh_eff_st(
40: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
41: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
42: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
43: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
44: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
45: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,

Line 42: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,

38: -- Routine to get the effective start date for a SUA history
39: FUNCTION enrp_get_suaeh_eff_st(
40: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
41: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
42: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
43: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
44: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
45: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
46: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,

Line 43: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,

39: FUNCTION enrp_get_suaeh_eff_st(
40: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
41: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
42: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
43: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
44: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
45: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
46: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
47: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)

Line 44: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,

40: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
41: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
42: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
43: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
44: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
45: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
46: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
47: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
48: RETURN DATE;

Line 45: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,

41: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
42: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
43: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
44: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
45: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
46: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
47: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
48: RETURN DATE;
49: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SUAEH_EFF_ST,WNDS);

Line 46: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,

42: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
43: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
44: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
45: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
46: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
47: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
48: RETURN DATE;
49: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SUAEH_EFF_ST,WNDS);
50:

Line 47: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)

43: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
44: p_ci_sequence_num IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
45: p_hist_start_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_start_dt%TYPE ,
46: p_unit_attempt_status IN IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE,
47: p_uoo_id IN IGS_EN_SU_ATTEMPT.UOO_ID%TYPE)
48: RETURN DATE;
49: PRAGMA RESTRICT_REFERENCES (ENRP_GET_SUAEH_EFF_ST,WNDS);
50:
51: END IGS_EN_GET_SUAEH_DTL;