APPS.IGS_PS_UNIT_INT_LVL_PKG dependencies on IGS_PS_UNT_INLV_HIST

Line 75: FROM IGS_PS_UNT_INLV_HIST

71: x_rowid VARCHAR2(25);
72: l_org_id NUMBER(15);
73: CURSOR SPUIH_CUR IS
74: SELECT Rowid
75: FROM IGS_PS_UNT_INLV_HIST
76: WHERE unit_int_course_level_cd = old_references.unit_int_course_level_cd;
77:
78: BEGIN
79: IF p_updating THEN

Line 98: IGS_PS_UNT_INLV_HIST_PKG.Insert_Row(

94: BEGIN
95:
96: l_org_id :=igs_ge_gen_003.get_org_id;
97:
98: IGS_PS_UNT_INLV_HIST_PKG.Insert_Row(
99: X_ROWID => x_rowid,
100: X_UNIT_INT_COURSE_LEVEL_CD => old_references.unit_int_course_level_cd,
101: X_HIST_START_DT => old_references.last_update_date,
102: X_HIST_END_DT => new_references.last_update_date,

Line 115: -- Delete IGS_PS_UNT_INLV_HIST records if the IGS_PS_UNIT_INT_LVL

111:
112: END IF;
113: END IF;
114: IF p_deleting THEN
115: -- Delete IGS_PS_UNT_INLV_HIST records if the IGS_PS_UNIT_INT_LVL
116: -- is deleted.
117: BEGIN
118: FOR SPUIH_Rec IN SPUIH_CUR
119: Loop

Line 120: IGS_PS_UNT_INLV_HIST_PKG.Delete_Row(X_ROWID=>SPUIH_Rec.Rowid);

116: -- is deleted.
117: BEGIN
118: FOR SPUIH_Rec IN SPUIH_CUR
119: Loop
120: IGS_PS_UNT_INLV_HIST_PKG.Delete_Row(X_ROWID=>SPUIH_Rec.Rowid);
121: End Loop;
122: END;
123: END IF;
124: