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_GRADUAND_PKG dependencies on IGS_GR_GRADUAND_ALL

Line 5: old_references IGS_GR_GRADUAND_ALL%RowType;

1: package body IGS_GR_GRADUAND_PKG as
2: /* $Header: IGSGI12B.pls 115.16 2003/10/08 09:10:33 ijeddy ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GR_GRADUAND_ALL%RowType;
6: new_references IGS_GR_GRADUAND_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_GR_GRADUAND_ALL%RowType;

2: /* $Header: IGSGI12B.pls 115.16 2003/10/08 09:10:33 ijeddy ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GR_GRADUAND_ALL%RowType;
6: new_references IGS_GR_GRADUAND_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 62: FROM IGS_GR_GRADUAND_ALL

58: ) AS
59:
60: CURSOR cur_old_ref_values IS
61: SELECT *
62: FROM IGS_GR_GRADUAND_ALL
63: WHERE rowid = x_rowid;
64:
65: BEGIN
66:

Line 141: -- ON IGS_GR_GRADUAND_ALL

137:
138: -- Trigger description :-
139: -- "OSS_TST".trg_gr_br_iu
140: -- BEFORE INSERT OR UPDATE
141: -- ON IGS_GR_GRADUAND_ALL
142: -- FOR EACH ROW
143:
144: PROCEDURE BeforeRowInsertUpdate1(
145: p_inserting IN BOOLEAN ,

Line 350: -- ON IGS_GR_GRADUAND_ALL

346:
347: -- Trigger description :-
348: -- "OSS_TST".trg_gr_ar_iu
349: -- AFTER INSERT OR UPDATE
350: -- ON IGS_GR_GRADUAND_ALL
351: -- FOR EACH ROW
352:
353: PROCEDURE AfterRowInsertUpdate2(
354: p_inserting IN BOOLEAN ,

Line 387: -- ON IGS_GR_GRADUAND_ALL

383:
384: -- Trigger description :-
385: -- "OSS_TST".trg_gr_ar_u_hist
386: -- AFTER UPDATE
387: -- ON IGS_GR_GRADUAND_ALL
388: -- FOR EACH ROW
389:
390: PROCEDURE AfterRowUpdate3(
391: p_inserting IN BOOLEAN ,

Line 828: FROM IGS_GR_GRADUAND_ALL

824: ) RETURN BOOLEAN AS
825:
826: CURSOR cur_rowid IS
827: SELECT rowid
828: FROM IGS_GR_GRADUAND_ALL
829: WHERE person_id = x_person_id
830: AND create_dt = x_create_dt
831: FOR UPDATE NOWAIT;
832:

Line 859: FROM IGS_GR_GRADUAND_ALL

855: ) RETURN BOOLEAN AS
856:
857: CURSOR cur_rowid IS
858: SELECT rowid
859: FROM IGS_GR_GRADUAND_ALL
860: WHERE person_id = x_person_id
861: AND create_dt = x_create_dt
862: AND award_course_cd = x_award_course_cd
863: AND award_crs_version_number = x_award_crs_version_number

Line 892: FROM IGS_GR_GRADUAND_ALL

888: ) AS
889:
890: CURSOR cur_rowid IS
891: SELECT rowid
892: FROM IGS_GR_GRADUAND_ALL
893: WHERE grd_cal_type = x_grd_cal_type
894: AND grd_ci_sequence_number = x_grd_ci_sequence_number ;
895:
896: lv_rowid cur_rowid%RowType;

Line 919: FROM IGS_GR_GRADUAND_ALL

915: ) AS
916:
917: CURSOR cur_rowid IS
918: SELECT rowid
919: FROM IGS_GR_GRADUAND_ALL
920: WHERE graduand_appr_status = x_graduand_appr_status ;
921:
922: lv_rowid cur_rowid%RowType;
923:

Line 945: FROM IGS_GR_GRADUAND_ALL

941: ) AS
942:
943: CURSOR cur_rowid IS
944: SELECT rowid
945: FROM IGS_GR_GRADUAND_ALL
946: WHERE graduand_status = x_graduand_status ;
947:
948: lv_rowid cur_rowid%RowType;
949:

Line 978: FROM IGS_GR_GRADUAND_ALL

974: ) AS
975:
976: CURSOR cur_rowid IS
977: SELECT rowid
978: FROM IGS_GR_GRADUAND_ALL
979: WHERE (person_id = x_person_id)
980: OR (proxy_award_person_id = x_person_id);
981:
982: lv_rowid cur_rowid%RowType;

Line 1006: FROM IGS_GR_GRADUAND_ALL

1002: ) AS
1003:
1004: CURSOR cur_rowid IS
1005: SELECT rowid
1006: FROM IGS_GR_GRADUAND_ALL
1007: WHERE person_id = x_person_id
1008: AND course_cd = x_course_cd ;
1009:
1010: lv_rowid cur_rowid%RowType;

Line 1035: FROM IGS_GR_GRADUAND_ALL

1031: ) AS
1032:
1033: CURSOR cur_rowid IS
1034: SELECT rowid
1035: FROM IGS_GR_GRADUAND_ALL
1036: WHERE person_id = x_person_id
1037: AND course_cd = x_course_cd
1038: AND award_cd = x_award_cd;
1039:

Line 1290: cursor C is select ROWID from IGS_GR_GRADUAND_ALL

1286: X_ATTRIBUTE18 IN VARCHAR2 ,
1287: X_ATTRIBUTE19 IN VARCHAR2 ,
1288: X_ATTRIBUTE20 IN VARCHAR2
1289: ) AS
1290: cursor C is select ROWID from IGS_GR_GRADUAND_ALL
1291: where PERSON_ID = X_PERSON_ID
1292: and CREATE_DT = NEW_REFERENCES.CREATE_DT;
1293: X_LAST_UPDATE_DATE DATE;
1294: X_LAST_UPDATED_BY NUMBER;

Line 1383: insert into IGS_GR_GRADUAND_ALL (

1379: x_attribute19=>X_ATTRIBUTE19,
1380: x_attribute20=>X_ATTRIBUTE20
1381: );
1382:
1383: insert into IGS_GR_GRADUAND_ALL (
1384: PERSON_ID,
1385: CREATE_DT,
1386: GRD_CAL_TYPE,
1387: GRD_CI_SEQUENCE_NUMBER,

Line 1590: from IGS_GR_GRADUAND_ALL

1586: ATTRIBUTE17,
1587: ATTRIBUTE18,
1588: ATTRIBUTE19,
1589: ATTRIBUTE20
1590: from IGS_GR_GRADUAND_ALL
1591: where ROWID = X_ROWID for update nowait;
1592: tlinfo c1%rowtype;
1593:
1594: begin

Line 1851: update IGS_GR_GRADUAND_ALL set

1847: else
1848: X_PROGRAM_UPDATE_DATE := SYSDATE;
1849: end if;
1850: end if;
1851: update IGS_GR_GRADUAND_ALL set
1852: GRD_CAL_TYPE = NEW_REFERENCES.GRD_CAL_TYPE,
1853: GRD_CI_SEQUENCE_NUMBER = NEW_REFERENCES.GRD_CI_SEQUENCE_NUMBER,
1854: COURSE_CD = NEW_REFERENCES.COURSE_CD,
1855: AWARD_COURSE_CD = NEW_REFERENCES.AWARD_COURSE_CD,

Line 1958: cursor c1 is select rowid from IGS_GR_GRADUAND_ALL

1954: X_ATTRIBUTE18 IN VARCHAR2 ,
1955: X_ATTRIBUTE19 IN VARCHAR2 ,
1956: X_ATTRIBUTE20 IN VARCHAR2
1957: ) AS
1958: cursor c1 is select rowid from IGS_GR_GRADUAND_ALL
1959: where PERSON_ID = X_PERSON_ID
1960: and CREATE_DT = NVL(X_CREATE_DT, SYSDATE)
1961: ;
1962:

Line 2078: delete from IGS_GR_GRADUAND_ALL

2074: p_action => 'DELETE',
2075: x_rowid => X_ROWID
2076: );
2077:
2078: delete from IGS_GR_GRADUAND_ALL
2079: where ROWID = X_ROWID;
2080: if (sql%notfound) then
2081: raise no_data_found;
2082: end if;