APPS.JAI_PO_PROC_PKG dependencies on JAI_PO_REQ_LINE_TAXES

Line 3968: FROM JAI_PO_REQ_LINE_TAXES jr,

3964: --Added by Qiong for bug14681309 End
3965:
3966: SELECT SUM(jr.TAX_AMOUNT)
3967: INTO v_exclu_tax_amount
3968: FROM JAI_PO_REQ_LINE_TAXES jr,
3969: JAI_CMN_TAXES_ALL jt
3970: WHERE jr.Requisition_Header_Id = pr_requisition_line.requisition_header_id
3971: AND jr.Requisition_Line_Id = pr_requisition_line.Requisition_Line_Id
3972: AND jr.tax_id = jt.tax_id

Line 3978: FROM JAI_PO_REQ_LINE_TAXES jr

3974: AND NVL(jt.INCLUSIVE_TAX_FLAG,'N') <> 'Y';
3975:
3976: SELECT SUM(jr.TAX_AMOUNT)
3977: INTO v_tax_amount
3978: FROM JAI_PO_REQ_LINE_TAXES jr
3979: WHERE jr.Requisition_Header_Id = pr_requisition_line.requisition_header_id
3980: AND jr.Requisition_Line_Id = pr_requisition_line.Requisition_Line_Id
3981: AND jr.Tax_Type <> jai_constants.tax_type_tds ;
3982:

Line 4078: r_old_jai_req_tax_line JAI_PO_REQ_LINE_TAXES%ROWTYPE;

4074: v_type_lookup_code Po_Requisition_Headers_All.Type_Lookup_Code % TYPE;
4075: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
4076: r_new_req_line PO_REQUISITION_LINES_ALL%ROWTYPE;
4077: r_old_jai_req_line JAI_PO_REQ_LINES%ROWTYPE;
4078: r_old_jai_req_tax_line JAI_PO_REQ_LINE_TAXES%ROWTYPE;
4079:
4080: /* CURSOR get_requesition_info IS
4081: SELECT *
4082: FROM PO_REQUISITION_LINES_ALL

Line 4092: FROM JAI_PO_REQ_LINE_TAXES

4088: WHERE requisition_line_id = pr_requisition_line.requisition_line_id;
4089:
4090: CURSOR get_jai_req_tax_line(p_requisition_Header_Id NUMBER) IS
4091: SELECT *
4092: FROM JAI_PO_REQ_LINE_TAXES
4093: WHERE requisition_Header_Id = p_requisition_Header_Id
4094: AND requisition_line_id = pr_requisition_line.requisition_line_id;--pn_requisition_line_id;
4095:
4096: CURSOR Fetch_Org_Id_Cur IS SELECT NVL(Operating_Unit,0)

Line 4198: DELETE from JAI_PO_REQ_LINE_TAXES

4194: FND_LOG.STRING(log_level =>G_LEVEL_PROCEDURE
4195: ,module =>G_MODULE_NAME||l_api_name
4196: ,message => 'Processing cancelling requistion');
4197: END IF;
4198: DELETE from JAI_PO_REQ_LINE_TAXES
4199: WHERE requisition_line_id = pr_requisition_line.requisition_line_id ;
4200:
4201: DELETE from JAI_PO_REQ_LINES
4202: WHERE requisition_line_id = pr_requisition_line.requisition_line_id;

Line 4296: Delete From JAI_PO_REQ_LINE_TAXES

4292: NVL( r_old_jai_req_line.suggested_vendor_location, 'X' ) <> NVL( pr_requisition_line.suggested_vendor_location, 'X' )
4293: )
4294: OR v_tax_flag = 'N'
4295: ) THEN
4296: Delete From JAI_PO_REQ_LINE_TAXES
4297: Where Requisition_Line_Id = v_line_id;
4298: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4299: FND_LOG.STRING(log_level =>G_LEVEL_PROCEDURE
4300: ,module =>G_MODULE_NAME||l_api_name

Line 4319: Update JAI_PO_REQ_LINE_TAXES

4315: AND Requisition_Header_Id = v_header_id;
4316:
4317: ELSIF v_tax_flag = 'Y' Then
4318: v_tax_category_id := r_old_jai_req_line.tax_category_id ;
4319: Update JAI_PO_REQ_LINE_TAXES
4320: Set Tax_Amount = 0
4321: WHERE Requisition_Header_Id = v_header_id
4322: AND Requisition_Line_Id = v_line_id
4323: AND nvl(Tax_Rate,0) <> 0 and nvl(qty_rate,0) <> 0;

Line 4350: FROM JAI_PO_REQ_LINE_TAXES jr,

4346: END IF;
4347:
4348: SELECT SUM(jr.TAX_AMOUNT)
4349: INTO v_exclu_tax_amount
4350: FROM JAI_PO_REQ_LINE_TAXES jr,
4351: JAI_CMN_TAXES_ALL jt
4352: WHERE jr.Requisition_Header_Id = pr_requisition_line.requisition_header_id
4353: AND jr.Requisition_Line_Id = pr_requisition_line.Requisition_Line_Id
4354: AND jr.tax_id = jt.tax_id

Line 4360: FROM JAI_PO_REQ_LINE_TAXES jr

4356: AND NVL(jt.INCLUSIVE_TAX_FLAG,'N') <> 'Y';
4357:
4358: SELECT SUM(jr.TAX_AMOUNT)
4359: INTO v_line_tax_amount
4360: FROM JAI_PO_REQ_LINE_TAXES jr
4361: WHERE jr.Requisition_Header_Id = pr_requisition_line.requisition_header_id
4362: AND jr.Requisition_Line_Id = pr_requisition_line.Requisition_Line_Id
4363: AND jr.Tax_Type <> jai_constants.tax_type_tds ;
4364:

Line 4529: FROM JAI_PO_REQ_LINE_TAXES

4525:
4526:
4527: CURSOR c_reqn_line_id(p_reqn_line_id Number) is
4528: SELECT 1
4529: FROM JAI_PO_REQ_LINE_TAXES
4530: WHERE requisition_line_id = p_reqn_line_id;
4531:
4532:
4533:

Line 4650: INSERT INTO JAI_PO_REQ_LINE_TAXES(

4646: FOR rec IN cur_bpa_tax_lines(v_po_line_id, v_line_location_id ) LOOP
4647: v_po_line_id := Rec.Po_Line_Id;
4648: v_tax_category_id := rec.tax_category_id ;
4649:
4650: INSERT INTO JAI_PO_REQ_LINE_TAXES(
4651: requisition_line_id, requisition_header_id, tax_line_no,
4652: precedence_1, precedence_2, precedence_3, precedence_4, precedence_5,
4653: precedence_6, precedence_7, precedence_8, precedence_9, precedence_10,
4654: tax_id, tax_rate, qty_rate, uom, tax_amount, tax_target_amount,

Line 4894: FROM JAI_PO_REQ_LINE_TAXES

4890: Precedence_6, Precedence_7, Precedence_8, Precedence_9, Precedence_10,
4891: Tax_Id, Currency, Tax_Rate, Qty_Rate, UOM, Tax_Amount, Tax_Type, Modvat_Flag,
4892: Vendor_Id, Tax_Target_Amount,
4893: tax_category_id
4894: FROM JAI_PO_REQ_LINE_TAXES
4895: WHERE requisition_line_id = rqlineid
4896: ORDER BY Tax_Line_No;
4897: rec_tax Fetch_Taxes_Cur%ROWTYPE;
4898: CURSOR Fetch_Mod_Cr_Cur( taxid IN NUMBER ) IS

Line 7402: DELETE from JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines

7398: (
7399: pn_requisition_line_id IN NUMBER
7400: ) IS
7401: BEGIN
7402: DELETE from JAI_PO_REQ_LINE_TAXES --ja_in_reqn_tax_lines
7403: WHERE requisition_line_id = pn_requisition_line_id ;
7404:
7405: DELETE from JAI_PO_REQ_LINES --ja_in_reqn_lines
7406: WHERE requisition_line_id = pn_requisition_line_id;

Line 8322: FROM JAI_PO_REQ_LINE_TAXES

8318: Precedence_6, Precedence_7, Precedence_8, Precedence_9, Precedence_10,
8319: Tax_Id, Currency, Tax_Rate, Qty_Rate, UOM, Tax_Amount, Tax_Type, Modvat_Flag,
8320: Vendor_Id, Tax_Target_Amount,
8321: tax_category_id
8322: FROM JAI_PO_REQ_LINE_TAXES
8323: WHERE requisition_line_id = rqlineid
8324: ORDER BY Tax_Line_No;
8325: rec_tax Fetch_Taxes_Cur%ROWTYPE;
8326: CURSOR Fetch_Mod_Cr_Cur( taxid IN NUMBER ) IS