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_PO_PROC_PKG dependencies on JAI_PLSQL_CACHE_PKG

Line 3894: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

3890: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE;
3891: v_modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%type;
3892: v_parent_req_line_id po_requisition_lines_all.parent_req_line_id%type;
3893: lv_unit_meas_lookup po_line_locations_all.unit_meas_lookup_code%TYPE;
3894: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
3895: r_req_line PO_REQUISITION_LINES_ALL%ROWTYPE;
3896:
3897: /* CURSOR get_requesition_info IS
3898: SELECT *

Line 3936: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

3932: OPEN Fetch_Org_Id_Cur(pr_requisition_line.Destination_Organization_Id);
3933: FETCH Fetch_Org_Id_Cur INTO v_org_id;
3934: CLOSE Fetch_Org_Id_Cur;
3935:
3936: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
3937: (p_org_id => pr_requisition_line.Destination_Organization_Id );
3938: v_gl_set_of_bks_id := l_func_curr_det.ledger_id;
3939: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3940: FND_LOG.STRING(log_level =>G_LEVEL_PROCEDURE

Line 4075: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

4071: v_total_amount NUMBER;
4072: v_exclu_tax_amount NUMBER;
4073:
4074: v_type_lookup_code Po_Requisition_Headers_All.Type_Lookup_Code % TYPE;
4075: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
4076: r_new_req_line PO_REQUISITION_LINES_ALL%ROWTYPE;
4077: r_old_jai_req_line JAI_PO_REQ_LINES%ROWTYPE;
4078: r_old_jai_req_tax_line JAI_PO_REQ_LINE_TAXES%ROWTYPE;
4079:

Line 4230: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

4226: CLOSE site_cur;
4227:
4228:
4229:
4230: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
4231: (p_org_id => v_dest_org_id );
4232: v_gl_set_of_bks_id := l_func_curr_det.ledger_id;
4233:
4234:

Line 4445: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

4441: lv_apps_source_code po_requisition_headers_all.apps_source_code%type;
4442: v_modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%type;
4443: v_parent_req_line_id po_requisition_lines_all.parent_req_line_id%type;
4444: lv_unit_meas_lookup po_line_locations_all.unit_meas_lookup_code%TYPE;
4445: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
4446: r_req_line PO_REQUISITION_LINES_ALL%ROWTYPE;
4447:
4448: /* CURSOR get_requesition_info IS
4449: SELECT *

Line 4565: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr

4561: OPEN Fetch_Org_Id_Cur(pr_requisition_line.Destination_Organization_Id);
4562: FETCH Fetch_Org_Id_Cur INTO v_org_id;
4563: CLOSE Fetch_Org_Id_Cur;
4564:
4565: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
4566: (p_org_id => pr_requisition_line.Destination_Organization_Id );
4567: v_gl_set_of_bks_id := l_func_curr_det.ledger_id;
4568:
4569:

Line 4953: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

4949:
4950: lv_tax_cnt NUMBER := 0;
4951: lv_tax_from_reqn_flag varchar2(1) := 'N';
4952:
4953: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
4954: v_requisition_header_id NUMBER;
4955: v_reqn_tax NUMBER;
4956:
4957: CURSOR Fetch_Focus_Id_Cur_for_req( line_id IN NUMBER , line_loc_id in Number ) IS

Line 6445: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

6441: END insert_po_taxes;
6442: FUNCTION get_currency_conv_rate (v_inv_org_id IN number,v_currency IN VARCHAR2, v_rate_date IN DATE, v_rate_type IN VARCHAR2, v_rate IN NUMBER) RETURN NUMBER IS
6443: v_conv_rate NUMBER;
6444: v_bookid NUMBER;
6445: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
6446: l_api_name CONSTANT VARCHAR2(200) := 'get_currency_conv_rate';
6447: BEGIN
6448:
6449: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 6452: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_inv_org_id );

6448:
6449: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6450: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
6451: END IF;
6452: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_inv_org_id );
6453:
6454: IF l_func_curr_det.currency_code <> v_currency OR v_currency IS NOT NULL THEN
6455:
6456: IF v_rate_type = 'User' THEN

Line 6484: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

6480: app_exception.raise_exception;
6481:
6482: END get_currency_conv_rate;
6483: FUNCTION get_func_currency(v_inv_org_id IN NUMBER)RETURN VARCHAR2 IS
6484: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
6485: BEGIN
6486: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_inv_org_id );
6487: RETURN l_func_curr_det.currency_code;
6488: END get_func_currency;

Line 6486: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_inv_org_id );

6482: END get_currency_conv_rate;
6483: FUNCTION get_func_currency(v_inv_org_id IN NUMBER)RETURN VARCHAR2 IS
6484: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
6485: BEGIN
6486: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_inv_org_id );
6487: RETURN l_func_curr_det.currency_code;
6488: END get_func_currency;
6489:
6490: FUNCTION rfq_quotation_related

Line 8381: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

8377:
8378: lv_tax_cnt NUMBER := 0;
8379: lv_tax_from_reqn_flag varchar2(1) := 'N';
8380:
8381: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
8382: v_requisition_header_id NUMBER;
8383: v_reqn_tax NUMBER;
8384:
8385: CURSOR Fetch_Focus_Id_Cur_for_req( line_id IN NUMBER , line_loc_id in Number ) IS