APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on PO_REQUISITION_HEADERS_ALL

Line 76: FROM Po_Requisition_Headers_All A

72: WHERE Organization_Id = v_dest_org_id;
73:
74: CURSOR org_cur IS
75: SELECT A.Segment1, A.Type_Lookup_Code,apps_source_code--added apps_source_code by rchandan for bug#4627239
76: FROM Po_Requisition_Headers_All A
77: WHERE A.Requisition_Header_Id = v_requisition_header_id;
78:
79: /* Bug 5243532. Addd by Lakshmi Gopalsami
80: * Removed the cursor Fetch_Book_Id_Cur

Line 189: lv_apps_source_code po_requisition_headers_all.apps_source_code%type; -- added by rchandan for bug#462739

185:
186: v_reqn_ctr Number :=0;
187:
188: -- additions by sriram - ends here Bug # 2977200
189: lv_apps_source_code po_requisition_headers_all.apps_source_code%type; -- added by rchandan for bug#462739
190: /*5852041..start */ -- pramasub start
191: ln_tax_amount NUMBER;
192: ln_program_id NUMBER;
193:

Line 1891: v_type_lookup_code Po_Requisition_Headers_All.Type_Lookup_Code % TYPE;

1887: v_last_update_date DATE ; --File.Sql.35 Cbabu := pr_new.Last_Update_Date;
1888: v_last_updated_by NUMBER ; --File.Sql.35 Cbabu := pr_new.Last_Updated_By;
1889: v_last_update_login NUMBER ; --File.Sql.35 Cbabu := pr_new.Last_Update_Login;
1890:
1891: v_type_lookup_code Po_Requisition_Headers_All.Type_Lookup_Code % TYPE;
1892: v_tax_category_id NUMBER;
1893: v_org_id NUMBER ; --File.Sql.35 Cbabu := 0;
1894: v_deliver_to_loc_id NUMBER;--Added by Xiao Lv for bug 10043656
1895: -- lv_enable_gst_flag VARCHAR2(3);--Added by Xiao Lv for bug 10043656

Line 1926: FROM Po_Requisition_Headers_All

1922: WHERE Organization_Id = v_dest_org_id;
1923:
1924: CURSOR bind_cur IS
1925: SELECT Segment1, Type_Lookup_Code, apps_source_code -- pramasub FP
1926: FROM Po_Requisition_Headers_All
1927: WHERE Requisition_Header_Id = v_header_id;
1928:
1929: CURSOR vend_cur(p_sugg_vendor_name IN VARCHAR2) IS
1930: SELECT vendor_id

Line 2707: v_type_lookup_code Po_Requisition_Headers_All.Type_Lookup_Code % TYPE;

2703: PROCEDURE ARU_T3 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
2704: -- Trigger used for Currency Updation.
2705:
2706: found BOOLEAN;
2707: v_type_lookup_code Po_Requisition_Headers_All.Type_Lookup_Code % TYPE;
2708: --v_row_id Rowid; --File.Sql.35 Cbabu := pr_new.ROWID;
2709: v_vendor_id NUMBER;
2710: v_site_id NUMBER;
2711: v_dest_org_id NUMBER ; --File.Sql.35 Cbabu := pr_new.Destination_Organization_Id;

Line 2765: FROM Po_Requisition_Headers_All

2761: FROM Org_Organization_Definitions
2762: WHERE Organization_Id = v_dest_org_id;
2763:
2764: Cursor bind_cur IS SELECT Segment1, Type_Lookup_Code
2765: FROM Po_Requisition_Headers_All
2766: WHERE Requisition_Header_Id = v_header_id;
2767:
2768: Cursor Vend_cur(p_sugg_vendor_name IN VARCHAR2) IS SELECT vendor_id
2769: FROM po_vendors