APPS.IGS_AS_SASSESS_TYPE_PKG dependencies on IGS_AS_SASSESS_TYPE

Line 1: package body IGS_AS_SASSESS_TYPE_PKG as

1: package body IGS_AS_SASSESS_TYPE_PKG as
2: /* $Header: IGSDI49B.pls 115.7 2003/10/30 13:28:18 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SASSESS_TYPE%RowType;

Line 5: old_references IGS_AS_SASSESS_TYPE%RowType;

1: package body IGS_AS_SASSESS_TYPE_PKG as
2: /* $Header: IGSDI49B.pls 115.7 2003/10/30 13:28:18 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SASSESS_TYPE%RowType;
6: new_references IGS_AS_SASSESS_TYPE%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 6: new_references IGS_AS_SASSESS_TYPE%RowType;

2: /* $Header: IGSDI49B.pls 115.7 2003/10/30 13:28:18 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SASSESS_TYPE%RowType;
6: new_references IGS_AS_SASSESS_TYPE%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
10: x_s_assessment_type IN VARCHAR2 DEFAULT NULL,

Line 22: FROM IGS_AS_SASSESS_TYPE

18: x_last_update_login IN NUMBER DEFAULT NULL
19: ) as
20: CURSOR cur_old_ref_values IS
21: SELECT *
22: FROM IGS_AS_SASSESS_TYPE
23: WHERE rowid = x_rowid;
24: BEGIN
25: l_rowid := x_rowid;
26: -- Code for setting the Old and New Reference Values.

Line 118: IGS_AS_ASSESSMNT_TYP_PKG.GET_FK_IGS_AS_SASSESS_TYPE (

114:
115:
116: PROCEDURE Check_Child_Existance as
117: BEGIN
118: IGS_AS_ASSESSMNT_TYP_PKG.GET_FK_IGS_AS_SASSESS_TYPE (
119: old_references.s_assessment_type
120: );
121: END Check_Child_Existance;
122: FUNCTION Get_PK_For_Validation (

Line 127: FROM IGS_AS_SASSESS_TYPE

123: x_s_assessment_type IN VARCHAR2
124: ) RETURN BOOLEAN AS
125: CURSOR cur_rowid IS
126: SELECT rowid
127: FROM IGS_AS_SASSESS_TYPE
128: WHERE s_assessment_type = x_s_assessment_type
129: FOR UPDATE NOWAIT;
130: lv_rowid cur_rowid%RowType;
131: BEGIN

Line 147: FROM IGS_AS_SASSESS_TYPE

143: x_location_cd IN VARCHAR2
144: ) as
145: CURSOR cur_rowid IS
146: SELECT rowid
147: FROM IGS_AS_SASSESS_TYPE
148: WHERE non_cntrl_exam_loc_cd = x_location_cd ;
149: lv_rowid cur_rowid%RowType;
150: BEGIN
151: Open cur_rowid;

Line 234: cursor C is select ROWID from IGS_AS_SASSESS_TYPE

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

Line 271: insert into IGS_AS_SASSESS_TYPE (

267: x_last_update_date=>X_LAST_UPDATE_DATE,
268: x_last_updated_by=>X_LAST_UPDATED_BY,
269: x_last_update_login=>X_LAST_UPDATE_LOGIN
270: );
271: insert into IGS_AS_SASSESS_TYPE (
272: S_ASSESSMENT_TYPE,
273: DESCRIPTION,
274: CLOSED_IND,
275: NON_CNTRL_EXAM_LOC_CD,

Line 311: from IGS_AS_SASSESS_TYPE

307: cursor c1 is select
308: DESCRIPTION,
309: CLOSED_IND,
310: NON_CNTRL_EXAM_LOC_CD
311: from IGS_AS_SASSESS_TYPE
312: where ROWID = X_ROWID for update nowait;
313: tlinfo c1%rowtype;
314: begin
315: open c1;

Line 384: update IGS_AS_SASSESS_TYPE set

380: x_last_update_date=>X_LAST_UPDATE_DATE,
381: x_last_updated_by=>X_LAST_UPDATED_BY,
382: x_last_update_login=>X_LAST_UPDATE_LOGIN
383: );
384: update IGS_AS_SASSESS_TYPE set
385: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
386: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
387: NON_CNTRL_EXAM_LOC_CD = NEW_REFERENCES.NON_CNTRL_EXAM_LOC_CD,
388: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 404: cursor c1 is select rowid from IGS_AS_SASSESS_TYPE

400: X_CLOSED_IND in VARCHAR2,
401: X_NON_CNTRL_EXAM_LOC_CD in VARCHAR2,
402: X_MODE in VARCHAR2 default 'R'
403: ) as
404: cursor c1 is select rowid from IGS_AS_SASSESS_TYPE
405: where S_ASSESSMENT_TYPE = X_S_ASSESSMENT_TYPE
406: ;
407: begin
408: open c1;

Line 437: delete from IGS_AS_SASSESS_TYPE

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

Line 443: end IGS_AS_SASSESS_TYPE_PKG;

439: if (sql%notfound) then
440: raise no_data_found;
441: end if;
442: end DELETE_ROW;
443: end IGS_AS_SASSESS_TYPE_PKG;