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.IGF_AP_OSS_INTEGR dependencies on IGS_CA_INST_ALL

Line 27: PROCEDURE get_acad_cal_from_awd(p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,

23: p_mil_service_desc OUT NOCOPY igs_lookups_view.meaning%TYPE,
24: p_multiple OUT NOCOPY VARCHAR2);
25:
26:
27: PROCEDURE get_acad_cal_from_awd(p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
28: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
29: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
30: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
31: p_acad_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);

Line 28: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

24: p_multiple OUT NOCOPY VARCHAR2);
25:
26:
27: PROCEDURE get_acad_cal_from_awd(p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
28: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
29: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
30: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
31: p_acad_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);
32:

Line 29: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,

25:
26:
27: PROCEDURE get_acad_cal_from_awd(p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
28: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
29: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
30: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
31: p_acad_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);
32:
33: PROCEDURE get_awd_cal_from_acad(p_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,

Line 30: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,

26:
27: PROCEDURE get_acad_cal_from_awd(p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
28: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
29: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
30: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
31: p_acad_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);
32:
33: PROCEDURE get_awd_cal_from_acad(p_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
34: p_acad_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

Line 31: p_acad_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);

27: PROCEDURE get_acad_cal_from_awd(p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
28: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
29: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
30: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
31: p_acad_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);
32:
33: PROCEDURE get_awd_cal_from_acad(p_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
34: p_acad_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
35: p_awd_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,

Line 33: PROCEDURE get_awd_cal_from_acad(p_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,

29: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
30: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
31: p_acad_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);
32:
33: PROCEDURE get_awd_cal_from_acad(p_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
34: p_acad_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
35: p_awd_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
36: p_awd_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
37: p_awd_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);

Line 34: p_acad_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

30: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
31: p_acad_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);
32:
33: PROCEDURE get_awd_cal_from_acad(p_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
34: p_acad_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
35: p_awd_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
36: p_awd_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
37: p_awd_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);
38:

Line 35: p_awd_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,

31: p_acad_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);
32:
33: PROCEDURE get_awd_cal_from_acad(p_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
34: p_acad_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
35: p_awd_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
36: p_awd_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
37: p_awd_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);
38:
39:

Line 36: p_awd_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,

32:
33: PROCEDURE get_awd_cal_from_acad(p_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
34: p_acad_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
35: p_awd_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
36: p_awd_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
37: p_awd_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);
38:
39:
40: --Made the p_adm_appl_number,p_course-cd,p_crv_version_number as IN OUT NOCOPY parameters From IN

Line 37: p_awd_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);

33: PROCEDURE get_awd_cal_from_acad(p_acad_cal_type IN igs_ca_inst_all.cal_type%TYPE,
34: p_acad_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
35: p_awd_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
36: p_awd_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
37: p_awd_alt_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE);
38:
39:
40: --Made the p_adm_appl_number,p_course-cd,p_crv_version_number as IN OUT NOCOPY parameters From IN
41: --as per the FACCR001 DLD

Line 44: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,

40: --Made the p_adm_appl_number,p_course-cd,p_crv_version_number as IN OUT NOCOPY parameters From IN
41: --as per the FACCR001 DLD
42:
43: PROCEDURE get_adm_appl_details( p_person_id IN hz_parties.party_id%TYPE,
44: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
45: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
46: p_ad_appl_row_id OUT NOCOPY ROWID,
47: p_ad_prog_appl_row_id OUT NOCOPY ROWID,
48: p_adm_appl_number IN OUT NOCOPY igs_ad_appl_all.admission_appl_number%TYPE,

Line 45: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

41: --as per the FACCR001 DLD
42:
43: PROCEDURE get_adm_appl_details( p_person_id IN hz_parties.party_id%TYPE,
44: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
45: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
46: p_ad_appl_row_id OUT NOCOPY ROWID,
47: p_ad_prog_appl_row_id OUT NOCOPY ROWID,
48: p_adm_appl_number IN OUT NOCOPY igs_ad_appl_all.admission_appl_number%TYPE,
49: p_course_cd IN OUT NOCOPY igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

Line 58: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,

54: p_multiple OUT NOCOPY VARCHAR2 );
55:
56:
57: FUNCTION get_adm_appl_val(p_person_id IN hz_parties.party_id%TYPE,
58: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
59: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
60: RETURN ROWID;
61:
62: FUNCTION get_adm_prog_appl_val(p_person_id IN hz_parties.party_id%TYPE,

Line 59: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)

55:
56:
57: FUNCTION get_adm_appl_val(p_person_id IN hz_parties.party_id%TYPE,
58: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
59: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
60: RETURN ROWID;
61:
62: FUNCTION get_adm_prog_appl_val(p_person_id IN hz_parties.party_id%TYPE,
63: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,

Line 63: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,

59: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
60: RETURN ROWID;
61:
62: FUNCTION get_adm_prog_appl_val(p_person_id IN hz_parties.party_id%TYPE,
63: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
64: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
65: RETURN ROWID;
66:
67: PRAGMA RESTRICT_REFERENCES (get_pe_active_holds, WNDS);

Line 64: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)

60: RETURN ROWID;
61:
62: FUNCTION get_adm_prog_appl_val(p_person_id IN hz_parties.party_id%TYPE,
63: p_awd_cal_type IN igs_ca_inst_all.cal_type%TYPE,
64: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE)
65: RETURN ROWID;
66:
67: PRAGMA RESTRICT_REFERENCES (get_pe_active_holds, WNDS);
68: PRAGMA RESTRICT_REFERENCES (get_pe_visa_type, WNDS);