APPS.IGS_PE_COURSE_EXCL_PKG dependencies on IGS_PE_COURSE_EXCL

Line 1: package body IGS_PE_COURSE_EXCL_PKG AS

1: package body IGS_PE_COURSE_EXCL_PKG AS
2: /* $Header: IGSNI13B.pls 115.3 2002/11/29 01:17:09 nsidana ship $ */
3:
4:
5:

Line 7: old_references IGS_PE_COURSE_EXCL%RowType;

3:
4:
5:
6: l_rowid VARCHAR2(25);
7: old_references IGS_PE_COURSE_EXCL%RowType;
8: new_references IGS_PE_COURSE_EXCL%RowType;
9:
10: PROCEDURE Set_Column_Values (
11: p_action IN VARCHAR2,

Line 8: new_references IGS_PE_COURSE_EXCL%RowType;

4:
5:
6: l_rowid VARCHAR2(25);
7: old_references IGS_PE_COURSE_EXCL%RowType;
8: new_references IGS_PE_COURSE_EXCL%RowType;
9:
10: PROCEDURE Set_Column_Values (
11: p_action IN VARCHAR2,
12: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 31: FROM IGS_PE_COURSE_EXCL

27: ) AS
28:
29: CURSOR cur_old_ref_values IS
30: SELECT *
31: FROM IGS_PE_COURSE_EXCL
32: WHERE rowid = x_rowid;
33:
34: BEGIN
35:

Line 137: 'IGS_PE_COURSE_EXCL',

133: -- effect type.
134: IF p_inserting THEN
135: IF IGS_EN_VAL_PCE.enrp_val_pee_table (
136: new_references.s_encmb_effect_type,
137: 'IGS_PE_COURSE_EXCL',
138: v_message_name) = FALSE THEN
139: Fnd_Message.Set_Name('IGS', v_message_name);
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;

Line 151: -- ON IGS_PE_COURSE_EXCL

147:
148: -- Trigger description :-
149: -- "OSS_TST".trg_pce_ar_iu
150: -- AFTER INSERT OR UPDATE
151: -- ON IGS_PE_COURSE_EXCL
152: -- FOR EACH ROW
153:
154: PROCEDURE AfterRowInsertUpdate2(
155: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 189: -- ON IGS_PE_COURSE_EXCL

185:
186: -- Trigger description :-
187: -- "OSS_TST".trg_pce_as_iu
188: -- AFTER INSERT OR UPDATE
189: -- ON IGS_PE_COURSE_EXCL
190:
191:
192:
193: PROCEDURE Check_Constraints (

Line 301: FROM IGS_PE_COURSE_EXCL

297: ) RETURN BOOLEAN AS
298:
299: CURSOR cur_rowid IS
300: SELECT rowid
301: FROM IGS_PE_COURSE_EXCL
302: WHERE person_id = x_person_id
303: AND encumbrance_type = x_encumbrance_type
304: AND pen_start_dt = x_pen_start_dt
305: AND s_encmb_effect_type = x_s_encmb_effect_type

Line 334: FROM IGS_PE_COURSE_EXCL

330: ) AS
331:
332: CURSOR cur_rowid IS
333: SELECT rowid
334: FROM IGS_PE_COURSE_EXCL
335: WHERE course_cd = x_course_cd ;
336:
337: lv_rowid cur_rowid%RowType;
338:

Line 365: FROM IGS_PE_COURSE_EXCL

361: ) AS
362:
363: CURSOR cur_rowid IS
364: SELECT rowid
365: FROM IGS_PE_COURSE_EXCL
366: WHERE person_id = x_person_id
367: AND encumbrance_type = x_encumbrance_type
368: AND pen_start_dt = x_pen_start_dt
369: AND s_encmb_effect_type = x_s_encmb_effect_type

Line 519: cursor C is select ROWID from IGS_PE_COURSE_EXCL

515: X_PCE_START_DT in DATE,
516: X_EXPIRY_DT in DATE,
517: X_MODE in VARCHAR2 default 'R'
518: ) AS
519: cursor C is select ROWID from IGS_PE_COURSE_EXCL
520: where PERSON_ID = X_PERSON_ID
521: and ENCUMBRANCE_TYPE = X_ENCUMBRANCE_TYPE
522: and PEN_START_DT = X_PEN_START_DT
523: and S_ENCMB_EFFECT_TYPE = X_S_ENCMB_EFFECT_TYPE

Line 568: insert into IGS_PE_COURSE_EXCL (

564: x_last_update_date=>X_LAST_UPDATE_DATE,
565: x_last_updated_by=>X_LAST_UPDATED_BY,
566: x_last_update_login=>X_LAST_UPDATE_LOGIN
567: );
568: insert into IGS_PE_COURSE_EXCL (
569: PERSON_ID,
570: ENCUMBRANCE_TYPE,
571: PEN_START_DT,
572: S_ENCMB_EFFECT_TYPE,

Line 629: from IGS_PE_COURSE_EXCL

625: X_EXPIRY_DT in DATE
626: ) AS
627: cursor c1 is select
628: EXPIRY_DT
629: from IGS_PE_COURSE_EXCL
630: where ROWID = X_ROWID
631: for update nowait;
632: tlinfo c1%rowtype;
633:

Line 711: update IGS_PE_COURSE_EXCL set

707: x_last_update_date=>X_LAST_UPDATE_DATE,
708: x_last_updated_by=>X_LAST_UPDATED_BY,
709: x_last_update_login=>X_LAST_UPDATE_LOGIN
710: );
711: update IGS_PE_COURSE_EXCL set
712: EXPIRY_DT = NEW_REFERENCES.EXPIRY_DT,
713: LAST_UPDATE_DATE = x_LAST_UPDATE_DATE,
714: LAST_UPDATED_BY = x_LAST_UPDATED_BY,
715: LAST_UPDATE_LOGIN = x_LAST_UPDATE_LOGIN

Line 740: cursor c1 is select rowid from IGS_PE_COURSE_EXCL

736: X_PCE_START_DT in DATE,
737: X_EXPIRY_DT in DATE,
738: X_MODE in VARCHAR2 default 'R'
739: ) AS
740: cursor c1 is select rowid from IGS_PE_COURSE_EXCL
741: where PERSON_ID = X_PERSON_ID
742: and ENCUMBRANCE_TYPE = X_ENCUMBRANCE_TYPE
743: and PEN_START_DT = X_PEN_START_DT
744: and S_ENCMB_EFFECT_TYPE = X_S_ENCMB_EFFECT_TYPE

Line 793: delete from IGS_PE_COURSE_EXCL

789: Before_DML(
790: p_action => 'DELETE',
791: x_rowid => X_ROWID
792: );
793: delete from IGS_PE_COURSE_EXCL
794: where ROWID = X_ROWID;
795: if (sql%notfound) then
796: raise no_data_found;
797: end if;

Line 804: end IGS_PE_COURSE_EXCL_PKG;

800: x_rowid => X_ROWID
801: );
802: end DELETE_ROW;
803:
804: end IGS_PE_COURSE_EXCL_PKG;