[Home] [Help]
17: --This trigger is used to default the taxes
18: --when Standard PO is created from a Standrad Requisition using AutoCreate.
19:
20: --When Standard PO is created from a Standard Requisition
21: --Using AutoCreate, AutoCreate inserts details into PO_HEADERS_ALL,PO_LINE_LOCATIONS_ALL,
22: -- PO_DISTRIBUTIONS_ALL
23:
24: --In PO_DISTRIBUTIONS_ALL , REQ_DISTRIBUTION_ID will be same as
25: --DISTRIBUTION_ID in PO_REQ_DISTRIBUTIONS_ALL and REQ_DISTRIBUTION_ID is inserted into
29: --This trigger will not fire if the user creates Requisition using Requisition Localized screen.
30:
31: --This trigger will not fire if Override_flag for the Vendor Vendor_site_id is not checked.
32:
33: --This trigger fetches details from PO_HEADERS_ALL using PO_HEADER_ID and
34: --jai_po_tax_pkg.copy_reqn_taxes procedure is called.
35:
36: /* End of About this trigger */
37: v_org_id NUMBER;
54: v_sup_id NUMBER;
55: v_sup_site_id NUMBER;
56: v_count1 NUMBER;
57: v_count number;
58: v_style_id po_headers_all.style_id%TYPE; --Added by Sanjikum for Bug#4483042
59:
60: CURSOR get_po_hdr(c_po_header_id number) IS
61: SELECT type_lookup_code,Quotation_Class_Code,Ship_To_Location_Id,
62: rate, rate_type, rate_date,currency_code,
60: CURSOR get_po_hdr(c_po_header_id number) IS
61: SELECT type_lookup_code,Quotation_Class_Code,Ship_To_Location_Id,
62: rate, rate_type, rate_date,currency_code,
63: style_id --Added by Sanjikum for Bug#4483042
64: FROM po_headers_all
65: WHERE po_header_id = v_po_hdr_id;
66:
67: -- Get the Inventory Organization Id
68:
93: ,rate_type
94: ,rate_date
95: ,currency_code
96: /* End of Bug#4242351 */
97: FROM Po_Headers_All
98: WHERE Po_Header_Id = v_po_hdr_id;
99:
100: CURSOR Line_Loc_Cur( lineid IN NUMBER ) IS
101: SELECT Line_Location_Id