APPS.IGS_PS_GOVT_DSCP_PKG dependencies on IGS_PS_GOVT_DSCP

Line 1: package body IGS_PS_GOVT_DSCP_PKG as

1: package body IGS_PS_GOVT_DSCP_PKG as
2: /* $Header: IGSPI59B.pls 115.3 2002/11/29 02:32:30 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_GOVT_DSCP%RowType;
5: new_references IGS_PS_GOVT_DSCP%RowType;

Line 4: old_references IGS_PS_GOVT_DSCP%RowType;

1: package body IGS_PS_GOVT_DSCP_PKG as
2: /* $Header: IGSPI59B.pls 115.3 2002/11/29 02:32:30 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_GOVT_DSCP%RowType;
5: new_references IGS_PS_GOVT_DSCP%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PS_GOVT_DSCP%RowType;

1: package body IGS_PS_GOVT_DSCP_PKG as
2: /* $Header: IGSPI59B.pls 115.3 2002/11/29 02:32:30 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_GOVT_DSCP%RowType;
5: new_references IGS_PS_GOVT_DSCP%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 22: FROM IGS_PS_GOVT_DSCP

18: ) AS
19:
20: CURSOR cur_old_ref_values IS
21: SELECT *
22: FROM IGS_PS_GOVT_DSCP
23: WHERE rowid = x_rowid;
24:
25: BEGIN
26:

Line 118: IGS_PS_DSCP_PKG.GET_FK_IGS_PS_GOVT_DSCP (

114:
115: PROCEDURE Check_Child_Existance AS
116: BEGIN
117:
118: IGS_PS_DSCP_PKG.GET_FK_IGS_PS_GOVT_DSCP (
119: old_references.govt_discipline_group_cd
120: );
121:
122: IGS_FI_GV_DSP_HEC_CN_PKG.GET_FK_IGS_PS_GOVT_DSCP (

Line 122: IGS_FI_GV_DSP_HEC_CN_PKG.GET_FK_IGS_PS_GOVT_DSCP (

118: IGS_PS_DSCP_PKG.GET_FK_IGS_PS_GOVT_DSCP (
119: old_references.govt_discipline_group_cd
120: );
121:
122: IGS_FI_GV_DSP_HEC_CN_PKG.GET_FK_IGS_PS_GOVT_DSCP (
123: old_references.govt_discipline_group_cd
124: );
125:
126: END Check_Child_Existance;

Line 134: FROM IGS_PS_GOVT_DSCP

130: ) RETURN BOOLEAN AS
131:
132: CURSOR cur_rowid IS
133: SELECT rowid
134: FROM IGS_PS_GOVT_DSCP
135: WHERE govt_discipline_group_cd = x_govt_discipline_group_cd
136: FOR UPDATE NOWAIT;
137:
138: lv_rowid cur_rowid%RowType;

Line 234: cursor C is select ROWID from IGS_PS_GOVT_DSCP

230: X_DESCRIPTION in VARCHAR2,
231: X_CLOSED_IND in VARCHAR2,
232: X_MODE in VARCHAR2 default 'R'
233: ) as
234: cursor C is select ROWID from IGS_PS_GOVT_DSCP
235: where GOVT_DISCIPLINE_GROUP_CD = X_GOVT_DISCIPLINE_GROUP_CD;
236: X_LAST_UPDATE_DATE DATE;
237: X_LAST_UPDATED_BY NUMBER;
238: X_LAST_UPDATE_LOGIN NUMBER;

Line 270: insert into IGS_PS_GOVT_DSCP (

266: x_last_update_date => X_LAST_UPDATE_DATE,
267: x_last_updated_by => X_LAST_UPDATED_BY,
268: x_last_update_login => X_LAST_UPDATE_LOGIN
269: );
270: insert into IGS_PS_GOVT_DSCP (
271: GOVT_DISCIPLINE_GROUP_CD,
272: DESCRIPTION,
273: CLOSED_IND,
274: CREATION_DATE,

Line 312: from IGS_PS_GOVT_DSCP

308: ) as
309: cursor c1 is select
310: DESCRIPTION,
311: CLOSED_IND
312: from IGS_PS_GOVT_DSCP
313: where ROWID = X_ROWID for update nowait;
314: tlinfo c1%rowtype;
315:
316: begin

Line 381: update IGS_PS_GOVT_DSCP set

377: x_last_update_date => X_LAST_UPDATE_DATE,
378: x_last_updated_by => X_LAST_UPDATED_BY,
379: x_last_update_login => X_LAST_UPDATE_LOGIN
380: );
381: update IGS_PS_GOVT_DSCP set
382: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
383: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
384: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
385: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 405: cursor c1 is select rowid from IGS_PS_GOVT_DSCP

401: X_DESCRIPTION in VARCHAR2,
402: X_CLOSED_IND in VARCHAR2,
403: X_MODE in VARCHAR2 default 'R'
404: ) as
405: cursor c1 is select rowid from IGS_PS_GOVT_DSCP
406: where GOVT_DISCIPLINE_GROUP_CD = X_GOVT_DISCIPLINE_GROUP_CD
407: ;
408: begin
409: open c1;

Line 437: delete from IGS_PS_GOVT_DSCP

433: begin
434: Before_DML( p_action => 'DELETE',
435: x_rowid => X_ROWID
436: );
437: delete from IGS_PS_GOVT_DSCP
438: where ROWID = X_ROWID;
439: if (sql%notfound) then
440: raise no_data_found;
441: end if;

Line 448: end IGS_PS_GOVT_DSCP_PKG;

444: x_rowid => X_ROWID
445: );
446: end DELETE_ROW;
447:
448: end IGS_PS_GOVT_DSCP_PKG;