APPS.IGS_OR_REL_PS_TYPE_PKG dependencies on IGS_OR_REL_PS_TYPE

Line 1: package body IGS_OR_REL_PS_TYPE_PKG AS

1: package body IGS_OR_REL_PS_TYPE_PKG AS
2: /* $Header: IGSOI15B.pls 115.6 2003/06/05 13:01:56 sarakshi ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_OR_REL_PS_TYPE%RowType;
5: new_references IGS_OR_REL_PS_TYPE%RowType;

Line 4: old_references IGS_OR_REL_PS_TYPE%RowType;

1: package body IGS_OR_REL_PS_TYPE_PKG AS
2: /* $Header: IGSOI15B.pls 115.6 2003/06/05 13:01:56 sarakshi ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_OR_REL_PS_TYPE%RowType;
5: new_references IGS_OR_REL_PS_TYPE%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_OR_REL_PS_TYPE%RowType;

1: package body IGS_OR_REL_PS_TYPE_PKG AS
2: /* $Header: IGSOI15B.pls 115.6 2003/06/05 13:01:56 sarakshi ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_OR_REL_PS_TYPE%RowType;
5: new_references IGS_OR_REL_PS_TYPE%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_OR_REL_PS_TYPE

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

Line 111: FROM IGS_OR_REL_PS_TYPE

107: x_course_type IN VARCHAR2
108: )RETURN BOOLEAN AS
109: CURSOR cur_rowid IS
110: SELECT rowid
111: FROM IGS_OR_REL_PS_TYPE
112: WHERE parent_org_unit_cd = x_parent_org_unit_cd
113: AND parent_start_dt = x_parent_start_dt
114: AND child_org_unit_cd = x_child_org_unit_cd
115: AND child_start_dt = x_child_start_dt

Line 142: FROM IGS_OR_REL_PS_TYPE

138: x_create_dt IN DATE
139: ) AS
140: CURSOR cur_rowid IS
141: SELECT rowid
142: FROM IGS_OR_REL_PS_TYPE
143: WHERE parent_org_unit_cd = x_parent_org_unit_cd
144: AND parent_start_dt = x_parent_start_dt
145: AND child_org_unit_cd = x_child_org_unit_cd
146: AND child_start_dt = x_child_start_dt

Line 265: cursor C is select ROWID from IGS_OR_REL_PS_TYPE

261: X_OUR_CREATE_DT in DATE,
262: X_COURSE_TYPE in VARCHAR2,
263: X_MODE in VARCHAR2 default 'R'
264: ) AS
265: cursor C is select ROWID from IGS_OR_REL_PS_TYPE
266: where PARENT_ORG_UNIT_CD = X_PARENT_ORG_UNIT_CD
267: and PARENT_START_DT = X_PARENT_START_DT
268: and CHILD_ORG_UNIT_CD = X_CHILD_ORG_UNIT_CD
269: and CHILD_START_DT = X_CHILD_START_DT

Line 309: insert into IGS_OR_REL_PS_TYPE (

305: x_last_update_date=>X_LAST_UPDATE_DATE,
306: x_last_updated_by=>X_LAST_UPDATED_BY,
307: x_last_update_login=>X_LAST_UPDATE_LOGIN
308: );
309: insert into IGS_OR_REL_PS_TYPE (
310: PARENT_ORG_UNIT_CD,
311: PARENT_START_DT,
312: CHILD_ORG_UNIT_CD,
313: CHILD_START_DT,

Line 357: from IGS_OR_REL_PS_TYPE

353: X_OUR_CREATE_DT in DATE,
354: X_COURSE_TYPE in VARCHAR2
355: ) AS
356: cursor c1 is select rowid
357: from IGS_OR_REL_PS_TYPE
358: where ROWID = X_ROWID
359: for update nowait ;
360: tlinfo c1%rowtype;
361: begin

Line 382: delete from IGS_OR_REL_PS_TYPE

378: Before_DML(
379: p_action=>'DELETE',
380: x_rowid=>X_ROWID
381: );
382: delete from IGS_OR_REL_PS_TYPE
383: where ROWID = X_ROWID ;
384: if (sql%notfound) then
385: raise no_data_found;
386: end if;

Line 429: END IGS_OR_REL_PS_TYPE_PKG;

425: END IF ;
426:
427: END Check_Constraints ;
428:
429: END IGS_OR_REL_PS_TYPE_PKG;