[Home] [Help]
54: /* Added by Ramananda for bug# exc_objects */
55: lv_object_name CONSTANT VARCHAR2(61) := 'jai_rcv_tax_pkg.default_taxes_onto_line';
56:
57: -- LAST MODIFIED BY SRIHARI on 25-JUN-2000
58: v_receipt_num rcv_shipment_headers.receipt_num % TYPE;
59: v_loc_quantity po_line_locations_all.quantity % TYPE;
60: v_cor_amount JAI_PO_LINE_LOCATIONS.tax_amount % TYPE;
61: -- v_form_id VARCHAR2(30); --File.Sql.35 Cbabu := 'JAINPORE';
62: v_chk_form VARCHAR2(30);
70: v_item_id rcv_shipment_lines.item_id % TYPE;
71: v_organization_id rcv_shipment_lines.to_organization_id % TYPE;
72: v_item_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag % TYPE;
73: v_item_trading_flag JAI_INV_ITM_SETUPS.item_trading_flag % TYPE;
74: v_receipt_source_code rcv_shipment_headers.receipt_source_code % TYPE;
75: -- v_paddr v$session.paddr % TYPE;
76: -- v_temp_status ja_in_temp_receipt.status % TYPE; --Commented by Nagaraj.s for Bug#2692052
77: v_paddr RAW(32); /*Bug 4644524 bduvarag*/
78: v_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag % TYPE; --Changed the %type by Nagaraj.s for Bug#2692052
96: v_conv_factor NUMBER;
97: v_register_type JAI_CMN_RG_23AC_I_TRXS.register_type % TYPE;
98: v_duplicate_ship VARCHAR2(1); --File.Sql.35 Cbabu := 'N';
99: v_picking_line_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE; --added
100: v_rsh_organization_id rcv_shipment_headers.organization_id % TYPE;
101: v_internal_vendor JAI_CMN_TAXES_ALL.vendor_id % TYPE;
102: v_current_tax NUMBER;
103: v_trading JAI_CMN_INVENTORY_ORGS.trading % TYPE;
104: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing % TYPE;
251: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. CURSOR c_hdr_attribute5(p_shipment_header_id IN NUMBER) IS
252: CURSOR c_hdr_dtl(p_shipment_header_id IN NUMBER) IS
253: SELECT -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. attribute5,
254: shipment_num
255: FROM rcv_shipment_headers
256: WHERE shipment_header_id = p_shipment_header_id;
257:
258: --Added by Sanjikum for Bug#4533114
259: CURSOR c_hdr_attribute5_1(p_delivery_name VARCHAR2)
276: -- bug 4516678. Added by Lakshmi Gopalsami
277: v_cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type;
278:
279: v_express VARCHAR2(100);
280: v_shipment_num rcv_shipment_headers.shipment_num%type; -- ssumaith - bug# 3657662
281: v_order_header_id oe_order_headers_all.header_id%type; -- ssumaith - bug# 3657662
282:
283: cursor c_order_cur (p_shipment_num rcv_shipment_headers.shipment_num%type) is
284: select order_header_id
279: v_express VARCHAR2(100);
280: v_shipment_num rcv_shipment_headers.shipment_num%type; -- ssumaith - bug# 3657662
281: v_order_header_id oe_order_headers_all.header_id%type; -- ssumaith - bug# 3657662
282:
283: cursor c_order_cur (p_shipment_num rcv_shipment_headers.shipment_num%type) is
284: select order_header_id
285: from JAI_OM_WSH_LINES_ALL
286: where delivery_id = p_shipment_num;
287:
361:
362:
363: cursor c_check_asbn is
364: SELECT '1' , shipment_num
365: from rcv_shipment_headers
366: where shipment_header_id = p_shipment_header_id
367: And asn_type = 'ASBN';
368:
369:
995: table.
996:
997: 17. 21/07/2003 Vijay Shankar for Bug# 3028040, Version : 616.2
998: Code is added to check for EXPRESS transaction and then stop 'For Passing' to fire for every RECEIVE transaction
999: of EXPRESS Receipt. This change is made as the PADDR concept is removed in RCV_SHIPMENT_HEADERS DFF.
1000:
1001: 18. 29/07/2003 Nagaraj.s for Bug #2993865 . Version#:616.3
1002: The two queries which were written earlier to fetch line_id,transaction_curr_code,
1003: delivery_detail_id have been merged to form one query.
1045:
1046: 26. 18/06/2004 ssumaith - bug# 3683666 - File Version 115.2
1047:
1048: When a RMA receipt is done without navigating from Receipts-localised form and not entering
1049: the values in the DFF of RCV_SHIPMENT_HEADERS or RCV_TRANSACTIONS, it was observed that
1050: taxes are not defaulted into localization tables (JAI_RCV_LINE_TAXES).
1051: The reason this was happening is because the if condition which was checking this to be a
1052: RMA receipt was also checking the chk_form to be not null with an "AND" to other required
1053: conditions. Hence the problem
1154:
1155: When a user creates a new receipt against a purchase order, he needs to enter the following information
1156: through a DFF : invoice no, invoice_date, Claim Cenvat On Receipt etc.
1157: This DFF is provided at two places, header and line.
1158: Information from the header DFF is captured into the rcv_shipment_headers table.
1159: Information from the lines DFF is captured into the rcv_transactions table.
1160: This information is retrieved into our base tables JAI_RCV_TRANSACTIONS and JAI_RCV_LINES.
1161: At this time, a facility has been provided for the user to default the information
1162: given at the header level DFF to all the lines only if these columns are null at the
1430: END IF;
1431:
1432: FOR row_rec IN (SELECT ROWID,
1433: organization_id
1434: FROM rcv_shipment_headers
1435: WHERE shipment_header_id = p_shipment_header_id)
1436: LOOP
1437: -- v_rowid := row_rec.ROWID;
1438: v_rsh_organization_id := row_rec.organization_id;
1527: --End Added by Ramananda for Bug#4533114
1528:
1529: -------------------------------- To retrieve receipt number ---------------------------------
1530: FOR header_rec IN (SELECT receipt_num
1531: FROM rcv_shipment_headers
1532: WHERE shipment_header_id = p_shipment_header_id)
1533: LOOP
1534: v_receipt_num := header_rec.receipt_num;
1535: END LOOP;
1539: END IF;
1540:
1541: IF p_transaction_type = 'RECEIVE' THEN
1542: FOR head_rec IN (SELECT receipt_source_code
1543: FROM rcv_shipment_headers
1544: WHERE shipment_header_id = p_shipment_header_id)
1545: LOOP
1546: v_receipt_source_code := head_rec.receipt_source_code;
1547: END LOOP;
3046: oe_order_headers_all sha,
3047: po_requisition_headers_all prha,
3048: po_requisition_lines_all prla,
3049: JAI_OM_WSH_LINES_ALL spl,
3050: rcv_shipment_headers rsh
3051:
3052: WHERE
3053:
3054: prha.requisition_header_id = prla.requisition_header_id