APPS.IGS_PE_PERS_RELATION_PKG dependencies on IGS_PE_PERS_RELATION

Line 1: package body IGS_PE_PERS_RELATION_PKG AS

1: package body IGS_PE_PERS_RELATION_PKG AS
2: /* $Header: IGSNI31B.pls 120.0 2005/06/01 20:57:59 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_PERS_RELATION%RowType;

Line 5: old_references IGS_PE_PERS_RELATION%RowType;

1: package body IGS_PE_PERS_RELATION_PKG AS
2: /* $Header: IGSNI31B.pls 120.0 2005/06/01 20:57:59 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_PERS_RELATION%RowType;
6: new_references IGS_PE_PERS_RELATION%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 6: new_references IGS_PE_PERS_RELATION%RowType;

2: /* $Header: IGSNI31B.pls 120.0 2005/06/01 20:57:59 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PE_PERS_RELATION%RowType;
6: new_references IGS_PE_PERS_RELATION%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
10: x_person_id IN NUMBER DEFAULT NULL,

Line 22: FROM IGS_PE_PERS_RELATION

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

Line 135: FROM IGS_PE_PERS_RELATION

131: ) RETURN BOOLEAN AS
132:
133: CURSOR cur_rowid IS
134: SELECT rowid
135: FROM IGS_PE_PERS_RELATION
136: WHERE person_id = x_person_id
137: AND person_id_also_related_to = x_person_id_also_related_to
138: AND person_relation_type = x_person_relation_type
139: FOR UPDATE NOWAIT;

Line 164: FROM IGS_PE_PERS_RELATION

160: ) AS
161:
162: CURSOR cur_rowid IS
163: SELECT rowid
164: FROM IGS_PE_PERS_RELATION
165: WHERE person_id = x_person_id OR
166: person_id_also_related_to = x_person_id ;
167:
168: lv_rowid cur_rowid%RowType;

Line 193: FROM IGS_PE_PERS_RELATION

189: ) AS
190:
191: CURSOR cur_rowid IS
192: SELECT rowid
193: FROM IGS_PE_PERS_RELATION
194: WHERE person_relation_type = x_person_relation_type ;
195:
196: lv_rowid cur_rowid%RowType;
197:

Line 314: cursor C is select ROWID from IGS_PE_PERS_RELATION

310: X_PERSON_ID_ALSO_RELATED_TO in NUMBER,
311: X_PERSON_RELATION_TYPE in VARCHAR2,
312: X_MODE in VARCHAR2 default 'R'
313: ) AS
314: cursor C is select ROWID from IGS_PE_PERS_RELATION
315: where PERSON_ID = X_PERSON_ID
316: and PERSON_ID_ALSO_RELATED_TO = X_PERSON_ID_ALSO_RELATED_TO
317: and PERSON_RELATION_TYPE = X_PERSON_RELATION_TYPE;
318: X_LAST_UPDATE_DATE DATE;

Line 357: insert into IGS_PE_PERS_RELATION (

353:
354: IF (x_mode = 'S') THEN
355: igs_sc_gen_001.set_ctx('R');
356: END IF;
357: insert into IGS_PE_PERS_RELATION (
358: PERSON_ID,
359: PERSON_ID_ALSO_RELATED_TO,
360: PERSON_RELATION_TYPE,
361: CREATION_DATE,

Line 415: from IGS_PE_PERS_RELATION

411: X_PERSON_ID_ALSO_RELATED_TO in NUMBER,
412: X_PERSON_RELATION_TYPE in VARCHAR2
413: ) AS
414: cursor c1 is select ROWID
415: from IGS_PE_PERS_RELATION
416: where ROWID = X_ROWID
417: for update nowait;
418: tlinfo c1%rowtype;
419:

Line 448: delete from IGS_PE_PERS_RELATION

444: );
445: IF (x_mode = 'S') THEN
446: igs_sc_gen_001.set_ctx('R');
447: END IF;
448: delete from IGS_PE_PERS_RELATION
449: where ROWID = X_ROWID;
450: if (sql%notfound) then
451: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
452: igs_ge_msg_stack.add;

Line 466: end IGS_PE_PERS_RELATION_PKG;

462: x_rowid => X_ROWID
463: );
464: end DELETE_ROW;
465:
466: end IGS_PE_PERS_RELATION_PKG;