APPS.IGS_PE_PERSON_ALIAS_PKG dependencies on IGS_PE_PERSON_ALIAS

Line 1: package body IGS_PE_PERSON_ALIAS_PKG AS

1: package body IGS_PE_PERSON_ALIAS_PKG AS
2: /* $Header: IGSNI11B.pls 120.2 2005/07/31 23:35:56 appldev ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What

Line 25: old_references IGS_PE_PERSON_ALIAS%RowType;

21:
22: ***********************************************************************/
23:
24: l_rowid VARCHAR2(25);
25: old_references IGS_PE_PERSON_ALIAS%RowType;
26: new_references IGS_PE_PERSON_ALIAS%RowType;
27:
28: PROCEDURE Set_Column_Values (
29: p_action IN VARCHAR2,

Line 26: new_references IGS_PE_PERSON_ALIAS%RowType;

22: ***********************************************************************/
23:
24: l_rowid VARCHAR2(25);
25: old_references IGS_PE_PERSON_ALIAS%RowType;
26: new_references IGS_PE_PERSON_ALIAS%RowType;
27:
28: PROCEDURE Set_Column_Values (
29: p_action IN VARCHAR2,
30: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 49: FROM IGS_PE_PERSON_ALIAS

45: ) AS
46:
47: CURSOR cur_old_ref_values IS
48: SELECT *
49: FROM IGS_PE_PERSON_ALIAS
50: WHERE rowid = x_rowid;
51:
52: BEGIN
53:

Line 106: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_PE_PERSON_ALIAS') THEN

102: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
103: v_message_name varchar2(30);
104: BEGIN
105: -- If trigger has not been disabled, perform required processing
106: IF igs_as_val_suaap.genp_val_sdtt_sess('IGS_PE_PERSON_ALIAS') THEN
107: -- Validate START DATE AND END DATE.
108: -- Validate that if end date is specified, then start date is also specified.
109: IF (new_references.end_dt IS NOT NULL) AND
110: ((p_inserting OR p_updating) OR

Line 242: FROM IGS_PE_PERSON_ALIAS

238: ) RETURN BOOLEAN AS
239:
240: CURSOR cur_rowid IS
241: SELECT rowid
242: FROM IGS_PE_PERSON_ALIAS
243: WHERE person_id = x_person_id
244: AND sequence_number = x_sequence_number
245: FOR UPDATE NOWAIT;
246:

Line 269: FROM IGS_PE_PERSON_ALIAS

265: ) AS
266:
267: CURSOR cur_rowid IS
268: SELECT rowid
269: FROM IGS_PE_PERSON_ALIAS
270: WHERE person_id = x_person_id ;
271:
272: lv_rowid cur_rowid%RowType;
273:

Line 397: cursor C is select ROWID from IGS_PE_PERSON_ALIAS

393: X_SURNAME in VARCHAR2,
394: X_GIVEN_NAMES in VARCHAR2,
395: X_MODE in VARCHAR2 default 'R'
396: ) is
397: cursor C is select ROWID from IGS_PE_PERSON_ALIAS
398: where PERSON_ID = X_PERSON_ID
399: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
400: X_LAST_UPDATE_DATE DATE;
401: X_LAST_UPDATED_BY NUMBER;

Line 445: insert into IGS_PE_PERSON_ALIAS (

441:
442: IF (x_mode = 'S') THEN
443: igs_sc_gen_001.set_ctx('R');
444: END IF;
445: insert into IGS_PE_PERSON_ALIAS (
446: TITLE,
447: ALIAS_COMMENT,
448: PERSON_ID,
449: ALIAS_TYPE,

Line 527: from IGS_PE_PERSON_ALIAS

523: START_DT,
524: END_DT,
525: SURNAME,
526: GIVEN_NAMES
527: from IGS_PE_PERSON_ALIAS
528: where ROWID = X_ROWID
529: for update nowait;
530: tlinfo c1%rowtype;
531:

Line 627: update IGS_PE_PERSON_ALIAS set

623: );
624: IF (x_mode = 'S') THEN
625: igs_sc_gen_001.set_ctx('R');
626: END IF;
627: update IGS_PE_PERSON_ALIAS set
628: TITLE = NEW_REFERENCES.TITLE,
629: ALIAS_COMMENT = NEW_REFERENCES.ALIAS_COMMENT,
630: START_DT = NEW_REFERENCES.START_DT,
631: END_DT = NEW_REFERENCES.END_DT,

Line 681: cursor c1 is select rowid from IGS_PE_PERSON_ALIAS

677: X_SURNAME in VARCHAR2,
678: X_GIVEN_NAMES in VARCHAR2,
679: X_MODE in VARCHAR2 default 'R'
680: ) AS
681: cursor c1 is select rowid from IGS_PE_PERSON_ALIAS
682: where PERSON_ID = X_PERSON_ID
683: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
684: ;
685:

Line 732: delete from IGS_PE_PERSON_ALIAS

728: );
729: IF (x_mode = 'S') THEN
730: igs_sc_gen_001.set_ctx('R');
731: END IF;
732: delete from IGS_PE_PERSON_ALIAS
733: where ROWID = X_ROWID;
734: if (sql%notfound) then
735: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
736: igs_ge_msg_stack.add;

Line 749: end IGS_PE_PERSON_ALIAS_PKG;

745: p_action => 'DELETE',
746: x_rowid => X_ROWID
747: );
748: end DELETE_ROW;
749: end IGS_PE_PERSON_ALIAS_PKG;