APPS.IGS_GR_VENUE_PKG dependencies on IGS_GR_VENUE_ALL

Line 4: old_references IGS_GR_VENUE_ALL%RowType;

1: package body IGS_GR_VENUE_PKG as
2: /* $Header: IGSGI19B.pls 115.10 2003/10/30 13:28:59 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_VENUE_ALL%RowType;
5: new_references IGS_GR_VENUE_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_GR_VENUE_ALL%RowType;

1: package body IGS_GR_VENUE_PKG as
2: /* $Header: IGSGI19B.pls 115.10 2003/10/30 13:28:59 rghosh ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_VENUE_ALL%RowType;
5: new_references IGS_GR_VENUE_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_GR_VENUE_ALL

31: ) AS
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM IGS_GR_VENUE_ALL
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

Line 87: -- ON IGS_GR_VENUE_ALL

83:
84: -- Trigger description :-
85: -- "OSS_TST".trg_ve_br_iu
86: -- BEFORE INSERT OR UPDATE
87: -- ON IGS_GR_VENUE_ALL
88: -- FOR EACH ROW
89:
90: PROCEDURE BeforeRowInsertUpdate1(
91: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 202: FROM IGS_GR_VENUE_ALL

198: ) RETURN BOOLEAN AS
199:
200: CURSOR cur_rowid IS
201: SELECT rowid
202: FROM IGS_GR_VENUE_ALL
203: WHERE venue_cd = x_venue_cd
204: FOR UPDATE NOWAIT;
205:
206: lv_rowid cur_rowid%RowType;

Line 315: FROM IGS_GR_VENUE_ALL

311: ) AS
312:
313: CURSOR cur_rowid IS
314: SELECT rowid
315: FROM IGS_GR_VENUE_ALL
316: WHERE exam_location_cd = x_location_cd ;
317:
318: lv_rowid cur_rowid%RowType;
319:

Line 340: FROM IGS_GR_VENUE_ALL

336: ) AS
337:
338: CURSOR cur_rowid IS
339: SELECT rowid
340: FROM IGS_GR_VENUE_ALL
341: WHERE coord_person_id = x_person_id ;
342:
343: lv_rowid cur_rowid%RowType;
344:

Line 467: cursor C is select ROWID from IGS_GR_VENUE_ALL

463: X_INSTRUCTIONS in VARCHAR2,
464: X_MODE in VARCHAR2 default 'R',
465: X_ORG_ID in NUMBER
466: ) AS
467: cursor C is select ROWID from IGS_GR_VENUE_ALL
468: where VENUE_CD = X_VENUE_CD;
469: X_LAST_UPDATE_DATE DATE;
470: X_LAST_UPDATED_BY NUMBER;
471: X_LAST_UPDATE_LOGIN NUMBER;

Line 517: insert into IGS_GR_VENUE_ALL (

513: x_last_update_login => X_LAST_UPDATE_LOGIN,
514: x_org_id => igs_ge_gen_003.get_org_id
515: );
516:
517: insert into IGS_GR_VENUE_ALL (
518: VENUE_CD,
519: EXAM_LOCATION_CD,
520: DESCRIPTION,
521: NUMBER_OF_SEATS,

Line 606: from IGS_GR_VENUE_ALL

602: ANNOUNCEMENTS,
603: BOOKING_INFORMATION,
604: SEATING_INFORMATION,
605: INSTRUCTIONS
606: from IGS_GR_VENUE_ALL
607: where ROWID = X_ROWID for update nowait;
608: tlinfo c1%rowtype;
609:
610: begin

Line 731: update IGS_GR_VENUE_ALL set

727: x_last_updated_by => X_LAST_UPDATED_BY,
728: x_last_update_login => X_LAST_UPDATE_LOGIN
729: );
730:
731: update IGS_GR_VENUE_ALL set
732: EXAM_LOCATION_CD = NEW_REFERENCES.EXAM_LOCATION_CD,
733: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
734: NUMBER_OF_SEATS = NEW_REFERENCES.NUMBER_OF_SEATS,
735: BOOKING_COST = NEW_REFERENCES.BOOKING_COST,

Line 777: cursor c1 is select rowid from IGS_GR_VENUE_ALL

773: X_INSTRUCTIONS in VARCHAR2,
774: X_MODE in VARCHAR2 default 'R',
775: X_ORG_ID in NUMBER
776: ) AS
777: cursor c1 is select rowid from IGS_GR_VENUE_ALL
778: where VENUE_CD = X_VENUE_CD
779: ;
780:
781: begin

Line 840: delete from IGS_GR_VENUE_ALL

836: p_action => 'DELETE',
837: x_rowid => X_ROWID
838: );
839:
840: delete from IGS_GR_VENUE_ALL
841: where ROWID = X_ROWID;
842: if (sql%notfound) then
843: raise no_data_found;
844: end if;