[Home] [Help]
436: trans_name := v_type_lookup_code || operation;
437: ELSE
438: trans_name := v_type_lookup_code || TO_CHAR( v_line_loc_id ) || operation;
439: END IF;
440: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED' , 'RELEASE' ) THEN
441: trans_name := 'OTHERS' || TO_CHAR( v_line_loc_id ) || operation;
442: ELSIF v_type_lookup_code = 'SCHEDULED' THEN
443: trans_name := v_type_lookup_code || TO_CHAR( v_line_loc_id ) || operation;
444: ELSIF v_type_lookup_code = 'BLANKET' THEN
827:
828: END IF;
829:
830: jai_po_tax_pkg.calc_tax(
831: p_type => 'STANDARDPO',
832: p_header_id => v_po_hdr_id,
833: P_line_id => v_po_line_id,
834: p_line_location_id => v_line_loc_id,
835: p_line_focus_id => v_line_focus_id,
1498: end if;
1499:
1500:
1501: insert_po_taxes
1502: ( 'STANDARD', NULL,
1503: v_line_focus_id, p_line_loc_id,
1504: rec.tax_line_no, p_po_line_id, p_po_hdr_id,
1505: rec.precedence_1, rec.precedence_2, rec.precedence_3,
1506: rec.precedence_4, rec.precedence_5,
1556: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1557: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,G_PKG_NAME||': p_po_hdr_id,'||p_po_hdr_id||'p_po_line_id,'||p_po_line_id||'p_line_loc_id,'||p_line_loc_id);
1558: END IF;
1559: jai_po_tax_pkg.calculate_tax(
1560: p_type => 'STANDARDPO'
1561: ,p_header_id => p_po_hdr_id
1562: ,P_line_id => p_po_line_id
1563: ,p_line_loc_id => p_line_loc_id
1564: ,p_line_quantity => p_qty
1569: ,p_vat_assess_value => v_vat_assess_value
1570: ,p_item_id => v_item_id
1571: );
1572: /*jai_po_tax_pkg.calc_tax(
1573: p_type => 'STANDARDPO',
1574: p_header_id => p_po_hdr_id,
1575: P_line_id => p_po_line_id,
1576: p_line_location_id => p_line_loc_id,
1577: p_line_focus_id => v_line_focus_id,
2115: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
2116: return;
2117: END IF;
2118:
2119: IF v_type_lookup_code IN ('STANDARD', 'PLANNED') AND (v_frm_hdr_id is NOT NULL and v_frm_po_line_id is NOT NULL) THEN
2120: Open Fetch_Lines_Cur;
2121: Fetch Fetch_Lines_Cur INTO v_line_loc_id, v_price, v_qty;
2122: Close Fetch_Lines_Cur;
2123:
2483: ELSE
2484:
2485: IF v_shipment_type NOT IN ( 'SCHEDULED' , 'BLANKET' ) THEN
2486: --Process for copy documents, from quotation to po and po to po.
2487: IF v_from_type_lookup_code IN ('QUOTATION','PLANNED','BLANKET','STANDARD') AND v_quot_from_hdr_id IS NOT NULL THEN
2488:
2489: OPEN Fetch_Count_Cur(v_quot_from_hdr_id);
2490: FETCH Fetch_Count_Cur INTO v_count;
2491: CLOSE Fetch_Count_Cur;
2520: END IF;
2521:
2522: v_q_line_id := v_from_line_id;
2523: --If the following if is satisfied, it implies that PO has been linked by a quotation.
2524: IF v_type_lookup_code IN ( 'STANDARD', 'PLANNED') AND v_q_line_id IS NOT NULL THEN
2525: OPEN fetch_uomcode_cur;
2526: FETCH fetch_uomcode_cur INTO v_uom_code;
2527: CLOSE fetch_uomcode_cur;
2528: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4844:
4845: ------------------------------>
4846: -- Check the vendor btn the vendor present in tax lines and that of suggested vendor in requisition lines
4847: -- If they are same or any one is null then insert po vendor else keep the vendor in tact.
4848: -- Check if the document to be created is a Blanket Release / Standard Purchase Order.
4849: -- Pick up Line Location Details as well.
4850:
4851: CURSOR c_inventory_org_id(p_ship_to_location_id IN NUMBER) IS
4852: SELECT Inventory_Organization_Id
5315: v_vendor_id := v_vendor2_id;
5316: END IF;
5317: END IF;
5318: insert_po_taxes
5319: ( 'STANDARD', NULL,
5320: v_line_focus_id, v_line_loc_id,
5321: rec_tax.Tax_Line_no, v_po_line_id, v_po_hdr_id,
5322: rec_tax.precedence_1, rec_tax.precedence_2, rec_tax.precedence_3,
5323: rec_tax.precedence_4, rec_tax.precedence_5,
5375:
5376: END IF;
5377: v_tax_amt := NULL;
5378:
5379: jai_po_tax_pkg.calculate_tax( 'STANDARDPO',
5380: v_po_hdr_id ,
5381: v_po_line_id,
5382: v_line_loc_id,
5383: v_quantity,
5390: 1/v_curr_conv_factor );
5391:
5392:
5393: /* jai_po_tax_pkg.calc_tax(
5394: p_type => 'STANDARDPO',
5395: p_header_id => v_po_hdr_id,
5396: P_line_id => v_po_line_id,
5397: p_line_location_id => v_line_loc_id,
5398: p_line_focus_id => v_line_focus_id,
6056:
6057:
6058:
6059: /* jai_po_tax_pkg.calculate_tax
6060: ( 'STANDARDPO', v_po_hdr_id , v_po_line_id, v_line_loc_id,
6061: v_qty, v_qty*v_temp_price, v_uom_code,v_tax_amt1,
6062: v_assessable_value, ln_vat_assess_value, NULL, 1/v_curr_conv_factor
6063: ); */
6064:
6062: v_assessable_value, ln_vat_assess_value, NULL, 1/v_curr_conv_factor
6063: ); */
6064:
6065: jai_po_tax_pkg.calc_tax(
6066: p_type => 'STANDARDPO',
6067: p_header_id => v_po_hdr_id,
6068: P_line_id => v_po_line_id,
6069: p_line_location_id => v_line_loc_id,
6070: p_line_focus_id => v_seq_val,
6547: lv_from_type_lookup_code :=r_po_hdr.from_type_lookup_code;
6548:
6549: ln_from_line_id := r_po_line.from_line_id;
6550:
6551: IF lv_type_lookup_code IN ( 'RFQ', 'QUOTATION' , 'BLANKET') OR (lv_from_type_lookup_code IN ('QUOTATION')/* AND lv_type_lookup_code NOT IN ( 'STANDARD')*/) --Added 'BLANKET' by Wenqiong for bug14748379 2012/10/15
6552: OR (lv_type_lookup_code IN ( 'STANDARD', 'PLANNED') AND ln_from_line_id IS NOT NULL ) THEN
6553: lb_related := TRUE;
6554: END IF;
6555: -- RETURN TRUE;
6548:
6549: ln_from_line_id := r_po_line.from_line_id;
6550:
6551: IF lv_type_lookup_code IN ( 'RFQ', 'QUOTATION' , 'BLANKET') OR (lv_from_type_lookup_code IN ('QUOTATION')/* AND lv_type_lookup_code NOT IN ( 'STANDARD')*/) --Added 'BLANKET' by Wenqiong for bug14748379 2012/10/15
6552: OR (lv_type_lookup_code IN ( 'STANDARD', 'PLANNED') AND ln_from_line_id IS NOT NULL ) THEN
6553: lb_related := TRUE;
6554: END IF;
6555: -- RETURN TRUE;
6556: IF (g_level_procedure >= fnd_log.g_current_runtime_level) THEN
6777: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
6778: return;
6779: END IF;
6780:
6781: IF v_type_lookup_code IN ('STANDARD', 'PLANNED')
6782: AND (nvl(v_frm_hdr_id,0) <> nvl(r_old_po_line.from_header_id,0)
6783: and nvl(v_frm_po_line_id,0) <> nvl(r_old_po_line.from_line_id,0)) THEN
6784: Open Fetch_Lines_Cur;
6785: Fetch Fetch_Lines_Cur INTO v_line_loc_id, v_price, v_qty;
7093: END IF;
7094: END IF;
7095:
7096: --If the following if is satisfied, it implies that PO has been linked by a quotation.
7097: IF v_type_lookup_code IN ( 'STANDARD', 'PLANNED') AND v_from_line_id IS NOT NULL THEN
7098: OPEN fetch_uomcode_cur;
7099: FETCH fetch_uomcode_cur INTO v_uom_code;
7100: CLOSE fetch_uomcode_cur;
7101: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8057: jai_po_proc_pkg.process_split_line(v_orig_ship_id ,v_line_loc_id,v_qty,v_price,v_type_lookup_code);
8058:
8059: ELSE--It's not split line
8060: IF v_shipment_type NOT IN ( 'SCHEDULED' , 'BLANKET' ) THEN
8061: IF (v_from_type_lookup_code IN ('QUOTATION','PLANNED','BLANKET','STANDARD') AND v_quot_from_hdr_id IS NOT NULL) THEN
8062: --Process for copy documents, from quotation to po
8063: OPEN Fetch_Count_Cur(v_quot_from_hdr_id);
8064: FETCH Fetch_Count_Cur INTO v_count;
8065: CLOSE Fetch_Count_Cur;
8092: END IF;
8093: END IF;
8094:
8095: --If the following if is satisfied, it implies that PO has been linked by a quotation.
8096: IF v_type_lookup_code IN ( 'STANDARD', 'PLANNED') AND v_from_line_id IS NOT NULL THEN
8097: OPEN fetch_uomcode_cur;
8098: FETCH fetch_uomcode_cur INTO v_uom_code;
8099: CLOSE fetch_uomcode_cur;
8100: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8272:
8273: ------------------------------>
8274: -- Check the vendor btn the vendor present in tax lines and that of suggested vendor in requisition lines
8275: -- If they are same or any one is null then insert po vendor else keep the vendor in tact.
8276: -- Check if the document to be created is a Blanket Release / Standard Purchase Order.
8277: -- Pick up Line Location Details as well.
8278:
8279: CURSOR c_inventory_org_id(p_ship_to_location_id IN NUMBER) IS
8280: SELECT Inventory_Organization_Id
8745: END IF;
8746: END IF;
8747:
8748: insert_po_taxes
8749: ( 'STANDARD', NULL,
8750: v_line_focus_id, v_line_loc_id,
8751: rec_tax.Tax_Line_no, v_po_line_id, v_po_hdr_id,
8752: rec_tax.precedence_1, rec_tax.precedence_2, rec_tax.precedence_3,
8753: rec_tax.precedence_4, rec_tax.precedence_5,
8808: v_tax_amt := NULL;
8809:
8810: jai_cmn_utils_pkg.write_fnd_log_msg('B13440775','14. jai_po_tax_pkg.calculate_tax. ' );
8811:
8812: jai_po_tax_pkg.calculate_tax( 'STANDARDPO',
8813: v_po_hdr_id ,
8814: v_po_line_id,
8815: v_line_loc_id,
8816: v_quantity,