APPS.IGS_AS_ASSESSMNT_TYP_PKG dependencies on IGS_AS_ASSESSMNT_TYP

Line 1: package body IGS_AS_ASSESSMNT_TYP_PKG as

1: package body IGS_AS_ASSESSMNT_TYP_PKG as
2: /* $Header: IGSDI40B.pls 115.9 2003/05/19 04:43:06 ijeddy ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_ASSESSMNT_TYP%RowType;

Line 5: old_references IGS_AS_ASSESSMNT_TYP%RowType;

1: package body IGS_AS_ASSESSMNT_TYP_PKG as
2: /* $Header: IGSDI40B.pls 115.9 2003/05/19 04:43:06 ijeddy ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_ASSESSMNT_TYP%RowType;
6: new_references IGS_AS_ASSESSMNT_TYP%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AS_ASSESSMNT_TYP%RowType;

2: /* $Header: IGSDI40B.pls 115.9 2003/05/19 04:43:06 ijeddy ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_ASSESSMNT_TYP%RowType;
6: new_references IGS_AS_ASSESSMNT_TYP%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 26: FROM IGS_AS_ASSESSMNT_TYP

22: ) as
23:
24: CURSOR cur_old_ref_values IS
25: SELECT *
26: FROM IGS_AS_ASSESSMNT_TYP
27: WHERE rowid = x_rowid;
28:
29: BEGIN
30:

Line 70: -- ON IGS_AS_ASSESSMNT_TYP

66:
67: -- Trigger description :-
68: -- "OSS_TST".trg_atyp_br_iu
69: -- BEFORE INSERT OR UPDATE
70: -- ON IGS_AS_ASSESSMNT_TYP
71: -- FOR EACH ROW
72:
73: PROCEDURE BeforeRowInsertUpdate1(
74: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 203: IGS_AS_ASSESSMNT_ITM_PKG.GET_FK_IGS_AS_ASSESSMNT_TYP (

199:
200: PROCEDURE Check_Child_Existance as
201: BEGIN
202:
203: IGS_AS_ASSESSMNT_ITM_PKG.GET_FK_IGS_AS_ASSESSMNT_TYP (
204: old_references.assessment_type
205: );
206:
207: END Check_Child_Existance;

Line 215: FROM IGS_AS_ASSESSMNT_TYP

211: ) RETURN BOOLEAN AS
212:
213: CURSOR cur_rowid IS
214: SELECT rowid
215: FROM IGS_AS_ASSESSMNT_TYP
216: WHERE assessment_type = x_assessment_type
217: FOR UPDATE NOWAIT;
218:
219: lv_rowid cur_rowid%RowType;

Line 241: FROM IGS_AS_ASSESSMNT_TYP

237: ) as
238:
239: CURSOR cur_rowid IS
240: SELECT rowid
241: FROM IGS_AS_ASSESSMNT_TYP
242: WHERE assessment_type = x_s_assessment_type ;
243:
244: lv_rowid cur_rowid%RowType;
245:

Line 350: cursor C is select ROWID from IGS_AS_ASSESSMNT_TYP

346: X_CLOSED_IND in VARCHAR2,
347: X_ANON_GRADING_IND in VARCHAR2,
348: X_MODE in VARCHAR2 default 'R'
349: ) as
350: cursor C is select ROWID from IGS_AS_ASSESSMNT_TYP
351: where ASSESSMENT_TYPE = X_ASSESSMENT_TYPE;
352: X_LAST_UPDATE_DATE DATE;
353: X_LAST_UPDATED_BY NUMBER;
354: X_LAST_UPDATE_LOGIN NUMBER;

Line 389: insert into IGS_AS_ASSESSMNT_TYP (

385: x_last_update_date=>X_LAST_UPDATE_DATE,
386: x_last_updated_by=>X_LAST_UPDATED_BY,
387: x_last_update_login=>X_LAST_UPDATE_LOGIN
388: );
389: insert into IGS_AS_ASSESSMNT_TYP (
390: ASSESSMENT_TYPE,
391: S_ASSESSMENT_TYPE,
392: DESCRIPTION,
393: EXAMINABLE_IND,

Line 440: from IGS_AS_ASSESSMNT_TYP

436: DESCRIPTION,
437: EXAMINABLE_IND,
438: CLOSED_IND,
439: ANON_GRADING_IND
440: from IGS_AS_ASSESSMNT_TYP
441: where ROWID = X_ROWID for update nowait;
442: tlinfo c1%rowtype;
443:
444: begin

Line 519: update IGS_AS_ASSESSMNT_TYP set

515: x_last_updated_by=>X_LAST_UPDATED_BY,
516: x_last_update_login=>X_LAST_UPDATE_LOGIN
517: );
518:
519: update IGS_AS_ASSESSMNT_TYP set
520: S_ASSESSMENT_TYPE = NEW_REFERENCES.S_ASSESSMENT_TYPE,
521: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
522: EXAMINABLE_IND = NEW_REFERENCES.EXAMINABLE_IND,
523: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 546: cursor c1 is select rowid from IGS_AS_ASSESSMNT_TYP

542: X_CLOSED_IND in VARCHAR2,
543: X_ANON_GRADING_IND in VARCHAR2,
544: X_MODE in VARCHAR2 default 'R'
545: ) as
546: cursor c1 is select rowid from IGS_AS_ASSESSMNT_TYP
547: where ASSESSMENT_TYPE = X_ASSESSMENT_TYPE
548: ;
549: begin
550: open c1;

Line 585: delete from IGS_AS_ASSESSMNT_TYP

581: p_action => 'DELETE',
582: x_rowid => X_ROWID
583: );
584:
585: delete from IGS_AS_ASSESSMNT_TYP
586: where ROWID = X_ROWID;
587: if (sql%notfound) then
588: raise no_data_found;
589: end if;

Line 594: end IGS_AS_ASSESSMNT_TYP_PKG;

590:
591:
592: end DELETE_ROW;
593:
594: end IGS_AS_ASSESSMNT_TYP_PKG;