APPS.IGS_FI_BILL_TRNSCTNS_PKG dependencies on IGS_FI_BILL_TRNSCTNS

Line 1: PACKAGE BODY igs_fi_bill_trnsctns_pkg AS

1: PACKAGE BODY igs_fi_bill_trnsctns_pkg AS
2: /* $Header: IGSSIB7B.pls 115.4 2002/11/29 04:05:21 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_fi_bill_trnsctns%ROWTYPE;

Line 5: old_references igs_fi_bill_trnsctns%ROWTYPE;

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

Line 6: new_references igs_fi_bill_trnsctns%ROWTYPE;

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

Line 38: FROM IGS_FI_BILL_TRNSCTNS

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

Line 174: FROM igs_fi_bill_trnsctns

170: || (reverse chronological order - newest change first)
171: */
172: CURSOR cur_rowid IS
173: SELECT rowid
174: FROM igs_fi_bill_trnsctns
175: WHERE transaction_id = x_transaction_id
176: FOR UPDATE NOWAIT;
177:
178: lv_rowid cur_rowid%RowType;

Line 210: FROM igs_fi_bill_trnsctns

206: || (reverse chronological order - newest change first)
207: */
208: CURSOR cur_rowid IS
209: SELECT rowid
210: FROM igs_fi_bill_trnsctns
211: WHERE transaction_type = x_transaction_type
212: AND invoice_creditact_id = x_invoice_creditact_id
213: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
214:

Line 246: FROM igs_fi_bill_trnsctns

242: || (reverse chronological order - newest change first)
243: */
244: CURSOR cur_rowid IS
245: SELECT rowid
246: FROM igs_fi_bill_trnsctns
247: WHERE ((invoice_creditact_id = x_invoice_id));
248:
249: lv_rowid cur_rowid%RowType;
250:

Line 281: FROM igs_fi_bill_trnsctns

277: || (reverse chronological order - newest change first)
278: */
279: CURSOR cur_rowid IS
280: SELECT rowid
281: FROM igs_fi_bill_trnsctns
282: WHERE ((bill_id = x_bill_id));
283:
284: lv_rowid cur_rowid%RowType;
285:

Line 316: FROM igs_fi_bill_trnsctns

312: || (reverse chronological order - newest change first)
313: */
314: CURSOR cur_rowid IS
315: SELECT rowid
316: FROM igs_fi_bill_trnsctns
317: WHERE ((invoice_creditact_id = x_credit_activity_id));
318:
319: lv_rowid cur_rowid%RowType;
320:

Line 444: FROM igs_fi_bill_trnsctns

440: || (reverse chronological order - newest change first)
441: */
442: CURSOR c IS
443: SELECT rowid
444: FROM igs_fi_bill_trnsctns
445: WHERE transaction_id = x_transaction_id;
446:
447: x_last_update_date DATE;
448: x_last_updated_by NUMBER;

Line 488: SELECT igs_fi_bill_trnsctns_s.NEXTVAL

484: igs_ge_msg_stack.add;
485: app_exception.raise_exception;
486: END IF;
487:
488: SELECT igs_fi_bill_trnsctns_s.NEXTVAL
489: INTO x_transaction_id
490: FROM dual;
491:
492: before_dml(

Line 511: INSERT INTO igs_fi_bill_trnsctns (

507: x_last_updated_by => x_last_updated_by,
508: x_last_update_login => x_last_update_login
509: );
510:
511: INSERT INTO igs_fi_bill_trnsctns (
512: transaction_id,
513: bill_id,
514: transaction_type,
515: invoice_creditact_id,

Line 593: FROM igs_fi_bill_trnsctns

589: transaction_number,
590: fee_credit_type,
591: transaction_description,
592: transaction_amount
593: FROM igs_fi_bill_trnsctns
594: WHERE rowid = x_rowid
595: FOR UPDATE NOWAIT;
596:
597: tlinfo c1%ROWTYPE;

Line 718: UPDATE igs_fi_bill_trnsctns

714: x_program_update_date := SYSDATE;
715: END IF;
716: END IF;
717:
718: UPDATE igs_fi_bill_trnsctns
719: SET
720: bill_id = new_references.bill_id,
721: transaction_type = new_references.transaction_type,
722: invoice_creditact_id = new_references.invoice_creditact_id,

Line 768: FROM igs_fi_bill_trnsctns

764: || (reverse chronological order - newest change first)
765: */
766: CURSOR c1 IS
767: SELECT rowid
768: FROM igs_fi_bill_trnsctns
769: WHERE transaction_id = x_transaction_id;
770:
771: BEGIN
772:

Line 831: DELETE FROM igs_fi_bill_trnsctns

827: p_action => 'DELETE',
828: x_rowid => x_rowid
829: );
830:
831: DELETE FROM igs_fi_bill_trnsctns
832: WHERE rowid = x_rowid;
833:
834: IF (SQL%NOTFOUND) THEN
835: RAISE NO_DATA_FOUND;

Line 841: END igs_fi_bill_trnsctns_pkg;

837:
838: END delete_row;
839:
840:
841: END igs_fi_bill_trnsctns_pkg;