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_AS_TRNCMT_LGCY_PUB dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 247: p_uoo_id OUT NOCOPY igs_ps_unit_ofr_opt_all.uoo_id%TYPE

243: p_lgcy_trncmt_rec IN OUT NOCOPY lgcy_trncmt_rec_type,
244: p_person_id OUT NOCOPY igs_pe_person.person_id%TYPE,
245: p_load_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
246: p_load_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
247: p_uoo_id OUT NOCOPY igs_ps_unit_ofr_opt_all.uoo_id%TYPE
248: )RETURN BOOLEAN
249: /****************************************************************************
250: || Created By : anilk
251: || Created On : 22-Sep-2003

Line 271: p_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,

267: l_teach_cal_type igs_ca_inst.cal_type%TYPE;
268: l_teach_sequence_number igs_ca_inst.sequence_number%TYPE;
269:
270: CURSOR cur_uoo_id(
271: p_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
272: p_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE,
273: p_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
274: p_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
275: p_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,

Line 272: p_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE,

268: l_teach_sequence_number igs_ca_inst.sequence_number%TYPE;
269:
270: CURSOR cur_uoo_id(
271: p_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
272: p_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE,
273: p_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
274: p_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
275: p_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
276: p_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE

Line 273: p_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,

269:
270: CURSOR cur_uoo_id(
271: p_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
272: p_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE,
273: p_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
274: p_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
275: p_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
276: p_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE
277: ) IS

Line 274: p_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,

270: CURSOR cur_uoo_id(
271: p_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
272: p_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE,
273: p_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
274: p_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
275: p_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
276: p_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE
277: ) IS
278: SELECT uoo_id

Line 275: p_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,

271: p_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
272: p_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE,
273: p_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
274: p_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
275: p_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
276: p_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE
277: ) IS
278: SELECT uoo_id
279: FROM igs_ps_unit_ofr_opt_all

Line 276: p_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE

272: p_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE,
273: p_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
274: p_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
275: p_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
276: p_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE
277: ) IS
278: SELECT uoo_id
279: FROM igs_ps_unit_ofr_opt_all
280: WHERE unit_cd = p_unit_cd

Line 279: FROM igs_ps_unit_ofr_opt_all

275: p_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
276: p_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE
277: ) IS
278: SELECT uoo_id
279: FROM igs_ps_unit_ofr_opt_all
280: WHERE unit_cd = p_unit_cd
281: AND version_number = p_version_number
282: AND cal_type = p_cal_type
283: AND ci_sequence_number = p_ci_sequence_number

Line 582: l_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

578: l_comment_id igs_as_stu_trn_cmts.comment_id%TYPE;
579: l_load_cal_type igs_ca_inst.cal_type%TYPE;
580: l_load_sequence_number igs_ca_inst.sequence_number%TYPE;
581: l_person_id igs_pe_person.person_id%TYPE;
582: l_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
583:
584: l_return_value VARCHAR2(1);
585: WARN_TYPE_ERR EXCEPTION;
586: