eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_REFUNDS_PKG dependencies on IGS_FI_REFUNDS

Line 1: PACKAGE BODY igs_fi_refunds_pkg AS

1: PACKAGE BODY igs_fi_refunds_pkg AS
2: /* $Header: IGSSIB4B.pls 120.3 2006/06/27 14:18:40 skharida ship $ */
3:
4: /*
5: || Created By : Vinay

Line 27: old_references igs_fi_refunds%ROWTYPE;

23: -- Who: vchappid
24: -- When: 25-Feb-2002
25:
26: l_rowid VARCHAR2(25);
27: old_references igs_fi_refunds%ROWTYPE;
28: new_references igs_fi_refunds%ROWTYPE;
29:
30: -- Initial Declaration of the procedure
31: PROCEDURE beforerowinsert;

Line 28: new_references igs_fi_refunds%ROWTYPE;

24: -- When: 25-Feb-2002
25:
26: l_rowid VARCHAR2(25);
27: old_references igs_fi_refunds%ROWTYPE;
28: new_references igs_fi_refunds%ROWTYPE;
29:
30: -- Initial Declaration of the procedure
31: PROCEDURE beforerowinsert;
32:

Line 43: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL and IGS_FI_REFUNDS

39: || Known limitations, enhancements or remarks :
40: || Change History :
41: || Who When What
42: || (reverse chronological order - newest change first)
43: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_INV_INT_ALL and IGS_FI_REFUNDS
44: || smadathi 01-Nov-2002 Enh. Bug 2584986. Modified igs_fi_inv_int_pkg.update_row
45: || to add new column REVERSAL_GL_DATE
46: || vvutukur 18-Sep-2002 Enh#2564643.Removed references to subaccount_id.ie., from the call to
47: || igs_fi_inv_int_pkg.update_row.

Line 163: skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_REFUNDS

159: Bug: 2144600
160: What: Created TBH
161: Who: vchappid
162: When: 25-Feb-2002
163: skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_REFUNDS
164: vvutukur 23-Sep-2002 removed default clause from parameters as gscc fix.
165: **********************************/
166:
167: CURSOR cur_old_ref_values IS

Line 169: FROM igs_fi_refunds

165: **********************************/
166:
167: CURSOR cur_old_ref_values IS
168: SELECT *
169: FROM igs_fi_refunds
170: WHERE rowid = x_rowid;
171:
172: BEGIN
173:

