APPS.IGS_PE_MATCH_SETS_PKG dependencies on IGS_PE_MATCH_SETS_ALL

Line 4: old_references igs_pe_match_sets_all%RowType;

1: PACKAGE BODY igs_pe_match_sets_pkg AS
2: /* $Header: IGSNI66B.pls 120.0 2005/06/01 20:07:51 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_match_sets_all%RowType;
5: new_references igs_pe_match_sets_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_pe_match_sets_all%RowType;

1: PACKAGE BODY igs_pe_match_sets_pkg AS
2: /* $Header: IGSNI66B.pls 120.0 2005/06/01 20:07:51 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_match_sets_all%RowType;
5: new_references igs_pe_match_sets_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 38: FROM igs_pe_match_sets_all

34: ***************************************************************/
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM igs_pe_match_sets_all
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 150: FROM igs_pe_match_sets_all

146: ***************************************************************/
147:
148: CURSOR cur_rowid IS
149: SELECT rowid
150: FROM igs_pe_match_sets_all
151: WHERE match_set_id = x_match_set_id
152: FOR UPDATE NOWAIT;
153:
154: lv_rowid cur_rowid%RowType;

Line 187: from igs_pe_match_sets_all

183: (reverse chronological order - newest change first)
184: ***************************************************************/
185: cursor cur_rowid is
186: select rowid
187: from igs_pe_match_sets_all
188: where source_type_id = x_source_type_id;
189:
190: lv_rowid cur_rowid%rowtype;
191:

Line 222: from igs_pe_match_sets_all

218: (reverse chronological order - newest change first)
219: ***************************************************************/
220: cursor cur_rowid is
221: select rowid
222: from igs_pe_match_sets_all
223: where match_set_id = x_duplicate_pair_id;
224:
225: lv_rowid cur_rowid%rowtype;
226:

Line 366: FROM igs_pe_match_sets_all

362:
363: AS
364: CURSOR cur_rowid IS
365: SELECT rowid
366: FROM igs_pe_match_sets_all
367: WHERE UPPER(match_set_name) = UPPER(x_match_set_name)
368: AND ((l_rowid is null) or (rowid <> l_rowid))
369: FOR UPDATE NOWAIT;
370:

Line 564: cursor C is select ROWID from igs_pe_match_sets_all

560: in call to before_dml as part of SWCR006 build.
561: sraj 17-MAY-2000 Added a column PARTIAL_IF_NULL to the table
562: (reverse chronological order - newest change first)
563: ***************************************************************/
564: cursor C is select ROWID from igs_pe_match_sets_all
565: where MATCH_SET_ID= X_MATCH_SET_ID
566: ;
567: X_LAST_UPDATE_DATE DATE ;
568: X_LAST_UPDATED_BY NUMBER ;

Line 613: insert into igs_pe_match_sets_all (

609: x_primary_addr_flag=>X_primary_addr_flag,
610: x_org_id=>igs_ge_gen_003.get_org_id
611:
612: );
613: insert into igs_pe_match_sets_all (
614: MATCH_SET_ID
615: ,SOURCE_TYPE_ID
616: ,MATCH_SET_NAME
617: ,DESCRIPTION

Line 686: from igs_pe_match_sets_all

682: , CLOSED_IND
683: , PARTIAL_IF_NULL
684: , primary_addr_flag
685: , exclude_inactive_ind
686: from igs_pe_match_sets_all
687: where ROWID = X_ROWID
688: for update nowait;
689: tlinfo c1%rowtype;
690: begin

Line 784: update igs_pe_match_sets_all set

780: x_last_update_login=>X_LAST_UPDATE_LOGIN,
781: x_primary_addr_flag=>X_primary_addr_flag,
782: x_org_id=>igs_ge_gen_003.get_org_id
783: );
784: update igs_pe_match_sets_all set
785: SOURCE_TYPE_ID = NEW_REFERENCES.SOURCE_TYPE_ID,
786: MATCH_SET_NAME = NEW_REFERENCES.MATCH_SET_NAME,
787: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
788: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 828: cursor c1 is select ROWID from igs_pe_match_sets_all

824: Who When What
825: sraj 17-MAY-2000 Added a column PARTIAL_IF_NULL to the table
826: (reverse chronological order - newest change first)
827: ***************************************************************/
828: cursor c1 is select ROWID from igs_pe_match_sets_all
829: where MATCH_SET_ID= X_MATCH_SET_ID
830: ;
831: begin
832: open c1;

Line 883: delete from igs_pe_match_sets_all

879: Before_DML (
880: p_action => 'DELETE',
881: x_rowid => X_ROWID
882: );
883: delete from igs_pe_match_sets_all
884: where ROWID = X_ROWID;
885: if (sql%notfound) then
886: raise no_data_found;
887: end if;