APPS.IGS_FI_OTC_CHARGES_PKG dependencies on IGS_FI_OTC_CHARGES

Line 1: PACKAGE BODY igs_fi_otc_charges_pkg AS

1: PACKAGE BODY igs_fi_otc_charges_pkg AS
2: /* $Header: IGSSIA4B.pls 115.4 2002/11/29 04:01:23 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_otc_charges%ROWTYPE;

Line 5: old_references igs_fi_otc_charges%ROWTYPE;

1: PACKAGE BODY igs_fi_otc_charges_pkg AS
2: /* $Header: IGSSIA4B.pls 115.4 2002/11/29 04:01:23 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_otc_charges%ROWTYPE;
6: new_references igs_fi_otc_charges%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_fi_otc_charges%ROWTYPE;

2: /* $Header: IGSSIA4B.pls 115.4 2002/11/29 04:01:23 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_otc_charges%ROWTYPE;
6: new_references igs_fi_otc_charges%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM IGS_FI_OTC_CHARGES

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

Line 148: FROM igs_fi_otc_charges

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

Line 184: FROM igs_fi_otc_charges

180: || (reverse chronological order - newest change first)
181: */
182: CURSOR cur_rowid IS
183: SELECT rowid
184: FROM igs_fi_otc_charges
185: WHERE credit_id = x_credit_id
186: AND invoice_id = x_invoice_id
187: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
188:

Line 220: FROM igs_fi_otc_charges

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

Line 255: FROM igs_fi_otc_charges

251: || (reverse chronological order - newest change first)
252: */
253: CURSOR cur_rowid IS
254: SELECT rowid
255: FROM igs_fi_otc_charges
256: WHERE ((invoice_id = x_invoice_id));
257:
258: lv_rowid cur_rowid%RowType;
259:

Line 365: FROM igs_fi_otc_charges

361: || (reverse chronological order - newest change first)
362: */
363: CURSOR c IS
364: SELECT rowid
365: FROM igs_fi_otc_charges
366: WHERE otc_charge_id = x_otc_charge_id;
367:
368: x_last_update_date DATE;
369: x_last_updated_by NUMBER;

Line 393: SELECT igs_fi_otc_charges_s.NEXTVAL

389: igs_ge_msg_stack.add;
390: app_exception.raise_exception;
391: END IF;
392:
393: SELECT igs_fi_otc_charges_s.NEXTVAL
394: INTO x_otc_charge_id
395: FROM dual;
396:
397: before_dml(

Line 410: INSERT INTO igs_fi_otc_charges (

406: x_last_updated_by => x_last_updated_by,
407: x_last_update_login => x_last_update_login
408: );
409:
410: INSERT INTO igs_fi_otc_charges (
411: otc_charge_id,
412: invoice_id,
413: credit_id,
414: creation_date,

Line 460: FROM igs_fi_otc_charges

456: CURSOR c1 IS
457: SELECT
458: invoice_id,
459: credit_id
460: FROM igs_fi_otc_charges
461: WHERE rowid = x_rowid
462: FOR UPDATE NOWAIT;
463:
464: tlinfo c1%ROWTYPE;

Line 549: UPDATE igs_fi_otc_charges

545: x_last_updated_by => x_last_updated_by,
546: x_last_update_login => x_last_update_login
547: );
548:
549: UPDATE igs_fi_otc_charges
550: SET
551: invoice_id = new_references.invoice_id,
552: credit_id = new_references.credit_id,
553: last_update_date = x_last_update_date,

Line 583: FROM igs_fi_otc_charges

579: || (reverse chronological order - newest change first)
580: */
581: CURSOR c1 IS
582: SELECT rowid
583: FROM igs_fi_otc_charges
584: WHERE otc_charge_id = x_otc_charge_id;
585:
586: BEGIN
587:

Line 634: DELETE FROM igs_fi_otc_charges

630: p_action => 'DELETE',
631: x_rowid => x_rowid
632: );
633:
634: DELETE FROM igs_fi_otc_charges
635: WHERE rowid = x_rowid;
636:
637: IF (SQL%NOTFOUND) THEN
638: RAISE NO_DATA_FOUND;

Line 644: END igs_fi_otc_charges_pkg;

640:
641: END delete_row;
642:
643:
644: END igs_fi_otc_charges_pkg;