APPS.IGS_PS_FACLTY_DISP_PKG dependencies on IGS_PS_FACLTY_DISP

Line 1: PACKAGE BODY igs_ps_faclty_disp_pkg AS

1: PACKAGE BODY igs_ps_faclty_disp_pkg AS
2: /* $Header: IGSPI0PB.pls 120.1 2005/06/28 06:24:44 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_faclty_disp%RowType;
5: new_references igs_ps_faclty_disp%RowType;

Line 4: old_references igs_ps_faclty_disp%RowType;

1: PACKAGE BODY igs_ps_faclty_disp_pkg AS
2: /* $Header: IGSPI0PB.pls 120.1 2005/06/28 06:24:44 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_faclty_disp%RowType;
5: new_references igs_ps_faclty_disp%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_faclty_disp%RowType;

1: PACKAGE BODY igs_ps_faclty_disp_pkg AS
2: /* $Header: IGSPI0PB.pls 120.1 2005/06/28 06:24:44 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_faclty_disp%RowType;
5: new_references igs_ps_faclty_disp%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGS_PS_FACLTY_DISP

30: ***************************************************************/
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM IGS_PS_FACLTY_DISP
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 206: FROM igs_ps_faclty_disp

202: ***************************************************************/
203:
204: CURSOR cur_rowid IS
205: SELECT rowid
206: FROM igs_ps_faclty_disp
207: WHERE displn_unit_id = x_displn_unit_id
208: FOR UPDATE NOWAIT;
209:
210: lv_rowid cur_rowid%RowType;

Line 244: FROM igs_ps_faclty_disp

240: ***************************************************************/
241:
242: CURSOR cur_rowid IS
243: SELECT rowid
244: FROM igs_ps_faclty_disp
245: WHERE displn_unit_cd = x_displn_unit_cd
246: AND displn_unit_type = x_displn_unit_type
247: AND person_id = x_person_id and ((l_rowid is null) or (rowid <> l_rowid))
248:

Line 281: FROM igs_ps_faclty_disp

277: ***************************************************************/
278:
279: CURSOR cur_rowid IS
280: SELECT rowid
281: FROM igs_ps_faclty_disp
282: WHERE person_id = x_person_id ;
283:
284: lv_rowid cur_rowid%RowType;
285:

Line 319: FROM igs_ps_faclty_disp

315: ***************************************************************/
316:
317: CURSOR cur_rowid IS
318: SELECT rowid
319: FROM igs_ps_faclty_disp
320: WHERE displn_unit_cd = x_displn_unit_cd
321: AND displn_unit_type='UNIT' ;
322:
323: lv_rowid cur_rowid%RowType;

Line 472: cursor C is select ROWID from IGS_PS_FACLTY_DISP

468:
469: (reverse chronological order - newest change first)
470: ***************************************************************/
471:
472: cursor C is select ROWID from IGS_PS_FACLTY_DISP
473: where DISPLN_UNIT_ID= X_DISPLN_UNIT_ID
474: ;
475: X_LAST_UPDATE_DATE DATE ;
476: X_LAST_UPDATED_BY NUMBER ;

Line 513: insert into IGS_PS_FACLTY_DISP (

509: x_last_update_login=>X_LAST_UPDATE_LOGIN);
510: IF (x_mode = 'S') THEN
511: igs_sc_gen_001.set_ctx('R');
512: END IF;
513: insert into IGS_PS_FACLTY_DISP (
514: DISPLN_UNIT_ID
515: ,DISPLN_UNIT_TYPE
516: ,PERSON_ID
517: ,DISPLN_UNIT_CD

Line 583: from IGS_PS_FACLTY_DISP

579: cursor c1 is select
580: DISPLN_UNIT_TYPE
581: , PERSON_ID
582: , DISPLN_UNIT_CD
583: from IGS_PS_FACLTY_DISP
584: where ROWID = X_ROWID
585: for update nowait;
586: tlinfo c1%rowtype;
587: begin

Line 666: update IGS_PS_FACLTY_DISP set

662: x_last_update_login=>X_LAST_UPDATE_LOGIN);
663: IF (x_mode = 'S') THEN
664: igs_sc_gen_001.set_ctx('R');
665: END IF;
666: update IGS_PS_FACLTY_DISP set
667: DISPLN_UNIT_TYPE = NEW_REFERENCES.DISPLN_UNIT_TYPE,
668: PERSON_ID = NEW_REFERENCES.PERSON_ID,
669: DISPLN_UNIT_CD = NEW_REFERENCES.DISPLN_UNIT_CD,
670: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 722: cursor c1 is select ROWID from IGS_PS_FACLTY_DISP

718:
719: (reverse chronological order - newest change first)
720: ***************************************************************/
721:
722: cursor c1 is select ROWID from IGS_PS_FACLTY_DISP
723: where DISPLN_UNIT_ID= X_DISPLN_UNIT_ID
724: ;
725: begin
726: open c1;

Line 771: delete from IGS_PS_FACLTY_DISP

767: );
768: IF (x_mode = 'S') THEN
769: igs_sc_gen_001.set_ctx('R');
770: END IF;
771: delete from IGS_PS_FACLTY_DISP
772: where ROWID = X_ROWID;
773: if (sql%notfound) then
774: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
775: igs_ge_msg_stack.add;

Line 788: END igs_ps_faclty_disp_pkg;

784: p_action => 'DELETE',
785: x_rowid => X_ROWID
786: );
787: end DELETE_ROW;
788: END igs_ps_faclty_disp_pkg;