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 PO_REQUISITION_HEADERS_ALL

Line 3889: lv_apps_source_code po_requisition_headers_all.apps_source_code%type;

3885: v_tax_amount NUMBER;
3886: v_exclu_tax_amount NUMBER;
3887: v_total_amount NUMBER;
3888:
3889: lv_apps_source_code po_requisition_headers_all.apps_source_code%type;
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;

Line 3909: FROM Po_Requisition_Headers_All A

3905: WHERE Organization_Id = p_Destination_Organization_Id;
3906:
3907: CURSOR org_cur(p_requisition_Header_Id NUMBER) IS
3908: SELECT A.Segment1, A.Type_Lookup_Code,apps_source_code
3909: FROM Po_Requisition_Headers_All A
3910: WHERE A.Requisition_Header_Id = p_requisition_Header_Id;
3911:
3912:
3913: l_api_name CONSTANT VARCHAR2(200) := 'process_inserting';

Line 4074: v_type_lookup_code Po_Requisition_Headers_All.Type_Lookup_Code % TYPE;

4070: v_line_amount NUMBER;
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;

Line 4102: FROM Po_Requisition_Headers_All

4098: WHERE Organization_Id = v_dest_org_id;
4099:
4100: CURSOR bind_cur IS
4101: SELECT Segment1, Type_Lookup_Code, apps_source_code
4102: FROM Po_Requisition_Headers_All
4103: WHERE Requisition_Header_Id = v_header_id;
4104:
4105: CURSOR vend_cur(p_sugg_vendor_name IN VARCHAR2) IS
4106: SELECT vendor_id

Line 4439: v_seg_id Po_Requisition_Headers_All.Segment1%TYPE;

4435: v_sob_hrou_id NUMBER;
4436: ln_tax_amount NUMBER;
4437: v_reqn_ctr Number :=0;
4438:
4439: v_seg_id Po_Requisition_Headers_All.Segment1%TYPE;
4440: v_type_lookup_code Po_Requisition_Headers_All.Type_Lookup_Code%TYPE;
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;

Line 4440: v_type_lookup_code Po_Requisition_Headers_All.Type_Lookup_Code%TYPE;

4436: ln_tax_amount NUMBER;
4437: v_reqn_ctr Number :=0;
4438:
4439: v_seg_id Po_Requisition_Headers_All.Segment1%TYPE;
4440: v_type_lookup_code Po_Requisition_Headers_All.Type_Lookup_Code%TYPE;
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;

Line 4441: lv_apps_source_code po_requisition_headers_all.apps_source_code%type;

4437: v_reqn_ctr Number :=0;
4438:
4439: v_seg_id Po_Requisition_Headers_All.Segment1%TYPE;
4440: v_type_lookup_code Po_Requisition_Headers_All.Type_Lookup_Code%TYPE;
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;

Line 4460: FROM Po_Requisition_Headers_All A

4456: WHERE Organization_Id = p_Destination_Organization_Id;
4457:
4458: CURSOR org_cur(p_requisition_Header_Id NUMBER) IS
4459: SELECT A.Segment1, A.Type_Lookup_Code,apps_source_code
4460: FROM Po_Requisition_Headers_All A
4461: WHERE A.Requisition_Header_Id = p_requisition_Header_Id;
4462:
4463: CURSOR vend_cur(p_sugg_vendor_name IN VARCHAR2) IS
4464: SELECT Vendor_Id