APPS.IGS_HE_PS_PKG dependencies on IGS_HE_POOUS_ALL

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 14: -- smaddali 20-Aug-03 Modified procedure for hefd208 bug#2717751 to add funding_source column to igs_he_poous_all tbh call

10: -- rshergil 03-Jan-02 Created Package to rollover Program
11: -- Version information relating to
12: -- 1.UK Statistics - Program details
13: -- 2.Program Offering Option Unit Set HESA Details
14: -- smaddali 20-Aug-03 Modified procedure for hefd208 bug#2717751 to add funding_source column to igs_he_poous_all tbh call
15: -- ayedubat 28-Aug-03 Created a new procedure, create_prg_cc_rec to copy the Hesa
16: -- Statistic Cost Center Details for HE207 Enhancement bug, 2717753
17: -- jbaber 25-Jan-05 Modified for HE355 - Org Unit Cost Center Link
18: -- jbaber 24-Nov-05 Included exclude_flag column for HE305

Line 51: FROM igs_he_poous_all

47: gv_hsp_new_rec gc_hsp_new_rec%ROWTYPE;
48:
49: CURSOR gc_hpus_old_rec IS
50: SELECT *
51: FROM igs_he_poous_all
52: WHERE course_cd = p_old_course_cd
53: AND crv_version_number = p_old_version_number;
54: gv_hpus_old_rec gc_hpus_old_rec%ROWTYPE;
55:

Line 64: FROM igs_he_poous_all

60: p_unit_set_cd igs_he_poous.unit_set_cd%TYPE,
61: p_us_version_number igs_he_poous.us_version_number%TYPE)
62: IS
63: SELECT hesa_poous_id
64: FROM igs_he_poous_all
65: WHERE course_cd = p_new_course_cd
66: AND crv_version_number = p_new_version_number
67: AND cal_type = p_cal_type
68: AND location_cd = p_location_cd

Line 263: --Procedure inserts into IGS_HE_POOUS_ALL table

259:
260: END create_prg_cc_rec;
261:
262:
263: --Procedure inserts into IGS_HE_POOUS_ALL table
264:
265: PROCEDURE cr_he_poo_us_rec (p_new_course_cd igs_he_poous.course_cd%TYPE,
266: p_new_version_number igs_he_poous.crv_version_number%TYPE) IS
267:

Line 274: SELECT igs_he_poous_all_s.NEXTVAL

270: DECLARE
271: v_poous_seq_num IGS_HE_POOUS.hesa_poous_id%TYPE;
272:
273: CURSOR c_poous_seq_num IS
274: SELECT igs_he_poous_all_s.NEXTVAL
275: FROM dual;
276:
277: l_org_id NUMBER(15);
278: x_rowid VARCHAR2(250);

Line 289: igs_he_poous_all_pkg.insert_row(

285:
286: x_rowid := NULL;
287: l_org_id := igs_ge_gen_003.get_org_id;
288:
289: igs_he_poous_all_pkg.insert_row(
290: X_ROWID => x_rowid,
291: X_ORG_ID => l_org_id,
292: X_HESA_POOUS_ID => v_poous_seq_num,
293: X_COURSE_CD => p_new_course_cd,