DBA Data[Home] [Help]

APPS.IGS_AS_ANON_GRD_PKG dependencies on HZ_PARTIES

Line 179: p_person_id IN hz_parties.party_id%TYPE,

175: END chk_anon_graded;
176:
177: PROCEDURE sub_get_insert(
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,

Line 630: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE)

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.
630: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE)
631: IS
632: SELECT party_number
633: FROM hz_parties
634: WHERE party_id = cp_person_id;

Line 633: FROM hz_parties

629: -- To get the Person Number of the Person processed.
630: CURSOR c_person(cp_person_id hz_parties.party_id%TYPE)
631: IS
632: SELECT party_number
633: FROM hz_parties
634: WHERE party_id = cp_person_id;
635:
636: c_method_rec c_method%ROWTYPE;
637: c_reallocate_rec c_reallocate%ROWTYPE;

Line 969: p_person_id IN hz_parties.party_id%TYPE,

965: END mnt_anon_id;
966:
967:
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,

Line 1322: p_person_id IN hz_parties.party_id%TYPE,

1318:
1319: FUNCTION user_anon_id (
1320: p_anonymous_number IN varchar2,
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,