APPS.IGS_PR_S_CRV_PRG_CAL_PKG dependencies on IGS_PR_S_CRV_PRG_CAL

Line 1: package body IGS_PR_S_CRV_PRG_CAL_PKG as

1: package body IGS_PR_S_CRV_PRG_CAL_PKG as
2: /* $Header: IGSQI21B.pls 115.3 2002/11/29 03:19:23 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_S_CRV_PRG_CAL%RowType;

Line 5: old_references IGS_PR_S_CRV_PRG_CAL%RowType;

1: package body IGS_PR_S_CRV_PRG_CAL_PKG as
2: /* $Header: IGSQI21B.pls 115.3 2002/11/29 03:19:23 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_S_CRV_PRG_CAL%RowType;
6: new_references IGS_PR_S_CRV_PRG_CAL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PR_S_CRV_PRG_CAL%RowType;

2: /* $Header: IGSQI21B.pls 115.3 2002/11/29 03:19:23 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_S_CRV_PRG_CAL%RowType;
6: new_references IGS_PR_S_CRV_PRG_CAL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 26: FROM IGS_PR_S_CRV_PRG_CAL

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

Line 70: -- ON IGS_PR_S_CRV_PRG_CAL

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

Line 162: FROM IGS_PR_S_CRV_PRG_CAL

158: ) RETURN BOOLEAN AS
159:
160: CURSOR cur_rowid IS
161: SELECT rowid
162: FROM IGS_PR_S_CRV_PRG_CAL
163: WHERE course_cd = x_course_cd
164: AND version_number = x_version_number
165: AND prg_cal_type = x_prg_cal_type
166: FOR UPDATE NOWAIT;

Line 190: FROM IGS_PR_S_CRV_PRG_CAL

186: ) AS
187:
188: CURSOR cur_rowid IS
189: SELECT rowid
190: FROM IGS_PR_S_CRV_PRG_CAL
191: WHERE prg_cal_type = x_cal_type ;
192:
193: lv_rowid cur_rowid%RowType;
194:

Line 218: FROM IGS_PR_S_CRV_PRG_CAL

214: ) AS
215:
216: CURSOR cur_rowid IS
217: SELECT rowid
218: FROM IGS_PR_S_CRV_PRG_CAL
219: WHERE course_cd = x_course_cd
220: AND version_number = x_version_number ;
221:
222: lv_rowid cur_rowid%RowType;

Line 321: cursor C is select ROWID from IGS_PR_S_CRV_PRG_CAL

317: X_SHOW_CAUSE_LENGTH in NUMBER,
318: X_APPEAL_LENGTH in NUMBER,
319: X_MODE in VARCHAR2 default 'R'
320: ) as
321: cursor C is select ROWID from IGS_PR_S_CRV_PRG_CAL
322: where COURSE_CD = X_COURSE_CD
323: and VERSION_NUMBER = X_VERSION_NUMBER
324: and PRG_CAL_TYPE = X_PRG_CAL_TYPE;
325: X_LAST_UPDATE_DATE DATE;

Line 364: insert into IGS_PR_S_CRV_PRG_CAL (

360: x_last_updated_by => X_LAST_UPDATED_BY,
361: x_last_update_login => X_LAST_UPDATE_LOGIN
362: );
363:
364: insert into IGS_PR_S_CRV_PRG_CAL (
365: COURSE_CD,
366: VERSION_NUMBER,
367: PRG_CAL_TYPE,
368: STREAM_NUM,

Line 413: from IGS_PR_S_CRV_PRG_CAL

409: cursor c1 is select
410: STREAM_NUM,
411: SHOW_CAUSE_LENGTH,
412: APPEAL_LENGTH
413: from IGS_PR_S_CRV_PRG_CAL
414: where ROWID = X_ROWID
415: for update nowait;
416: tlinfo c1%rowtype;
417:

Line 497: update IGS_PR_S_CRV_PRG_CAL set

493: x_last_updated_by => X_LAST_UPDATED_BY,
494: x_last_update_login => X_LAST_UPDATE_LOGIN
495: );
496:
497: update IGS_PR_S_CRV_PRG_CAL set
498: STREAM_NUM = NEW_REFERENCES.STREAM_NUM,
499: SHOW_CAUSE_LENGTH = NEW_REFERENCES.SHOW_CAUSE_LENGTH,
500: APPEAL_LENGTH = NEW_REFERENCES.APPEAL_LENGTH,
501: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 522: cursor c1 is select rowid from IGS_PR_S_CRV_PRG_CAL

518: X_SHOW_CAUSE_LENGTH in NUMBER,
519: X_APPEAL_LENGTH in NUMBER,
520: X_MODE in VARCHAR2 default 'R'
521: ) as
522: cursor c1 is select rowid from IGS_PR_S_CRV_PRG_CAL
523: where COURSE_CD = X_COURSE_CD
524: and VERSION_NUMBER = X_VERSION_NUMBER
525: and PRG_CAL_TYPE = X_PRG_CAL_TYPE
526: ;

Line 566: delete from IGS_PR_S_CRV_PRG_CAL

562: p_action=>'DELETE',
563: x_rowid=>X_ROWID
564: );
565:
566: delete from IGS_PR_S_CRV_PRG_CAL
567: where ROWID = X_ROWID;
568: if (sql%notfound) then
569: raise no_data_found;
570: end if;

Line 647: end IGS_PR_S_CRV_PRG_CAL_PKG;

643:
644:
645: END Check_Constraints;
646:
647: end IGS_PR_S_CRV_PRG_CAL_PKG;