Line 378: ELSIF NOT igs_fi_refunds_pkg.get_pk_for_validation (

374:
375: IF (((old_references.source_refund_id = new_references.source_refund_id)) OR
376: ((new_references.source_refund_id IS NULL))) THEN
377: NULL;
378: ELSIF NOT igs_fi_refunds_pkg.get_pk_for_validation (
379: new_references.source_refund_id
380: ) THEN
381: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
382: igs_ge_msg_stack.add;

Line 412: igs_fi_refunds_pkg.get_fk_igs_fi_refunds (

408: || (reverse chronological order - newest change first)
409: */
410: BEGIN
411:
412: igs_fi_refunds_pkg.get_fk_igs_fi_refunds (
413: old_references.refund_id
414: );
415:
416: igs_fi_refund_int_pkg.get_fk_igs_fi_refunds (

Line 416: igs_fi_refund_int_pkg.get_fk_igs_fi_refunds (

412: igs_fi_refunds_pkg.get_fk_igs_fi_refunds (
413: old_references.refund_id
414: );
415:
416: igs_fi_refund_int_pkg.get_fk_igs_fi_refunds (
417: old_references.refund_id
418: );
419:
420: END check_child_existance;

Line 437: FROM igs_fi_refunds

433: || (reverse chronological order - newest change first)
434: */
435: CURSOR cur_rowid IS
436: SELECT rowid
437: FROM igs_fi_refunds
438: WHERE refund_id = x_refund_id
439: FOR UPDATE NOWAIT;
440:
441: lv_rowid cur_rowid%RowType;

Line 478: FROM igs_fi_refunds

474: || (reverse chronological order - newest change first)
475: */
476: CURSOR cur_rowid IS
477: SELECT rowid
478: FROM igs_fi_refunds
479: WHERE person_id = x_person_id
480: AND pay_person_id = x_pay_person_id
481: AND fee_type = x_fee_type
482: AND fee_cal_type = x_fee_cal_type

Line 505: PROCEDURE get_fk_igs_fi_refunds (

501:
502: END get_uk_for_validation ;
503:
504:
505: PROCEDURE get_fk_igs_fi_refunds (
506: x_refund_id IN NUMBER
507: ) AS
508: /*
509: || Created By : vchappid

Line 519: FROM igs_fi_refunds

515: || (reverse chronological order - newest change first)
516: */
517: CURSOR cur_rowid IS
518: SELECT rowid
519: FROM igs_fi_refunds
520: WHERE ((source_refund_id = x_refund_id));
521:
522: lv_rowid cur_rowid%RowType;
523:

Line 537: END get_fk_igs_fi_refunds;

533: RETURN;
534: END IF;
535: CLOSE cur_rowid;
536:
537: END get_fk_igs_fi_refunds;
538:
539:
540: PROCEDURE get_fk_igs_fi_inv_int (
541: x_invoice_id IN NUMBER

Line 551: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_REFUNDS

547: || Known limitations, enhancements or remarks :
548: || Change History :
549: || Who When What
550: || (reverse chronological order - newest change first)
551: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_REFUNDS
552: */
553: CURSOR cur_rowid IS
554: SELECT rowid
555: FROM igs_fi_refunds

Line 555: FROM igs_fi_refunds

551: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_REFUNDS
552: */
553: CURSOR cur_rowid IS
554: SELECT rowid
555: FROM igs_fi_refunds
556: WHERE ((invoice_id = x_invoice_id));
557:
558: lv_rowid cur_rowid%RowType;
559:

Line 634: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_REFUNDS

630: || Known limitations, enhancements or remarks :
631: || Change History :
632: || Who When What
633: || (reverse chronological order - newest change first)
634: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_REFUNDS
635: || smadathi 06-Nov-2002 Enh. Bug 2584986. Added new column GL_DATE,REVERSAL_GL_DATE
636: || vvutukur 23-Sep-2002 Enh#2564643.Removed default clause as gscc fix.
637: */
638: BEGIN

Line 781: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_REFUNDS

777: || Known limitations, enhancements or remarks :
778: || Change History :
779: || Who When What
780: || (reverse chronological order - newest change first)
781: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_REFUNDS
782: || smadathi 06-Nov-2002 Enh. Bug 2584986. Added new column GL_DATE,REVERSAL_GL_DATE
783: || vvutukur 23-Sep-2002 Enh#2564643.Removed default clause from parameters as gscc fix.
784: */
785: CURSOR c IS

Line 787: FROM igs_fi_refunds

783: || vvutukur 23-Sep-2002 Enh#2564643.Removed default clause from parameters as gscc fix.
784: */
785: CURSOR c IS
786: SELECT rowid
787: FROM igs_fi_refunds
788: WHERE refund_id = x_refund_id;
789:
790: x_last_update_date DATE;
791: x_last_updated_by NUMBER;

Line 831: SELECT igs_fi_refunds_s.NEXTVAL

827: igs_ge_msg_stack.add;
828: app_exception.raise_exception;
829: END IF;
830:
831: SELECT igs_fi_refunds_s.NEXTVAL
832: INTO x_refund_id
833: FROM dual;
834:
835: before_dml(

Line 885: INSERT INTO igs_fi_refunds (

881: x_gl_date => x_gl_date,
882: x_reversal_gl_date => x_reversal_gl_date
883: );
884:
885: INSERT INTO igs_fi_refunds (
886: refund_id,
887: voucher_date,
888: person_id,
889: pay_person_id,

Line 1048: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_REFUNDS

1044: || Purpose : Handles the LOCK mechanism for the table.
1045: || Known limitations, enhancements or remarks :
1046: || Change History :
1047: || Who When What
1048: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_REFUNDS
1049: || smadathi 06-Nov-2002 Enh. Bug 2584986. Added new column GL_DATE,REVERSAL_GL_DATE
1050: || (reverse chronological order - newest change first)
1051: */
1052: CURSOR c1 IS

Line 1093: FROM igs_fi_refunds

1089: attribute19,
1090: attribute20,
1091: gl_date,
1092: reversal_gl_date
1093: FROM igs_fi_refunds
1094: WHERE rowid = x_rowid
1095: FOR UPDATE NOWAIT;
1096:
1097: tlinfo c1%ROWTYPE;

Line 1217: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_REFUNDS

1213: || Known limitations, enhancements or remarks :
1214: || Change History :
1215: || Who When What
1216: || (reverse chronological order - newest change first)
1217: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_REFUNDS
1218: || smadathi 06-Nov-2002 Enh. Bug 2584986. Added new column GL_DATE,REVERSAL_GL_DATE
1219: || vvutukur 23-Sep-2002 Enh#2564643.Removed DEFAULT clause from parameters as gscc fix.
1220: */
1221: x_last_update_date DATE ;

Line 1314: UPDATE igs_fi_refunds

1310: x_program_update_date := SYSDATE;
1311: END IF;
1312: END IF;
1313:
1314: UPDATE igs_fi_refunds
1315: SET
1316: voucher_date = new_references.voucher_date,
1317: person_id = new_references.person_id,
1318: pay_person_id = new_references.pay_person_id,

Line 1423: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_REFUNDS

1419: || Known limitations, enhancements or remarks :
1420: || Change History :
1421: || Who When What
1422: || (reverse chronological order - newest change first)
1423: || skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns of the table IGS_FI_REFUNDS
1424: || smadathi 06-Nov-2002 Enh. Bug 2584986. Added new column GL_DATE,REVERSAL_GL_DATE
1425: || vvutukur 23-Sep-2002 Enh#2564643.Removed DEFAULT clause from parameters as gscc fix.
1426: */
1427: CURSOR c1 IS

Line 1429: FROM igs_fi_refunds

1425: || vvutukur 23-Sep-2002 Enh#2564643.Removed DEFAULT clause from parameters as gscc fix.
1426: */
1427: CURSOR c1 IS
1428: SELECT rowid
1429: FROM igs_fi_refunds
1430: WHERE refund_id = x_refund_id;
1431:
1432: BEGIN
1433:

Line 1554: DELETE FROM igs_fi_refunds

1550: p_action => 'DELETE',
1551: x_rowid => x_rowid
1552: );
1553:
1554: DELETE FROM igs_fi_refunds
1555: WHERE rowid = x_rowid;
1556:
1557: IF (SQL%NOTFOUND) THEN
1558: RAISE NO_DATA_FOUND;

Line 1568: || Purpose : Before a record is created in the igs_fi_refunds table, a charge record has to be created

1564: AS
1565: /*
1566: || Created By : vchappid
1567: || Created On : 26-FEB-2002
1568: || Purpose : Before a record is created in the igs_fi_refunds table, a charge record has to be created
1569: || call to charges api is made.
1570: || Known limitations, enhancements or remarks :
1571: || Change History :
1572: || Who When What

Line 1771: END igs_fi_refunds_pkg;

1767: -- Update the Invoice Record by calling the Update Invoice procedure
1768: update_invoice(new_references.invoice_id);
1769: END IF;
1770: END beforerowinsert;
1771: END igs_fi_refunds_pkg;