[Home] [Help]
551:
552: -- Added code for copy document.
553: -- for quotation to PO and PO to PO on 15-OCT-2000 subbu
554:
555: IF v_from_type_lookup_code IN ('QUOTATION','PLANNED','BLANKET','STANDARD')
556: AND v_quot_from_hdr_id IS NOT NULL
557: THEN
558:
559: OPEN Fetch_Count_Cur;
591:
592: -- end of modification for copy quotation to PO. on 15th oct 2000. subbu
593:
594: -- If the following if is satisfied, it implies that PO has been linked by a quotation.
595: IF v_type_lookup_code IN ( 'STANDARD', 'PLANNED') AND v_q_line_id IS NOT NULL THEN
596:
597: OPEN Fetch_UOMCode_Cur( v_temp_uom );
598: FETCH Fetch_UOMCode_Cur INTO v_unit_code;
599: CLOSE Fetch_UOMCode_Cur;
674: IF v_type_lookup_code = 'RFQ' THEN
675: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );
676: success := 1;
677:
678: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN
679: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINPO', found );
680: success := 1;
681: END IF;
682:
1385: IF v_shipment_type NOT IN ( 'SCHEDULED', 'BLANKET' ) THEN
1386:
1387: /*IF v_type_lookup_code IN ( 'RFQ', 'QUOTATION' ) THEN
1388: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINRFQQ', found );
1389: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) and v_exist <> 1 THEN
1390: jai_po_cmn_pkg.query_locator_for_line( v_po_hdr_id, 'JAINPO', found );
1391: END IF;
1392:
1393: IF NOT found THEN
1392:
1393: IF NOT found THEN
1394: RETURN;
1395: END IF;*//*commented by rchandan for bug#4479131*/
1396: IF v_type_lookup_code IN ( 'RFQ', 'QUOTATION', 'STANDARD', 'PLANNED', 'CONTRACT', 'BLANKET' ) THEN
1397: v_hook_value := jai_cmn_hook_pkg.Ja_In_po_line_locations_all( -- added the hook call for bug 3438863 to customize the code for deciding on India loc Tax defaultation
1398: pr_new.LINE_LOCATION_ID ,
1399: pr_new.PO_HEADER_ID ,
1400: pr_new.PO_LINE_ID ,
1585: v_currency_conv_rate := 1;
1586: END IF;
1587:
1588: jai_po_tax_pkg.calc_tax(
1589: p_type => 'STANDARDPO',
1590: p_header_id => v_po_hdr_id,
1591: P_line_id => v_po_line_id,
1592: p_line_location_id => v_line_loc_id,
1593: p_line_focus_id => null,
1605: );
1606: -- End, Vijay Shankar for Bug #3184673
1607:
1608: /* commented by Vijay Shankar for Bug #3184673
1609: jai_po_tax_pkg.calculate_tax( 'STANDARDPO', v_po_hdr_id, v_po_line_id, v_line_loc_id, v_qty,
1610: v_price*v_qty, v_uom_code, P_TAX_AMOUNT, v_assessable_value,
1611: NULL, v_curr_conv_factor
1612: );
1613: */