eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_GR_AWD_CEREMONY_PKG dependencies on IGS_GR_AWD_CEREMONY

Line 1: package body IGS_GR_AWD_CEREMONY_PKG as

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;

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 150: FROM IGS_GR_AWD_CEREMONY awc

146: v_rowid_saved BOOLEAN := FALSE;
147:
148: CURSOR c_awc IS
149: SELECT 'X'
150: FROM IGS_GR_AWD_CEREMONY awc
151: WHERE awc.grd_cal_type = NEW_REFERENCES.grd_cal_type AND
152: awc.grd_ci_sequence_number = NEW_REFERENCES.grd_ci_sequence_number AND
153: awc.ceremony_number = NEW_REFERENCES.ceremony_number AND
154: awc.order_in_ceremony = NEW_REFERENCES.order_in_ceremony AND

Line 288: IGS_GR_AWD_CRM_US_GP_PKG.GET_UFK_IGS_GR_AWD_CEREMONY (

284:
285: PROCEDURE Check_Child_Existance AS
286: BEGIN
287:
288: IGS_GR_AWD_CRM_US_GP_PKG.GET_UFK_IGS_GR_AWD_CEREMONY (
289: old_references.grd_cal_type,
290: old_references.grd_ci_sequence_number,
291: old_references.ceremony_number,
292: old_references.award_course_cd,

Line 297: IGS_GR_AWD_CRMN_PKG.GET_UFK_IGS_GR_AWD_CEREMONY (

293: old_references.award_crs_version_number,
294: old_references.award_cd
295: );
296:
297: IGS_GR_AWD_CRMN_PKG.GET_UFK_IGS_GR_AWD_CEREMONY (
298: old_references.grd_cal_type,
299: old_references.grd_ci_sequence_number,
300: old_references.ceremony_number,
301: old_references.award_course_cd,

Line 325: IGS_GR_AWD_CRM_US_GP_PKG.GET_UFK_IGS_GR_AWD_CEREMONY (

321: (old_references.AWARD_CD IS NULL) AND
322: (old_references.AWARD_CRS_VERSION_NUMBER IS NULL))) THEN
323: NULL;
324: ELSE
325: IGS_GR_AWD_CRM_US_GP_PKG.GET_UFK_IGS_GR_AWD_CEREMONY (
326: old_references.grd_cal_type,
327: old_references.grd_ci_sequence_number,
328: old_references.ceremony_number,
329: old_references.award_course_cd,

Line 334: IGS_GR_AWD_CRMN_PKG.GET_UFK_IGS_GR_AWD_CEREMONY (

330: old_references.award_crs_version_number,
331: old_references.award_cd
332: );
333:
334: IGS_GR_AWD_CRMN_PKG.GET_UFK_IGS_GR_AWD_CEREMONY (
335: old_references.grd_cal_type,
336: old_references.grd_ci_sequence_number,
337: old_references.ceremony_number,
338: old_references.award_course_cd,

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 558: SELECT IGS_GR_AWD_CEREMONY_AWC_ID_S.NEXTVAL INTO X_AWC_ID FROM DUAL;

554: X_LAST_UPDATED_BY NUMBER;
555: X_LAST_UPDATE_LOGIN NUMBER;
556: begin
557:
558: SELECT IGS_GR_AWD_CEREMONY_AWC_ID_S.NEXTVAL INTO X_AWC_ID FROM DUAL;
559:
560: X_LAST_UPDATE_DATE := SYSDATE;
561: if(X_MODE = 'I') then
562: X_LAST_UPDATED_BY := 1;

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;

Line 931: END igs_gr_awd_ceremony_pkg;

927: END IF;
928:
929: END Check_Constraints;
930:
931: END igs_gr_awd_ceremony_pkg;