APPS.IGS_PE_HEARING_DTLS_PKG dependencies on IGS_PE_HEARING_DTLS

Line 1: PACKAGE BODY igs_pe_hearing_dtls_pkg AS

1: PACKAGE BODY igs_pe_hearing_dtls_pkg AS
2: /* $Header: IGSNI92B.pls 120.1 2005/06/28 05:40:08 appldev ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_hearing_dtls%ROWTYPE;

Line 5: old_references igs_pe_hearing_dtls%ROWTYPE;

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

Line 6: new_references igs_pe_hearing_dtls%ROWTYPE;

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

Line 37: FROM igs_pe_hearing_dtls

33: */
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM igs_pe_hearing_dtls
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 166: FROM igs_pe_hearing_dtls

162: || (reverse chronological order - newest change first)
163: */
164: CURSOR cur_rowid IS
165: SELECT rowid
166: FROM igs_pe_hearing_dtls
167: WHERE hearing_details_id = x_hearing_details_id
168: FOR UPDATE NOWAIT;
169:
170: lv_rowid cur_rowid%RowType;

Line 201: FROM igs_pe_hearing_dtls

197: || (reverse chronological order - newest change first)
198: */
199: CURSOR cur_rowid IS
200: SELECT rowid
201: FROM igs_pe_hearing_dtls
202: WHERE ((person_id = x_party_id));
203:
204: lv_rowid cur_rowid%RowType;
205:

Line 327: FROM igs_pe_hearing_dtls

323: || (reverse chronological order - newest change first)
324: */
325: CURSOR c IS
326: SELECT rowid
327: FROM igs_pe_hearing_dtls
328: WHERE hearing_details_id = x_hearing_details_id;
329:
330: x_last_update_date DATE;
331: x_last_updated_by NUMBER;

Line 355: SELECT igs_pe_hearing_dtls_s.NEXTVAL

351: igs_ge_msg_stack.add;
352: app_exception.raise_exception;
353: END IF;
354:
355: SELECT igs_pe_hearing_dtls_s.NEXTVAL
356: INTO x_hearing_details_id
357: FROM dual;
358:
359: before_dml(

Line 380: INSERT INTO igs_pe_hearing_dtls (

376:
377: IF (x_mode = 'S') THEN
378: igs_sc_gen_001.set_ctx('R');
379: END IF;
380: INSERT INTO igs_pe_hearing_dtls (
381: hearing_details_id,
382: person_id,
383: description,
384: start_date,

Line 467: FROM igs_pe_hearing_dtls

463: end_date,
464: dspl_file_ind,
465: acad_dism_ind,
466: non_acad_dism_ind
467: FROM igs_pe_hearing_dtls
468: WHERE rowid = x_rowid
469: FOR UPDATE NOWAIT;
470:
471: tlinfo c1%ROWTYPE;

Line 574: UPDATE igs_pe_hearing_dtls

570:
571: IF (x_mode = 'S') THEN
572: igs_sc_gen_001.set_ctx('R');
573: END IF;
574: UPDATE igs_pe_hearing_dtls
575: SET
576: person_id = new_references.person_id,
577: description = new_references.description,
578: start_date = new_references.start_date,

Line 638: FROM igs_pe_hearing_dtls

634: || (reverse chronological order - newest change first)
635: */
636: CURSOR c1 IS
637: SELECT rowid
638: FROM igs_pe_hearing_dtls
639: WHERE hearing_details_id = x_hearing_details_id;
640:
641: BEGIN
642:

Line 703: DELETE FROM igs_pe_hearing_dtls

699:
700: IF (x_mode = 'S') THEN
701: igs_sc_gen_001.set_ctx('R');
702: END IF;
703: DELETE FROM igs_pe_hearing_dtls
704: WHERE rowid = x_rowid;
705:
706: IF (SQL%NOTFOUND) THEN
707: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 720: END igs_pe_hearing_dtls_pkg;

716:
717: END delete_row;
718:
719:
720: END igs_pe_hearing_dtls_pkg;