eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_PO_TAX_PKG dependencies on STANDARD

Line 377: Hence, in case of an Standard PO created without an requisition

373: S.No Date Author and Details
374: ------------------------------------------------------------------------------------------
375: 1. 23-Aug-02 Nagaraj.s for Bug2519359
376: The Adhoc Amounts were being picked up from requisitions earlier.
377: Hence, in case of an Standard PO created without an requisition
378: the adhoc amounts were populated as Zero which has been taken care
379: by, incorporating an if condition if p_type='REQUISITION' then
380: adhoc amounts are picked up from Requisition, else it will be picked
381: from the previous adhoc amounts entered in the Tax screen.

Line 444: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN -- Vijay Shankar for Bug# 3190782

440: max_iter := 15; -- bug 5228046. Changed from 10 to 15
441: v_curr := p_line_uom_code;
442: v_line_uom_code := p_line_uom_code;
443:
444: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN -- Vijay Shankar for Bug# 3190782
445:
446: IF p_item_id IS NULL THEN
447: OPEN Fetch_Item_Cur;
448: FETCH Fetch_Item_Cur INTO p_inventory_item_id;

Line 464: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN

460: --end 6/05/02 cbabu bug2357371
461:
462: END IF; -- Vijay Shankar for Bug# 3190782
463:
464: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN
465:
466: /* Added by LGOPALSA. Bug 4210102.
467: * Added CVD and Excise Education Cess
468: * */

Line 632: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO', 'REQUISITION', 'RECEIPTS' , 'ASBN' ) THEN

628: ORDER BY 1;
629:
630: END IF;
631: -- START ILIPROCUREMENT FORWARD PORTING - KVAIDYAN
632: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO', 'REQUISITION', 'RECEIPTS' , 'ASBN' ) THEN
633: -- END ILIPROCUREMENT FORWARD PORTING - KVAIDYAN
634: LOOP
635:
636: FETCH c_tax_cur INTO rec;

Line 1303: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN -- Vijay Shankar for Bug# 3190782

1299: max_iter := 15; -- bug 5228046. Changed from 10 to 15
1300: v_curr := p_line_uom_code;
1301: v_line_uom_code := p_line_uom_code;
1302:
1303: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN -- Vijay Shankar for Bug# 3190782
1304:
1305: IF p_item_id IS NULL THEN
1306: OPEN Fetch_Item_Cur;
1307: FETCH Fetch_Item_Cur INTO p_inventory_item_id;

Line 1323: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN

1319: --end 6/05/02 cbabu bug2357371
1320:
1321: END IF; -- Vijay Shankar for Bug# 3190782
1322:
1323: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN
1324:
1325: /* Added by LGOPALSA. Bug 4210102.
1326: * Added CVD and Excise Education Cess
1327: * */

Line 1462: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO', 'REQUISITION', 'RECEIPTS' , 'ASBN' ) THEN

1458: ORDER BY 1;
1459: */
1460: END IF;
1461: -- START ILIPROCUREMENT FORWARD PORTING - KVAIDYAN
1462: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO', 'REQUISITION', 'RECEIPTS' , 'ASBN' ) THEN
1463: -- END ILIPROCUREMENT FORWARD PORTING - KVAIDYAN
1464: LOOP
1465:
1466: FETCH c_tax_retro_cur INTO rec_retro;

Line 1556: , 'STANDARD PO'

1552: Jai_Retro_Line_Changes jrlc
1553: WHERE jrlc.line_location_id = p_line_loc_id
1554: AND jrlc.doc_line_id = p_line_id
1555: AND jrlc.doc_type IN ( 'RELEASE'
1556: , 'STANDARD PO'
1557: )
1558: AND jrlc.doc_version_number = (SELECT
1559: MAX(jrlc1.doc_version_number)
1560: FROM

Line 1565: , 'STANDARD PO'

1561: Jai_Retro_Line_Changes jrlc1
1562: WHERE jrlc1.line_location_id = p_line_loc_id
1563: AND jrlc1.doc_line_id = p_line_id
1564: AND jrlc1.doc_type IN ( 'RELEASE'
1565: , 'STANDARD PO'
1566: )
1567: )
1568: );
1569: END IF;

