APPS.IGS_PS_CATEGORISE_PKG dependencies on IGS_PS_CATEGORISE_ALL

Line 5: old_references IGS_PS_CATEGORISE_ALL%RowType;

1: package body IGS_PS_CATEGORISE_PKG AS
2: /* $Header: IGSPI09B.pls 115.8 2002/11/29 01:54:36 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_CATEGORISE_ALL%RowType;
6: new_references IGS_PS_CATEGORISE_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_CATEGORISE_ALL%RowType;

2: /* $Header: IGSPI09B.pls 115.8 2002/11/29 01:54:36 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_CATEGORISE_ALL%RowType;
6: new_references IGS_PS_CATEGORISE_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_PS_CATEGORISE_ALL

20: ) AS
21:
22: CURSOR cur_old_ref_values IS
23: SELECT *
24: FROM IGS_PS_CATEGORISE_ALL
25: WHERE rowid = x_rowid;
26:
27: BEGIN
28:

Line 65: -- ON IGS_PS_CATEGORISE_ALL

61:
62: -- Trigger description :-
63: -- "OSS_TST".trg_crc_br_iud
64: -- BEFORE INSERT OR DELETE OR UPDATE
65: -- ON IGS_PS_CATEGORISE_ALL
66: -- FOR EACH ROW
67:
68: PROCEDURE BeforeRowInsertUpdateDelete1(
69: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 74: v_course_cd IGS_PS_CATEGORISE_ALL.course_cd%TYPE;

70: p_updating IN BOOLEAN DEFAULT FALSE,
71: p_deleting IN BOOLEAN DEFAULT FALSE
72: ) AS
73: v_message_name varchar2(30);
74: v_course_cd IGS_PS_CATEGORISE_ALL.course_cd%TYPE;
75: v_version_number IGS_PS_CATEGORISE_ALL.version_number%TYPE;
76: BEGIN
77:
78: -- Set variables.

Line 75: v_version_number IGS_PS_CATEGORISE_ALL.version_number%TYPE;

71: p_deleting IN BOOLEAN DEFAULT FALSE
72: ) AS
73: v_message_name varchar2(30);
74: v_course_cd IGS_PS_CATEGORISE_ALL.course_cd%TYPE;
75: v_version_number IGS_PS_CATEGORISE_ALL.version_number%TYPE;
76: BEGIN
77:
78: -- Set variables.
79: IF p_deleting THEN

Line 187: FROM IGS_PS_CATEGORISE_ALL

183: RETURN BOOLEAN AS
184:
185: CURSOR cur_rowid IS
186: SELECT rowid
187: FROM IGS_PS_CATEGORISE_ALL
188: WHERE course_cd = x_course_cd
189: AND version_number = x_version_number
190: AND course_cat = x_course_cat
191: FOR UPDATE NOWAIT;

Line 215: FROM IGS_PS_CATEGORISE_ALL

211: ) AS
212:
213: CURSOR cur_rowid IS
214: SELECT rowid
215: FROM IGS_PS_CATEGORISE_ALL
216: WHERE course_cat = x_course_cat ;
217:
218: lv_rowid cur_rowid%RowType;
219:

Line 242: FROM IGS_PS_CATEGORISE_ALL

238: ) AS
239:
240: CURSOR cur_rowid IS
241: SELECT rowid
242: FROM IGS_PS_CATEGORISE_ALL
243: WHERE course_cd = x_course_cd
244: AND version_number = x_version_number ;
245:
246: lv_rowid cur_rowid%RowType;

Line 356: cursor C is select ROWID from IGS_PS_CATEGORISE_ALL

352: X_COURSE_CAT in VARCHAR2,
353: X_MODE in VARCHAR2 default 'R',
354: X_ORG_ID in NUMBER
355: ) AS
356: cursor C is select ROWID from IGS_PS_CATEGORISE_ALL
357: where COURSE_CD = X_COURSE_CD
358: and VERSION_NUMBER = X_VERSION_NUMBER
359: and COURSE_CAT = X_COURSE_CAT;
360: X_LAST_UPDATE_DATE DATE;

Line 397: insert into IGS_PS_CATEGORISE_ALL (

393: x_last_update_login => X_LAST_UPDATE_LOGIN,
394: x_org_id => igs_ge_gen_003.get_org_id
395: );
396:
397: insert into IGS_PS_CATEGORISE_ALL (
398: COURSE_CD,
399: VERSION_NUMBER,
400: COURSE_CAT,
401: CREATION_DATE,

Line 442: from IGS_PS_CATEGORISE_ALL

438: X_COURSE_CAT in VARCHAR2
439:
440: ) AS
441: cursor c1 is select ROWID
442: from IGS_PS_CATEGORISE_ALL
443: where ROWID = X_ROWID
444: for update nowait;
445: tlinfo c1%rowtype;
446:

Line 473: delete from IGS_PS_CATEGORISE_ALL

469: p_action => 'DELETE',
470: x_rowid => X_ROWID
471: );
472:
473: delete from IGS_PS_CATEGORISE_ALL
474: where ROWID = X_ROWID;
475: if (sql%notfound) then
476: raise no_data_found;
477: end if;