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 976: pn_created_by IN ap_invoices_interface.created_by%TYPE,

972: pn_calculated_amount IN jai_rgm_settlements.calculated_amount%TYPE,
973: pn_invoice_amount IN jai_rgm_settlements.payment_amount%TYPE,
974: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
975: pv_regsitration_no IN jai_rgm_settlements.primary_registration_no%TYPE,
976: pn_created_by IN ap_invoices_interface.created_by%TYPE,
977: pd_creation_date IN ap_invoices_interface.creation_date%TYPE,
978: pn_last_updated_by IN ap_invoices_interface.last_updated_by%TYPE,
979: pd_last_update_date IN ap_invoices_interface.last_update_date%TYPE,
980: pn_last_update_login IN ap_invoices_interface.last_update_login%TYPE,

Line 977: pd_creation_date IN ap_invoices_interface.creation_date%TYPE,

973: pn_invoice_amount IN jai_rgm_settlements.payment_amount%TYPE,
974: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
975: pv_regsitration_no IN jai_rgm_settlements.primary_registration_no%TYPE,
976: pn_created_by IN ap_invoices_interface.created_by%TYPE,
977: pd_creation_date IN ap_invoices_interface.creation_date%TYPE,
978: pn_last_updated_by IN ap_invoices_interface.last_updated_by%TYPE,
979: pd_last_update_date IN ap_invoices_interface.last_update_date%TYPE,
980: pn_last_update_login IN ap_invoices_interface.last_update_login%TYPE,
981: pv_system_invoice_no OUT NOCOPY jai_rgm_settlements.system_invoice_no%TYPE,

Line 978: pn_last_updated_by IN ap_invoices_interface.last_updated_by%TYPE,

974: pn_org_id IN jai_rgm_stl_balances.party_id%TYPE,
975: pv_regsitration_no IN jai_rgm_settlements.primary_registration_no%TYPE,
976: pn_created_by IN ap_invoices_interface.created_by%TYPE,
977: pd_creation_date IN ap_invoices_interface.creation_date%TYPE,
978: pn_last_updated_by IN ap_invoices_interface.last_updated_by%TYPE,
979: pd_last_update_date IN ap_invoices_interface.last_update_date%TYPE,
980: pn_last_update_login IN ap_invoices_interface.last_update_login%TYPE,
981: pv_system_invoice_no OUT NOCOPY jai_rgm_settlements.system_invoice_no%TYPE,
982: pv_process_flag OUT NOCOPY VARCHAR2,

Line 979: pd_last_update_date IN ap_invoices_interface.last_update_date%TYPE,

975: pv_regsitration_no IN jai_rgm_settlements.primary_registration_no%TYPE,
976: pn_created_by IN ap_invoices_interface.created_by%TYPE,
977: pd_creation_date IN ap_invoices_interface.creation_date%TYPE,
978: pn_last_updated_by IN ap_invoices_interface.last_updated_by%TYPE,
979: pd_last_update_date IN ap_invoices_interface.last_update_date%TYPE,
980: pn_last_update_login IN ap_invoices_interface.last_update_login%TYPE,
981: pv_system_invoice_no OUT NOCOPY jai_rgm_settlements.system_invoice_no%TYPE,
982: pv_process_flag OUT NOCOPY VARCHAR2,
983: pv_process_message OUT NOCOPY VARCHAR2)

Line 980: pn_last_update_login IN ap_invoices_interface.last_update_login%TYPE,

976: pn_created_by IN ap_invoices_interface.created_by%TYPE,
977: pd_creation_date IN ap_invoices_interface.creation_date%TYPE,
978: pn_last_updated_by IN ap_invoices_interface.last_updated_by%TYPE,
979: pd_last_update_date IN ap_invoices_interface.last_update_date%TYPE,
980: pn_last_update_login IN ap_invoices_interface.last_update_login%TYPE,
981: pv_system_invoice_no OUT NOCOPY jai_rgm_settlements.system_invoice_no%TYPE,
982: pv_process_flag OUT NOCOPY VARCHAR2,
983: pv_process_message OUT NOCOPY VARCHAR2)
984: IS

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

1004: pay_group_lookup_code
1005: FROM po_vendors
1006: WHERE vendor_id = pn_vendor_id;
1007:
1008: CURSOR counter_cur(pn_invoice_id ap_invoices_interface.invoice_id%TYPE) IS
1009: SELECT NVL(MAX(line_number),0)
1010: FROM ap_invoice_lines_interface
1011: -- bug 4929081. Added by Lakshmi Gopalsami
1012: WHERE invoice_id = pn_invoice_id;

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

1077: HAVING sum(debit_balance) - sum(credit_balance) > 0;
1078:
1079: -- Bug 4929081. Added by Lakshmi Gopalsami
1080:
1081: CURSOR cur_inv_exists(pn_invoice_id IN ap_invoices_interface.invoice_id%TYPE) IS
1082: SELECT 'Y'
1083: FROM ap_invoices_interface
1084: WHERE invoice_id = pn_invoice_id;
1085:

Line 1083: FROM ap_invoices_interface

1079: -- Bug 4929081. Added by Lakshmi Gopalsami
1080:
1081: CURSOR cur_inv_exists(pn_invoice_id IN ap_invoices_interface.invoice_id%TYPE) IS
1082: SELECT 'Y'
1083: FROM ap_invoices_interface
1084: WHERE invoice_id = pn_invoice_id;
1085:
1086:
1087: lv_invoice_num ap_invoices_interface.invoice_num%TYPE;

Line 1087: lv_invoice_num ap_invoices_interface.invoice_num%TYPE;

1083: FROM ap_invoices_interface
1084: WHERE invoice_id = pn_invoice_id;
1085:
1086:
1087: lv_invoice_num ap_invoices_interface.invoice_num%TYPE;
1088: lv_currency_code gl_sets_of_books.currency_code%TYPE;
1089: for_terms_id_rec for_terms_id%ROWTYPE;
1090: counter_tds_dm_v NUMBER;
1091: ln_tmp NUMBER;