APPS.IGS_AS_DOCPROC_STUP_PKG dependencies on IGS_AS_DOCPROC_STUP

Line 1: PACKAGE BODY igs_as_docproc_stup_pkg AS

1: PACKAGE BODY igs_as_docproc_stup_pkg AS
2: /* $Header: IGSDI67B.pls 115.2 2002/11/28 23:27:51 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_docproc_stup%ROWTYPE;

Line 5: old_references igs_as_docproc_stup%ROWTYPE;

1: PACKAGE BODY igs_as_docproc_stup_pkg AS
2: /* $Header: IGSDI67B.pls 115.2 2002/11/28 23:27:51 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_docproc_stup%ROWTYPE;
6: new_references igs_as_docproc_stup%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_as_docproc_stup%ROWTYPE;

2: /* $Header: IGSDI67B.pls 115.2 2002/11/28 23:27:51 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_docproc_stup%ROWTYPE;
6: new_references igs_as_docproc_stup%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 44: FROM igs_as_docproc_stup

40: */
41:
42: CURSOR cur_old_ref_values IS
43: SELECT *
44: FROM igs_as_docproc_stup
45: WHERE rowid = x_rowid;
46:
47: BEGIN
48:

Line 109: FROM igs_as_docproc_stup

105: || (reverse chronological order - newest change first)
106: */
107: CURSOR cur_rowid IS
108: SELECT rowid
109: FROM igs_as_docproc_stup
110: WHERE tpset_id = x_tpset_id
111: FOR UPDATE NOWAIT;
112:
113: lv_rowid cur_rowid%RowType;

Line 245: FROM igs_as_docproc_stup

241: || kdande 18-Oct-2002 Added new columns as per the Enh# 2632096.
242: */
243: CURSOR c IS
244: SELECT rowid
245: FROM igs_as_docproc_stup
246: WHERE tpset_id = x_tpset_id;
247:
248: x_last_update_date DATE;
249: x_last_updated_by NUMBER;

Line 273: SELECT igs_as_docproc_stup_s.NEXTVAL

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

Line 301: INSERT INTO igs_as_docproc_stup (

297: x_charge_delivery_fee_ind => x_charge_delivery_fee_ind,
298: x_administrator_id => x_administrator_id
299: );
300:
301: INSERT INTO igs_as_docproc_stup (
302: tpset_id,
303: lifetime_trans_fee_ind,
304: provide_transcript_ind,
305: trans_request_if_hold_ind,

Line 396: FROM igs_as_docproc_stup

392: provide_duplicate_doc_ind,
393: charge_document_fee_ind,
394: charge_delivery_fee_ind,
395: administrator_id
396: FROM igs_as_docproc_stup
397: WHERE rowid = x_rowid
398: FOR UPDATE NOWAIT;
399:
400: tlinfo c1%ROWTYPE;

Line 519: UPDATE igs_as_docproc_stup

515: x_charge_delivery_fee_ind => x_charge_delivery_fee_ind,
516: x_administrator_id => x_administrator_id
517: );
518:
519: UPDATE igs_as_docproc_stup
520: SET
521: lifetime_trans_fee_ind = new_references.lifetime_trans_fee_ind,
522: provide_transcript_ind = new_references.provide_transcript_ind,
523: trans_request_if_hold_ind = new_references.trans_request_if_hold_ind,

Line 576: FROM igs_as_docproc_stup

572: || kdande 18-Oct-2002 Added new columns as per the Enh# 2632096.
573: */
574: CURSOR c1 IS
575: SELECT rowid
576: FROM igs_as_docproc_stup
577: WHERE tpset_id = x_tpset_id;
578:
579: BEGIN
580:

Line 649: DELETE FROM igs_as_docproc_stup

645: p_action => 'DELETE',
646: x_rowid => x_rowid
647: );
648:
649: DELETE FROM igs_as_docproc_stup
650: WHERE rowid = x_rowid;
651:
652: IF (SQL%NOTFOUND) THEN
653: RAISE NO_DATA_FOUND;

Line 659: END igs_as_docproc_stup_pkg;

655:
656: END delete_row;
657:
658:
659: END igs_as_docproc_stup_pkg;