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_AD_GEN_002 dependencies on IGS_AD_PS_APPL_INST

Line 100: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

96: p_admission_appl_number IN NUMBER)
97: RETURN VARCHAR2;
98:
99: PROCEDURE check_adm_appl_inst_stat(
100: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
101: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
102: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
103: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
104: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.

Line 101: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

97: RETURN VARCHAR2;
98:
99: PROCEDURE check_adm_appl_inst_stat(
100: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
101: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
102: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
103: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
104: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
105: );

Line 102: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,

98:
99: PROCEDURE check_adm_appl_inst_stat(
100: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
101: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
102: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
103: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
104: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
105: );
106:

Line 103: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,

99: PROCEDURE check_adm_appl_inst_stat(
100: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
101: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
102: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
103: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
104: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
105: );
106:
107:

Line 112: p_person_id igs_ad_ps_appl_inst.person_id%TYPE ,

108: -- This function will return true if for this application at least one application instance has an application offer response
109: -- status of 'Accepted' OR the offer response status is 'Deffered' with the deferment status as 'Confirmed'. For all other
110: -- cases it will return false. -- rghosh (bug#2901627)
111: FUNCTION valid_ofr_resp_status(
112: p_person_id igs_ad_ps_appl_inst.person_id%TYPE ,
113: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE)
114: RETURN BOOLEAN ;
115:
116: -- 20-Jul-2005 ANWEST Created for the Submitted Applications Reusable Component

Line 113: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE)

109: -- status of 'Accepted' OR the offer response status is 'Deffered' with the deferment status as 'Confirmed'. For all other
110: -- cases it will return false. -- rghosh (bug#2901627)
111: FUNCTION valid_ofr_resp_status(
112: p_person_id igs_ad_ps_appl_inst.person_id%TYPE ,
113: p_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE)
114: RETURN BOOLEAN ;
115:
116: -- 20-Jul-2005 ANWEST Created for the Submitted Applications Reusable Component
117: -- (ADTD003) in IGS.M

Line 125: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

121: )
122: RETURN VARCHAR2;
123:
124: PROCEDURE Admp_resub_inst(
125: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
126: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
127: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
128: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
129: p_do_commit VARCHAR2 DEFAULT NULL,

Line 126: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

122: RETURN VARCHAR2;
123:
124: PROCEDURE Admp_resub_inst(
125: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
126: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
127: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
128: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
129: p_do_commit VARCHAR2 DEFAULT NULL,
130: x_return_status OUT NOCOPY VARCHAR2,

Line 127: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

123:
124: PROCEDURE Admp_resub_inst(
125: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
126: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
127: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
128: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
129: p_do_commit VARCHAR2 DEFAULT NULL,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,

Line 128: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

124: PROCEDURE Admp_resub_inst(
125: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
126: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
127: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
128: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
129: p_do_commit VARCHAR2 DEFAULT NULL,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2

Line 138: (p_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,

134:
135: --Begin apadegal TD001 IGS.M
136:
137: FUNCTION check_any_offer_inst
138: (p_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
139: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
140: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE DEFAULT NULL,
141: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE DEFAULT NULL
142: )

Line 139: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

135: --Begin apadegal TD001 IGS.M
136:
137: FUNCTION check_any_offer_inst
138: (p_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
139: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
140: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE DEFAULT NULL,
141: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE DEFAULT NULL
142: )
143: RETURN BOOLEAN;

Line 140: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE DEFAULT NULL,

136:
137: FUNCTION check_any_offer_inst
138: (p_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
139: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
140: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE DEFAULT NULL,
141: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE DEFAULT NULL
142: )
143: RETURN BOOLEAN;
144:

Line 141: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE DEFAULT NULL

137: FUNCTION check_any_offer_inst
138: (p_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
139: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
140: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE DEFAULT NULL,
141: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE DEFAULT NULL
142: )
143: RETURN BOOLEAN;
144:
145: FUNCTION Is_App_Inst_Complete (

Line 153: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

149: p_sequence_number IN NUMBER
150: )
151: RETURN VARCHAR2;
152:
153: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
154: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
155: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
156: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
157: p_success out nocopy VARCHAR2,

Line 154: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

150: )
151: RETURN VARCHAR2;
152:
153: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
154: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
155: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
156: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
157: p_success out nocopy VARCHAR2,
158: p_message_name out nocopy VARCHAR2

Line 155: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

151: RETURN VARCHAR2;
152:
153: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
154: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
155: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
156: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
157: p_success out nocopy VARCHAR2,
158: p_message_name out nocopy VARCHAR2
159: );

Line 156: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

152:
153: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
154: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
155: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
156: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
157: p_success out nocopy VARCHAR2,
158: p_message_name out nocopy VARCHAR2
159: );
160: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

Line 160: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

156: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
157: p_success out nocopy VARCHAR2,
158: p_message_name out nocopy VARCHAR2
159: );
160: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
161: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
162: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
163: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
164: )

Line 161: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

157: p_success out nocopy VARCHAR2,
158: p_message_name out nocopy VARCHAR2
159: );
160: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
161: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
162: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
163: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
164: )
165: RETURN VARCHAR2;

