APPS.IGS_PS_PAT_STUDY_PRD_PKG dependencies on IGS_PS_PAT_STUDY_PRD

Line 1: package body IGS_PS_PAT_STUDY_PRD_PKG as

1: package body IGS_PS_PAT_STUDY_PRD_PKG as
2: /* $Header: IGSPI62B.pls 115.4 2002/11/29 02:33:22 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_PAT_STUDY_PRD%RowType;
5: new_references IGS_PS_PAT_STUDY_PRD%RowType;

Line 4: old_references IGS_PS_PAT_STUDY_PRD%RowType;

1: package body IGS_PS_PAT_STUDY_PRD_PKG as
2: /* $Header: IGSPI62B.pls 115.4 2002/11/29 02:33:22 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_PAT_STUDY_PRD%RowType;
5: new_references IGS_PS_PAT_STUDY_PRD%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PS_PAT_STUDY_PRD%RowType;

1: package body IGS_PS_PAT_STUDY_PRD_PKG as
2: /* $Header: IGSPI62B.pls 115.4 2002/11/29 02:33:22 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_PAT_STUDY_PRD%RowType;
5: new_references IGS_PS_PAT_STUDY_PRD%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 27: FROM IGS_PS_PAT_STUDY_PRD

23: ) AS
24:
25: CURSOR cur_old_ref_values IS
26: SELECT *
27: FROM IGS_PS_PAT_STUDY_PRD
28: WHERE rowid = x_rowid;
29:
30: BEGIN
31:

Line 117: -- Validate IGS_PS_PAT_STUDY_PRD record

113: ) AS
114: v_message_name VARCHAR2(30);
115: BEGIN
116: -- Validate the pattern of study record
117: -- Validate IGS_PS_PAT_STUDY_PRD record
118: IF IGS_PS_VAL_POSp.crsp_val_posp_iu(
119: new_references.course_cd,
120: new_references.version_number,
121: new_references.cal_type,

Line 267: IGS_PS_PAT_STUDY_UNT_PKG.GET_FK_IGS_PS_PAT_STUDY_PRD (

263:
264: PROCEDURE Check_Child_Existance AS
265: BEGIN
266:
267: IGS_PS_PAT_STUDY_UNT_PKG.GET_FK_IGS_PS_PAT_STUDY_PRD (
268: old_references.course_cd,
269: old_references.version_number,
270: old_references.cal_type,
271: old_references.pos_sequence_number,

Line 287: FROM IGS_PS_PAT_STUDY_PRD

283: ) RETURN BOOLEAN AS
284:
285: CURSOR cur_rowid IS
286: SELECT rowid
287: FROM IGS_PS_PAT_STUDY_PRD
288: WHERE course_cd = x_course_cd
289: AND version_number = x_version_number
290: AND cal_type = x_cal_type
291: AND pos_sequence_number = x_pos_sequence_number

Line 316: FROM IGS_PS_PAT_STUDY_PRD

312: ) AS
313:
314: CURSOR cur_rowid IS
315: SELECT rowid
316: FROM IGS_PS_PAT_STUDY_PRD
317: WHERE teach_cal_type = x_cal_type ;
318:
319: lv_rowid cur_rowid%RowType;
320:

Line 345: FROM IGS_PS_PAT_STUDY_PRD

341: ) AS
342:
343: CURSOR cur_rowid IS
344: SELECT rowid
345: FROM IGS_PS_PAT_STUDY_PRD
346: WHERE course_cd = x_course_cd
347: AND version_number = x_version_number
348: AND cal_type = x_cal_type
349: AND pos_sequence_number = x_sequence_number ;

Line 480: cursor C is select ROWID from IGS_PS_PAT_STUDY_PRD

476: X_TEACH_CAL_TYPE in VARCHAR2,
477: X_DESCRIPTION in VARCHAR2,
478: X_MODE in VARCHAR2 default 'R'
479: ) as
480: cursor C is select ROWID from IGS_PS_PAT_STUDY_PRD
481: where COURSE_CD = X_COURSE_CD
482: and VERSION_NUMBER = X_VERSION_NUMBER
483: and POS_SEQUENCE_NUMBER = X_POS_SEQUENCE_NUMBER
484: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER

Line 525: insert into IGS_PS_PAT_STUDY_PRD (

521: x_last_updated_by => X_LAST_UPDATED_BY,
522: x_last_update_login => X_LAST_UPDATE_LOGIN
523: );
524:
525: insert into IGS_PS_PAT_STUDY_PRD (
526: COURSE_CD,
527: VERSION_NUMBER,
528: CAL_TYPE,
529: POS_SEQUENCE_NUMBER,

Line 585: from IGS_PS_PAT_STUDY_PRD

581: cursor c1 is select
582: ACAD_PERIOD_NUM,
583: TEACH_CAL_TYPE,
584: DESCRIPTION
585: from IGS_PS_PAT_STUDY_PRD
586: where ROWID = X_ROWID for update nowait;
587: tlinfo c1%rowtype;
588:
589: begin

Line 667: update IGS_PS_PAT_STUDY_PRD set

663: x_last_updated_by => X_LAST_UPDATED_BY,
664: x_last_update_login => X_LAST_UPDATE_LOGIN
665: );
666:
667: update IGS_PS_PAT_STUDY_PRD set
668: ACAD_PERIOD_NUM = NEW_REFERENCES.ACAD_PERIOD_NUM,
669: TEACH_CAL_TYPE = NEW_REFERENCES.TEACH_CAL_TYPE,
670: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
671: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 698: cursor c1 is select rowid from IGS_PS_PAT_STUDY_PRD

694: X_TEACH_CAL_TYPE in VARCHAR2,
695: X_DESCRIPTION in VARCHAR2,
696: X_MODE in VARCHAR2 default 'R'
697: ) as
698: cursor c1 is select rowid from IGS_PS_PAT_STUDY_PRD
699: where COURSE_CD = X_COURSE_CD
700: and VERSION_NUMBER = X_VERSION_NUMBER
701: and POS_SEQUENCE_NUMBER = X_POS_SEQUENCE_NUMBER
702: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER

Line 744: delete from IGS_PS_PAT_STUDY_PRD

740: begin
741: Before_DML( p_action => 'DELETE',
742: x_rowid => X_ROWID
743: );
744: delete from IGS_PS_PAT_STUDY_PRD
745: where ROWID = X_ROWID;
746: if (sql%notfound) then
747: raise no_data_found;
748: end if;

Line 756: end IGS_PS_PAT_STUDY_PRD_PKG;

752: );
753:
754: end DELETE_ROW;
755:
756: end IGS_PS_PAT_STUDY_PRD_PKG;