APPS.IGS_AD_TEST_TYPE_PKG dependencies on IGS_AD_TEST_TYPE

Line 1: package body IGS_AD_TEST_TYPE_PKG as

1: package body IGS_AD_TEST_TYPE_PKG as
2: /* $Header: IGSAI10B.pls 115.16 2003/10/30 13:11:09 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_TEST_TYPE%RowType;

Line 5: old_references IGS_AD_TEST_TYPE%RowType;

1: package body IGS_AD_TEST_TYPE_PKG as
2: /* $Header: IGSAI10B.pls 115.16 2003/10/30 13:11:09 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_TEST_TYPE%RowType;
6: new_references IGS_AD_TEST_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AD_TEST_TYPE%RowType;

2: /* $Header: IGSAI10B.pls 115.16 2003/10/30 13:11:09 akadam ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AD_TEST_TYPE%RowType;
6: new_references IGS_AD_TEST_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_AD_TEST_TYPE

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

Line 131: IGS_AD_TEST_RESULTS_PKG.GET_FK_IGS_AD_TEST_TYPE (

127:
128: IGS_AD_TEST_SEGMENTS_PKG.GET_FK_IGS_TEST_TYPE (
129: old_references.admission_test_type
130: );
131: IGS_AD_TEST_RESULTS_PKG.GET_FK_IGS_AD_TEST_TYPE (
132: old_references.admission_test_type
133: );
134:
135: END Check_Child_Existance;

Line 144: FROM IGS_AD_TEST_TYPE

140: )return BOOLEAN AS
141:
142: CURSOR cur_rowid IS
143: SELECT rowid
144: FROM IGS_AD_TEST_TYPE
145: WHERE admission_test_type = x_admission_test_type AND
146: closed_ind = NVL(x_closed_ind,closed_ind)
147: FOR UPDATE NOWAIT;
148:

Line 246: cursor C is select ROWID from IGS_AD_TEST_TYPE

242: X_SCORE_TYPE in VARCHAR2 DEFAULT NULL,
243: X_STEP_CODE in VARCHAR2 DEFAULT NULL,
244: X_MODE in VARCHAR2 default 'R'
245: ) as
246: cursor C is select ROWID from IGS_AD_TEST_TYPE
247: where ADMISSION_TEST_TYPE = X_ADMISSION_TEST_TYPE;
248: X_LAST_UPDATE_DATE DATE;
249: X_LAST_UPDATED_BY NUMBER;
250: X_LAST_UPDATE_LOGIN NUMBER;

Line 286: insert into IGS_AD_TEST_TYPE (

282: x_last_updated_by => X_LAST_UPDATED_BY,
283: x_last_update_login => X_LAST_UPDATE_LOGIN
284: );
285:
286: insert into IGS_AD_TEST_TYPE (
287: ADMISSION_TEST_TYPE,
288: DESCRIPTION,
289: CLOSED_IND,
290: SCORE_TYPE,

Line 338: from IGS_AD_TEST_TYPE

334: DESCRIPTION,
335: CLOSED_IND,
336: SCORE_TYPE,
337: STEP_CODE
338: from IGS_AD_TEST_TYPE
339: where ROWID = X_ROWID for update nowait;
340: tlinfo c1%rowtype;
341:
342: begin

Line 417: update IGS_AD_TEST_TYPE set

413: x_last_updated_by => X_LAST_UPDATED_BY,
414: x_last_update_login => X_LAST_UPDATE_LOGIN
415: );
416:
417: update IGS_AD_TEST_TYPE set
418: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
419: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
420: SCORE_TYPE = NEW_REFERENCES.SCORE_TYPE,
421: STEP_CODE = NEW_REFERENCES.STEP_CODE,

Line 447: cursor c1 is select rowid from IGS_AD_TEST_TYPE

443: X_SCORE_TYPE in VARCHAR2 DEFAULT NULL,
444: X_STEP_CODE in VARCHAR2 DEFAULT NULL,
445: X_MODE in VARCHAR2 default 'R'
446: ) as
447: cursor c1 is select rowid from IGS_AD_TEST_TYPE
448: where ADMISSION_TEST_TYPE = X_ADMISSION_TEST_TYPE
449: ;
450: begin
451: open c1;

Line 486: delete from IGS_AD_TEST_TYPE

482: p_action => 'DELETE',
483: x_rowid => X_ROWID
484: );
485:
486: delete from IGS_AD_TEST_TYPE
487: where ROWID = X_ROWID;
488: if (sql%notfound) then
489: raise no_data_found;
490: end if;

Line 499: end IGS_AD_TEST_TYPE_PKG;

495: );
496:
497: end DELETE_ROW;
498:
499: end IGS_AD_TEST_TYPE_PKG;