Line 162: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

158: p_message_name out nocopy VARCHAR2
159: );
160: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
161: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
162: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
163: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
164: )
165: RETURN VARCHAR2;
166:

Line 163: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE

159: );
160: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
161: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
162: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
163: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
164: )
165: RETURN VARCHAR2;
166:
167:

Line 169: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

165: RETURN VARCHAR2;
166:
167:
168: PROCEDURE Reconsider_Appl_Inst (
169: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
170: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
171: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
172: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
173: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)

Line 170: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

166:
167:
168: PROCEDURE Reconsider_Appl_Inst (
169: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
170: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
171: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
172: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
173: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
174: ) ;

Line 171: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

167:
168: PROCEDURE Reconsider_Appl_Inst (
169: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
170: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
171: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
172: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
173: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
174: ) ;
175:

Line 172: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

168: PROCEDURE Reconsider_Appl_Inst (
169: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
170: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
171: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
172: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
173: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
174: ) ;
175:
176:

Line 178: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

174: ) ;
175:
176:
177: PROCEDURE Recon_Appl_inst (
178: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
179: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
180: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
181: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
182: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)

Line 179: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

175:
176:
177: PROCEDURE Recon_Appl_inst (
178: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
179: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
180: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
181: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
182: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
183: ); --- this procedure would be invoked from

Line 180: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

176:
177: PROCEDURE Recon_Appl_inst (
178: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
179: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
180: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
181: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
182: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
183: ); --- this procedure would be invoked from
184:

Line 181: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,

177: PROCEDURE Recon_Appl_inst (
178: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
179: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
180: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
181: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
182: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
183: ); --- this procedure would be invoked from
184:
185: FUNCTION check_adm_appl_inst_stat( -- An overloaded function - would be invoked in Self Service

Line 186: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

182: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
183: ); --- this procedure would be invoked from
184:
185: FUNCTION check_adm_appl_inst_stat( -- An overloaded function - would be invoked in Self Service
186: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
187: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
188: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
189: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
190: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.

Line 187: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

183: ); --- this procedure would be invoked from
184:
185: FUNCTION check_adm_appl_inst_stat( -- An overloaded function - would be invoked in Self Service
186: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
187: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
188: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
189: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
190: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
191: )

Line 188: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,

184:
185: FUNCTION check_adm_appl_inst_stat( -- An overloaded function - would be invoked in Self Service
186: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
187: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
188: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
189: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
190: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
191: )
192: RETURN VARCHAR2;

Line 189: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,

185: FUNCTION check_adm_appl_inst_stat( -- An overloaded function - would be invoked in Self Service
186: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
187: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
188: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
189: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
190: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
191: )
192: RETURN VARCHAR2;
193:

Line 195: PROCEDURE ins_dummy_pend_hist_rec ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

191: )
192: RETURN VARCHAR2;
193:
194:
195: PROCEDURE ins_dummy_pend_hist_rec ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
196: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
197: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
198: ) ;
199:

Line 196: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

192: RETURN VARCHAR2;
193:
194:
195: PROCEDURE ins_dummy_pend_hist_rec ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
196: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
197: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
198: ) ;
199:
200: --End apadegal TD001 IGS.m

Line 197: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE

193:
194:
195: PROCEDURE ins_dummy_pend_hist_rec ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
196: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
197: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
198: ) ;
199:
200: --End apadegal TD001 IGS.m
201: