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_EN_WLST_GEN_PROC dependencies on IGS_CA_INST

Line 109: p_alternate_code OUT NOCOPY igs_ca_inst.alternate_code%TYPE ,

105: PROCEDURE getuoodetail ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
106: p_unit_cd OUT NOCOPY igs_ps_unit_ver.unit_cd%TYPE ,
107: p_unit_title OUT NOCOPY igs_ps_unit_ver.title%TYPE ,
108: p_cal_type OUT NOCOPY igs_ps_unit_ofr_opt.cal_type%TYPE ,
109: p_alternate_code OUT NOCOPY igs_ca_inst.alternate_code%TYPE ,
110: p_location_desc OUT NOCOPY igs_ad_location.description%TYPE ,
111: p_unit_class OUT NOCOPY igs_ps_unit_ofr_opt.unit_class%TYPE ,
112: p_message OUT NOCOPY VARCHAR2
113: ) IS

Line 136: igs_ca_inst ci

132: uoo.unit_class
133: FROM igs_ps_unit_ofr_opt uoo ,
134: igs_ad_location al ,
135: igs_ps_unit_ver uv ,
136: igs_ca_inst ci
137: WHERE uoo.unit_cd = uv.unit_cd
138: AND uoo.version_number = uv.version_number
139: AND uoo.cal_type = ci.cal_type
140: AND uoo.ci_sequence_number = ci.sequence_number

Line 179: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

175: P_program_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
176: p_org_id IN NUMBER,
177: p_old_key_program IN igs_en_stdnt_ps_att.course_cd%TYPE,
178: p_old_prim_program IN igs_en_stdnt_ps_att.course_cd%TYPE,
179: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
180: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE
181: )
182: ------------------------------------------------------------------
183: --Created by : svenkata, Oracle IDC

Line 180: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE

176: p_org_id IN NUMBER,
177: p_old_key_program IN igs_en_stdnt_ps_att.course_cd%TYPE,
178: p_old_prim_program IN igs_en_stdnt_ps_att.course_cd%TYPE,
179: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
180: p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE
181: )
182: ------------------------------------------------------------------
183: --Created by : svenkata, Oracle IDC
184: --Date created: 17-Jan-2002

Line 1114: CURSOR cur_teach_to_load ( cp_teach_cal_type igs_ca_inst.cal_type%TYPE ,

1110:
1111: l_org_unit_cd igs_ps_unit_ofr_opt.owner_org_unit_cd%TYPE;
1112:
1113: -- Cursor to get the load calender type associated with a teaching calender instance
1114: CURSOR cur_teach_to_load ( cp_teach_cal_type igs_ca_inst.cal_type%TYPE ,
1115: cp_teach_seq_no igs_ca_inst.sequence_number%TYPE)
1116: IS
1117: SELECT load_cal_type
1118: FROM igs_ca_teach_to_load_v

Line 1115: cp_teach_seq_no igs_ca_inst.sequence_number%TYPE)

1111: l_org_unit_cd igs_ps_unit_ofr_opt.owner_org_unit_cd%TYPE;
1112:
1113: -- Cursor to get the load calender type associated with a teaching calender instance
1114: CURSOR cur_teach_to_load ( cp_teach_cal_type igs_ca_inst.cal_type%TYPE ,
1115: cp_teach_seq_no igs_ca_inst.sequence_number%TYPE)
1116: IS
1117: SELECT load_cal_type
1118: FROM igs_ca_teach_to_load_v
1119: WHERE teach_cal_type = cp_teach_cal_type

Line 1123: l_load_cal_type igs_ca_inst.cal_type%TYPE;

1119: WHERE teach_cal_type = cp_teach_cal_type
1120: AND teach_ci_sequence_number = cp_teach_seq_no
1121: ORDER BY load_start_dt;
1122:
1123: l_load_cal_type igs_ca_inst.cal_type%TYPE;
1124:
1125: -- Cursor to select priorities at organizational unit level
1126: CURSOR cur_wlst_org_pri ( cp_org_unit_cd igs_en_or_unit_wlst.org_unit_cd%TYPE ,
1127: cp_cal_type igs_en_or_unit_wlst.cal_type%TYPE )

