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.

[Home] [Help]

APPS.IGS_RATINGS_PUB dependencies on IGS_AD_APPL_PGMAPPRV

Line 65: FROM Igs_Ad_Appl_Pgmapprv a

61: )
62: IS
63: CURSOR c_pgm_appr IS
64: SELECT rowid row_id, appl_pgmapprv_id
65: FROM Igs_Ad_Appl_Pgmapprv a
66: WHERE person_id = p_person_id
67: AND admission_appl_number = p_admission_appl_number
68: AND nominated_course_cd = p_nominated_program_cd
69: AND sequence_number = p_sequence_number

Line 72: l_pgm_appr Igs_Ad_Appl_Pgmapprv%ROWTYPE;

68: AND nominated_course_cd = p_nominated_program_cd
69: AND sequence_number = p_sequence_number
70: AND pgm_approver_id = p_pgm_approver_id ;
71:
72: l_pgm_appr Igs_Ad_Appl_Pgmapprv%ROWTYPE;
73: l_api_version CONSTANT NUMBER := 1.0;
74: l_api_name CONSTANT VARCHAR2(30) := 'REC_PGM_APPROVAL';
75: l_msg_index NUMBER := 0;
76: l_return_status VARCHAR2(1);

Line 96: check_length('PERSON_ID', 'IGS_AD_APPL_PGMAPPRV', length(p_person_id));

92: END IF;
93: l_msg_index := igs_ge_msg_stack.count_msg;
94:
95: -- P_PERSON_ID
96: check_length('PERSON_ID', 'IGS_AD_APPL_PGMAPPRV', length(p_person_id));
97: -- P_ADMISSION_APPL_NUMBER
98: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_APPL_PGMAPPRV', length(p_admission_appl_number));
99: -- p_nominated_program_cd
100: check_length('NOMINATED_COURSE_CD', 'IGS_AD_APPL_PGMAPPRV', length(p_nominated_program_cd));

Line 98: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_APPL_PGMAPPRV', length(p_admission_appl_number));

94:
95: -- P_PERSON_ID
96: check_length('PERSON_ID', 'IGS_AD_APPL_PGMAPPRV', length(p_person_id));
97: -- P_ADMISSION_APPL_NUMBER
98: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_APPL_PGMAPPRV', length(p_admission_appl_number));
99: -- p_nominated_program_cd
100: check_length('NOMINATED_COURSE_CD', 'IGS_AD_APPL_PGMAPPRV', length(p_nominated_program_cd));
101: -- P_SEQUENCE_NUMBER
102: check_length('SEQUENCE_NUMBER', 'IGS_AD_APPL_PGMAPPRV', length(p_sequence_number));

Line 100: check_length('NOMINATED_COURSE_CD', 'IGS_AD_APPL_PGMAPPRV', length(p_nominated_program_cd));

96: check_length('PERSON_ID', 'IGS_AD_APPL_PGMAPPRV', length(p_person_id));
97: -- P_ADMISSION_APPL_NUMBER
98: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_APPL_PGMAPPRV', length(p_admission_appl_number));
99: -- p_nominated_program_cd
100: check_length('NOMINATED_COURSE_CD', 'IGS_AD_APPL_PGMAPPRV', length(p_nominated_program_cd));
101: -- P_SEQUENCE_NUMBER
102: check_length('SEQUENCE_NUMBER', 'IGS_AD_APPL_PGMAPPRV', length(p_sequence_number));
103: -- P_PGM_APPROVER_ID
104: check_length('PGM_APPROVER_ID', 'IGS_AD_APPL_PGMAPPRV', length(p_pgm_approver_id));

Line 102: check_length('SEQUENCE_NUMBER', 'IGS_AD_APPL_PGMAPPRV', length(p_sequence_number));

98: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_APPL_PGMAPPRV', length(p_admission_appl_number));
99: -- p_nominated_program_cd
100: check_length('NOMINATED_COURSE_CD', 'IGS_AD_APPL_PGMAPPRV', length(p_nominated_program_cd));
101: -- P_SEQUENCE_NUMBER
102: check_length('SEQUENCE_NUMBER', 'IGS_AD_APPL_PGMAPPRV', length(p_sequence_number));
103: -- P_PGM_APPROVER_ID
104: check_length('PGM_APPROVER_ID', 'IGS_AD_APPL_PGMAPPRV', length(p_pgm_approver_id));
105: -- P_PROGRAM_APPROVAL_STATUS
106: check_length('PROGRAM_APPROVAL_STATUS', 'IGS_AD_APPL_PGMAPPRV', length(p_program_approval_status));

