APPS.IGS_PS_UNIT_PKG dependencies on IGS_PS_UNIT

Line 1: package body IGS_PS_UNIT_PKG as

1: package body IGS_PS_UNIT_PKG as
2: /* $Header: IGSPI73B.pls 115.5 2003/02/18 11:01:05 shtatiko ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_UNIT%RowType;
5: new_references IGS_PS_UNIT%RowType;

Line 4: old_references IGS_PS_UNIT%RowType;

1: package body IGS_PS_UNIT_PKG as
2: /* $Header: IGSPI73B.pls 115.5 2003/02/18 11:01:05 shtatiko ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_UNIT%RowType;
5: new_references IGS_PS_UNIT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PS_UNIT%RowType;

1: package body IGS_PS_UNIT_PKG as
2: /* $Header: IGSPI73B.pls 115.5 2003/02/18 11:01:05 shtatiko ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_UNIT%RowType;
5: new_references IGS_PS_UNIT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 20: FROM IGS_PS_UNIT

16: ) AS
17:
18: CURSOR cur_old_ref_values IS
19: SELECT *
20: FROM IGS_PS_UNIT
21: WHERE rowid = x_rowid;
22:
23: BEGIN
24:

Line 58: IGS_PS_PAT_STUDY_UNT_PKG.GET_FK_IGS_PS_UNIT (

54:
55: PROCEDURE Check_Child_Existance AS
56: BEGIN
57:
58: IGS_PS_PAT_STUDY_UNT_PKG.GET_FK_IGS_PS_UNIT (
59: old_references.unit_cd
60: );
61:
62: IGS_PE_PERS_UNT_EXCL_PKG.GET_FK_IGS_PS_UNIT (

Line 62: IGS_PE_PERS_UNT_EXCL_PKG.GET_FK_IGS_PS_UNIT (

58: IGS_PS_PAT_STUDY_UNT_PKG.GET_FK_IGS_PS_UNIT (
59: old_references.unit_cd
60: );
61:
62: IGS_PE_PERS_UNT_EXCL_PKG.GET_FK_IGS_PS_UNIT (
63: old_references.unit_cd
64: );
65:
66: IGS_PE_UNT_REQUIRMNT_PKG.GET_FK_IGS_PS_UNIT (

Line 66: IGS_PE_UNT_REQUIRMNT_PKG.GET_FK_IGS_PS_UNIT (

62: IGS_PE_PERS_UNT_EXCL_PKG.GET_FK_IGS_PS_UNIT (
63: old_references.unit_cd
64: );
65:
66: IGS_PE_UNT_REQUIRMNT_PKG.GET_FK_IGS_PS_UNIT (
67: old_references.unit_cd
68: );
69:
70: IGS_PR_OU_UNIT_PKG.GET_FK_IGS_PS_UNIT (

Line 70: IGS_PR_OU_UNIT_PKG.GET_FK_IGS_PS_UNIT (

66: IGS_PE_UNT_REQUIRMNT_PKG.GET_FK_IGS_PS_UNIT (
67: old_references.unit_cd
68: );
69:
70: IGS_PR_OU_UNIT_PKG.GET_FK_IGS_PS_UNIT (
71: old_references.unit_cd
72: );
73:
74: IGS_PR_STDNT_PR_UNIT_PKG.GET_FK_IGS_PS_UNIT (

Line 74: IGS_PR_STDNT_PR_UNIT_PKG.GET_FK_IGS_PS_UNIT (

70: IGS_PR_OU_UNIT_PKG.GET_FK_IGS_PS_UNIT (
71: old_references.unit_cd
72: );
73:
74: IGS_PR_STDNT_PR_UNIT_PKG.GET_FK_IGS_PS_UNIT (
75: old_references.unit_cd
76: );
77:
78: IGS_EN_SU_ATTEMPT_PKG.GET_FK_IGS_PS_UNIT (

Line 78: IGS_EN_SU_ATTEMPT_PKG.GET_FK_IGS_PS_UNIT (

74: IGS_PR_STDNT_PR_UNIT_PKG.GET_FK_IGS_PS_UNIT (
75: old_references.unit_cd
76: );
77:
78: IGS_EN_SU_ATTEMPT_PKG.GET_FK_IGS_PS_UNIT (
79: old_references.unit_cd
80: );
81:
82: IGS_FI_UNIT_FEE_TRG_PKG.GET_FK_IGS_PS_UNIT (

Line 82: IGS_FI_UNIT_FEE_TRG_PKG.GET_FK_IGS_PS_UNIT (

78: IGS_EN_SU_ATTEMPT_PKG.GET_FK_IGS_PS_UNIT (
79: old_references.unit_cd
80: );
81:
82: IGS_FI_UNIT_FEE_TRG_PKG.GET_FK_IGS_PS_UNIT (
83: old_references.unit_cd
84: );
85:
86: IGS_PS_UNIT_RU_PKG.GET_FK_IGS_PS_UNIT (

Line 86: IGS_PS_UNIT_RU_PKG.GET_FK_IGS_PS_UNIT (

82: IGS_FI_UNIT_FEE_TRG_PKG.GET_FK_IGS_PS_UNIT (
83: old_references.unit_cd
84: );
85:
86: IGS_PS_UNIT_RU_PKG.GET_FK_IGS_PS_UNIT (
87: old_references.unit_cd
88: );
89:
90: IGS_PS_UNIT_VER_PKG.GET_FK_IGS_PS_UNIT (

Line 90: IGS_PS_UNIT_VER_PKG.GET_FK_IGS_PS_UNIT (

86: IGS_PS_UNIT_RU_PKG.GET_FK_IGS_PS_UNIT (
87: old_references.unit_cd
88: );
89:
90: IGS_PS_UNIT_VER_PKG.GET_FK_IGS_PS_UNIT (
91: old_references.unit_cd
92: );
93:
94: END Check_Child_Existance;

Line 108: FROM IGS_PS_UNIT

104: ***************************************************************************************/
105:
106: CURSOR cur_rowid IS
107: SELECT rowid
108: FROM IGS_PS_UNIT
109: WHERE unit_cd = x_unit_cd;
110:
111: lv_rowid cur_rowid%RowType;
112:

