[Home] [Help]
165: source_document_id, order_number, price_list_id,
166: order_category_code, orig_sys_document_ref, transactional_curr_code,
167: conversion_type_code, conversion_rate, conversion_rate_date,
168: nvl(ordered_date, creation_date)
169: FROM oe_order_headers_all
170: WHERE header_id = p_header_id;
171:
172: CURSOR soure_doc_cur(p_header_id NUMBER) IS
173: SELECT order_category_code
170: WHERE header_id = p_header_id;
171:
172: CURSOR soure_doc_cur(p_header_id NUMBER) IS
173: SELECT order_category_code
174: FROM oe_order_headers_all
175: WHERE header_id = p_header_id;
176:
177: CURSOR address_cur(p_ship_to_site_use_id IN NUMBER) IS
178: SELECT NVL(cust_acct_site_id, 0) address_id
192: CURSOR po_reqn_lines_count(p_requisition_number VARCHAR2) IS
193: SELECT count(1)
194: FROM JAI_PO_REQ_LINES
195: WHERE requisition_header_id IN ( SELECT requisition_header_id
196: FROM po_requisition_headers_all a, oe_order_headers_all b
197: WHERE A.segment1 = b.orig_sys_document_ref
198: AND A.segment1 = p_requisition_number );
199:
200:
272: -- Web Stores Order's Import
273: -- by Amit Chopra on 7th June 2000
274: CURSOR get_original_source IS
275: SELECT NVL(orig_sys_document_ref,'NON_IMPORT')
276: FROM oe_order_headers_all
277: WHERE header_id = v_header_id ;
278:
279: v_source_id NUMBER;
280: CURSOR get_source_id IS
278:
279: v_source_id NUMBER;
280: CURSOR get_source_id IS
281: SELECT order_source_id
282: FROM oe_order_headers_all
283: WHERE header_id = v_header_id;
284:
285: ---------------------------------
286: /* Declarations for Copy Order */
294: --2001/10/01 Anuradha Parthasarathy
295: v_source_order_category_code VARCHAR2(30);
296: CURSOR source_order_doc_cur(P_Source_Document_Id NUMBER) IS
297: SELECT order_category_code
298: FROM oe_order_headers_all
299: WHERE header_id = p_source_document_id;
300:
301: --2001/10/01 Anuradha Parthasarathy
302: CURSOR get_order_source_type(p_source_document_type_id NUMBER) IS
1115: IS
1116: SELECT
1117: ordered_date
1118: FROM
1119: oe_order_headers_all
1120: WHERE
1121: header_id = pr_new.header_id ;
1122:
1123: CURSOR c_get_ship_qty(cp_delivery_detail_id wsh_delivery_details.delivery_detail_id%TYPE)
1496: FROM JAI_OM_OE_RMA_LINES
1497: WHERE rma_header_id = cp_rma_header_id
1498: AND rma_line_id = cp_rma_line_id;
1499:
1500: /* get the new order number from oe_order_headers_all*/
1501: CURSOR c_rma_number(cp_rma_header_id number) is
1502: SELECT order_number
1503: FROM oe_order_headers_all
1504: WHERE header_id = cp_rma_header_id;
1499:
1500: /* get the new order number from oe_order_headers_all*/
1501: CURSOR c_rma_number(cp_rma_header_id number) is
1502: SELECT order_number
1503: FROM oe_order_headers_all
1504: WHERE header_id = cp_rma_header_id;
1505:
1506: cv_rma_details C_RMA_DETAILS%ROWTYPE;
1507: lv_rma_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;
1503: FROM oe_order_headers_all
1504: WHERE header_id = cp_rma_header_id;
1505:
1506: cv_rma_details C_RMA_DETAILS%ROWTYPE;
1507: lv_rma_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;
1508:
1509: BEGIN
1510: pv_return_code := jai_constants.successful ;
1511:
3071: CONVERSION_RATE_DATE,
3072: SOLD_TO_ORG_ID,
3073: price_list_id,
3074: NVL(ORDERED_DATE, creation_date)
3075: FROM OE_ORDER_HEADERS_ALL
3076: WHERE header_id = p_header_id;
3077:
3078: CURSOR address_cur(p_ship_to_org_id IN NUMBER) IS
3079: SELECT NVL(cust_acct_site_id, 0) address_id
3503: Cursor c_ordered_date_cur is
3504: select
3505: ordered_date
3506: from
3507: oe_order_headers_all
3508: where
3509: header_id = pr_new.header_id;
3510:
3511: -- following cursor is used to get the ship confirm date based on the delivery detail id
3533: WHERE
3534: organization_id = pr_new.ship_from_org_id
3535: AND location_id = 0;
3536:
3537: v_ordered_Date oe_order_headers_all.ordered_date%type;
3538: v_confirm_date wsh_new_deliveries.confirm_date%type;
3539: v_excise_return_days Number;
3540: v_sales_return_days Number;
3541: