APPS.IGS_PS_GRP_MBR_PKG dependencies on IGS_PS_GRP_MBR

Line 1: package body IGS_PS_GRP_MBR_PKG AS

1: package body IGS_PS_GRP_MBR_PKG AS
2: /* $Header: IGSPI17B.pls 115.4 2003/02/20 10:34:13 shtatiko ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_GRP_MBR%RowType;

Line 5: old_references IGS_PS_GRP_MBR%RowType;

1: package body IGS_PS_GRP_MBR_PKG AS
2: /* $Header: IGSPI17B.pls 115.4 2003/02/20 10:34:13 shtatiko ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_GRP_MBR%RowType;
6: new_references IGS_PS_GRP_MBR%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_GRP_MBR%RowType;

2: /* $Header: IGSPI17B.pls 115.4 2003/02/20 10:34:13 shtatiko ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_GRP_MBR%RowType;
6: new_references IGS_PS_GRP_MBR%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_PS_GRP_MBR

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

Line 63: -- ON IGS_PS_GRP_MBR

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

Line 72: v_course_cd IGS_PS_GRP_MBR.course_cd%TYPE;

68: p_updating IN BOOLEAN DEFAULT FALSE,
69: p_deleting IN BOOLEAN DEFAULT FALSE
70: ) AS
71: v_message_name varchar2(30);
72: v_course_cd IGS_PS_GRP_MBR.course_cd%TYPE;
73: v_version_number IGS_PS_GRP_MBR.version_number%TYPE;
74: v_course_group_cd IGS_PS_GRP_MBR.course_group_cd%TYPE;
75: BEGIN
76:

Line 73: v_version_number IGS_PS_GRP_MBR.version_number%TYPE;

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

Line 74: v_course_group_cd IGS_PS_GRP_MBR.course_group_cd%TYPE;

70: ) AS
71: v_message_name varchar2(30);
72: v_course_cd IGS_PS_GRP_MBR.course_cd%TYPE;
73: v_version_number IGS_PS_GRP_MBR.version_number%TYPE;
74: v_course_group_cd IGS_PS_GRP_MBR.course_group_cd%TYPE;
75: BEGIN
76:
77: -- Set variables.
78: IF p_deleting THEN

Line 187: FROM IGS_PS_GRP_MBR

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

Line 216: FROM IGS_PS_GRP_MBR

212: ) AS
213:
214: CURSOR cur_rowid IS
215: SELECT rowid
216: FROM IGS_PS_GRP_MBR
217: WHERE course_cd = x_course_cd
218: AND version_number = x_version_number ;
219:
220: lv_rowid cur_rowid%RowType;

Line 319: cursor C is select ROWID from IGS_PS_GRP_MBR

315: X_COURSE_GROUP_CD in VARCHAR2,
316: X_VERSION_NUMBER in NUMBER,
317: X_MODE in VARCHAR2 default 'R'
318: ) AS
319: cursor C is select ROWID from IGS_PS_GRP_MBR
320: where COURSE_CD = X_COURSE_CD
321: and COURSE_GROUP_CD = X_COURSE_GROUP_CD
322: and VERSION_NUMBER = X_VERSION_NUMBER;
323: X_LAST_UPDATE_DATE DATE;

Line 359: insert into IGS_PS_GRP_MBR (

355: x_last_updated_by => X_LAST_UPDATED_BY ,
356: x_last_update_login => X_LAST_UPDATE_LOGIN
357: );
358:
359: insert into IGS_PS_GRP_MBR (
360: COURSE_CD,
361: VERSION_NUMBER,
362: COURSE_GROUP_CD,
363: CREATION_DATE,

Line 399: from IGS_PS_GRP_MBR

395: X_COURSE_GROUP_CD in VARCHAR2,
396: X_VERSION_NUMBER in NUMBER
397: ) AS
398: cursor c1 is select ROWID
399: from IGS_PS_GRP_MBR
400: where ROWID = X_ROWID
401: for update nowait;
402: tlinfo c1%rowtype;
403:

Line 427: delete from IGS_PS_GRP_MBR

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

Line 438: end IGS_PS_GRP_MBR_PKG;

434: x_rowid => X_ROWID
435: );
436: end DELETE_ROW;
437:
438: end IGS_PS_GRP_MBR_PKG;