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_CRMN_PKG dependencies on IGS_GR_AWD_CRMN

Line 1: package body IGS_GR_AWD_CRMN_PKG as

1: package body IGS_GR_AWD_CRMN_PKG as
2: /* $Header: IGSGI03B.pls 115.7 2002/11/29 00:34:09 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_AWD_CRMN%RowType;
5: new_references IGS_GR_AWD_CRMN%RowType;

Line 4: old_references IGS_GR_AWD_CRMN%RowType;

1: package body IGS_GR_AWD_CRMN_PKG as
2: /* $Header: IGSGI03B.pls 115.7 2002/11/29 00:34:09 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_AWD_CRMN%RowType;
5: new_references IGS_GR_AWD_CRMN%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_GR_AWD_CRMN%RowType;

1: package body IGS_GR_AWD_CRMN_PKG as
2: /* $Header: IGSGI03B.pls 115.7 2002/11/29 00:34:09 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_AWD_CRMN%RowType;
5: new_references IGS_GR_AWD_CRMN%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 42: FROM IGS_GR_AWD_CRMN

38: ) AS
39:
40: CURSOR cur_old_ref_values IS
41: SELECT *
42: FROM IGS_GR_AWD_CRMN
43: WHERE rowid = x_rowid;
44:
45: BEGIN
46:

Line 102: -- ON IGS_GR_AWD_CRMN

98:
99: -- Trigger description :-
100: -- "OSS_TST".trg_gac_br_iu
101: -- BEFORE INSERT OR UPDATE
102: -- ON IGS_GR_AWD_CRMN
103: -- FOR EACH ROW
104:
105: PROCEDURE BeforeRowInsertUpdate1(
106: p_inserting IN BOOLEAN,

Line 267: -- ON IGS_GR_AWD_CRMN

263:
264: -- Trigger description :-
265: -- "OSS_TST".trg_gac_ar_d_hist
266: -- AFTER DELETE
267: -- ON IGS_GR_AWD_CRMN
268: -- FOR EACH ROW
269:
270: PROCEDURE AfterRowDelete2(
271: p_inserting IN BOOLEAN,

Line 299: -- ON IGS_GR_AWD_CRMN

295:
296: -- Trigger description :-
297: -- "OSS_TST".trg_gac_ar_iu
298: -- AFTER INSERT OR UPDATE
299: -- ON IGS_GR_AWD_CRMN
300: -- FOR EACH ROW
301:
302: PROCEDURE AfterRowInsertUpdate3(
303: p_inserting IN BOOLEAN,

Line 382: -- ON IGS_GR_AWD_CRMN

378:
379: -- Trigger description :-
380: -- "OSS_TST".trg_gac_ar_u_hist
381: -- AFTER UPDATE
382: -- ON IGS_GR_AWD_CRMN
383: -- FOR EACH ROW
384:
385: PROCEDURE AfterRowUpdate4(
386: p_inserting IN BOOLEAN,

Line 747: FROM IGS_GR_AWD_CRMN

743: ) RETURN BOOLEAN AS
744:
745: CURSOR cur_rowid IS
746: SELECT rowid
747: FROM IGS_GR_AWD_CRMN
748: WHERE GAC_ID = X_GAC_ID
749: FOR UPDATE NOWAIT;
750:
751: lv_rowid cur_rowid%RowType;

Line 779: FROM IGS_GR_AWD_CRMN

775: x_award_cd IN VARCHAR2
776: ) RETURN BOOLEAN AS
777: CURSOR cur_rowid IS
778: SELECT rowid
779: FROM IGS_GR_AWD_CRMN
780: WHERE person_id = x_person_id
781: AND create_dt = x_create_dt
782: AND grd_cal_type = x_grd_cal_type
783: AND grd_ci_sequence_number = x_grd_ci_sequence_number

Line 815: FROM IGS_GR_AWD_CRMN

811: ) AS
812:
813: CURSOR cur_rowid IS
814: SELECT rowid
815: FROM IGS_GR_AWD_CRMN
816: WHERE grd_cal_type = x_grd_cal_type
817: AND grd_ci_sequence_number = x_grd_ci_sequence_number ;
818:
819: lv_rowid cur_rowid%RowType;

Line 842: FROM IGS_GR_AWD_CRMN

838: ) AS
839:
840: CURSOR cur_rowid IS
841: SELECT rowid
842: FROM IGS_GR_AWD_CRMN
843: WHERE academic_gown_size = x_measurement_cd
844: OR academic_hat_size = x_measurement_cd;
845:
846: lv_rowid cur_rowid%RowType;

Line 873: FROM IGS_GR_AWD_CRMN

869: ) AS
870:
871: CURSOR cur_rowid IS
872: SELECT rowid
873: FROM IGS_GR_AWD_CRMN
874: WHERE person_id = x_person_id
875: AND create_dt = x_create_dt
876: AND award_course_cd = x_award_course_cd
877: AND award_crs_version_number = x_award_crs_version_number

Line 909: FROM IGS_GR_AWD_CRMN

905: ) AS
906:
907: CURSOR cur_rowid IS
908: SELECT rowid
909: FROM IGS_GR_AWD_CRMN
910: WHERE grd_cal_type = x_grd_cal_type
911: AND grd_ci_sequence_number = x_grd_ci_sequence_number
912: AND ceremony_number = x_ceremony_number
913: AND award_course_cd = x_award_course_cd

Line 946: FROM IGS_GR_AWD_CRMN

942: ) AS
943:
944: CURSOR cur_rowid IS
945: SELECT rowid
946: FROM IGS_GR_AWD_CRMN
947: WHERE grd_cal_type = x_grd_cal_type
948: AND grd_ci_sequence_number = x_grd_ci_sequence_number
949: AND ceremony_number = x_ceremony_number
950: AND award_course_cd = x_award_course_cd

Line 1132: cursor C is select ROWID from IGS_GR_AWD_CRMN

1128: X_US_GROUP_NUMBER in NUMBER,
1129: X_ORDER_IN_PRESENTATION in NUMBER,
1130: X_MODE in VARCHAR2
1131: ) AS
1132: cursor C is select ROWID from IGS_GR_AWD_CRMN
1133: where GAC_ID = X_GAC_ID;
1134: X_LAST_UPDATE_DATE DATE;
1135: X_LAST_UPDATED_BY NUMBER;
1136: X_LAST_UPDATE_LOGIN NUMBER;

Line 1143: SELECT IGS_GR_AWD_CRMN_GAC_ID_S.NEXTVAL INTO X_GAC_ID FROM DUAL;

1139: X_PROGRAM_APPLICATION_ID NUMBER;
1140: X_PROGRAM_UPDATE_DATE DATE;
1141: begin
1142:
1143: SELECT IGS_GR_AWD_CRMN_GAC_ID_S.NEXTVAL INTO X_GAC_ID FROM DUAL;
1144:
1145: X_LAST_UPDATE_DATE := SYSDATE;
1146: if(X_MODE = 'I') then
1147: X_LAST_UPDATED_BY := 1;

Line 1207: insert into IGS_GR_AWD_CRMN (

1203: x_last_updated_by => X_LAST_UPDATED_BY,
1204: x_last_update_login => X_LAST_UPDATE_LOGIN
1205: );
1206:
1207: insert into IGS_GR_AWD_CRMN (
1208: GRADUAND_SEAT_NUMBER,
1209: NAME_PRONUNCIATION,
1210: NAME_ANNOUNCED,
1211: ACADEMIC_DRESS_RQRD_IND,

Line 1339: from IGS_GR_AWD_CRMN

1335: AWARD_CRS_VERSION_NUMBER,
1336: AWARD_CD,
1337: US_GROUP_NUMBER,
1338: ORDER_IN_PRESENTATION
1339: from IGS_GR_AWD_CRMN
1340: where ROWID = X_ROWID for update nowait;
1341: tlinfo c1%rowtype;
1342:
1343: begin

Line 1513: update IGS_GR_AWD_CRMN set

1509: X_PROGRAM_UPDATE_DATE := SYSDATE;
1510: end if;
1511: end if;
1512:
1513: update IGS_GR_AWD_CRMN set
1514: GRADUAND_SEAT_NUMBER = NEW_REFERENCES.GRADUAND_SEAT_NUMBER,
1515: NAME_PRONUNCIATION = NEW_REFERENCES.NAME_PRONUNCIATION,
1516: NAME_ANNOUNCED = NEW_REFERENCES.NAME_ANNOUNCED,
1517: ACADEMIC_DRESS_RQRD_IND = NEW_REFERENCES.ACADEMIC_DRESS_RQRD_IND,

Line 1583: cursor c1 is select rowid from IGS_GR_AWD_CRMN

1579: X_US_GROUP_NUMBER in NUMBER,
1580: X_ORDER_IN_PRESENTATION in NUMBER,
1581: X_MODE in VARCHAR2
1582: ) AS
1583: cursor c1 is select rowid from IGS_GR_AWD_CRMN
1584: where GAC_ID = X_GAC_ID
1585: ;
1586:
1587: begin

Line 1654: delete from IGS_GR_AWD_CRMN

1650: X_ROWID in VARCHAR2
1651: ) AS
1652: begin
1653:
1654: delete from IGS_GR_AWD_CRMN
1655: where ROWID = X_ROWID;
1656: if (sql%notfound) then
1657: raise no_data_found;
1658: end if;

Line 1667: end IGS_GR_AWD_CRMN_PKG;

1663: );
1664:
1665: end DELETE_ROW;
1666:
1667: end IGS_GR_AWD_CRMN_PKG;