APPS.IGS_PE_PRSID_GRP_MEM_PKG dependencies on IGS_PE_PRSID_GRP_MEM_ALL

Line 4: old_references igs_pe_prsid_grp_mem_all%RowType;

1: PACKAGE BODY igs_pe_prsid_grp_mem_pkg AS
2: /* $Header: IGSNI22B.pls 120.0 2005/06/01 21:38:36 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_prsid_grp_mem_all%RowType;
5: new_references igs_pe_prsid_grp_mem_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_pe_prsid_grp_mem_all%RowType;

1: PACKAGE BODY igs_pe_prsid_grp_mem_pkg AS
2: /* $Header: IGSNI22B.pls 120.0 2005/06/01 21:38:36 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_prsid_grp_mem_all%RowType;
5: new_references igs_pe_prsid_grp_mem_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 35: FROM IGS_PE_PRSID_GRP_MEM_ALL

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

Line 243: FROM igs_pe_prsid_grp_mem_all

239: ***************************************************************/
240:
241: CURSOR cur_rowid IS
242: SELECT rowid
243: FROM igs_pe_prsid_grp_mem_all
244: WHERE group_id = x_group_id
245: AND person_id = x_person_id
246: FOR UPDATE NOWAIT;
247:

Line 280: FROM igs_pe_prsid_grp_mem_all

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

Line 448: cursor C is select ROWID from IGS_PE_PRSID_GRP_MEM_ALL

444: sraj 2000/05/05 the table structure has been changed
445: (reverse chronological order - newest change first)
446: ***************************************************************/
447:
448: cursor C is select ROWID from IGS_PE_PRSID_GRP_MEM_ALL
449: where GROUP_ID= X_GROUP_ID
450: and PERSON_ID = X_PERSON_ID;
451: X_LAST_UPDATE_DATE DATE ;
452: X_LAST_UPDATED_BY NUMBER ;

Line 502: insert into IGS_PE_PRSID_GRP_MEM_ALL (

498: x_last_updated_by=>X_LAST_UPDATED_BY,
499: x_last_update_login=>X_LAST_UPDATE_LOGIN,
500: x_org_id=>igs_ge_gen_003.get_org_id
501: );
502: insert into IGS_PE_PRSID_GRP_MEM_ALL (
503: GROUP_ID
504: ,PERSON_ID
505: ,START_DATE
506: ,END_DATE

Line 567: from IGS_PE_PRSID_GRP_MEM_ALL

563:
564: cursor c1 is select
565: START_DATE,
566: END_DATE
567: from IGS_PE_PRSID_GRP_MEM_ALL
568: where ROWID = X_ROWID
569: for update nowait;
570: tlinfo c1%rowtype;
571: begin

Line 669: update IGS_PE_PRSID_GRP_MEM_ALL set

665: end if;
666: end if;
667:
668:
669: update IGS_PE_PRSID_GRP_MEM_ALL set
670: START_DATE = NEW_REFERENCES.START_DATE,
671: END_DATE = NEW_REFERENCES.END_DATE,
672: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
673: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 711: cursor c1 is select ROWID from IGS_PE_PRSID_GRP_MEM_ALL

707: sraj 2000/05/05 the table structure has been changed
708: (reverse chronological order - newest change first)
709: ***************************************************************/
710:
711: cursor c1 is select ROWID from IGS_PE_PRSID_GRP_MEM_ALL
712: where GROUP_ID= X_GROUP_ID
713: and PERSON_ID = X_PERSON_ID
714: ;
715: begin

Line 758: delete from IGS_PE_PRSID_GRP_MEM_ALL

754: Before_DML (
755: p_action => 'DELETE',
756: x_rowid => X_ROWID
757: );
758: delete from IGS_PE_PRSID_GRP_MEM_ALL
759: where ROWID = X_ROWID;
760: if (sql%notfound) then
761: raise no_data_found;
762: end if;