APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on PO_REQUISITION_HEADERS_ALL

Line 70: FROM Po_Requisition_Headers_All A

66: WHERE Organization_Id = v_dest_org_id;
67:
68: CURSOR org_cur IS
69: SELECT A.Segment1, A.Type_Lookup_Code,apps_source_code--added apps_source_code by rchandan for bug#4627239
70: FROM Po_Requisition_Headers_All A
71: WHERE A.Requisition_Header_Id = v_requisition_header_id;
72:
73: /* Bug 5243532. Addd by Lakshmi Gopalsami
74: * Removed the cursor Fetch_Book_Id_Cur

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

179:
180: v_reqn_ctr Number :=0;
181:
182: -- additions by sriram - ends here Bug # 2977200
183: lv_apps_source_code po_requisition_headers_all.apps_source_code%type; -- added by rchandan for bug#462739
184: /*5852041..start */ -- pramasub start
185: ln_tax_amount NUMBER;
186: ln_program_id NUMBER;
187:

Line 1763: v_type_lookup_code Po_Requisition_Headers_All.Type_Lookup_Code % TYPE;

1759: v_last_update_date DATE ; --File.Sql.35 Cbabu := pr_new.Last_Update_Date;
1760: v_last_updated_by NUMBER ; --File.Sql.35 Cbabu := pr_new.Last_Updated_By;
1761: v_last_update_login NUMBER ; --File.Sql.35 Cbabu := pr_new.Last_Update_Login;
1762:
1763: v_type_lookup_code Po_Requisition_Headers_All.Type_Lookup_Code % TYPE;
1764: v_tax_category_id NUMBER;
1765: v_org_id NUMBER ; --File.Sql.35 Cbabu := 0;
1766: found BOOLEAN;
1767: v_vendor_id NUMBER;

Line 1795: FROM Po_Requisition_Headers_All

1791: WHERE Organization_Id = v_dest_org_id;
1792:
1793: CURSOR bind_cur IS
1794: SELECT Segment1, Type_Lookup_Code, apps_source_code -- pramasub FP
1795: FROM Po_Requisition_Headers_All
1796: WHERE Requisition_Header_Id = v_header_id;
1797:
1798: CURSOR vend_cur(p_sugg_vendor_name IN VARCHAR2) IS
1799: SELECT vendor_id

Line 2487: v_type_lookup_code Po_Requisition_Headers_All.Type_Lookup_Code % TYPE;

2483: 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
2484: -- Trigger used for Currency Updation.
2485:
2486: found BOOLEAN;
2487: v_type_lookup_code Po_Requisition_Headers_All.Type_Lookup_Code % TYPE;
2488: --v_row_id Rowid; --File.Sql.35 Cbabu := pr_new.ROWID;
2489: v_vendor_id NUMBER;
2490: v_site_id NUMBER;
2491: v_dest_org_id NUMBER ; --File.Sql.35 Cbabu := pr_new.Destination_Organization_Id;

Line 2542: FROM Po_Requisition_Headers_All

2538: FROM Org_Organization_Definitions
2539: WHERE Organization_Id = v_dest_org_id;
2540:
2541: Cursor bind_cur IS SELECT Segment1, Type_Lookup_Code
2542: FROM Po_Requisition_Headers_All
2543: WHERE Requisition_Header_Id = v_header_id;
2544:
2545: Cursor Vend_cur(p_sugg_vendor_name IN VARCHAR2) IS SELECT vendor_id
2546: FROM po_vendors