APPS.IGS_FI_REFUNDS_PKG dependencies on IGS_FI_INV_INT

Line 33: PROCEDURE update_invoice(p_invoice_id igs_fi_inv_int.invoice_id%TYPE) AS

29:
30: -- Initial Declaration of the procedure
31: PROCEDURE beforerowinsert;
32:
33: PROCEDURE update_invoice(p_invoice_id igs_fi_inv_int.invoice_id%TYPE) AS
34: /*
35: || Created By : Amit.Gairola
36: || Created On : 06-JUN-2002
37: || Purpose : Updates the Charge record in case of reversal. Updates the Reversal Flag and the reversal reason

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 44: || smadathi 01-Nov-2002 Enh. Bug 2584986. Modified igs_fi_inv_int_pkg.update_row

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.
48: */

Line 47: || igs_fi_inv_int_pkg.update_row.

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.
48: */
49:
50: CURSOR cur_inv(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
51: SELECT inv.*

Line 50: CURSOR cur_inv(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS

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.
48: */
49:
50: CURSOR cur_inv(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
51: SELECT inv.*
52: FROM igs_fi_inv_int inv
53: WHERE inv.invoice_id = cp_invoice_id;
54:

Line 52: FROM igs_fi_inv_int inv

48: */
49:
50: CURSOR cur_inv(cp_invoice_id igs_fi_inv_int.invoice_id%TYPE) IS
51: SELECT inv.*
52: FROM igs_fi_inv_int inv
53: WHERE inv.invoice_id = cp_invoice_id;
54:
55: BEGIN
56: IF new_references.source_refund_id IS NOT NULL THEN

Line 58: igs_fi_inv_int_pkg.update_row (

54:
55: BEGIN
56: IF new_references.source_refund_id IS NOT NULL THEN
57: FOR recinv IN cur_inv(p_invoice_id) LOOP
58: igs_fi_inv_int_pkg.update_row (
59: x_rowid => recinv.row_id,
60: x_invoice_id => recinv.invoice_id,
61: x_person_id => recinv.person_id,
62: x_fee_type => recinv.fee_type,

Line 389: ELSIF NOT igs_fi_inv_int_pkg.get_pk_for_validation (

385:
386: IF (((old_references.invoice_id = new_references.invoice_id)) OR
387: ((new_references.invoice_id IS NULL))) THEN
388: NULL;
389: ELSIF NOT igs_fi_inv_int_pkg.get_pk_for_validation (
390: new_references.invoice_id
391: ) THEN
392: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
393: igs_ge_msg_stack.add;

Line 540: PROCEDURE get_fk_igs_fi_inv_int (

536:
537: END get_fk_igs_fi_refunds;
538:
539:
540: PROCEDURE get_fk_igs_fi_inv_int (
541: x_invoice_id IN NUMBER
542: ) AS
543: /*
544: || Created By : vchappid

Line 573: END get_fk_igs_fi_inv_int;

569: RETURN;
570: END IF;
571: CLOSE cur_rowid;
572:
573: END get_fk_igs_fi_inv_int;
574:
575:
576: PROCEDURE before_dml (
577: p_action IN VARCHAR2,

Line 1597: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;

1593: -- Variables added for the Charges API call
1594: l_header_rec igs_fi_charges_api_pvt.header_rec_type;
1595: l_line_tbl igs_fi_charges_api_pvt.line_tbl_type;
1596: l_line_id_tbl igs_fi_charges_api_pvt.line_id_tbl_type;
1597: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
1598: l_description igs_fi_fee_type.description%TYPE;
1599: l_return_status VARCHAR2(1);
1600: l_msg_count NUMBER(3);
1601: l_msg_data VARCHAR2(2000);