Line 2060: ELSIF p_type IN ( 'RELEASE', 'STANDARDPO' ) THEN /*********************************/

2056: WHERE Requisition_Line_Id = p_header_id
2057: AND Tax_Line_No = I;
2058: END LOOP;
2059: P_TAX_AMOUNT := v_tax_amt;
2060: ELSIF p_type IN ( 'RELEASE', 'STANDARDPO' ) THEN /*********************************/
2061: FOR I IN 1 .. row_count LOOP
2062: IF tax_type_tab( i ) = 1 THEN
2063: bsln_amt := p_assessable_value;
2064: ELSIF tax_type_tab(i) = 4 THEN -- Ravi for VAT

Line 2096: ELSIF p_type = 'STANDARDPO' THEN

2092: app_exception.raise_exception;
2093: END IF;
2094: END IF;
2095: --=====================================================
2096: ELSIF p_type = 'STANDARDPO' THEN
2097: UPDATE JAI_PO_TAXES
2098: SET Tax_Amount = NVL( tax_amt_tab(I), 0 ),
2099: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ) * ( 1/p_conv_rate )
2100: WHERE Line_Location_Id = p_line_loc_id

Line 2134: ELSIF p_type = 'STANDARDPO' THEN

2130: SET Tax_Amount = NVL( v_tax_amt, 0 ),
2131: Total_Amount = v_tax_amt + p_price
2132: WHERE Line_Location_Id = p_header_id
2133: AND Po_Line_Id = p_line_id;
2134: ELSIF p_type = 'STANDARDPO' THEN
2135: OPEN Fetch_Sum_Cur( p_line_loc_id );
2136: FETCH Fetch_Sum_Cur INTO v_tax_amt;
2137: CLOSE Fetch_Sum_Cur;
2138:

Line 2680: /** jai_po_tax_pkg.calculate_tax( 'STANDARDPO', v_po_hdr_id , v_Po_Line_Id1, v_line_location_id,

2676: NVL( v_assessable_value, -9999 ),
2677: ln_vat_assess_value,
2678: NVL( v_conv_rate, 1 ) );
2679:
2680: /** jai_po_tax_pkg.calculate_tax( 'STANDARDPO', v_po_hdr_id , v_Po_Line_Id1, v_line_location_id,
2681: v_qty, v_price*v_qty, v_uom, v_assessable_value,
2682: NVL( v_assessable_value, v_price*v_qty ), NULL, nvl(v_conv_rate,1));
2683:
2684:

Line 3191: Added standard who columns in all update statements.

3187: of REQUISITION_BLANKET as p_line_id would have po_line_id in this case.
3188: In case of requistion Blanket, v_po_curr is not populated at all. Added code to
3189: populate it with p_po_currency.
3190: Commented code to populate v_func_cur if p_func_curr is NULL
3191: Added standard who columns in all update statements.
3192:
3193: 7. 12/17/2007 Kevin Cheng Update the logic for inclusive tax calculation
3194:
3195: 8. 01/15/2008 Kevin Cheng Add a branch to deal with taxes recalculate for retroactive price update

Line 3407: ELSIF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN

3403:
3404: row_count := row_count + 1;
3405: END LOOP;
3406:
3407: ELSIF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN
3408:
3409: IF p_item_id IS NULL THEN
3410: OPEN Fetch_Item_Cur;
3411: FETCH Fetch_Item_Cur INTO p_inventory_item_id;

Line 4355: ELSIF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN

4351:
4352: row_count := row_count + 1;
4353: END LOOP;
4354:
4355: ELSIF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN
4356:
4357: IF p_item_id IS NULL THEN
4358: OPEN Fetch_Item_Cur;
4359: FETCH Fetch_Item_Cur INTO p_inventory_item_id;

Line 4447: , 'STANDARD PO'

4443: Jai_Retro_Line_Changes jrlc
4444: WHERE jrlc.line_location_id = p_line_location_id
4445: AND jrlc.doc_type IN ( 'RELEASE'
4446: , 'RECEIPT'
4447: , 'STANDARD PO'
4448: )
4449: AND jrlc.doc_version_number = (SELECT
4450: MAX(jrlc1.doc_version_number)
4451: FROM

Line 4456: , 'STANDARD PO'

4452: Jai_Retro_Line_Changes jrlc1
4453: WHERE jrlc1.line_location_id = p_line_location_id
4454: AND jrlc1.doc_type IN ( 'RELEASE'
4455: , 'RECEIPT'
4456: , 'STANDARD PO'
4457: )
4458: )
4459: );
4460: tax_rate_tab(rec.lno) := -99999;

Line 4930: --Bgowrava for Bug#5877782 Added standard Who columns

4926: END IF;
4927: --end, cbabu for Bug# 2659815
4928:
4929:
4930: --Bgowrava for Bug#5877782 Added standard Who columns
4931: UPDATE JAI_PO_REQ_LINE_TAXES
4932: SET Tax_Amount = round( nvl(tax_amt_tab(I),0), nvl(rnd_factor(I),0) ),/*4281841*/
4933: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ),
4934: last_update_date = sysdate,