Line 1221: l_teach_cal_type igs_ca_inst.cal_type%TYPE;

1217: l_pref_weight NUMBER;
1218: l_wlst_level VARCHAR2(10);
1219: l_pref_satisfied BOOLEAN;
1220: l_pri_satisfied VARCHAR2(1);
1221: l_teach_cal_type igs_ca_inst.cal_type%TYPE;
1222: l_teach_seq_no igs_ca_inst.sequence_number%TYPE;
1223: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;
1224:
1225: BEGIN

Line 1222: l_teach_seq_no igs_ca_inst.sequence_number%TYPE;

1218: l_wlst_level VARCHAR2(10);
1219: l_pref_satisfied BOOLEAN;
1220: l_pri_satisfied VARCHAR2(1);
1221: l_teach_cal_type igs_ca_inst.cal_type%TYPE;
1222: l_teach_seq_no igs_ca_inst.sequence_number%TYPE;
1223: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;
1224:
1225: BEGIN
1226: l_pref_order := 0;

Line 1637: CURSOR c_cal_desc (pc_cal_type igs_ca_inst.cal_type%TYPE, pc_seq_num igs_ca_inst.sequence_number%TYPE) IS

1633: FROM hz_parties
1634: WHERE party_id = cp_person_id;
1635:
1636: -- cursor to get the calendar description
1637: CURSOR c_cal_desc (pc_cal_type igs_ca_inst.cal_type%TYPE, pc_seq_num igs_ca_inst.sequence_number%TYPE) IS
1638: SELECT description
1639: FROM igs_ca_inst
1640: WHERE cal_type=pc_cal_type
1641: AND sequence_number=pc_seq_num;

Line 1639: FROM igs_ca_inst

1635:
1636: -- cursor to get the calendar description
1637: CURSOR c_cal_desc (pc_cal_type igs_ca_inst.cal_type%TYPE, pc_seq_num igs_ca_inst.sequence_number%TYPE) IS
1638: SELECT description
1639: FROM igs_ca_inst
1640: WHERE cal_type=pc_cal_type
1641: AND sequence_number=pc_seq_num;
1642:
1643: l_party_id hz_parties.party_id%TYPE;

Line 1644: l_cal_type igs_ca_inst.cal_type%TYPE;

1640: WHERE cal_type=pc_cal_type
1641: AND sequence_number=pc_seq_num;
1642:
1643: l_party_id hz_parties.party_id%TYPE;
1644: l_cal_type igs_ca_inst.cal_type%TYPE;
1645: l_seq_num igs_ca_inst.sequence_number%TYPE;
1646: l_party_number hz_parties.party_number%TYPE;
1647: l_description igs_ca_inst.description%TYPE;
1648:

Line 1645: l_seq_num igs_ca_inst.sequence_number%TYPE;

1641: AND sequence_number=pc_seq_num;
1642:
1643: l_party_id hz_parties.party_id%TYPE;
1644: l_cal_type igs_ca_inst.cal_type%TYPE;
1645: l_seq_num igs_ca_inst.sequence_number%TYPE;
1646: l_party_number hz_parties.party_number%TYPE;
1647: l_description igs_ca_inst.description%TYPE;
1648:
1649: BEGIN

Line 1647: l_description igs_ca_inst.description%TYPE;

1643: l_party_id hz_parties.party_id%TYPE;
1644: l_cal_type igs_ca_inst.cal_type%TYPE;
1645: l_seq_num igs_ca_inst.sequence_number%TYPE;
1646: l_party_number hz_parties.party_number%TYPE;
1647: l_description igs_ca_inst.description%TYPE;
1648:
1649: BEGIN
1650:
1651: