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_AD_INS_ADMPERD dependencies on IGS_AD_PRD_AD_PRC_CA

Line 164: FROM IGS_AD_PRD_AD_PRC_CA

160: CURSOR C_IGS_ADPRD_NUM_S IS
161: SELECT IGS_AD_PRD_PS_OF_OPT_SEQ_NUM_S.NEXTVAL FROM DUAL;
162: CURSOR c_apapc IS
163: SELECT s_admission_process_type
164: FROM IGS_AD_PRD_AD_PRC_CA
165: WHERE adm_cal_type = p_adm_cal_type AND
166: adm_ci_sequence_number = p_new_adm_ci_sequence_number AND
167: admission_cat = p_new_admission_cat AND
168: closed_ind = 'N'; --added the closed indicator for bug# 2380108 (rghosh)

Line 171: cp_s_adm_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%

167: admission_cat = p_new_admission_cat AND
168: closed_ind = 'N'; --added the closed indicator for bug# 2380108 (rghosh)
169: v_apapc_rec c_apapc%ROWTYPE;
170: CURSOR c_apapc_check (
171: cp_s_adm_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%
172: TYPE) IS
173: SELECT 'x'
174: FROM IGS_AD_PRD_AD_PRC_CA
175: WHERE adm_cal_type = p_adm_cal_type AND

Line 174: FROM IGS_AD_PRD_AD_PRC_CA

170: CURSOR c_apapc_check (
171: cp_s_adm_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%
172: TYPE) IS
173: SELECT 'x'
174: FROM IGS_AD_PRD_AD_PRC_CA
175: WHERE adm_cal_type = p_adm_cal_type AND
176: adm_ci_sequence_number = p_old_adm_ci_sequence_number AND
177: admission_cat = p_old_admission_cat AND
178: s_admission_process_type = cp_s_adm_process_type AND

Line 182: cp_s_adm_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%

178: s_admission_process_type = cp_s_adm_process_type AND
179: closed_ind = 'N'; --added the closed indicator for bug# 2380108 (rghosh)
180: v_apapc_check_exist VARCHAR2(1);
181: CURSOR c_aa_child (
182: cp_s_adm_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%
183: TYPE) IS
184: SELECT 'x'
185: FROM IGS_AD_APPL
186: WHERE adm_cal_type = p_adm_cal_type AND

Line 192: cp_s_adm_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%

188: admission_cat = p_new_admission_cat AND
189: s_admission_process_type = cp_s_adm_process_type;
190: v_aa_child_exist VARCHAR2(1);
191: CURSOR c_apcood_child (
192: cp_s_adm_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%
193: TYPE) IS
194: SELECT 'x'
195: FROM IGS_AD_PECRS_OFOP_DT
196: WHERE adm_cal_type = p_adm_cal_type AND

Line 203: IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS

