APPS.IGS_HE_UV_PKG dependencies on IGS_HE_ST_UNT_VS

Line 10: | of location_cd to igs_he_st_unt_vs_all |

6: | --------- ---------------- ------------------------------ |
7: | 02-Jan-02 M. S. GARCHA Created |
8: | 08-Feb-02 A Kataria Added TBH's |
9: | 09-Apr-02 sbaliga Changed code corresponding to the addition |
10: | of location_cd to igs_he_st_unt_vs_all |
11: | table as part of #2278825 |
12: | 26-Jan-05 jbaber Modified x_c2 for HE355 - Org Unit Cost |
13: | Centre Link |
14: | 24-Nov-05 jbaber Added exclude_flag to x_c1 for HE305 |

Line 30: l_location_cd igs_he_st_unt_vs.location_cd%TYPE;

26:
27: x_err_msg VARCHAR2(240);
28: x_seq_id NUMBER := '';
29: x_org_id NUMBER(15);
30: l_location_cd igs_he_st_unt_vs.location_cd%TYPE;
31:
32: CURSOR x_c1 IS
33: SELECT rowid
34: ,prop_of_teaching_in_welsh

Line 40: FROM igs_he_st_unt_vs

36: ,module_length
37: ,proportion_of_fte
38: ,location_cd
39: ,exclude_flag
40: FROM igs_he_st_unt_vs
41: WHERE unit_cd = p_c_old_unit_cd
42: AND version_number = p_n_old_version_number
43: AND NOT EXISTS (
44: SELECT 'x'

Line 45: FROM igs_he_st_unt_vs

41: WHERE unit_cd = p_c_old_unit_cd
42: AND version_number = p_n_old_version_number
43: AND NOT EXISTS (
44: SELECT 'x'
45: FROM igs_he_st_unt_vs
46: WHERE unit_cd = p_c_new_unit_cd
47: AND version_number = p_n_new_version_number
48: );
49:

Line 90: -- p_c_message := 'WILL NOW INSERT INTO IGS_HE_ST_UNT_VS_ALL';

86: ELSE
87: l_location_cd:= NULL;
88: END IF;
89:
90: -- p_c_message := 'WILL NOW INSERT INTO IGS_HE_ST_UNT_VS_ALL';
91: -- IGSWI24B.pls
92: IGS_HE_ST_UNT_VS_ALL_PKG.Insert_Row(
93: X_ROWID => x_c1_rec.rowid,
94: X_HESA_ST_UNT_VS_ID => x_seq_id,--Sequence generated in handler!!

Line 92: IGS_HE_ST_UNT_VS_ALL_PKG.Insert_Row(

88: END IF;
89:
90: -- p_c_message := 'WILL NOW INSERT INTO IGS_HE_ST_UNT_VS_ALL';
91: -- IGSWI24B.pls
92: IGS_HE_ST_UNT_VS_ALL_PKG.Insert_Row(
93: X_ROWID => x_c1_rec.rowid,
94: X_HESA_ST_UNT_VS_ID => x_seq_id,--Sequence generated in handler!!
95: X_ORG_ID => x_org_id,
96: X_UNIT_CD => p_c_new_unit_cd,