APPS.IGS_AS_COURSE_TYPE_PKG dependencies on IGS_AS_COURSE_TYPE_ALL

Line 4: old_references IGS_AS_COURSE_TYPE_ALL%RowType;

1: package body IGS_AS_COURSE_TYPE_PKG as
2: /* $Header: IGSDI01B.pls 115.6 2003/06/05 12:56:57 sarakshi ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_COURSE_TYPE_ALL%RowType;
5: new_references IGS_AS_COURSE_TYPE_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_COURSE_TYPE_ALL%RowType;

1: package body IGS_AS_COURSE_TYPE_PKG as
2: /* $Header: IGSDI01B.pls 115.6 2003/06/05 12:56:57 sarakshi ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_COURSE_TYPE_ALL%RowType;
5: new_references IGS_AS_COURSE_TYPE_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 20: FROM IGS_AS_COURSE_TYPE_ALL

16: x_last_update_login IN NUMBER DEFAULT NULL
17: ) AS
18: CURSOR cur_old_ref_values IS
19: SELECT *
20: FROM IGS_AS_COURSE_TYPE_ALL
21: WHERE rowid = x_rowid;
22: BEGIN
23: l_rowid := x_rowid;
24: -- Code for setting the Old and New Reference Values.

Line 152: FROM IGS_AS_COURSE_TYPE_ALL

148: x_course_type IN VARCHAR2
149: ) RETURN BOOLEAN AS
150: CURSOR cur_rowid IS
151: SELECT rowid
152: FROM IGS_AS_COURSE_TYPE_ALL
153: WHERE ass_id = x_ass_id
154: AND course_type = x_course_type
155: FOR UPDATE NOWAIT;
156: lv_rowid cur_rowid%RowType;

Line 173: FROM IGS_AS_COURSE_TYPE_ALL

169: x_ass_id IN NUMBER
170: ) AS
171: CURSOR cur_rowid IS
172: SELECT rowid
173: FROM IGS_AS_COURSE_TYPE_ALL
174: WHERE ass_id = x_ass_id ;
175: lv_rowid cur_rowid%RowType;
176: BEGIN
177: Open cur_rowid;

Line 259: cursor C is select ROWID from IGS_AS_COURSE_TYPE_all

255: X_ASS_ID in NUMBER,
256: X_COURSE_TYPE in VARCHAR2,
257: X_MODE in VARCHAR2 default 'R'
258: ) AS
259: cursor C is select ROWID from IGS_AS_COURSE_TYPE_all
260: where ASS_ID = X_ASS_ID
261: and COURSE_TYPE = X_COURSE_TYPE;
262: X_LAST_UPDATE_DATE DATE;
263: X_LAST_UPDATED_BY NUMBER;

Line 296: insert into IGS_AS_COURSE_TYPE_ALL (

292: x_last_update_date=>X_LAST_UPDATE_DATE,
293: x_last_updated_by=>X_LAST_UPDATED_BY,
294: x_last_update_login=>X_LAST_UPDATE_LOGIN
295: );
296: insert into IGS_AS_COURSE_TYPE_ALL (
297: ASS_ID,
298: ORG_ID,
299: COURSE_TYPE,
300: CREATION_DATE,

Line 331: from IGS_AS_COURSE_TYPE_ALL

327: X_COURSE_TYPE in VARCHAR2
328: ) AS
329: cursor c1 is select
330: ROWID
331: from IGS_AS_COURSE_TYPE_ALL
332: where ROWID = X_ROWID for update nowait;
333: tlinfo c1%rowtype;
334: begin
335: open c1;

Line 354: delete from IGS_AS_COURSE_TYPE_ALL

350: Before_DML(
351: p_action => 'DELETE',
352: x_rowid => X_ROWID
353: );
354: delete from IGS_AS_COURSE_TYPE_ALL
355: where ROWID = X_ROWID;
356:
357: if (sql%notfound) then
358: raise no_data_found;