APPS.IGS_PE_HZ_PTY_SITES_PKG dependencies on IGS_PE_HZ_PTY_SITES

Line 1: PACKAGE BODY igs_pe_hz_pty_sites_pkg AS

1: PACKAGE BODY igs_pe_hz_pty_sites_pkg AS
2: /* $Header: IGSNIB5B.pls 120.3 2005/09/22 02:31:33 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_hz_pty_sites%ROWTYPE;
5: new_references igs_pe_hz_pty_sites%ROWTYPE;

Line 4: old_references igs_pe_hz_pty_sites%ROWTYPE;

1: PACKAGE BODY igs_pe_hz_pty_sites_pkg AS
2: /* $Header: IGSNIB5B.pls 120.3 2005/09/22 02:31:33 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_hz_pty_sites%ROWTYPE;
5: new_references igs_pe_hz_pty_sites%ROWTYPE;
6:
7: PROCEDURE set_column_values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_pe_hz_pty_sites%ROWTYPE;

1: PACKAGE BODY igs_pe_hz_pty_sites_pkg AS
2: /* $Header: IGSNIB5B.pls 120.3 2005/09/22 02:31:33 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_hz_pty_sites%ROWTYPE;
5: new_references igs_pe_hz_pty_sites%ROWTYPE;
6:
7: PROCEDURE set_column_values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2,

Line 31: FROM igs_pe_hz_pty_sites

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

Line 183: FROM igs_pe_hz_pty_sites

179: || (reverse chronological order - newest change first)
180: */
181: CURSOR cur_rowid IS
182: SELECT ROWID
183: FROM igs_pe_hz_pty_sites
184: WHERE party_site_id = x_party_site_id
185: FOR UPDATE NOWAIT;
186: lv_rowid cur_rowid%RowType;
187:

Line 302: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_PTY_SITES_PKG.INSERT_ROW');

298: x_last_update_login := -1;
299: END IF;
300: ELSE
301: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
302: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_PTY_SITES_PKG.INSERT_ROW');
303: igs_ge_msg_stack.add;
304: app_exception.raise_exception;
305: END IF;
306:

Line 324: INSERT INTO igs_pe_hz_pty_sites (

320:
321: IF (x_mode = 'S') THEN
322: igs_sc_gen_001.set_ctx('R');
323: END IF;
324: INSERT INTO igs_pe_hz_pty_sites (
325: party_site_id,
326: start_date,
327: end_date,
328: creation_date,

Line 384: FROM igs_pe_hz_pty_sites

380: SELECT
381: party_site_id,
382: start_date,
383: end_date
384: FROM igs_pe_hz_pty_sites
385: WHERE rowid = x_rowid
386: FOR UPDATE NOWAIT;
387:
388: tlinfo c1%ROWTYPE;

Line 457: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_PTY_SITES_PKG.UPDATE_ROW');

453: x_last_update_login := -1;
454: END IF;
455: ELSE
456: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
457: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_PTY_SITES_PKG.UPDATE_ROW');
458: igs_ge_msg_stack.add;
459: app_exception.raise_exception;
460: END IF;
461:

Line 478: UPDATE igs_pe_hz_pty_sites

474:
475: IF (x_mode = 'S') THEN
476: igs_sc_gen_001.set_ctx('R');
477: END IF;
478: UPDATE igs_pe_hz_pty_sites
479: SET
480: party_site_id = new_references.party_site_id,
481: start_date = new_references.start_date,
482: end_date = new_references.end_date,

Line 533: FROM igs_pe_hz_pty_sites

529: || (reverse chronological order - newest change first)
530: */
531: CURSOR c1 IS
532: SELECT rowid
533: FROM igs_pe_hz_pty_sites
534: WHERE party_site_id = x_party_site_id;
535:
536: BEGIN
537:

Line 588: DELETE FROM igs_pe_hz_pty_sites

584:
585: IF (x_mode = 'S') THEN
586: igs_sc_gen_001.set_ctx('R');
587: END IF;
588: DELETE FROM igs_pe_hz_pty_sites
589: WHERE rowid = x_rowid;
590:
591: IF (SQL%NOTFOUND) THEN
592: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 605: END igs_pe_hz_pty_sites_pkg;

601:
602: END delete_row;
603:
604:
605: END igs_pe_hz_pty_sites_pkg;