APPS.IGS_PE_HZ_PARTIES_PKG dependencies on HZ_PARTIES

Line 1: PACKAGE BODY igs_pe_hz_parties_pkg AS

1: PACKAGE BODY igs_pe_hz_parties_pkg AS
2: /* $Header: IGSNI77B.pls 120.5 2006/02/22 06:24:28 vredkar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_hz_parties%ROWTYPE;

Line 5: old_references igs_pe_hz_parties%ROWTYPE;

1: PACKAGE BODY igs_pe_hz_parties_pkg AS
2: /* $Header: IGSNI77B.pls 120.5 2006/02/22 06:24:28 vredkar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_hz_parties%ROWTYPE;
6: new_references igs_pe_hz_parties%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_hz_parties%ROWTYPE;

2: /* $Header: IGSNI77B.pls 120.5 2006/02/22 06:24:28 vredkar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_hz_parties%ROWTYPE;
6: new_references igs_pe_hz_parties%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 70: FROM IGS_PE_HZ_PARTIES

66: */
67:
68: CURSOR cur_old_ref_values IS
69: SELECT *
70: FROM IGS_PE_HZ_PARTIES
71: WHERE rowid = x_rowid;
72:
73: BEGIN
74:

Line 163: FROM igs_pe_hz_parties

159: || (reverse chronological order - newest change first)
160: */
161: CURSOR cur_rowid IS
162: SELECT rowid
163: FROM igs_pe_hz_parties
164: WHERE party_id = x_party_id
165: FOR UPDATE NOWAIT;
166:
167: lv_rowid cur_rowid%RowType;

Line 198: FROM igs_pe_hz_parties

194: || (reverse chronological order - newest change first)
195: */
196: CURSOR cur_org_unit_exists(cp_oss_org_unit_cd VARCHAR2) IS
197: SELECT 'X'
198: FROM igs_pe_hz_parties
199: WHERE oss_org_unit_cd = cp_oss_org_unit_cd;
200:
201: l_exists VARCHAR2(1);
202: BEGIN

Line 233: FROM igs_pe_hz_parties

229: || (reverse chronological order - newest change first)
230: */
231: CURSOR cur_rowid IS
232: SELECT rowid
233: FROM igs_pe_hz_parties
234: WHERE ((sec_school_location_id = x_code_id));
235:
236: lv_rowid cur_rowid%ROWTYPE;
237: BEGIN

Line 266: FROM HZ_PARTIES

262:
263: FUNCTION validate_pk(x_party_id NUMBER) RETURN BOOLEAN IS
264: CURSOR cur_rowid IS
265: SELECT rowid
266: FROM HZ_PARTIES
267: WHERE party_id = x_party_id
268: FOR UPDATE NOWAIT;
269: lv_rowid cur_rowid%RowType;
270: BEGIN

Line 344: FROM igs_pe_hz_parties

340: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
341:
342: CURSOR local_inst_cur IS
343: SELECT party_id
344: FROM igs_pe_hz_parties
345: WHERE oi_local_institution_ind ='Y'
346: FOR UPDATE NOWAIT;
347:
348: l_inst_rec local_inst_cur%ROWTYPE;

Line 359: UPDATE igs_pe_hz_parties

355: OPEN local_inst_cur;
356: LOOP
357: FETCH local_inst_cur INTO l_inst_rec;
358: EXIT WHEN local_inst_cur%NOTFOUND;
359: UPDATE igs_pe_hz_parties
360: SET oi_local_institution_ind = 'N'
361: WHERE party_id = l_inst_rec.party_id;
362: END LOOP;
363: CLOSE local_inst_cur;

Line 600: FROM igs_pe_hz_parties

596: || (reverse chronological order - newest change first)
597: */
598: CURSOR c IS
599: SELECT rowid
600: FROM igs_pe_hz_parties
601: WHERE party_id = x_party_id;
602:
603: x_last_update_date DATE;
604: x_last_updated_by NUMBER;

Line 700: INSERT INTO igs_pe_hz_parties (

696: igs_sc_gen_001.set_ctx('R');
697: END IF;
698:
699:
700: INSERT INTO igs_pe_hz_parties (
701: party_id,
702: deceased_ind,
703: archive_exclusion_ind,
704: archive_dt,

Line 926: FROM igs_pe_hz_parties

922: birth_city ,
923: birth_country,
924: oss_org_unit_cd,
925: felony_convicted_flag
926: FROM igs_pe_hz_parties
927: WHERE rowid = x_rowid
928: FOR UPDATE NOWAIT;
929:
930: tlinfo c1%ROWTYPE;

Line 1150: UPDATE igs_pe_hz_parties

1146:
1147: IF (x_mode = 'S') THEN
1148: igs_sc_gen_001.set_ctx('R');
1149: END IF;
1150: UPDATE igs_pe_hz_parties
1151: SET
1152: deceased_ind = new_references.deceased_ind,
1153: archive_exclusion_ind = new_references.archive_exclusion_ind,
1154: archive_dt = new_references.archive_dt,

Line 1284: FROM igs_pe_hz_parties

1280: || (reverse chronological order - newest change first)
1281: */
1282: CURSOR c1 IS
1283: SELECT rowid
1284: FROM igs_pe_hz_parties
1285: WHERE party_id = x_party_id;
1286:
1287: BEGIN
1288:

Line 1415: DELETE FROM igs_pe_hz_parties

1411:
1412: IF (x_mode = 'S') THEN
1413: igs_sc_gen_001.set_ctx('R');
1414: END IF;
1415: DELETE FROM igs_pe_hz_parties
1416: WHERE rowid = x_rowid;
1417:
1418: IF (SQL%NOTFOUND) THEN
1419: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 1431: END igs_pe_hz_parties_pkg;

1427:
1428:
1429: END delete_row;
1430:
1431: END igs_pe_hz_parties_pkg;