APPS.IGS_HE_PS_PKG dependencies on IGS_HE_ST_PROG

Line 8: -- IGS_HE_ST_PROG_ALL and IGS_HE_POOUS_ALL tables

4: -----------------------------------------------------------------------------
5: -- Change History
6: -- Who When What
7: --sbaliga 8-Apr-02 Modified package to reflect datamodel changes in
8: -- IGS_HE_ST_PROG_ALL and IGS_HE_POOUS_ALL tables
9: -- as part of #2278825.
10: -- rshergil 03-Jan-02 Created Package to rollover Program
11: -- Version information relating to
12: -- 1.UK Statistics - Program details

Line 36: FROM igs_he_st_prog_all

32:
33:
34: CURSOR gc_hsp_old_rec IS
35: SELECT *
36: FROM igs_he_st_prog_all
37: WHERE course_cd = p_old_course_cd
38: AND version_number = p_old_version_number;
39: gv_hsp_old_rec gc_hsp_old_rec%ROWTYPE;
40:

Line 44: FROM igs_he_st_prog_all

40:
41:
42: CURSOR gc_hsp_new_rec IS
43: SELECT hesa_st_prog_id
44: FROM igs_he_st_prog_all
45: WHERE course_cd = p_new_course_cd
46: AND version_number = p_new_version_number;
47: gv_hsp_new_rec gc_hsp_new_rec%ROWTYPE;
48:

Line 102: --Procedure inserts into IGS_HE_ST_PROG_ALL table

98: AND us_version_number = p_us_version_number
99: AND organization_unit = p_organization_unit;
100: gv_hpo_new_rec gc_hpo_new_rec%ROWTYPE;
101:
102: --Procedure inserts into IGS_HE_ST_PROG_ALL table
103:
104: PROCEDURE cr_he_st_pr_rec ( p_new_course_cd igs_he_st_prog.course_cd%TYPE,
105: p_new_version_number igs_he_st_prog.version_number%TYPE) IS
106:

Line 104: PROCEDURE cr_he_st_pr_rec ( p_new_course_cd igs_he_st_prog.course_cd%TYPE,

100: gv_hpo_new_rec gc_hpo_new_rec%ROWTYPE;
101:
102: --Procedure inserts into IGS_HE_ST_PROG_ALL table
103:
104: PROCEDURE cr_he_st_pr_rec ( p_new_course_cd igs_he_st_prog.course_cd%TYPE,
105: p_new_version_number igs_he_st_prog.version_number%TYPE) IS
106:
107: BEGIN
108:

Line 105: p_new_version_number igs_he_st_prog.version_number%TYPE) IS

101:
102: --Procedure inserts into IGS_HE_ST_PROG_ALL table
103:
104: PROCEDURE cr_he_st_pr_rec ( p_new_course_cd igs_he_st_prog.course_cd%TYPE,
105: p_new_version_number igs_he_st_prog.version_number%TYPE) IS
106:
107: BEGIN
108:
109: DECLARE

Line 110: v_hesa_seq_num igs_he_st_prog.hesa_st_prog_id%TYPE;

106:
107: BEGIN
108:
109: DECLARE
110: v_hesa_seq_num igs_he_st_prog.hesa_st_prog_id%TYPE;
111:
112: CURSOR c_hesa_seq_num IS
113: SELECT igs_he_st_prog_all_s.NEXTVAL
114: FROM dual;

Line 113: SELECT igs_he_st_prog_all_s.NEXTVAL

109: DECLARE
110: v_hesa_seq_num igs_he_st_prog.hesa_st_prog_id%TYPE;
111:
112: CURSOR c_hesa_seq_num IS
113: SELECT igs_he_st_prog_all_s.NEXTVAL
114: FROM dual;
115:
116: x_rowid VARCHAR2(250);
117: l_org_id NUMBER(15);

Line 128: igs_he_st_prog_all_pkg.insert_row(

124:
125: l_org_id := igs_ge_gen_003.get_org_id;
126: x_rowid := NULL;
127:
128: igs_he_st_prog_all_pkg.insert_row(
129: X_ROWID => x_rowid,
130: X_HESA_ST_PROG_ID => v_hesa_seq_num,
131: X_ORG_ID => l_org_id,
132: X_COURSE_CD => p_new_course_cd,

Line 550: -- This checks to see if the specified old IGS_HE_ST_PROG record exists, and if so then need to copy,

546: RETURN;
547: END IF;
548:
549:
550: -- This checks to see if the specified old IGS_HE_ST_PROG record exists, and if so then need to copy,
551: -- if does not exist in IGS_HE_ST_PROG for new course code and version then insert
552: OPEN gc_hsp_old_rec;
553: FETCH gc_hsp_old_rec into gv_hsp_old_rec;
554: IF gc_hsp_old_rec%FOUND THEN

Line 551: -- if does not exist in IGS_HE_ST_PROG for new course code and version then insert

547: END IF;
548:
549:
550: -- This checks to see if the specified old IGS_HE_ST_PROG record exists, and if so then need to copy,
551: -- if does not exist in IGS_HE_ST_PROG for new course code and version then insert
552: OPEN gc_hsp_old_rec;
553: FETCH gc_hsp_old_rec into gv_hsp_old_rec;
554: IF gc_hsp_old_rec%FOUND THEN
555: OPEN gc_hsp_new_rec;