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_RLA_TRIGGER_PKG dependencies on JAI_PO_REQ_LINE_TAXES

Line 177: FROM JAI_PO_REQ_LINE_TAXES

173: -- additions by sriram - starts here Bug # 2977200
174:
175: CURSOR c_reqn_line_id(p_reqn_line_id Number) is
176: SELECT 1
177: FROM JAI_PO_REQ_LINE_TAXES
178: WHERE requisition_line_id = p_reqn_line_id;
179:
180: v_reqn_ctr Number :=0;
181:

Line 228: A check has been added to ensure that the insert into JAI_PO_REQ_LINE_TAXES

224: the tax table will be useful to identify whether the tax is a defaulted or a manual tax.
225:
226: 2. 26/05/2003 sriram - Bug # 2977200
227:
228: A check has been added to ensure that the insert into JAI_PO_REQ_LINE_TAXES
229: should happen only when the requisition line id
230: does not exist in the JAI_PO_REQ_LINE_TAXES table.
231: This check has been added at 2 places , before insert into JAI_PO_REQ_LINE_TAXES
232:

Line 230: does not exist in the JAI_PO_REQ_LINE_TAXES table.

226: 2. 26/05/2003 sriram - Bug # 2977200
227:
228: A check has been added to ensure that the insert into JAI_PO_REQ_LINE_TAXES
229: should happen only when the requisition line id
230: does not exist in the JAI_PO_REQ_LINE_TAXES table.
231: This check has been added at 2 places , before insert into JAI_PO_REQ_LINE_TAXES
232:
233: 3 21/10/2003 Vijay Shankar for Bug# 3207886, FileVersion# 616.2
234: Taxes are not getting defaulted from ITEM_CLASS and TAX_CATEGORY setup if Supplier information is not provided

Line 231: This check has been added at 2 places , before insert into JAI_PO_REQ_LINE_TAXES

227:
228: A check has been added to ensure that the insert into JAI_PO_REQ_LINE_TAXES
229: should happen only when the requisition line id
230: does not exist in the JAI_PO_REQ_LINE_TAXES table.
231: This check has been added at 2 places , before insert into JAI_PO_REQ_LINE_TAXES
232:
233: 3 21/10/2003 Vijay Shankar for Bug# 3207886, FileVersion# 616.2
234: Taxes are not getting defaulted from ITEM_CLASS and TAX_CATEGORY setup if Supplier information is not provided
235: requisition line. The issue occured because jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes accepts the Inventory