Line 4943: --Bgowrava for Bug#5877782 Added standard Who columns

4939: AND Tax_Line_No = I;
4940: END LOOP;
4941:
4942: -- cbabu for Bug# 2659815
4943: --Bgowrava for Bug#5877782 Added standard Who columns
4944: UPDATE JAI_PO_REQ_LINES
4945: SET Tax_Amount = v_tax_amt,
4946: total_amount = p_base_value + v_tax_amt,
4947: last_update_date = sysdate,

Line 4976: --Bgowrava for Bug#5877782 Added standard Who columns

4972: END IF;
4973: --ILIPROCUREMENT END
4974:
4975: --end, cbabu for Bug# 2659815
4976: --Bgowrava for Bug#5877782 Added standard Who columns
4977: UPDATE JAI_PO_REQ_LINE_TAXES
4978: SET Tax_Amount = round( nvl(tax_amt_tab(I),0), rnd_factor(I) ),
4979: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ),
4980: last_update_date = sysdate,

Line 4988: ELSIF p_type IN ( 'RELEASE', 'STANDARDPO' ) THEN

4984: AND Tax_Line_No = I;
4985: END LOOP;
4986:
4987:
4988: ELSIF p_type IN ( 'RELEASE', 'STANDARDPO' ) THEN
4989:
4990: IF v_debug = 'Y' THEN
4991: fnd_file.put_line( fnd_file.log, '3 Before Updating the table');
4992: END IF;

Line 5018: --Bgowrava for Bug#5877782 Added standard Who columns

5014: fnd_file.put_line( fnd_file.log,' cur->'||curr_tab(i)||', tax_amt_tab('||i||') -> '||tax_amt_tab(i)||
5015: ', tax_target_tab -> '||tax_target_tab(i));
5016: END IF;
5017:
5018: --Bgowrava for Bug#5877782 Added standard Who columns
5019: UPDATE JAI_PO_TAXES
5020: SET tax_amount = round( nvl( tax_amt_tab(i), 0 ), nvl(rnd_factor(I),0) ),
5021: tax_target_amount = nvl( tax_target_tab(i), 0 ),
5022: last_update_date = sysdate,

Line 5050: --Bgowrava for Bug#5877782 Added standard Who columns

5046: END IF;
5047: --=====================================================
5048: END LOOP;
5049:
5050: --Bgowrava for Bug#5877782 Added standard Who columns
5051: UPDATE JAI_PO_LINE_LOCATIONS
5052: SET Tax_Amount = NVL( v_tax_amt, 0 ),
5053: Total_Amount = v_tax_amt + p_base_value ,
5054: last_update_date = sysdate,

Line 5606: ( 'STANDARD',

5602: p_frm_line_id
5603: );
5604:
5605: jai_po_cmn_pkg.insert_line
5606: ( 'STANDARD',
5607: p_line_loc_id,
5608: p_po_hdr_id,
5609: p_po_line_id,
5610: p_cre_dt,

Line 5738: ( 'STANDARDPO', p_po_hdr_id , p_po_line_id, p_line_loc_id,

5734: ) ; -- Ravi for VAT
5735:
5736:
5737: jai_po_tax_pkg.calculate_tax
5738: ( 'STANDARDPO', p_po_hdr_id , p_po_line_id, p_line_loc_id,
5739: p_qty, p_price*p_qty, p_unit_code, v_tax_amt, p_assessable_value, ln_vat_assess_value*p_qty, NULL );
5740: -- Ravi for VAT
5741:
5742: EXCEPTION

Line 6281: ( 'STANDARDPO', v_po_hdr_id , v_po_line_id, v_line_loc_id,

6277:
6278: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, DUMMY, v_doc_curr, v_curr_conv_factor ) ;
6279:
6280: jai_po_tax_pkg.calculate_tax
6281: ( 'STANDARDPO', v_po_hdr_id , v_po_line_id, v_line_loc_id,
6282: v_qty, v_qty*v_temp_price, v_uom_code,
6283: v_assessable_value, v_assessable_value, NULL, v_curr_conv_factor
6284: );
6285:

Line 7033: jai_po_tax_pkg.calculate_tax( 'STANDARDPO', v_po_hdr_id , v_po_line_id, v_line_loc_id,

7029: If ( ( v_type_lookup_code <> 'QUOTATION' AND v_quot_class_code <> 'CATALOG' )
7030: OR v_type_lookup_code <> 'BLANKET' )
7031: THEN
7032:
7033: jai_po_tax_pkg.calculate_tax( 'STANDARDPO', v_po_hdr_id , v_po_line_id, v_line_loc_id,
7034: -- v_qty, v_price*v_qty, v_uom, v_tax_amt, v_assessable_value, v_item_id ); -- cbabu for Bug# 2695844
7035: v_qty, v_price*v_qty, v_uom_code, v_tax_amt, v_assessable_value,ln_vat_assess_value, -- added, Harshita for bug #4245062
7036: v_item_id );
7037:

Line 7225: IF v_type_lookup_code NOT IN ( 'STANDARD', 'BLANKET', 'CONTRACT', 'PLANNED' ) THEN

7221:
7222:
7223: IF v_tax_ctg_id IS NOT NULL THEN -- 000a
7224:
7225: IF v_type_lookup_code NOT IN ( 'STANDARD', 'BLANKET', 'CONTRACT', 'PLANNED' ) THEN
7226: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, dummy, v_curr, v_curr_conv_factor );
7227: END IF;
7228:
7229: OPEN Fetch_UOMCode_Cur;

Line 7311: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED' , 'RELEASE' ) THEN

7307: trans_name := v_type_lookup_code || TO_CHAR( v_line_loc_id ) || operation;
7308: END IF;
7309: -- Date 08-Aug-2007 by sacsethi for bug 6134628
7310: -- RELEASE look up type added
7311: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED' , 'RELEASE' ) THEN
7312: trans_name := 'OTHERS' || TO_CHAR( v_line_loc_id ) || operation;
7313: ELSIF v_type_lookup_code = 'SCHEDULED' THEN
7314: trans_name := v_type_lookup_code || TO_CHAR( v_line_loc_id ) || operation;
7315: ELSIF v_type_lookup_code = 'BLANKET' THEN