DBA Data[Home] [Help]

APPS.IGS_HE_MRK_PROG_ATT_PKG dependencies on IGS_HE_EX_RN_DAT_LN

Line 6: PROCEDURE update_data(errbuf OUT NOCOPY varchar2, retcode OUT NOCOPY number,l_extract_run_id igs_he_ex_rn_dat_ln.extract_run_id%type, l_submission_name igs_he_submsn_header.submission_name%type,

2: /* $Header: IGSHE06B.pls 120.1 2006/02/08 19:49:27 anwest noship $ */
3:
4:
5:
6: PROCEDURE update_data(errbuf OUT NOCOPY varchar2, retcode OUT NOCOPY number,l_extract_run_id igs_he_ex_rn_dat_ln.extract_run_id%type, l_submission_name igs_he_submsn_header.submission_name%type,
7: l_return_name igs_he_submsn_return.return_name%type ) IS
8:
9: /*************************************************************
10: Created By : sowsubra

Line 22: FROM igs_he_ex_rn_dat_ln WHERE

18: ***************************************************************/
19:
20: CURSOR get_person_course_stud_details IS
21: SELECT person_id, course_cd , student_inst_number
22: FROM igs_he_ex_rn_dat_ln WHERE
23: extract_run_id = l_extract_run_id;
24: get_details_rec get_person_course_stud_details%ROWTYPE;
25:
26: BEGIN