APPS.IGS_GR_AWD_CEREMONY_PKG dependencies on IGS_GR_AWD_CEREMONY_ALL

Line 4: old_references IGS_GR_AWD_CEREMONY_ALL%RowType;

1: package body IGS_GR_AWD_CEREMONY_PKG as
2: /* $Header: IGSGI02B.pls 115.14 2004/01/21 06:44:00 nalkumar ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_AWD_CEREMONY_ALL%RowType;
5: new_references IGS_GR_AWD_CEREMONY_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_GR_AWD_CEREMONY_ALL%RowType;

1: package body IGS_GR_AWD_CEREMONY_PKG as
2: /* $Header: IGSGI02B.pls 115.14 2004/01/21 06:44:00 nalkumar ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_AWD_CEREMONY_ALL%RowType;
5: new_references IGS_GR_AWD_CEREMONY_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 29: FROM IGS_GR_AWD_CEREMONY_ALL

25: ) AS
26:
27: CURSOR cur_old_ref_values IS
28: SELECT *
29: FROM IGS_GR_AWD_CEREMONY_ALL
30: WHERE rowid = x_rowid;
31:
32: BEGIN
33:

Line 76: -- ON IGS_GR_AWD_CEREMONY_ALL

72:
73: -- Trigger description :-
74: -- "OSS_TST".trg_awc_br_iu
75: -- BEFORE INSERT OR UPDATE
76: -- ON IGS_GR_AWD_CEREMONY_ALL
77: -- FOR EACH ROW
78:
79: PROCEDURE BeforeRowInsertUpdate1(
80: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 137: -- ON IGS_GR_AWD_CEREMONY_ALL

133:
134: -- Trigger description :-
135: -- "OSS_TST".trg_awc_ar_iu
136: -- AFTER INSERT OR UPDATE
137: -- ON IGS_GR_AWD_CEREMONY_ALL
138: -- FOR EACH ROW
139:
140: PROCEDURE AfterRowInsertUpdate2(
141: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 351: FROM IGS_GR_AWD_CEREMONY_ALL

347: ) RETURN BOOLEAN AS
348:
349: CURSOR cur_rowid IS
350: SELECT rowid
351: FROM IGS_GR_AWD_CEREMONY_ALL
352: WHERE AWC_ID = x_AWC_ID
353: FOR UPDATE NOWAIT;
354:
355: lv_rowid cur_rowid%RowType;

Line 382: FROM IGS_GR_AWD_CEREMONY_ALL

378: ) RETURN BOOLEAN AS
379:
380: CURSOR cur_rowid IS
381: SELECT rowid
382: FROM IGS_GR_AWD_CEREMONY_ALL
383: WHERE grd_cal_type = x_grd_cal_type
384: AND grd_ci_sequence_number = x_grd_ci_sequence_number
385: AND ceremony_number = x_ceremony_number
386: AND award_course_cd = x_award_course_cd

Line 414: FROM IGS_GR_AWD_CEREMONY_ALL

410: ) AS
411:
412: CURSOR cur_rowid IS
413: SELECT rowid
414: FROM IGS_GR_AWD_CEREMONY_ALL
415: WHERE grd_cal_type = x_grd_cal_type
416: AND grd_ci_sequence_number = x_grd_ci_sequence_number
417: AND ceremony_number = x_ceremony_number ;
418:

Line 551: cursor C is select ROWID from IGS_GR_AWD_CEREMONY_ALL

547: X_CLOSED_IND in VARCHAR2,
548: X_MODE in VARCHAR2 default 'R',
549: X_ORG_ID in NUMBER
550: ) AS
551: cursor C is select ROWID from IGS_GR_AWD_CEREMONY_ALL
552: where AWC_ID = X_AWC_ID;
553: X_LAST_UPDATE_DATE DATE;
554: X_LAST_UPDATED_BY NUMBER;
555: X_LAST_UPDATE_LOGIN NUMBER;

Line 599: insert into IGS_GR_AWD_CEREMONY_ALL (

595: x_last_update_login => X_LAST_UPDATE_LOGIN,
596: x_org_id => igs_ge_gen_003.get_org_id
597: );
598:
599: insert into IGS_GR_AWD_CEREMONY_ALL (
600: AWC_ID,
601: GRD_CAL_TYPE,
602: GRD_CI_SEQUENCE_NUMBER,
603: CEREMONY_NUMBER,

Line 669: from IGS_GR_AWD_CEREMONY_ALL

665: AWARD_CRS_VERSION_NUMBER,
666: AWARD_CD,
667: ORDER_IN_CEREMONY,
668: CLOSED_IND
669: from IGS_GR_AWD_CEREMONY_ALL
670: where ROWID = X_ROWID for update nowait;
671: tlinfo c1%rowtype;
672:
673: begin

Line 761: update IGS_GR_AWD_CEREMONY_ALL set

757: x_last_updated_by => X_LAST_UPDATED_BY,
758: x_last_update_login => X_LAST_UPDATE_LOGIN
759: );
760:
761: update IGS_GR_AWD_CEREMONY_ALL set
762: GRD_CAL_TYPE = NEW_REFERENCES.GRD_CAL_TYPE,
763: GRD_CI_SEQUENCE_NUMBER = NEW_REFERENCES.GRD_CI_SEQUENCE_NUMBER,
764: CEREMONY_NUMBER = NEW_REFERENCES.CEREMONY_NUMBER,
765: AWARD_COURSE_CD = NEW_REFERENCES.AWARD_COURSE_CD,

Line 800: cursor c1 is select rowid from IGS_GR_AWD_CEREMONY_ALL

796: X_CLOSED_IND in VARCHAR2,
797: X_MODE in VARCHAR2 default 'R',
798: X_ORG_ID in NUMBER
799: ) AS
800: cursor c1 is select rowid from IGS_GR_AWD_CEREMONY_ALL
801: where AWC_ID = X_AWC_ID
802: ;
803:
804: begin

Line 850: delete from IGS_GR_AWD_CEREMONY_ALL

846: p_action => 'DELETE',
847: x_rowid => X_ROWID
848: );
849:
850: delete from IGS_GR_AWD_CEREMONY_ALL
851: where ROWID = X_ROWID;
852: if (sql%notfound) then
853: raise no_data_found;
854: end if;