APPS.IGS_HE_SUBMSN_HEADER_PKG dependencies on IGS_HE_SUBMSN_HEADER

Line 1: PACKAGE BODY igs_he_submsn_header_pkg AS

1: PACKAGE BODY igs_he_submsn_header_pkg AS
2: /* $Header: IGSWI10B.pls 115.5 2002/11/29 04:37:10 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_submsn_header%ROWTYPE;

Line 5: old_references igs_he_submsn_header%ROWTYPE;

1: PACKAGE BODY igs_he_submsn_header_pkg AS
2: /* $Header: IGSWI10B.pls 115.5 2002/11/29 04:37:10 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_submsn_header%ROWTYPE;
6: new_references igs_he_submsn_header%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_he_submsn_header%ROWTYPE;

2: /* $Header: IGSWI10B.pls 115.5 2002/11/29 04:37:10 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_he_submsn_header%ROWTYPE;
6: new_references igs_he_submsn_header%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 39: FROM IGS_HE_SUBMSN_HEADER

35: */
36:
37: CURSOR cur_old_ref_values IS
38: SELECT *
39: FROM IGS_HE_SUBMSN_HEADER
40: WHERE rowid = x_rowid;
41:
42: BEGIN
43:

Line 98: igs_he_submsn_return_pkg.get_fk_igs_he_submsn_header (

94: || (reverse chronological order - newest change first)
95: */
96: BEGIN
97:
98: igs_he_submsn_return_pkg.get_fk_igs_he_submsn_header (
99: old_references.submission_name
100: );
101:
102: END check_child_existance;

Line 119: FROM igs_he_submsn_header

115: || (reverse chronological order - newest change first)
116: */
117: CURSOR cur_rowid IS
118: SELECT rowid
119: FROM igs_he_submsn_header
120: WHERE submission_name = x_submission_name
121: FOR UPDATE NOWAIT;
122:
123: lv_rowid cur_rowid%RowType;

Line 246: FROM igs_he_submsn_header

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

Line 274: SELECT igs_he_submsn_header_s.NEXTVAL

270: igs_ge_msg_stack.add;
271: app_exception.raise_exception;
272: END IF;
273:
274: SELECT igs_he_submsn_header_s.NEXTVAL
275: INTO x_sub_hdr_id
276: FROM dual;
277:
278: before_dml(

Line 298: INSERT INTO igs_he_submsn_header (

294: x_last_updated_by => x_last_updated_by,
295: x_last_update_login => x_last_update_login
296: );
297:
298: INSERT INTO igs_he_submsn_header (
299: sub_hdr_id,
300: submission_name,
301: description,
302: enrolment_start_date,

Line 376: FROM igs_he_submsn_header

372: apply_to_atmpt_st_dt,
373: apply_to_inst_st_dt,
374: complete_flag,
375: validation_country
376: FROM igs_he_submsn_header
377: WHERE rowid = x_rowid
378: FOR UPDATE NOWAIT;
379:
380: tlinfo c1%ROWTYPE;

Line 486: UPDATE igs_he_submsn_header

482: x_last_updated_by => x_last_updated_by,
483: x_last_update_login => x_last_update_login
484: );
485:
486: UPDATE igs_he_submsn_header
487: SET
488: sub_hdr_id = new_references.sub_hdr_id,
489: description = new_references.description,
490: enrolment_start_date = new_references.enrolment_start_date,

Line 534: FROM igs_he_submsn_header

530: || (reverse chronological order - newest change first)
531: */
532: CURSOR c1 IS
533: SELECT rowid
534: FROM igs_he_submsn_header
535: WHERE submission_name = x_submission_name;
536:
537: BEGIN
538:

Line 599: DELETE FROM igs_he_submsn_header

595: p_action => 'DELETE',
596: x_rowid => x_rowid
597: );
598:
599: DELETE FROM igs_he_submsn_header
600: WHERE rowid = x_rowid;
601:
602: IF (SQL%NOTFOUND) THEN
603: RAISE NO_DATA_FOUND;

Line 609: END igs_he_submsn_header_pkg;

605:
606: END delete_row;
607:
608:
609: END igs_he_submsn_header_pkg;