APPS.IGS_PE_SN_CONTACT_PKG dependencies on IGS_PE_SN_CONTACT

Line 1: PACKAGE BODY igs_pe_sn_contact_pkg AS

1: PACKAGE BODY igs_pe_sn_contact_pkg AS
2: /* $Header: IGSNI88B.pls 120.1 2005/06/28 06:14:48 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_sn_contact%ROWTYPE;

Line 5: old_references igs_pe_sn_contact%ROWTYPE;

1: PACKAGE BODY igs_pe_sn_contact_pkg AS
2: /* $Header: IGSNI88B.pls 120.1 2005/06/28 06:14:48 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_sn_contact%ROWTYPE;
6: new_references igs_pe_sn_contact%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_sn_contact%ROWTYPE;

2: /* $Header: IGSNI88B.pls 120.1 2005/06/28 06:14:48 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_sn_contact%ROWTYPE;
6: new_references igs_pe_sn_contact%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM igs_pe_sn_contact

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

Line 141: FROM igs_pe_sn_contact

137: || (reverse chronological order - newest change first)
138: */
139: CURSOR cur_rowid IS
140: SELECT rowid
141: FROM igs_pe_sn_contact
142: WHERE sn_contact_id = x_sn_contact_id
143: FOR UPDATE NOWAIT;
144:
145: lv_rowid cur_rowid%RowType;

Line 177: FROM igs_pe_sn_contact

173: || (reverse chronological order - newest change first)
174: */
175: CURSOR cur_rowid IS
176: SELECT rowid
177: FROM igs_pe_sn_contact
178: WHERE disability_id = x_disability_id
179: AND ( (contact_date = x_contact_date) OR (contact_date IS NULL and x_contact_date IS NULL ))
180: AND ( (UPPER(contact_name) = UPPER(x_contact_name)) OR (contact_name IS NULL and x_contact_name IS NULL ))
181: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 215: FROM igs_pe_sn_contact

211: || (reverse chronological order - newest change first)
212: */
213: CURSOR cur_rowid IS
214: SELECT rowid
215: FROM igs_pe_sn_contact
216: WHERE ((disability_id = x_igs_pe_pers_disablty_id));
217:
218: lv_rowid cur_rowid%RowType;
219:

Line 332: FROM igs_pe_sn_contact

328: || (reverse chronological order - newest change first)
329: */
330: CURSOR c IS
331: SELECT rowid
332: FROM igs_pe_sn_contact
333: WHERE sn_contact_id = x_sn_contact_id;
334:
335: x_last_update_date DATE;
336: x_last_updated_by NUMBER;

Line 360: SELECT igs_pe_sn_contact_s.NEXTVAL

356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: END IF;
359:
360: SELECT igs_pe_sn_contact_s.NEXTVAL
361: INTO x_sn_contact_id
362: FROM dual;
363:
364: before_dml(

Line 382: INSERT INTO igs_pe_sn_contact (

378:
379: IF (x_mode = 'S') THEN
380: igs_sc_gen_001.set_ctx('R');
381: END IF;
382: INSERT INTO igs_pe_sn_contact (
383: sn_contact_id,
384: disability_id,
385: contact_name,
386: contact_date,

Line 457: FROM igs_pe_sn_contact

453: disability_id,
454: contact_name,
455: contact_date,
456: comments
457: FROM igs_pe_sn_contact
458: WHERE rowid = x_rowid
459: FOR UPDATE NOWAIT;
460:
461: tlinfo c1%ROWTYPE;

Line 555: UPDATE igs_pe_sn_contact

551:
552: IF (x_mode = 'S') THEN
553: igs_sc_gen_001.set_ctx('R');
554: END IF;
555: UPDATE igs_pe_sn_contact
556: SET
557: disability_id = new_references.disability_id,
558: contact_name = new_references.contact_name,
559: contact_date = new_references.contact_date,

Line 613: FROM igs_pe_sn_contact

609: || (reverse chronological order - newest change first)
610: */
611: CURSOR c1 IS
612: SELECT rowid
613: FROM igs_pe_sn_contact
614: WHERE sn_contact_id = x_sn_contact_id;
615:
616: BEGIN
617:

Line 672: DELETE FROM igs_pe_sn_contact

668:
669: IF (x_mode = 'S') THEN
670: igs_sc_gen_001.set_ctx('R');
671: END IF;
672: DELETE FROM igs_pe_sn_contact
673: WHERE rowid = x_rowid;
674:
675: IF (SQL%NOTFOUND) THEN
676: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 689: END igs_pe_sn_contact_pkg;

685:
686: END delete_row;
687:
688:
689: END igs_pe_sn_contact_pkg;