APPS.IGS_AS_DOC_DLVY_FEE_PKG dependencies on IGS_AS_DOC_DLVY_FEE

Line 1: PACKAGE BODY igs_as_doc_dlvy_fee_pkg AS

1: PACKAGE BODY igs_as_doc_dlvy_fee_pkg AS
2: /* $Header: IGSDI68B.pls 115.2 2003/02/11 10:08:00 pathipat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_doc_dlvy_fee%ROWTYPE;

Line 5: old_references igs_as_doc_dlvy_fee%ROWTYPE;

1: PACKAGE BODY igs_as_doc_dlvy_fee_pkg AS
2: /* $Header: IGSDI68B.pls 115.2 2003/02/11 10:08:00 pathipat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_doc_dlvy_fee%ROWTYPE;
6: new_references igs_as_doc_dlvy_fee%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_as_doc_dlvy_fee%ROWTYPE;

2: /* $Header: IGSDI68B.pls 115.2 2003/02/11 10:08:00 pathipat noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_doc_dlvy_fee%ROWTYPE;
6: new_references igs_as_doc_dlvy_fee%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 33: FROM igs_as_doc_dlvy_fee

29: */
30:
31: CURSOR cur_old_ref_values IS
32: SELECT *
33: FROM igs_as_doc_dlvy_fee
34: WHERE rowid = x_rowid;
35:
36: BEGIN
37:

Line 149: FROM igs_as_doc_dlvy_fee

145: || (reverse chronological order - newest change first)
146: */
147: CURSOR cur_rowid IS
148: SELECT rowid
149: FROM igs_as_doc_dlvy_fee
150: WHERE dfee_id = x_dfee_id
151: FOR UPDATE NOWAIT;
152:
153: lv_rowid cur_rowid%RowType;

Line 184: FROM igs_as_doc_dlvy_fee

180: || (reverse chronological order - newest change first)
181: */
182: CURSOR cur_rowid IS
183: SELECT rowid
184: FROM igs_as_doc_dlvy_fee
185: WHERE (delivery_method_type = x_delivery_method_type)
186: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
187:
188: lv_rowid cur_rowid%RowType;

Line 219: FROM igs_as_doc_dlvy_fee

215: || (reverse chronological order - newest change first)
216: */
217: CURSOR cur_rowid IS
218: SELECT rowid
219: FROM igs_as_doc_dlvy_fee
220: WHERE ((delivery_method_type = x_delivery_method_type));
221:
222: lv_rowid cur_rowid%RowType;
223:

Line 332: FROM igs_as_doc_dlvy_fee

328: || (reverse chronological order - newest change first)
329: */
330: CURSOR c IS
331: SELECT rowid
332: FROM igs_as_doc_dlvy_fee
333: WHERE dfee_id = x_dfee_id;
334:
335: x_last_update_date DATE;
336: x_last_updated_by NUMBER;

Line 360: SELECT igs_as_doc_dlvy_fee_s.NEXTVAL

356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: END IF;
359:
360: SELECT igs_as_doc_dlvy_fee_s.NEXTVAL
361: INTO x_dfee_id
362: FROM dual;
363:
364: before_dml(

Line 378: INSERT INTO igs_as_doc_dlvy_fee (

374: x_last_updated_by => x_last_updated_by,
375: x_last_update_login => x_last_update_login
376: );
377:
378: INSERT INTO igs_as_doc_dlvy_fee (
379: dfee_id,
380: delivery_method_type,
381: amount,
382: fee_type,

Line 432: FROM igs_as_doc_dlvy_fee

428: SELECT
429: delivery_method_type,
430: amount,
431: fee_type
432: FROM igs_as_doc_dlvy_fee
433: WHERE rowid = x_rowid
434: FOR UPDATE NOWAIT;
435:
436: tlinfo c1%ROWTYPE;

Line 524: UPDATE igs_as_doc_dlvy_fee

520: x_last_updated_by => x_last_updated_by,
521: x_last_update_login => x_last_update_login
522: );
523:
524: UPDATE igs_as_doc_dlvy_fee
525: SET
526: delivery_method_type = new_references.delivery_method_type,
527: amount = new_references.amount,
528: fee_type = new_references.fee_type,

Line 560: FROM igs_as_doc_dlvy_fee

556: || (reverse chronological order - newest change first)
557: */
558: CURSOR c1 IS
559: SELECT rowid
560: FROM igs_as_doc_dlvy_fee
561: WHERE dfee_id = x_dfee_id;
562:
563: BEGIN
564:

Line 613: DELETE FROM igs_as_doc_dlvy_fee

609: p_action => 'DELETE',
610: x_rowid => x_rowid
611: );
612:
613: DELETE FROM igs_as_doc_dlvy_fee
614: WHERE rowid = x_rowid;
615:
616: IF (SQL%NOTFOUND) THEN
617: RAISE NO_DATA_FOUND;

Line 623: END igs_as_doc_dlvy_fee_pkg;

619:
620: END delete_row;
621:
622:
623: END igs_as_doc_dlvy_fee_pkg;