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

Line 182: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,

178: p_method IN igs_as_anon_method.method%TYPE,
179: p_person_id IN hz_parties.party_id%TYPE,
180: p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE,
181: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
182: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
183: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
184: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
185: p_assessment_type IN igs_as_assessmnt_typ.assessment_type%TYPE,
186: p_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,

Line 183: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

179: p_person_id IN hz_parties.party_id%TYPE,
180: p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE,
181: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
182: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
183: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
184: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
185: p_assessment_type IN igs_as_assessmnt_typ.assessment_type%TYPE,
186: p_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
187: p_load_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE )

Line 186: p_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,

182: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
183: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
184: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
185: p_assessment_type IN igs_as_assessmnt_typ.assessment_type%TYPE,
186: p_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
187: p_load_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE )
188: IS
189: /*
190: || Created By : [email protected]

Line 187: p_load_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE )

183: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
184: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
185: p_assessment_type IN igs_as_assessmnt_typ.assessment_type%TYPE,
186: p_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
187: p_load_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE )
188: IS
189: /*
190: || Created By : [email protected]
191: || Created On : 28-JAN-2002

Line 349: l_ld_cal_type igs_ca_inst_all.cal_type%TYPE;

345: temp_table t_temp_table;
346:
347: l_random_number binary_integer;
348: l_index binary_integer;
349: l_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
350: l_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
351: l_anon_id_count NUMBER;
352: l_anon_id_required NUMBER;
353: l_rowid ROWID;

Line 350: l_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;

346:
347: l_random_number binary_integer;
348: l_index binary_integer;
349: l_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
350: l_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
351: l_anon_id_count NUMBER;
352: l_anon_id_required NUMBER;
353: l_rowid ROWID;
354: l_method igs_as_anon_method.method%TYPE;

Line 625: FROM igs_ca_inst

621: CURSOR c_cal(cp_load_cal_type igs_as_anon_number.load_cal_type%TYPE,
622: cp_load_ci_sequence_number igs_as_anon_number.load_ci_sequence_number%TYPE)
623: IS
624: SELECT alternate_code,start_dt, end_dt
625: FROM igs_ca_inst
626: WHERE cal_type = cp_load_cal_type
627: AND sequence_number = cp_load_ci_sequence_number;
628:
629: -- To get the Person Number of the Person processed.

Line 972: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,

968: FUNCTION get_anon_id (
969: p_person_id IN hz_parties.party_id%TYPE,
970: p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE,
971: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
972: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
973: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
974: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
975: p_ass_id IN igs_as_assessmnt_itm_all.ass_id%TYPE,
976: p_unit_grading_ind IN VARCHAR2

Line 973: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

969: p_person_id IN hz_parties.party_id%TYPE,
970: p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE,
971: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
972: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
973: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
974: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
975: p_ass_id IN igs_as_assessmnt_itm_all.ass_id%TYPE,
976: p_unit_grading_ind IN VARCHAR2
977: ) RETURN VARCHAR2 IS

Line 1187: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1183:
1184:
1185: FUNCTION get_person_id (
1186: p_anonymous_id IN igs_as_anon_id_ps.anonymous_id%TYPE,
1187: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1188: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1189: ) RETURN NUMBER IS
1190:
1191: /*

Line 1188: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

1184:
1185: FUNCTION get_person_id (
1186: p_anonymous_id IN igs_as_anon_id_ps.anonymous_id%TYPE,
1187: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1188: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1189: ) RETURN NUMBER IS
1190:
1191: /*
1192: || Created By : pkpatel

Line 1325: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1321: p_method IN igs_as_anon_method.METHOD%TYPE,
1322: p_person_id IN hz_parties.party_id%TYPE,
1323: p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE,
1324: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
1325: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1326: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1327: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1328: p_assessment_type IN igs_as_assessmnt_typ.assessment_type%TYPE,
1329: p_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,

Line 1326: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

1322: p_person_id IN hz_parties.party_id%TYPE,
1323: p_course_cd IN igs_en_su_attempt_all.course_cd%TYPE,
1324: p_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
1325: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1326: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1327: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1328: p_assessment_type IN igs_as_assessmnt_typ.assessment_type%TYPE,
1329: p_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1330: p_load_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

Line 1329: p_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1325: p_teach_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1326: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1327: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1328: p_assessment_type IN igs_as_assessmnt_typ.assessment_type%TYPE,
1329: p_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1330: p_load_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1331: ) RETURN VARCHAR2 IS
1332: /*
1333: || Created By : pkpatel

Line 1330: p_load_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

1326: p_teach_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1327: p_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1328: p_assessment_type IN igs_as_assessmnt_typ.assessment_type%TYPE,
1329: p_load_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1330: p_load_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
1331: ) RETURN VARCHAR2 IS
1332: /*
1333: || Created By : pkpatel
1334: || Created On : 28-JAN-2002