APPS.IGS_AS_GRD_SCH_TRN_PKG dependencies on IGS_AS_GRD_SCH_TRN_ALL

Line 4: old_references IGS_AS_GRD_SCH_TRN_ALL%RowType;

1: package body IGS_AS_GRD_SCH_TRN_PKG AS
2: /* $Header: IGSDI15B.pls 115.6 2003/12/09 11:29:51 ijeddy ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_GRD_SCH_TRN_ALL%RowType;
5: new_references IGS_AS_GRD_SCH_TRN_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_AS_GRD_SCH_TRN_ALL%RowType;

1: package body IGS_AS_GRD_SCH_TRN_PKG AS
2: /* $Header: IGSDI15B.pls 115.6 2003/12/09 11:29:51 ijeddy ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_GRD_SCH_TRN_ALL%RowType;
5: new_references IGS_AS_GRD_SCH_TRN_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_org_id IN NUMBER DEFAULT NULL,

Line 24: FROM IGS_AS_GRD_SCH_TRN_ALL

20: x_last_update_login IN NUMBER DEFAULT NULL
21: ) AS
22: CURSOR cur_old_ref_values IS
23: SELECT *
24: FROM IGS_AS_GRD_SCH_TRN_ALL
25: WHERE rowid = x_rowid;
26: BEGIN
27: l_rowid := x_rowid;
28: -- Code for setting the Old and New Reference Values.

Line 174: FROM IGS_AS_GRD_SCH_TRN_ALL

170: x_to_grade IN VARCHAR2
171: ) RETURN BOOLEAN AS
172: CURSOR cur_rowid IS
173: SELECT rowid
174: FROM IGS_AS_GRD_SCH_TRN_ALL
175: WHERE grading_schema_cd = x_grading_schema_cd
176: AND version_number = x_version_number
177: AND grade = x_grade
178: AND to_grading_schema_cd = x_to_grading_schema_cd

Line 201: FROM IGS_AS_GRD_SCH_TRN_ALL

197: x_grade IN VARCHAR2
198: ) AS
199: CURSOR cur_rowid IS
200: SELECT rowid
201: FROM IGS_AS_GRD_SCH_TRN_ALL
202: WHERE to_grading_schema_cd = x_grading_schema_cd
203: AND to_version_number = x_version_number
204: AND to_grade = x_grade OR
205: (grading_schema_cd = x_grading_schema_cd

Line 314: cursor C is select ROWID from IGS_AS_GRD_SCH_TRN_ALL

310: X_TO_VERSION_NUMBER in NUMBER,
311: X_TO_GRADE in VARCHAR2,
312: X_MODE in VARCHAR2 default 'R'
313: ) AS
314: cursor C is select ROWID from IGS_AS_GRD_SCH_TRN_ALL
315: where GRADING_SCHEMA_CD = X_GRADING_SCHEMA_CD
316: and VERSION_NUMBER = X_VERSION_NUMBER
317: and GRADE = X_GRADE
318: and TO_GRADING_SCHEMA_CD = X_TO_GRADING_SCHEMA_CD

Line 359: insert into IGS_AS_GRD_SCH_TRN_ALL (

355: x_last_update_date=>X_LAST_UPDATE_DATE,
356: x_last_updated_by=>X_LAST_UPDATED_BY,
357: x_last_update_login=>X_LAST_UPDATE_LOGIN
358: );
359: insert into IGS_AS_GRD_SCH_TRN_ALL (
360: ORG_ID,
361: GRADING_SCHEMA_CD,
362: VERSION_NUMBER,
363: GRADE,

Line 406: from IGS_AS_GRD_SCH_TRN_ALL

402: X_TO_GRADE in VARCHAR2
403: ) AS
404: cursor c1 is select
405: ROWID
406: from IGS_AS_GRD_SCH_TRN_ALL
407: where ROWID = X_ROWID for update nowait;
408: tlinfo c1%rowtype;
409: begin
410: open c1;

Line 429: delete from IGS_AS_GRD_SCH_TRN_ALL

425: Before_DML(
426: p_action => 'DELETE',
427: x_rowid => X_ROWID
428: );
429: delete from IGS_AS_GRD_SCH_TRN_ALL
430: where ROWID = X_ROWID;
431: if (sql%notfound) then
432: raise no_data_found;
433: end if;