Line 667: INSERT INTO JAI_PO_REQ_LINE_TAXES(

663: v_po_line_id := Rec.Po_Line_Id;
664:
665:
666: -- Date 01/11/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
667: INSERT INTO JAI_PO_REQ_LINE_TAXES(
668: requisition_line_id, requisition_header_id, tax_line_no,
669: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
670: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10,
671: tax_id, tax_rate, qty_rate, uom, tax_amount, tax_target_amount,

Line 720: INSERT INTO JAI_PO_REQ_LINE_TAXES(

716: v_po_line_id := Rec.Po_Line_Id;
717:
718:
719: -- Date 01/11/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
720: INSERT INTO JAI_PO_REQ_LINE_TAXES(
721: requisition_line_id, requisition_header_id, tax_line_no,
722: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
723: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10,
724: tax_id, tax_rate, qty_rate, uom, tax_amount, tax_target_amount,

Line 797: FROM JAI_PO_REQ_LINE_TAXES

793: END IF;
794:
795: SELECT SUM(TAX_AMOUNT)
796: INTO v_tax_amount
797: FROM JAI_PO_REQ_LINE_TAXES
798: WHERE Requisition_Header_Id = v_requisition_header_id
799: AND Requisition_Line_Id = v_requisition_line_id
800: AND Tax_Type <> jai_constants.tax_type_tds ; /* 'TDS' ;Ramananda for removal of SQL LITERALs */
801: v_total_amount := v_line_amount + v_tax_amount;

Line 976: FROM JAI_PO_REQ_LINE_TAXES

972: Precedence_6, Precedence_7, Precedence_8, Precedence_9, Precedence_10,
973: Tax_Id, Currency, Tax_Rate, Qty_Rate, UOM, Tax_Amount, Tax_Type, Modvat_Flag,
974: Vendor_Id, Tax_Target_Amount,
975: tax_category_id -- cbabu for EnhancementBug# 2427465
976: FROM JAI_PO_REQ_LINE_TAXES
977: WHERE requisition_line_id = rqlineid
978: ORDER BY Tax_Line_No;
979:
980: CURSOR Fetch_Mod_Cr_Cur( taxid IN NUMBER ) IS

Line 1876: FROM JAI_PO_REQ_LINE_TAXES

1872:
1873: CURSOR c_reqn_line_id(p_reqn_line_id Number) is
1874: SELECT 1
1875: --FROM ja_in_reqn_tax_lines
1876: FROM JAI_PO_REQ_LINE_TAXES
1877: WHERE requisition_line_id = p_reqn_line_id;
1878:
1879: v_unit_price NUMBER;
1880:

Line 2183: DELETE from JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines

2179:
2180:
2181: --IF DELETING THEN
2182: IF pv_action = jai_constants.deleting THEN
2183: DELETE from JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines
2184: WHERE requisition_line_id = pr_old.requisition_line_id ;
2185:
2186: DELETE from JAI_PO_REQ_LINES --ja_in_reqn_lines
2187: WHERE requisition_line_id = pr_old.requisition_line_id;

Line 2194: DELETE from JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines

2190:
2191: --ELSIF UPDATING AND NVL(pr_new.cancel_flag,'$') = 'Y' AND NVL(pr_old.cancel_flag,'#') <> 'Y' THEN
2192: ELSIF pv_action = jai_constants.updating
2193: AND NVL(pr_new.cancel_flag,'$') = 'Y' AND NVL(pr_old.cancel_flag,'#') <> 'Y' THEN
2194: DELETE from JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines
2195: WHERE requisition_line_id = pr_old.requisition_line_id ;
2196:
2197: DELETE from JAI_PO_REQ_LINES --ja_in_reqn_lines
2198: WHERE requisition_line_id = pr_old.requisition_line_id;

Line 2308: Delete From JAI_PO_REQ_LINE_TAXES

2304: NVL( pr_old.suggested_vendor_location, 'X' ) <> NVL( pr_new.suggested_vendor_location, 'X' )
2305: )
2306: ) Then --pramasub end FP
2307:
2308: Delete From JAI_PO_REQ_LINE_TAXES
2309: Where Requisition_Line_Id = v_line_id;
2310:
2311: jai_cmn_tax_defaultation_pkg.JA_IN_VENDOR_DEFAULT_TAXES( v_dest_org_id, v_vendor_id, /*rchandan for bug# replaced NVL(v_org_id,0) with v_dest_org_id*/ --pramasub FP
2312: v_site_id, v_inventory_item_id, v_header_id,

Line 2333: Delete From JAI_PO_REQ_LINE_TAXES --Ja_In_Reqn_Tax_Lines pramasub FP

2329: WHERE Requisition_Line_Id = v_line_id
2330: AND Requisition_Header_Id = v_header_id;*/ --pramasub commented for FP
2331: --pramasub FP start 115.10
2332: ELSIF v_tax_flag = 'N' THEN /*5852041*/
2333: Delete From JAI_PO_REQ_LINE_TAXES --Ja_In_Reqn_Tax_Lines pramasub FP
2334: Where Requisition_Line_Id = v_line_id;
2335: IF v_blanket_hdr IS NOT NULL AND v_blanket_line IS NOT NULL THEN
2336: --Ja_In_Locate_Line( v_blanket_hdr, v_blanket_line, v_quantity, v_po_line_id, v_line_location_id );
2337: jai_po_cmn_pkg.locate_source_line( v_blanket_hdr, v_blanket_line, v_quantity, v_po_line_id,

Line 2345: INSERT INTO JAI_PO_REQ_LINE_TAXES(requisition_line_id, requisition_header_id, tax_line_no,

2341: close c_reqn_line_id;
2342:
2343: if nvl(v_reqn_ctr,0) = 0 then
2344: FOR rec IN cur_bpa_tax_lines(v_po_line_id, v_line_location_id) LOOP
2345: INSERT INTO JAI_PO_REQ_LINE_TAXES(requisition_line_id, requisition_header_id, tax_line_no,
2346: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
2347: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10,
2348: tax_id, tax_rate, qty_rate, uom, tax_amount, tax_target_amount,
2349: tax_type, modvat_flag, vendor_id, currency,

Line 2408: Update JAI_PO_REQ_LINE_TAXES

2404: END IF;
2405: END IF;
2406: --pramasub FP end
2407: ELSIF v_tax_flag = 'Y' Then
2408: Update JAI_PO_REQ_LINE_TAXES
2409: Set Tax_Amount = 0
2410: WHERE Requisition_Header_Id = v_header_id
2411: AND Requisition_Line_Id = v_line_id
2412: --AND Tax_Rate is Not Null;

Line 2417: UPDATE JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines

2413: AND nvl(Tax_Rate,0) <> 0 and nvl(qty_rate,0) <> 0; /*5852041*/ --pramasub FP 115.10
2414: /*5852041*/ --pramasub FP 115.12
2415: IF ( NVL( pr_old.CURRENCY_CODE, 'INR' ) <> NVL( pr_new.CURRENCY_CODE,'INR' ) ) THEN
2416:
2417: UPDATE JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines
2418: SET currency = nvl(pr_new.CURRENCY_CODE,'INR')
2419: WHERE requisition_header_id = v_header_id
2420: AND requisition_line_id = v_line_id;
2421:

Line 2422: UPDATE JAI_PO_REQ_LINE_TAXES jrtl --ja_in_reqn_tax_lines jrtl

2418: SET currency = nvl(pr_new.CURRENCY_CODE,'INR')
2419: WHERE requisition_header_id = v_header_id
2420: AND requisition_line_id = v_line_id;
2421:
2422: UPDATE JAI_PO_REQ_LINE_TAXES jrtl --ja_in_reqn_tax_lines jrtl
2423: SET tax_amount = tax_amount * DECODE(nvl(pr_new.CURRENCY_CODE,'INR'),
2424: 'INR',jai_cmn_utils_pkg.currency_conversion( v_gl_set_of_bks_id, pr_old.CURRENCY_CODE,
2425: pr_old.rate_date, pr_old.rate_type, pr_old.rate ),conv_rate)
2426: WHERE requisition_header_id = v_header_id

Line 2917: Delete From JAI_PO_REQ_LINE_TAXES

2913: END IF;
2914:
2915: IF v_tax_flag = 'N' THEN
2916:
2917: Delete From JAI_PO_REQ_LINE_TAXES
2918: Where Requisition_Line_Id = v_line_id;
2919:
2920: jai_cmn_tax_defaultation_pkg.Ja_In_vendor_Default_Taxes( nvl(v_org_id,0),
2921: v_vendor_id, v_site_id,

Line 2944: Update JAI_PO_REQ_LINE_TAXES

2940: WHERE Requisition_Line_Id = v_line_id
2941: AND Requisition_Header_Id = v_header_id;
2942:
2943: ELSIF v_tax_flag = 'Y' THEN
2944: Update JAI_PO_REQ_LINE_TAXES
2945: Set Tax_Amount = 0
2946: WHERE Requisition_Header_Id = v_header_id
2947: AND Requisition_Line_Id = v_line_id
2948: AND Currency = NVL( v_currency, v_hdr_curr )