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_AS_GRD_SCHEMA_PKG dependencies on IGS_AS_GRD_SCHEMA

Line 1: PACKAGE BODY IGS_AS_GRD_SCHEMA_PKG AS

1: PACKAGE BODY IGS_AS_GRD_SCHEMA_PKG AS
2: /* $Header: IGSDI23B.pls 115.13 2003/10/09 09:44:18 anilk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_GRD_SCHEMA%ROWTYPE;
5: new_references IGS_AS_GRD_SCHEMA%ROWTYPE;

Line 4: old_references IGS_AS_GRD_SCHEMA%ROWTYPE;

1: PACKAGE BODY IGS_AS_GRD_SCHEMA_PKG AS
2: /* $Header: IGSDI23B.pls 115.13 2003/10/09 09:44:18 anilk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_GRD_SCHEMA%ROWTYPE;
5: new_references IGS_AS_GRD_SCHEMA%ROWTYPE;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AS_GRD_SCHEMA%ROWTYPE;

1: PACKAGE BODY IGS_AS_GRD_SCHEMA_PKG AS
2: /* $Header: IGSDI23B.pls 115.13 2003/10/09 09:44:18 anilk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_GRD_SCHEMA%ROWTYPE;
5: new_references IGS_AS_GRD_SCHEMA%ROWTYPE;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 47: FROM IGS_AS_GRD_SCHEMA

43: ) AS
44:
45: CURSOR cur_old_ref_values IS
46: SELECT *
47: FROM IGS_AS_GRD_SCHEMA
48: WHERE ROWID = x_rowid;
49:
50: BEGIN
51:

Line 137: -- ON IGS_AS_GRD_SCHEMA

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

Line 176: FROM IGS_AS_GRD_SCHEMA

172: ) IS
173:
174: CURSOR cur_rowid IS
175: SELECT ROWID
176: FROM IGS_AS_GRD_SCHEMA
177: WHERE grading_schema_type = x_grading_schema_type ;
178:
179: lv_rowid cur_rowid%ROWTYPE;
180:

Line 199: -- ON IGS_AS_GRD_SCHEMA

195:
196: -- Trigger description :-
197: -- "OSS_TST".trg_gs_as_iu
198: -- AFTER INSERT OR UPDATE
199: -- ON IGS_AS_GRD_SCHEMA
200:
201:
202: PROCEDURE Check_Child_Existance AS
203: BEGIN

Line 205: IGS_PS_OFR_PAT_PKG.GET_FK_IGS_AS_GRD_SCHEMA (

201:
202: PROCEDURE Check_Child_Existance AS
203: BEGIN
204:
205: IGS_PS_OFR_PAT_PKG.GET_FK_IGS_AS_GRD_SCHEMA (
206: old_references.grading_schema_cd,
207: old_references.version_number
208: );
209:

Line 210: IGS_AS_GRD_SCH_GRADE_PKG.GET_FK_IGS_AS_GRD_SCHEMA (

206: old_references.grading_schema_cd,
207: old_references.version_number
208: );
209:
210: IGS_AS_GRD_SCH_GRADE_PKG.GET_FK_IGS_AS_GRD_SCHEMA (
211: old_references.grading_schema_cd,
212: old_references.version_number
213: );
214:

Line 220: IGS_PS_UNIT_OFR_OPT_PKG.GET_FK_IGS_AS_GRD_SCHEMA (

216: old_references.grading_schema_cd,
217: old_references.version_number
218: );
219:
220: IGS_PS_UNIT_OFR_OPT_PKG.GET_FK_IGS_AS_GRD_SCHEMA (
221: old_references.grading_schema_cd,
222: old_references.version_number
223: );
224:

Line 227: IGS_PS_UNIT_GRD_SCHM_PKG.GET_FK_IGS_AS_GRD_SCHEMA (

223: );
224:
225: ---Added on 13th may b'cos of the new relation with new table.,
226:
227: IGS_PS_UNIT_GRD_SCHM_PKG.GET_FK_IGS_AS_GRD_SCHEMA (
228: old_references.grading_schema_cd,
229:
230: old_references.version_number);
231: ---Added on 18th may

Line 233: IGS_PS_USEC_GRD_SCHM_PKG.GET_FK_IGS_AS_GRD_SCHEMA (

229:
230: old_references.version_number);
231: ---Added on 18th may
232:
233: IGS_PS_USEC_GRD_SCHM_PKG.GET_FK_IGS_AS_GRD_SCHEMA (
234: old_references.GRADING_SCHEMA_CD ,
235: old_references.VERSION_NUMBER
236: );
237:

Line 240: IGS_AS_UNITASS_ITEM_PKG.GET_FK_IGS_AS_GRD_SCHEMA (

236: );
237:
238: -- Added by DDEY as a part of Enhancement Bug # 2162831
239:
240: IGS_AS_UNITASS_ITEM_PKG.GET_FK_IGS_AS_GRD_SCHEMA (
241: old_references.grading_schema_cd ,
242: old_references.version_number
243: );
244:

Line 247: IGS_PS_UNITASS_ITEM_PKG.GET_FK_IGS_AS_GRD_SCHEMA (

243: );
244:
245: -- Added by DDEY as a part of Enhancement Bug # 2162831
246:
247: IGS_PS_UNITASS_ITEM_PKG.GET_FK_IGS_AS_GRD_SCHEMA (
248: old_references.grading_schema_cd ,
249: old_references.version_number
250: );
251:

Line 254: IGS_PS_AWD_PKG.GET_FK_IGS_AS_GRD_SCHEMA (

250: );
251:
252: -- Added by aiyer for the build of PSCR015 Tertiary And Secondary Bug No #2216952
253:
254: IGS_PS_AWD_PKG.GET_FK_IGS_AS_GRD_SCHEMA (
255: old_references.grading_schema_cd ,
256: old_references.version_number
257: );
258:

Line 266: IGS_EN_SPAA_HIST_PKG.GET_FK_IGS_AS_GRD_SCHEMA (

262: old_references.version_number
263: );
264:
265: -- Added by anilk for the build of Program Completion Validation , Bug# 3129913
266: IGS_EN_SPAA_HIST_PKG.GET_FK_IGS_AS_GRD_SCHEMA (
267: old_references.grading_schema_cd ,
268: old_references.version_number
269: );
270:

Line 280: FROM IGS_AS_GRD_SCHEMA

276: ) RETURN BOOLEAN AS
277:
278: CURSOR cur_rowid IS
279: SELECT ROWID
280: FROM IGS_AS_GRD_SCHEMA
281: WHERE grading_schema_cd = x_grading_schema_cd
282: AND version_number = x_version_number
283: ;
284:

Line 472: CURSOR C IS SELECT ROWID FROM IGS_AS_GRD_SCHEMA

468: X_MODE IN VARCHAR2 DEFAULT 'R',
469: x_grading_schema_type IN VARCHAR2
470:
471: ) AS
472: CURSOR C IS SELECT ROWID FROM IGS_AS_GRD_SCHEMA
473: WHERE GRADING_SCHEMA_CD = X_GRADING_SCHEMA_CD
474: AND VERSION_NUMBER = X_VERSION_NUMBER;
475: X_LAST_UPDATE_DATE DATE;
476: X_LAST_UPDATED_BY NUMBER;

Line 534: INSERT INTO IGS_AS_GRD_SCHEMA (

530: x_last_updated_by=>X_LAST_UPDATED_BY,
531: x_last_update_login=>X_LAST_UPDATE_LOGIN,
532: x_grading_schema_type => x_grading_schema_type
533: );
534: INSERT INTO IGS_AS_GRD_SCHEMA (
535: GRADING_SCHEMA_CD,
536: VERSION_NUMBER,
537: DESCRIPTION,
538: START_DT,

Line 675: FROM IGS_AS_GRD_SCHEMA

671: , ATTRIBUTE18
672: , ATTRIBUTE19
673: , ATTRIBUTE20
674: , grading_schema_type
675: FROM IGS_AS_GRD_SCHEMA
676: WHERE ROWID = X_ROWID FOR UPDATE NOWAIT;
677: tlinfo c1%ROWTYPE;
678:
679: BEGIN

Line 868: UPDATE IGS_AS_GRD_SCHEMA SET

864: x_last_updated_by=>X_LAST_UPDATED_BY,
865: x_last_update_login=>X_LAST_UPDATE_LOGIN,
866: x_grading_schema_type =>x_grading_schema_type
867: );
868: UPDATE IGS_AS_GRD_SCHEMA SET
869: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
870: START_DT = NEW_REFERENCES.START_DT,
871: END_DT = NEW_REFERENCES.END_DT,
872: COMMENTS = NEW_REFERENCES.COMMENTS,

Line 941: CURSOR c1 IS SELECT ROWID FROM IGS_AS_GRD_SCHEMA

937: x_ATTRIBUTE20 IN VARCHAR2,
938: X_MODE IN VARCHAR2 DEFAULT 'R',
939: x_grading_schema_type IN VARCHAR2
940: ) AS
941: CURSOR c1 IS SELECT ROWID FROM IGS_AS_GRD_SCHEMA
942: WHERE GRADING_SCHEMA_CD = X_GRADING_SCHEMA_CD
943: AND VERSION_NUMBER = X_VERSION_NUMBER;
944: BEGIN
945: OPEN c1;

Line 1051: END IGS_AS_GRD_SCHEMA_PKG;

1047: END IF;
1048:
1049: END Check_Constraints;
1050:
1051: END IGS_AS_GRD_SCHEMA_PKG;