Line 104: check_length('PGM_APPROVER_ID', 'IGS_AD_APPL_PGMAPPRV', length(p_pgm_approver_id));

100: check_length('NOMINATED_COURSE_CD', 'IGS_AD_APPL_PGMAPPRV', length(p_nominated_program_cd));
101: -- P_SEQUENCE_NUMBER
102: check_length('SEQUENCE_NUMBER', 'IGS_AD_APPL_PGMAPPRV', length(p_sequence_number));
103: -- P_PGM_APPROVER_ID
104: check_length('PGM_APPROVER_ID', 'IGS_AD_APPL_PGMAPPRV', length(p_pgm_approver_id));
105: -- P_PROGRAM_APPROVAL_STATUS
106: check_length('PROGRAM_APPROVAL_STATUS', 'IGS_AD_APPL_PGMAPPRV', length(p_program_approval_status));
107: -- P_APPROVAL_NOTES
108: check_length('APPROVAL_NOTES', 'IGS_AD_APPL_PGMAPPRV', length(p_approval_notes));

Line 106: check_length('PROGRAM_APPROVAL_STATUS', 'IGS_AD_APPL_PGMAPPRV', length(p_program_approval_status));

102: check_length('SEQUENCE_NUMBER', 'IGS_AD_APPL_PGMAPPRV', length(p_sequence_number));
103: -- P_PGM_APPROVER_ID
104: check_length('PGM_APPROVER_ID', 'IGS_AD_APPL_PGMAPPRV', length(p_pgm_approver_id));
105: -- P_PROGRAM_APPROVAL_STATUS
106: check_length('PROGRAM_APPROVAL_STATUS', 'IGS_AD_APPL_PGMAPPRV', length(p_program_approval_status));
107: -- P_APPROVAL_NOTES
108: check_length('APPROVAL_NOTES', 'IGS_AD_APPL_PGMAPPRV', length(p_approval_notes));
109:
110: OPEN c_pgm_appr;

Line 108: check_length('APPROVAL_NOTES', 'IGS_AD_APPL_PGMAPPRV', length(p_approval_notes));

104: check_length('PGM_APPROVER_ID', 'IGS_AD_APPL_PGMAPPRV', length(p_pgm_approver_id));
105: -- P_PROGRAM_APPROVAL_STATUS
106: check_length('PROGRAM_APPROVAL_STATUS', 'IGS_AD_APPL_PGMAPPRV', length(p_program_approval_status));
107: -- P_APPROVAL_NOTES
108: check_length('APPROVAL_NOTES', 'IGS_AD_APPL_PGMAPPRV', length(p_approval_notes));
109:
110: OPEN c_pgm_appr;
111: FETCH c_pgm_appr INTO lv_rowid,l_appl_pgmapprv_id;
112: CLOSE c_pgm_appr;

Line 115: Igs_Ad_Appl_Pgmapprv_Pkg.Insert_Row (

111: FETCH c_pgm_appr INTO lv_rowid,l_appl_pgmapprv_id;
112: CLOSE c_pgm_appr;
113: IF l_appl_pgmapprv_id is NULL THEN
114: -- Initialize API return status to success
115: Igs_Ad_Appl_Pgmapprv_Pkg.Insert_Row (
116: X_ROWID => lv_rowid,
117: x_APPL_PGMAPPRV_ID => l_appl_pgmapprv_id ,
118: x_PERSON_ID => p_person_id,
119: x_ADMISSION_APPL_NUMBER => p_admission_appl_number,

Line 131: Igs_Ad_Appl_Pgmapprv_Pkg.update_row (

127: x_APPROVAL_NOTES => p_approval_notes,
128: X_Mode => 'R'
129: );
130: ELSE
131: Igs_Ad_Appl_Pgmapprv_Pkg.update_row (
132: X_ROWID => lv_rowid,
133: x_APPL_PGMAPPRV_ID => l_appl_pgmapprv_id,
134: x_PERSON_ID => p_person_id,
135: x_ADMISSION_APPL_NUMBER => p_admission_appl_number,