Line 218: cursor C is select ROWID from IGS_PS_UNIT

214: X_ROWID in out NOCOPY VARCHAR2,
215: X_UNIT_CD in VARCHAR2,
216: X_MODE in VARCHAR2 default 'R'
217: ) AS
218: cursor C is select ROWID from IGS_PS_UNIT
219: where UNIT_CD = X_UNIT_CD;
220: X_LAST_UPDATE_DATE DATE;
221: X_LAST_UPDATED_BY NUMBER;
222: X_LAST_UPDATE_LOGIN NUMBER;

Line 253: insert into IGS_PS_UNIT (

249: x_last_updated_by => X_LAST_UPDATED_BY,
250: x_last_update_login => X_LAST_UPDATE_LOGIN
251: );
252:
253: insert into IGS_PS_UNIT (
254: UNIT_CD,
255: CREATION_DATE,
256: CREATED_BY,
257: LAST_UPDATE_DATE,

Line 288: from IGS_PS_UNIT

284: X_ROWID IN VARCHAR2,
285: X_UNIT_CD in VARCHAR2
286: ) AS
287: cursor c1 is select ROWID
288: from IGS_PS_UNIT
289: where ROWID = X_ROWID
290: for update nowait;
291: tlinfo c1%rowtype;
292:

Line 316: delete from IGS_PS_UNIT

312: Before_DML(
313: p_action => 'DELETE',
314: x_rowid => X_ROWID
315: );
316: delete from IGS_PS_UNIT
317: where ROWID = X_ROWID;
318: if (sql%notfound) then
319: raise no_data_found;
320: end if;

Line 327: end IGS_PS_UNIT_PKG;

323: x_rowid => X_ROWID
324: );
325: end DELETE_ROW;
326:
327: end IGS_PS_UNIT_PKG;