APPS.IGS_PE_HZ_LOCATIONS_PKG dependencies on HZ_LOCATIONS

Line 1: PACKAGE BODY igs_pe_hz_locations_pkg AS

1: PACKAGE BODY igs_pe_hz_locations_pkg AS
2: /* $Header: IGSNI71B.pls 120.1 2005/06/28 05:45:20 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_hz_locations%ROWTYPE;

Line 5: old_references igs_pe_hz_locations%ROWTYPE;

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

Line 6: new_references igs_pe_hz_locations%ROWTYPE;

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

Line 35: FROM IGS_PE_HZ_LOCATIONS

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

Line 92: FROM igs_pe_hz_locations

88: || (reverse chronological order - newest change first)
89: */
90: CURSOR cur_rowid IS
91: SELECT rowid
92: FROM igs_pe_hz_locations
93: WHERE location_id = x_location_id
94: FOR UPDATE NOWAIT;
95:
96: lv_rowid cur_rowid%RowType;

Line 190: FROM HZ_LOCATIONS

186:
187: PROCEDURE Check_Parent_Existance as
188: CURSOR cur_rowid IS
189: SELECT rowid
190: FROM HZ_LOCATIONS
191: WHERE LOCATION_ID = new_references.LOCATION_ID ;
192: lv_rowid cur_rowid%RowType;
193: /*
194: || Created By : nalin.kumar

Line 245: FROM igs_pe_hz_locations

241: || (reverse chronological order - newest change first)
242: */
243: CURSOR c IS
244: SELECT rowid
245: FROM igs_pe_hz_locations
246: WHERE location_id = x_location_id;
247:
248: x_last_update_date DATE;
249: x_last_updated_by NUMBER;

Line 308: INSERT INTO igs_pe_hz_locations (

304:
305: IF (x_mode = 'S') THEN
306: igs_sc_gen_001.set_ctx('R');
307: END IF;
308: INSERT INTO igs_pe_hz_locations (
309: location_id,
310: other_details_1,
311: other_details_2,
312: other_details_3,

Line 395: FROM igs_pe_hz_locations

391: other_details_2,
392: other_details_3,
393: date_last_verified,
394: contact_person
395: FROM igs_pe_hz_locations
396: WHERE rowid = x_rowid
397: FOR UPDATE NOWAIT;
398:
399: tlinfo c1%ROWTYPE;

Line 514: UPDATE igs_pe_hz_locations

510:
511: IF (x_mode = 'S') THEN
512: igs_sc_gen_001.set_ctx('R');
513: END IF;
514: UPDATE igs_pe_hz_locations
515: SET
516: other_details_1 = new_references.other_details_1,
517: other_details_2 = new_references.other_details_2,
518: other_details_3 = new_references.other_details_3,

Line 578: FROM igs_pe_hz_locations

574: || (reverse chronological order - newest change first)
575: */
576: CURSOR c1 IS
577: SELECT rowid
578: FROM igs_pe_hz_locations
579: WHERE location_id = x_location_id;
580:
581: BEGIN
582:

Line 639: DELETE FROM igs_pe_hz_locations

635:
636: IF (x_mode = 'S') THEN
637: igs_sc_gen_001.set_ctx('R');
638: END IF;
639: DELETE FROM igs_pe_hz_locations
640: WHERE rowid = x_rowid;
641:
642: IF (SQL%NOTFOUND) THEN
643: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 656: END igs_pe_hz_locations_pkg;

652:
653: END delete_row;
654:
655:
656: END igs_pe_hz_locations_pkg;