APPS.JAI_OM_TAX_PROCESSING_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 204: tab_ooh OE_ORDER_HEADERS_ALL%ROWTYPE ;

200: AND rgmpt.location_id = cp_location_id
201: AND rgmpt.organization_id = cp_organization_id
202: AND rgms.regime_code = jai_constants.vat_regime;
203:
204: tab_ooh OE_ORDER_HEADERS_ALL%ROWTYPE ;
205: CURSOR cur_get_org_hdr (cp_header_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE)
206: IS
207: SELECT
208: *

Line 205: CURSOR cur_get_org_hdr (cp_header_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE)

201: AND rgmpt.organization_id = cp_organization_id
202: AND rgms.regime_code = jai_constants.vat_regime;
203:
204: tab_ooh OE_ORDER_HEADERS_ALL%ROWTYPE ;
205: CURSOR cur_get_org_hdr (cp_header_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE)
206: IS
207: SELECT
208: *
209: FROM

Line 210: oe_order_headers_all

206: IS
207: SELECT
208: *
209: FROM
210: oe_order_headers_all
211: WHERE
212: header_id = cp_header_id ;
213:
214: CURSOR c_ato_line_id IS

Line 218: oe_order_headers_all oeh,

214: CURSOR c_ato_line_id IS
215: SELECT
216: oel.ato_line_id
217: FROM
218: oe_order_headers_all oeh,
219: oe_order_lines_all oel
220: WHERE
221: oeh.header_id = p_rec_new.header_id
222: AND oeh.header_id = oel.header_id

Line 1240: FROM oe_order_headers_all

1236: AND location_id = 0;
1237:
1238: CURSOR c_ordered_date IS
1239: SELECT ordered_date
1240: FROM oe_order_headers_all
1241: WHERE header_id = pr_order_line.header_id;
1242:
1243: CURSOR c_fulfilled_date IS
1244: SELECT CREATION_DATE

Line 1842: /* get the new order number from oe_order_headers_all*/

1838: FROM JAI_OM_OE_RMA_LINES
1839: WHERE rma_header_id = cp_rma_header_id
1840: AND rma_line_id = cp_rma_line_id;
1841:
1842: /* get the new order number from oe_order_headers_all*/
1843: CURSOR c_rma_number(cp_rma_header_id number) is
1844: SELECT order_number
1845: FROM oe_order_headers_all
1846: WHERE header_id = cp_rma_header_id;

Line 1845: FROM oe_order_headers_all

1841:
1842: /* get the new order number from oe_order_headers_all*/
1843: CURSOR c_rma_number(cp_rma_header_id number) is
1844: SELECT order_number
1845: FROM oe_order_headers_all
1846: WHERE header_id = cp_rma_header_id;
1847:
1848: cv_rma_details C_RMA_DETAILS%ROWTYPE;
1849: lv_rma_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;

Line 1849: lv_rma_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;

1845: FROM oe_order_headers_all
1846: WHERE header_id = cp_rma_header_id;
1847:
1848: cv_rma_details C_RMA_DETAILS%ROWTYPE;
1849: lv_rma_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;
1850:
1851: -- get the details from JAI_OM_WSH_LINES_ALL table
1852: CURSOR cur_get_picking_lines(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,
1853: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) IS

Line 1996: FROM oe_order_headers_all

1992: AND location_id = 0;
1993:
1994: CURSOR c_ordered_date IS
1995: SELECT ordered_date
1996: FROM oe_order_headers_all
1997: WHERE header_id = pr_order_line.header_id;
1998:
1999: CURSOR c_fulfilled_date IS
2000: SELECT CREATION_DATE

Line 2607: FROM oe_order_headers_all

2603: v_api_name CONSTANT VARCHAR2(30) := 'COPY_SOURCE_ORDER';
2604:
2605: CURSOR source_order_doc_cur(P_Source_Document_Id NUMBER) IS
2606: SELECT order_category_code
2607: FROM oe_order_headers_all
2608: WHERE header_id = p_source_document_id;
2609:
2610: copy_rec get_copy_order_line%ROWTYPE;
2611: v_source_order_category_code VARCHAR2(30);

Line 2715: FROM oe_order_headers_all

2711: v_api_name CONSTANT VARCHAR2(30) := 'CREATE_NORMAL_ORDER';
2712:
2713: CURSOR get_source_id IS
2714: SELECT order_source_id
2715: FROM oe_order_headers_all
2716: WHERE header_id = pr_order_line.header_id;
2717:
2718: CURSOR get_rma_tax_lines_count_cur IS
2719: SELECT COUNT(1)

Line 4059: FROM OE_ORDER_HEADERS_ALL

4055: CONVERSION_RATE_DATE,
4056: SOLD_TO_ORG_ID,
4057: price_list_id,
4058: NVL(ORDERED_DATE, creation_date)
4059: FROM OE_ORDER_HEADERS_ALL
4060: WHERE header_id = p_header_id;
4061:
4062: CURSOR address_cur(p_ship_to_org_id IN NUMBER) IS
4063: SELECT NVL(cust_acct_site_id, 0) address_id

Line 4507: from oe_order_headers_all

4503: l_new_delivery_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE;
4504:
4505: Cursor c_ordered_date_cur is
4506: select ordered_date
4507: from oe_order_headers_all
4508: where header_id = pr_new.header_id;
4509:
4510: -- following cursor is used to get the ship confirm date based on the delivery detail id
4511:

Line 4538: v_ordered_Date oe_order_headers_all.ordered_date%type;

4534: ln_organization_id NUMBER;
4535: ln_inventory_item_id NUMBER;
4536: ln_item_exists NUMBER;
4537:
4538: v_ordered_Date oe_order_headers_all.ordered_date%type;
4539: v_confirm_date wsh_new_deliveries.confirm_date%type;
4540: v_excise_return_days Number;
4541: v_sales_return_days Number;
4542: