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_PS_CAL_RSR_VAL dependencies on IGS_PS_UNIT_VER_ALL

Line 103: igs_ps_unit_ver_all uv,

99: CURSOR cur_uoo1( p_cal_type VARCHAR2,
100: p_ci_sequence_number NUMBER) IS
101: SELECT uoov.*,uoov.rowid row_id,uc.unit_mode,loc.description location_description
102: FROM igs_ps_unit_ofr_opt_all uoov,igs_as_unit_class_all uc, igs_ad_location_all loc,
103: igs_ps_unit_ver_all uv,
104: igs_ps_unit_stat st
105: WHERE uoov.cal_type = p_cal_type AND
106: uoov.ci_sequence_number = p_ci_sequence_number AND
107: (uoov.owner_org_unit_cd = p_org_unit_cd OR p_org_unit_cd IS NULL) AND

Line 270: PROCEDURE update_unit_version ( p_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE ,

266: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
267:
268: END del_reserved_seating;
269:
270: PROCEDURE update_unit_version ( p_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE ,
271: p_version_number igs_ps_unit_ver_all.version_number%TYPE ,
272: p_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ,
273: p_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE,
274: p_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE,

Line 271: p_version_number igs_ps_unit_ver_all.version_number%TYPE ,

267:
268: END del_reserved_seating;
269:
270: PROCEDURE update_unit_version ( p_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE ,
271: p_version_number igs_ps_unit_ver_all.version_number%TYPE ,
272: p_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ,
273: p_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE,
274: p_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE,
275: p_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE

Line 272: p_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ,

268: END del_reserved_seating;
269:
270: PROCEDURE update_unit_version ( p_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE ,
271: p_version_number igs_ps_unit_ver_all.version_number%TYPE ,
272: p_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ,
273: p_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE,
274: p_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE,
275: p_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE
276: ) IS

Line 273: p_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE,

269:
270: PROCEDURE update_unit_version ( p_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE ,
271: p_version_number igs_ps_unit_ver_all.version_number%TYPE ,
272: p_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ,
273: p_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE,
274: p_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE,
275: p_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE
276: ) IS
277: ------------------------------------------------------------------

Line 274: p_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE,

270: PROCEDURE update_unit_version ( p_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE ,
271: p_version_number igs_ps_unit_ver_all.version_number%TYPE ,
272: p_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ,
273: p_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE,
274: p_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE,
275: p_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE
276: ) IS
277: ------------------------------------------------------------------
278: --Created by : sarakshi, Oracle IDC

Line 275: p_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE

271: p_version_number igs_ps_unit_ver_all.version_number%TYPE ,
272: p_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ,
273: p_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE,
274: p_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE,
275: p_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE
276: ) IS
277: ------------------------------------------------------------------
278: --Created by : sarakshi, Oracle IDC
279: --Date created: 25-Nov-2003

Line 460: FROM igs_ps_unit_ofr_pat uop , igs_ca_load_to_teach_v lteach ,igs_ps_unit_ver_all uv, igs_ps_unit_stat us

456: CURSOR cur_units( p_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,
457: p_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE ) IS
458: SELECT DISTINCT uop.unit_cd,
459: uop.version_number
460: FROM igs_ps_unit_ofr_pat uop , igs_ca_load_to_teach_v lteach ,igs_ps_unit_ver_all uv, igs_ps_unit_stat us
461: WHERE lteach.load_cal_type = p_input_load_cal_type AND
462: lteach.load_ci_sequence_number = p_input_load_sequence_number AND
463: uop.cal_type = lteach.teach_cal_type AND
464: uop.ci_sequence_number = lteach.teach_ci_sequence_number AND

Line 536: l_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ;

532: uv.sequence_num_offer_load_cal = ci.sequence_number;
533: cur_unit_ver_offer_rec cur_unit_ver_offer%ROWTYPE;
534:
535:
536: l_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ;
537: l_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;
538: l_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;
539: l_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;
540:

Line 537: l_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;

533: cur_unit_ver_offer_rec cur_unit_ver_offer%ROWTYPE;
534:
535:
536: l_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ;
537: l_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;
538: l_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;
539: l_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;
540:
541:

Line 538: l_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;

534:
535:
536: l_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ;
537: l_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;
538: l_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;
539: l_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;
540:
541:
542: BEGIN

Line 539: l_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;

535:
536: l_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ;
537: l_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;
538: l_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;
539: l_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;
540:
541:
542: BEGIN
543: