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 427: Hence, in case of an Standard PO created without an requisition

423: S.No Date Author and Details
424: ------------------------------------------------------------------------------------------
425: 1. 23-Aug-02 Nagaraj.s for Bug2519359
426: The Adhoc Amounts were being picked up from requisitions earlier.
427: Hence, in case of an Standard PO created without an requisition
428: the adhoc amounts were populated as Zero which has been taken care
429: by, incorporating an if condition if p_type='REQUISITION' then
430: adhoc amounts are picked up from Requisition, else it will be picked
431: from the previous adhoc amounts entered in the Tax screen.

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

507: max_iter := 15; -- bug 5228046. Changed from 10 to 15
508: v_curr := p_line_uom_code;
509: v_line_uom_code := p_line_uom_code;
510:
511: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN -- Vijay Shankar for Bug# 3190782
512:
513: IF p_item_id IS NULL THEN
514: OPEN Fetch_Item_Cur;
515: FETCH Fetch_Item_Cur INTO p_inventory_item_id;

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

527: --end 6/05/02 cbabu bug2357371
528:
529: END IF; -- Vijay Shankar for Bug# 3190782
530:
531: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN
532:
533: /* Added by LGOPALSA. Bug 4210102.
534: * Added CVD and Excise Education Cess
535: * */

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

715: ORDER BY 1;
716:
717: END IF;
718: -- START ILIPROCUREMENT FORWARD PORTING - KVAIDYAN
719: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO', 'REQUISITION', 'RECEIPTS' , 'ASBN' ) THEN
720: -- END ILIPROCUREMENT FORWARD PORTING - KVAIDYAN
721: LOOP
722:
723: FETCH c_tax_cur INTO rec;

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

1973: max_iter := 15; -- bug 5228046. Changed from 10 to 15
1974: v_curr := p_line_uom_code;
1975: v_line_uom_code := p_line_uom_code;
1976:
1977: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN -- Vijay Shankar for Bug# 3190782
1978:
1979: IF p_item_id IS NULL THEN
1980: OPEN Fetch_Item_Cur;
1981: FETCH Fetch_Item_Cur INTO p_inventory_item_id;

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

1993: --end 6/05/02 cbabu bug2357371
1994:
1995: END IF; -- Vijay Shankar for Bug# 3190782
1996:
1997: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN
1998:
1999: /* Added by LGOPALSA. Bug 4210102.
2000: * Added CVD and Excise Education Cess
2001: * */

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

2142: ORDER BY 1;
2143: */
2144: END IF;
2145: -- START ILIPROCUREMENT FORWARD PORTING - KVAIDYAN
2146: IF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO', 'REQUISITION', 'RECEIPTS' , 'ASBN' ) THEN
2147: -- END ILIPROCUREMENT FORWARD PORTING - KVAIDYAN
2148: LOOP
2149:
2150: FETCH c_tax_retro_cur INTO rec_retro;

Line 2249: , 'STANDARD PO'

2245: Jai_Retro_Line_Changes jrlc
2246: WHERE jrlc.line_location_id = p_line_loc_id
2247: AND jrlc.doc_line_id = p_line_id
2248: AND jrlc.doc_type IN ( 'RELEASE'
2249: , 'STANDARD PO'
2250: )
2251: AND jrlc.doc_version_number = (SELECT
2252: MAX(jrlc1.doc_version_number)
2253: FROM

Line 2258: , 'STANDARD PO'

2254: Jai_Retro_Line_Changes jrlc1
2255: WHERE jrlc1.line_location_id = p_line_loc_id
2256: AND jrlc1.doc_line_id = p_line_id
2257: AND jrlc1.doc_type IN ( 'RELEASE'
2258: , 'STANDARD PO'
2259: )
2260: )
2261: );
2262: END IF;

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

2773: WHERE Requisition_Line_Id = p_header_id
2774: AND Tax_Line_No = I;
2775: END LOOP;
2776: P_TAX_AMOUNT := v_tax_amt;
2777: ELSIF p_type IN ( 'RELEASE', 'STANDARDPO' ) THEN /*********************************/
2778: FOR I IN 1 .. row_count LOOP
2779: IF tax_type_tab( i ) = 1 THEN
2780: bsln_amt := p_assessable_value;
2781: ELSIF tax_type_tab(i) = 4 THEN -- Ravi for VAT

Line 2817: ELSIF p_type = 'STANDARDPO' THEN

2813: app_exception.raise_exception;
2814: END IF;
2815: END IF;
2816: --=====================================================
2817: ELSIF p_type = 'STANDARDPO' THEN
2818: UPDATE JAI_PO_TAXES
2819: SET Tax_Amount = NVL( tax_amt_tab(I), 0 ),
2820: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ) * ( 1/p_conv_rate )
2821: WHERE Line_Location_Id = p_line_loc_id

Line 2855: ELSIF p_type = 'STANDARDPO' THEN

2851: SET Tax_Amount = NVL( v_tax_amt, 0 ),
2852: Total_Amount = v_tax_amt + p_price
2853: WHERE Line_Location_Id = p_header_id
2854: AND Po_Line_Id = p_line_id;
2855: ELSIF p_type = 'STANDARDPO' THEN
2856: OPEN Fetch_Sum_Cur( p_line_loc_id );
2857: FETCH Fetch_Sum_Cur INTO v_tax_amt;
2858: CLOSE Fetch_Sum_Cur;
2859:

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

3433: , pn_gst_assessable_value => ln_gst_assessable_value ); --Added by Jia for GST Bug#10043656 on 2010/09/10
3434: */
3435: );
3436:
3437: /** jai_po_tax_pkg.calculate_tax( 'STANDARDPO', v_po_hdr_id , v_Po_Line_Id1, v_line_location_id,
3438: v_qty, v_price*v_qty, v_uom, v_assessable_value,
3439: NVL( v_assessable_value, v_price*v_qty ), NULL, nvl(v_conv_rate,1));
3440:
3441:

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

3977: of REQUISITION_BLANKET as p_line_id would have po_line_id in this case.
3978: In case of requistion Blanket, v_po_curr is not populated at all. Added code to
3979: populate it with p_po_currency.
3980: Commented code to populate v_func_cur if p_func_curr is NULL
3981: Added standard who columns in all update statements.
3982:
3983: 7. 12/17/2007 Kevin Cheng Update the logic for inclusive tax calculation
3984:
3985: 8. 01/15/2008 Kevin Cheng Add a branch to deal with taxes recalculate for retroactive price update

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

4207:
4208: row_count := row_count + 1;
4209: END LOOP;
4210:
4211: ELSIF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN
4212:
4213: IF p_item_id IS NULL THEN
4214: OPEN Fetch_Item_Cur;
4215: FETCH Fetch_Item_Cur INTO p_inventory_item_id;

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

5723:
5724: row_count := row_count + 1;
5725: END LOOP;
5726:
5727: ELSIF p_type IN ( 'RELEASE', 'REQUISITION_BLANKET', 'STANDARDPO' ) THEN
5728:
5729: IF p_item_id IS NULL THEN
5730: OPEN Fetch_Item_Cur;
5731: FETCH Fetch_Item_Cur INTO p_inventory_item_id;

Line 5828: , 'STANDARD PO'

5824: Jai_Retro_Line_Changes jrlc
5825: WHERE jrlc.line_location_id = p_line_location_id
5826: AND jrlc.doc_type IN ( 'RELEASE'
5827: , 'RECEIPT'
5828: , 'STANDARD PO'
5829: )
5830: AND jrlc.doc_version_number = (SELECT
5831: MAX(jrlc1.doc_version_number)
5832: FROM

Line 5837: , 'STANDARD PO'

5833: Jai_Retro_Line_Changes jrlc1
5834: WHERE jrlc1.line_location_id = p_line_location_id
5835: AND jrlc1.doc_type IN ( 'RELEASE'
5836: , 'RECEIPT'
5837: , 'STANDARD PO'
5838: )
5839: )
5840: );
5841: tax_rate_tab(rec.lno) := -99999;

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

6315: END IF;
6316: --end, cbabu for Bug# 2659815
6317:
6318:
6319: --Bgowrava for Bug#5877782 Added standard Who columns
6320: UPDATE JAI_PO_REQ_LINE_TAXES
6321: SET Tax_Amount = round( nvl(tax_amt_tab(I),0), nvl(rnd_factor(I),0) ),/*4281841*/
6322: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ),
6323: last_update_date = sysdate,

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

6328: AND Tax_Line_No = I;
6329: END LOOP;
6330:
6331: -- cbabu for Bug# 2659815
6332: --Bgowrava for Bug#5877782 Added standard Who columns
6333: UPDATE JAI_PO_REQ_LINES
6334: SET Tax_Amount = v_tax_amt,
6335: total_amount = p_base_value + v_tax_amt,
6336: last_update_date = sysdate,

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

6361: END IF;
6362: --ILIPROCUREMENT END
6363:
6364: --end, cbabu for Bug# 2659815
6365: --Bgowrava for Bug#5877782 Added standard Who columns
6366: UPDATE JAI_PO_REQ_LINE_TAXES
6367: SET Tax_Amount = round( nvl(tax_amt_tab(I),0), rnd_factor(I) ),
6368: Tax_Target_Amount = NVL( tax_target_tab(I), 0 ),
6369: last_update_date = sysdate,

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

6373: AND Tax_Line_No = I;
6374: END LOOP;
6375:
6376:
6377: ELSIF p_type IN ( 'RELEASE', 'STANDARDPO' ) THEN
6378:
6379: IF v_debug = 'Y' THEN
6380: fnd_file.put_line( fnd_file.log, '3 Before Updating the table');
6381: END IF;

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

