APPS.IGS_PS_DSCP_PKG dependencies on IGS_PS_DSCP_HIST

Line 88: FROM IGS_PS_DSCP_HIST

84: x_rowid varchar2(25);
85: l_org_id NUMBER(15);
86: CURSOR SPDH_CUR IS
87: SELECT Rowid
88: FROM IGS_PS_DSCP_HIST
89: WHERE discipline_group_cd = old_references.discipline_group_cd;
90:
91: BEGIN
92: -- Validate Govt IGS_PS_DSCP group code. Also validate if the closed

Line 135: IGS_PS_DSCP_HIST_PKG.Insert_Row(

131: END IF;
132:
133:
134: BEGIN
135: IGS_PS_DSCP_HIST_PKG.Insert_Row(
136: X_ROWID => x_rowid,
137: X_DISCIPLINE_GROUP_CD => old_references.discipline_group_cd,
138: X_HIST_START_DT => old_references.last_update_date,
139: X_HIST_END_DT => new_references.last_update_date,

Line 153: -- Delete IGS_PS_DSCP_HIST records if the IGS_PS_DSCP is deleted.

149: END ;
150: END IF;
151: END IF;
152: IF p_deleting THEN
153: -- Delete IGS_PS_DSCP_HIST records if the IGS_PS_DSCP is deleted.
154: BEGIN
155:
156: FOR SPDH_Rec IN SPDH_CUR
157: Loop

Line 158: IGS_PS_DSCP_HIST_PKG.Delete_Row(X_ROWID => SPDH_Rec.Rowid);

154: BEGIN
155:
156: FOR SPDH_Rec IN SPDH_CUR
157: Loop
158: IGS_PS_DSCP_HIST_PKG.Delete_Row(X_ROWID => SPDH_Rec.Rowid);
159: End Loop;
160:
161: END;
162: