APPS.IGS_PE_PERS_RELN_TYP_PKG dependencies on IGS_PE_PERS_RELN_TYP

Line 1: package body IGS_PE_PERS_RELN_TYP_PKG AS

1: package body IGS_PE_PERS_RELN_TYP_PKG AS
2: /* $Header: IGSNI30B.pls 115.3 2002/11/29 01:21:11 nsidana ship $ */
3:
4:
5: l_rowid VARCHAR2(25);

Line 6: old_references IGS_PE_PERS_RELN_TYP%RowType;

2: /* $Header: IGSNI30B.pls 115.3 2002/11/29 01:21:11 nsidana ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PE_PERS_RELN_TYP%RowType;
7: new_references IGS_PE_PERS_RELN_TYP%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_PE_PERS_RELN_TYP%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PE_PERS_RELN_TYP%RowType;
7: new_references IGS_PE_PERS_RELN_TYP%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_PE_PERS_RELN_TYP

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

Line 86: IGS_PE_PERS_RELATION_PKG.GET_FK_IGS_PE_PERS_RELN_TYP (

82:
83: PROCEDURE Check_Child_Existance AS
84: BEGIN
85:
86: IGS_PE_PERS_RELATION_PKG.GET_FK_IGS_PE_PERS_RELN_TYP (
87: old_references.person_relation_type
88: );
89:
90: END Check_Child_Existance;

Line 98: FROM IGS_PE_PERS_RELN_TYP

94: ) RETURN BOOLEAN AS
95:
96: CURSOR cur_rowid IS
97: SELECT rowid
98: FROM IGS_PE_PERS_RELN_TYP
99: WHERE person_relation_type = x_person_relation_type
100: FOR UPDATE NOWAIT;
101:
102: lv_rowid cur_rowid%RowType;

Line 210: cursor C is select ROWID from IGS_PE_PERS_RELN_TYP

206: X_PERSON_RELATION_TYPE in VARCHAR2,
207: X_DESCRIPTION in VARCHAR2,
208: X_MODE in VARCHAR2 default 'R'
209: ) AS
210: cursor C is select ROWID from IGS_PE_PERS_RELN_TYP
211: where PERSON_RELATION_TYPE = X_PERSON_RELATION_TYPE;
212: X_LAST_UPDATE_DATE DATE;
213: X_LAST_UPDATED_BY NUMBER;
214: X_LAST_UPDATE_LOGIN NUMBER;

Line 246: insert into IGS_PE_PERS_RELN_TYP (

242: x_last_updated_by=>X_LAST_UPDATED_BY,
243: x_last_update_login=>X_LAST_UPDATE_LOGIN
244: );
245:
246: insert into IGS_PE_PERS_RELN_TYP (
247: PERSON_RELATION_TYPE,
248: DESCRIPTION,
249: CREATION_DATE,
250: CREATED_BY,

Line 284: from IGS_PE_PERS_RELN_TYP

280: X_DESCRIPTION in VARCHAR2
281: ) AS
282: cursor c1 is select
283: DESCRIPTION
284: from IGS_PE_PERS_RELN_TYP
285: where ROWID = X_ROWID
286: for update nowait;
287: tlinfo c1%rowtype;
288:

Line 352: update IGS_PE_PERS_RELN_TYP set

348: x_last_updated_by=>X_LAST_UPDATED_BY,
349: x_last_update_login=>X_LAST_UPDATE_LOGIN
350: );
351:
352: update IGS_PE_PERS_RELN_TYP set
353: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
354: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
355: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
356: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 375: cursor c1 is select rowid from IGS_PE_PERS_RELN_TYP

371: X_PERSON_RELATION_TYPE in VARCHAR2,
372: X_DESCRIPTION in VARCHAR2,
373: X_MODE in VARCHAR2 default 'R'
374: ) AS
375: cursor c1 is select rowid from IGS_PE_PERS_RELN_TYP
376: where PERSON_RELATION_TYPE = X_PERSON_RELATION_TYPE
377: ;
378:
379: begin

Line 408: delete from IGS_PE_PERS_RELN_TYP

404: Before_DML(
405: p_action => 'DELETE',
406: x_rowid => X_ROWID
407: );
408: delete from IGS_PE_PERS_RELN_TYP
409: where ROWID = X_ROWID;
410: if (sql%notfound) then
411: raise no_data_found;
412: end if;

Line 419: end IGS_PE_PERS_RELN_TYP_PKG;

415: x_rowid => X_ROWID
416: );
417: end DELETE_ROW;
418:
419: end IGS_PE_PERS_RELN_TYP_PKG;