199: s_admission_process_type = cp_s_adm_process_type;
200: v_apcood_child_exist VARCHAR2(1);
201: CURSOR c_apcoo(
202: cp_s_admission_process_type
203: IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
204: SELECT adm_cal_type,
205: adm_ci_sequence_number,
206: admission_cat,
207: s_admission_process_type,

Line 240: CURSOR Cur_IGS_AD_PRD_AD_PRC_CA (p_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,

236: cir.sup_cal_type = cop.cal_type AND
237: cir.sup_ci_sequence_number = cop.ci_sequence_number;
238: v_val_ep c_val_entry_point%ROWTYPE;
239:
240: CURSOR Cur_IGS_AD_PRD_AD_PRC_CA (p_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
241: p_new_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
242: p_new_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,
243: p_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE
244: )IS

Line 241: p_new_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,

237: cir.sup_ci_sequence_number = cop.ci_sequence_number;
238: v_val_ep c_val_entry_point%ROWTYPE;
239:
240: CURSOR Cur_IGS_AD_PRD_AD_PRC_CA (p_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
241: p_new_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
242: p_new_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,
243: p_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE
244: )IS
245: SELECT rowid, APAPC.*

Line 242: p_new_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,

238: v_val_ep c_val_entry_point%ROWTYPE;
239:
240: CURSOR Cur_IGS_AD_PRD_AD_PRC_CA (p_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
241: p_new_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
242: p_new_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,
243: p_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE
244: )IS
245: SELECT rowid, APAPC.*
246: FROM IGS_AD_PRD_AD_PRC_CA APAPC

Line 243: p_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE

239:
240: CURSOR Cur_IGS_AD_PRD_AD_PRC_CA (p_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
241: p_new_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
242: p_new_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,
243: p_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE
244: )IS
245: SELECT rowid, APAPC.*
246: FROM IGS_AD_PRD_AD_PRC_CA APAPC
247: WHERE adm_cal_type = p_adm_cal_type AND

Line 246: FROM IGS_AD_PRD_AD_PRC_CA APAPC

242: p_new_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,
243: p_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE
244: )IS
245: SELECT rowid, APAPC.*
246: FROM IGS_AD_PRD_AD_PRC_CA APAPC
247: WHERE adm_cal_type = p_adm_cal_type AND
248: adm_ci_sequence_number = p_new_adm_ci_sequence_number AND
249: admission_cat = p_new_admission_cat AND
250: s_admission_process_type = p_s_admission_process_type;

Line 320: -- Select IGS_AD_PRD_AD_PRC_CA to duplicate IGS_PS_COURSE offering

316: END;
317: END admpl_ins_insert_log;
318:
319: BEGIN
320: -- Select IGS_AD_PRD_AD_PRC_CA to duplicate IGS_PS_COURSE offering
321: -- option restrictions.
322: OPEN c_apapc;
323: LOOP
324: FETCH c_apapc INTO v_apapc_rec;

Line 345: FOR Rec_IGS_AD_PRD_AD_PRC_CA IN Cur_IGS_AD_PRD_AD_PRC_CA(p_adm_cal_type, p_new_adm_ci_sequence_number, p_new_admission_cat, v_apapc_rec.s_admission_process_type) LOOP

341: FETCH c_apcood_child INTO v_apcood_child_exist;
342: IF c_apcood_child%NOTFOUND THEN
343: CLOSE c_apcood_child;
344:
345: FOR Rec_IGS_AD_PRD_AD_PRC_CA IN Cur_IGS_AD_PRD_AD_PRC_CA(p_adm_cal_type, p_new_adm_ci_sequence_number, p_new_admission_cat, v_apapc_rec.s_admission_process_type) LOOP
346: IGS_AD_PRD_AD_PRC_CA_Pkg.Delete_Row (
347: Rec_IGS_AD_PRD_AD_PRC_CA.RowId
348: );
349: END LOOP;

Line 346: IGS_AD_PRD_AD_PRC_CA_Pkg.Delete_Row (

342: IF c_apcood_child%NOTFOUND THEN
343: CLOSE c_apcood_child;
344:
345: FOR Rec_IGS_AD_PRD_AD_PRC_CA IN Cur_IGS_AD_PRD_AD_PRC_CA(p_adm_cal_type, p_new_adm_ci_sequence_number, p_new_admission_cat, v_apapc_rec.s_admission_process_type) LOOP
346: IGS_AD_PRD_AD_PRC_CA_Pkg.Delete_Row (
347: Rec_IGS_AD_PRD_AD_PRC_CA.RowId
348: );
349: END LOOP;
350: ELSE

Line 347: Rec_IGS_AD_PRD_AD_PRC_CA.RowId

343: CLOSE c_apcood_child;
344:
345: FOR Rec_IGS_AD_PRD_AD_PRC_CA IN Cur_IGS_AD_PRD_AD_PRC_CA(p_adm_cal_type, p_new_adm_ci_sequence_number, p_new_admission_cat, v_apapc_rec.s_admission_process_type) LOOP
346: IGS_AD_PRD_AD_PRC_CA_Pkg.Delete_Row (
347: Rec_IGS_AD_PRD_AD_PRC_CA.RowId
348: );
349: END LOOP;
350: ELSE
351: CLOSE c_apcood_child;