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.JAI_CMN_RGM_SETTLEMENT_PKG dependencies on AP_INVOICES_INTERFACE

Line 55: ap_invoices_interface so that invoice_id condition can be used.

51: Passed operating unit also as this parameter has been added by base.
52:
53: 27-Feb-2006 Bug 4929081. Added by Lakshmi Gopalsami version 120.5
54: (1) Moved cursor counter_cur after inserting into
55: ap_invoices_interface so that invoice_id condition can be used.
56: (2) Removed the select for count(*) and put the same in the cursor.
57: 30-JAN-2007 Bug#5631784. Added by CSahoo File Version 120.11
58: Forward Porting of BUG#4742259 (TCS solution)
59: Changes made in the procedure create_invoice to create invoice at the

Line 1501: pn_created_by IN ap_invoices_interface.created_by%TYPE,

1497: pn_calculated_amount IN jai_rgm_settlements.calculated_amount%TYPE,
1498: pn_invoice_amount IN jai_rgm_settlements.payment_amount%TYPE,
1499: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
1500: pv_regsitration_no IN jai_rgm_settlements.primary_registration_no%TYPE,
1501: pn_created_by IN ap_invoices_interface.created_by%TYPE,
1502: pd_creation_date IN ap_invoices_interface.creation_date%TYPE,
1503: pn_last_updated_by IN ap_invoices_interface.last_updated_by%TYPE,
1504: pd_last_update_date IN ap_invoices_interface.last_update_date%TYPE,
1505: pn_last_update_login IN ap_invoices_interface.last_update_login%TYPE,

Line 1502: pd_creation_date IN ap_invoices_interface.creation_date%TYPE,

1498: pn_invoice_amount IN jai_rgm_settlements.payment_amount%TYPE,
1499: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
1500: pv_regsitration_no IN jai_rgm_settlements.primary_registration_no%TYPE,
1501: pn_created_by IN ap_invoices_interface.created_by%TYPE,
1502: pd_creation_date IN ap_invoices_interface.creation_date%TYPE,
1503: pn_last_updated_by IN ap_invoices_interface.last_updated_by%TYPE,
1504: pd_last_update_date IN ap_invoices_interface.last_update_date%TYPE,
1505: pn_last_update_login IN ap_invoices_interface.last_update_login%TYPE,
1506: pv_system_invoice_no OUT NOCOPY jai_rgm_settlements.system_invoice_no%TYPE,

Line 1503: pn_last_updated_by IN ap_invoices_interface.last_updated_by%TYPE,

1499: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
1500: pv_regsitration_no IN jai_rgm_settlements.primary_registration_no%TYPE,
1501: pn_created_by IN ap_invoices_interface.created_by%TYPE,
1502: pd_creation_date IN ap_invoices_interface.creation_date%TYPE,
1503: pn_last_updated_by IN ap_invoices_interface.last_updated_by%TYPE,
1504: pd_last_update_date IN ap_invoices_interface.last_update_date%TYPE,
1505: pn_last_update_login IN ap_invoices_interface.last_update_login%TYPE,
1506: pv_system_invoice_no OUT NOCOPY jai_rgm_settlements.system_invoice_no%TYPE,
1507: pv_process_flag OUT NOCOPY VARCHAR2,

Line 1504: pd_last_update_date IN ap_invoices_interface.last_update_date%TYPE,

1500: pv_regsitration_no IN jai_rgm_settlements.primary_registration_no%TYPE,
1501: pn_created_by IN ap_invoices_interface.created_by%TYPE,
1502: pd_creation_date IN ap_invoices_interface.creation_date%TYPE,
1503: pn_last_updated_by IN ap_invoices_interface.last_updated_by%TYPE,
1504: pd_last_update_date IN ap_invoices_interface.last_update_date%TYPE,
1505: pn_last_update_login IN ap_invoices_interface.last_update_login%TYPE,
1506: pv_system_invoice_no OUT NOCOPY jai_rgm_settlements.system_invoice_no%TYPE,
1507: pv_process_flag OUT NOCOPY VARCHAR2,
1508: pv_process_message OUT NOCOPY VARCHAR2)

Line 1505: pn_last_update_login IN ap_invoices_interface.last_update_login%TYPE,

1501: pn_created_by IN ap_invoices_interface.created_by%TYPE,
1502: pd_creation_date IN ap_invoices_interface.creation_date%TYPE,
1503: pn_last_updated_by IN ap_invoices_interface.last_updated_by%TYPE,
1504: pd_last_update_date IN ap_invoices_interface.last_update_date%TYPE,
1505: pn_last_update_login IN ap_invoices_interface.last_update_login%TYPE,
1506: pv_system_invoice_no OUT NOCOPY jai_rgm_settlements.system_invoice_no%TYPE,
1507: pv_process_flag OUT NOCOPY VARCHAR2,
1508: pv_process_message OUT NOCOPY VARCHAR2)
1509: IS

Line 1533: CURSOR counter_cur(pn_invoice_id ap_invoices_interface.invoice_id%TYPE) IS

1529: pay_group_lookup_code
1530: FROM po_vendors
1531: WHERE vendor_id = pn_vendor_id;
1532:
1533: CURSOR counter_cur(pn_invoice_id ap_invoices_interface.invoice_id%TYPE) IS
1534: SELECT NVL(MAX(line_number),0)
1535: FROM ap_invoice_lines_interface
1536: -- bug 4929081. Added by Lakshmi Gopalsami
1537: WHERE invoice_id = pn_invoice_id;

Line 1646: CURSOR cur_inv_exists(pn_invoice_id IN ap_invoices_interface.invoice_id%TYPE) IS

1642: HAVING sum(debit_balance) - sum(credit_balance) > 0;
1643:
1644: -- Bug 4929081. Added by Lakshmi Gopalsami
1645:
1646: CURSOR cur_inv_exists(pn_invoice_id IN ap_invoices_interface.invoice_id%TYPE) IS
1647: SELECT 'Y'
1648: FROM ap_invoices_interface
1649: WHERE invoice_id = pn_invoice_id;
1650:

Line 1648: FROM ap_invoices_interface

1644: -- Bug 4929081. Added by Lakshmi Gopalsami
1645:
1646: CURSOR cur_inv_exists(pn_invoice_id IN ap_invoices_interface.invoice_id%TYPE) IS
1647: SELECT 'Y'
1648: FROM ap_invoices_interface
1649: WHERE invoice_id = pn_invoice_id;
1650:
1651:
1652: lv_invoice_num ap_invoices_interface.invoice_num%TYPE;

Line 1652: lv_invoice_num ap_invoices_interface.invoice_num%TYPE;

1648: FROM ap_invoices_interface
1649: WHERE invoice_id = pn_invoice_id;
1650:
1651:
1652: lv_invoice_num ap_invoices_interface.invoice_num%TYPE;
1653: lv_currency_code gl_sets_of_books.currency_code%TYPE;
1654: for_terms_id_rec for_terms_id%ROWTYPE;
1655: counter_tds_dm_v NUMBER;
1656: ln_tmp NUMBER;