APPS.IGS_PE_HZ_PARTY_REL_PKG dependencies on IGS_PE_HZ_PARTY_REL

Line 1: PACKAGE BODY igs_pe_hz_party_rel_pkg AS

1: PACKAGE BODY igs_pe_hz_party_rel_pkg AS
2: /* $Header: IGSNI70B.pls 120.1 2005/06/28 05:54:49 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_hz_party_rel%ROWTYPE;

Line 5: old_references igs_pe_hz_party_rel%ROWTYPE;

1: PACKAGE BODY igs_pe_hz_party_rel_pkg AS
2: /* $Header: IGSNI70B.pls 120.1 2005/06/28 05:54:49 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_hz_party_rel%ROWTYPE;
6: new_references igs_pe_hz_party_rel%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_hz_party_rel%ROWTYPE;

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

Line 31: FROM IGS_PE_HZ_PARTY_REL

27: */
28:
29: CURSOR cur_old_ref_values IS
30: SELECT *
31: FROM IGS_PE_HZ_PARTY_REL
32: WHERE rowid = x_rowid;
33:
34: BEGIN
35:

Line 84: FROM igs_pe_hz_party_rel

80: || (reverse chronological order - newest change first)
81: */
82: CURSOR cur_rowid IS
83: SELECT rowid
84: FROM igs_pe_hz_party_rel
85: WHERE party_relationship_id = x_party_relationship_id
86: FOR UPDATE NOWAIT;
87:
88: lv_rowid cur_rowid%RowType;

Line 182: FROM igs_pe_hz_party_rel

178: || (reverse chronological order - newest change first)
179: */
180: CURSOR c IS
181: SELECT rowid
182: FROM igs_pe_hz_party_rel
183: WHERE party_relationship_id = x_party_relationship_id;
184:
185: x_last_update_date DATE;
186: x_last_updated_by NUMBER;

Line 241: INSERT INTO igs_pe_hz_party_rel (

237:
238: IF (x_mode = 'S') THEN
239: igs_sc_gen_001.set_ctx('R');
240: END IF;
241: INSERT INTO igs_pe_hz_party_rel (
242: party_relationship_id,
243: other_rel_type,
244: creation_date,
245: created_by,

Line 312: FROM igs_pe_hz_party_rel

308: */
309: CURSOR c1 IS
310: SELECT
311: other_rel_type
312: FROM igs_pe_hz_party_rel
313: WHERE rowid = x_rowid
314: FOR UPDATE NOWAIT;
315:
316: tlinfo c1%ROWTYPE;

Line 419: UPDATE igs_pe_hz_party_rel

415:
416: IF (x_mode = 'S') THEN
417: igs_sc_gen_001.set_ctx('R');
418: END IF;
419: UPDATE igs_pe_hz_party_rel
420: SET
421: other_rel_type = new_references.other_rel_type,
422: last_update_date = x_last_update_date,
423: last_updated_by = x_last_updated_by,

Line 475: FROM igs_pe_hz_party_rel

471: || (reverse chronological order - newest change first)
472: */
473: CURSOR c1 IS
474: SELECT rowid
475: FROM igs_pe_hz_party_rel
476: WHERE party_relationship_id = x_party_relationship_id;
477:
478: BEGIN
479:

Line 528: DELETE FROM igs_pe_hz_party_rel

524:
525: IF (x_mode = 'S') THEN
526: igs_sc_gen_001.set_ctx('R');
527: END IF;
528: DELETE FROM igs_pe_hz_party_rel
529: WHERE rowid = x_rowid;
530:
531: IF (SQL%NOTFOUND) THEN
532: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 545: END igs_pe_hz_party_rel_pkg;

541:
542: END delete_row;
543:
544:
545: END igs_pe_hz_party_rel_pkg;