6403: fnd_file.put_line( fnd_file.log,' cur->'||curr_tab(i)||', tax_amt_tab('||i||') -> '||tax_amt_tab(i)||
6404: ', tax_target_tab -> '||tax_target_tab(i));
6405: END IF;
6406:
6407: --Bgowrava for Bug#5877782 Added standard Who columns
6408: UPDATE JAI_PO_TAXES
6409: SET tax_amount = round( nvl( tax_amt_tab(i), 0 ), nvl(rnd_factor(I),0) ),
6410: tax_target_amount = nvl( tax_target_tab(i), 0 ),
6411: last_update_date = sysdate,

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

6435: END IF;
6436: --=====================================================
6437: END LOOP;
6438:
6439: --Bgowrava for Bug#5877782 Added standard Who columns
6440: UPDATE JAI_PO_LINE_LOCATIONS
6441: SET Tax_Amount = NVL( v_tax_amt, 0 ),
6442: Total_Amount = v_tax_amt + p_base_value ,
6443: last_update_date = sysdate,

Line 7000: ( 'STANDARD',

6996: p_frm_line_id
6997: );
6998:
6999: jai_po_cmn_pkg.insert_line
7000: ( 'STANDARD',
7001: p_line_loc_id,
7002: p_po_hdr_id,
7003: p_po_line_id,
7004: p_cre_dt,

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

7143: -----------------------------------------------------------
7144: -- Added by Jia for GST Bug#10043656 on 2010/09/10, End
7145:
7146: jai_po_tax_pkg.calculate_tax
7147: ( 'STANDARDPO', p_po_hdr_id , p_po_line_id, p_line_loc_id,
7148: p_qty, p_price*p_qty, p_unit_code, v_tax_amt, p_assessable_value, ln_vat_assess_value*p_qty, NULL -- Ravi for VAT
7149: /* for bug 16013918 by anupgupt
7150: , pn_gst_assessable_value => ln_gst_assessable_value*p_qty); -- Added by Jia for GST Bug#10043656 on 2010/09/10
7151: */

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

7721:
7722: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, DUMMY, v_doc_curr, v_curr_conv_factor ) ;
7723:
7724: jai_po_tax_pkg.calculate_tax
7725: ( 'STANDARDPO', v_po_hdr_id , v_po_line_id, v_line_loc_id,
7726: v_qty, v_qty*v_temp_price, v_uom_code,
7727: v_assessable_value, v_assessable_value, NULL, v_curr_conv_factor
7728: /* for bug 16013918 by anupgupt
7729: , pn_gst_assessable_value => ln_gst_assessable_value ); -- Added by Jia for GST Bug#10043656 on 2010/09/10

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

8539: If ( ( v_type_lookup_code <> 'QUOTATION' AND v_quot_class_code <> 'CATALOG' )
8540: OR v_type_lookup_code <> 'BLANKET' )
8541: THEN
8542:
8543: jai_po_tax_pkg.calculate_tax( 'STANDARDPO', v_po_hdr_id , v_po_line_id, v_line_loc_id,
8544: -- v_qty, v_price*v_qty, v_uom, v_tax_amt, v_assessable_value, v_item_id ); -- cbabu for Bug# 2695844
8545: v_qty, v_price*v_qty, v_uom_code, v_tax_amt, v_assessable_value,ln_vat_assess_value, -- added, Harshita for bug #4245062
8546: v_item_id
8547: /* for bug 16013918 by anupgupt

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

8771:
8772:
8773: IF v_tax_ctg_id IS NOT NULL THEN -- 000a
8774:
8775: IF v_type_lookup_code NOT IN ( 'STANDARD', 'BLANKET', 'CONTRACT', 'PLANNED' ) THEN
8776: jai_po_cmn_pkg.Ja_In_Po_Func_Curr( v_po_hdr_id, dummy, v_curr, v_curr_conv_factor );
8777: END IF;
8778:
8779: OPEN Fetch_UOMCode_Cur;

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

8885: trans_name := v_type_lookup_code || TO_CHAR( v_line_loc_id ) || operation;
8886: END IF;
8887: -- Date 08-Aug-2007 by sacsethi for bug 6134628
8888: -- RELEASE look up type added
8889: ELSIF v_type_lookup_code IN ( 'STANDARD', 'PLANNED' , 'RELEASE' ) THEN
8890: trans_name := 'OTHERS' || TO_CHAR( v_line_loc_id ) || operation;
8891: ELSIF v_type_lookup_code = 'SCHEDULED' THEN
8892: trans_name := v_type_lookup_code || TO_CHAR( v_line_loc_id ) || operation;
8893: ELSIF v_type_lookup_code = 'BLANKET' THEN