[Home] [Help]
3544: WHERE REQUISITION_HEADER_ID = pn_requisition_hdr_id;
3545:
3546: CURSOR c_line_exist(cn_req_line_id NUMBER) IS
3547: SELECT 1
3548: FROM JAI_PO_REQ_LINES
3549: WHERE Requisition_Line_Id = cn_req_line_id
3550: AND Requisition_Header_Id = pn_requisition_hdr_id;
3551:
3552: ln_line_exist NUMBER;
3938: v_gl_set_of_bks_id := l_func_curr_det.ledger_id;
3939: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3940: FND_LOG.STRING(log_level =>G_LEVEL_PROCEDURE
3941: ,module =>G_MODULE_NAME||l_api_name
3942: ,message => 'Before insert into JAI_PO_REQ_LINES');
3943: END IF;
3944: INSERT INTO JAI_PO_REQ_LINES (
3945: requisition_line_id, requisition_header_id, tax_modified_flag,
3946: tax_amount, total_amount,SUGGESTED_VENDOR_NAME,SUGGESTED_VENDOR_LOCATION,currency_code,
3940: FND_LOG.STRING(log_level =>G_LEVEL_PROCEDURE
3941: ,module =>G_MODULE_NAME||l_api_name
3942: ,message => 'Before insert into JAI_PO_REQ_LINES');
3943: END IF;
3944: INSERT INTO JAI_PO_REQ_LINES (
3945: requisition_line_id, requisition_header_id, tax_modified_flag,
3946: tax_amount, total_amount,SUGGESTED_VENDOR_NAME,SUGGESTED_VENDOR_LOCATION,currency_code,
3947: creation_date, created_by, last_update_date,
3948: last_updated_by, last_update_login
3955:
3956: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3957: FND_LOG.STRING(log_level =>G_LEVEL_PROCEDURE
3958: ,module =>G_MODULE_NAME||l_api_name
3959: ,message => 'After insert into JAI_PO_REQ_LINES');
3960: END IF;
3961:
3962: --Added by Qiong for bug14681309 Begin
3963: po_req_tax_default(pr_requisition_line,v_tax_category_id, v_line_amount);
3982:
3983:
3984: v_total_amount := v_line_amount + v_exclu_tax_amount;
3985:
3986: UPDATE JAI_PO_REQ_LINES
3987: SET tax_amount = v_tax_amount,
3988: total_amount = v_total_amount,
3989: tax_category_id=v_tax_category_id
3990: WHERE requisition_line_id = pr_requisition_line.Requisition_Line_Id;
4073:
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 *
4083: WHERE requisition_line_id = pn_requisition_line_id;
4084: */
4085: CURSOR get_jai_req_info IS
4086: SELECT *
4087: FROM JAI_PO_REQ_LINES
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 *
4127: FROM Mtl_Units_Of_Measure
4128: WHERE Unit_Of_Measure = v_uom;
4129:
4130: CURSOR Fetch_Mod_Flag_Cur IS Select Tax_modified_Flag
4131: From JAI_PO_REQ_LINES
4132: Where Requisition_Line_Id = v_line_id;
4133:
4134:
4135: l_api_name CONSTANT VARCHAR2(200) := 'process_updating';
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;
4203:
4204: RETURN;
4205:
4300: ,module =>G_MODULE_NAME||l_api_name
4301: ,message => 'Before call po_req_tax_default');
4302: FND_LOG.STRING(log_level =>G_LEVEL_PROCEDURE
4303: ,module =>G_MODULE_NAME||l_api_name
4304: ,message => 'Updating table JAI_PO_REQ_LINES');
4305: END IF;
4306: --Added by Qiong for bug14681309 Begin
4307: po_req_tax_default(pr_requisition_line,v_tax_category_id, v_line_amount);
4308: --Added by Qiong for bug14681309 End
4306: --Added by Qiong for bug14681309 Begin
4307: po_req_tax_default(pr_requisition_line,v_tax_category_id, v_line_amount);
4308: --Added by Qiong for bug14681309 End
4309:
4310: UPDATE JAI_PO_REQ_LINES
4311: SET suggested_vendor_name = pr_requisition_line.suggested_vendor_name,
4312: suggested_vendor_location = pr_requisition_line.suggested_vendor_location,
4313: currency_code = pr_requisition_line.currency_code
4314: WHERE Requisition_Line_Id = v_line_id
4363: AND jr.Tax_Type <> jai_constants.tax_type_tds ;
4364:
4365: v_total_amount := v_line_amount + v_exclu_tax_amount;
4366:
4367: UPDATE JAI_PO_REQ_LINES
4368: SET tax_amount = v_line_tax_amount,
4369: total_amount = v_total_amount,
4370: tax_category_id=v_tax_category_id,
4371: currency_code = pr_requisition_line.currency_code
4914:
4915:
4916: CURSOR Chk_localization_entry(c_req_line_id NUMBER) IS
4917: SELECT COUNT(REQUISITION_LINE_ID)
4918: FROM JAI_PO_REQ_LINES
4919: WHERE REQUISITION_LINE_ID = c_req_line_id;
4920:
4921: CURSOR tax_override_flag_cur(c_vendor_id NUMBER, c_vendor_site_id NUMBER) IS
4922: SELECT override_flag
4927: v_override_flag VARCHAR2(1);
4928:
4929: CURSOR c_get_tax_category_id(p_requisition_line_id IN NUMBER) IS
4930: SELECT tax_category_id
4931: FROM JAI_PO_REQ_LINES
4932: WHERE requisition_line_id = p_requisition_line_id;
4933:
4934:
4935:
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;
7407:
7408: END delete_po_req_line_taxes;
7409:
8342:
8343:
8344: CURSOR Chk_localization_entry(c_req_line_id NUMBER) IS
8345: SELECT COUNT(REQUISITION_LINE_ID)
8346: FROM JAI_PO_REQ_LINES
8347: WHERE REQUISITION_LINE_ID = c_req_line_id;
8348:
8349: CURSOR tax_override_flag_cur(c_vendor_id NUMBER, c_vendor_site_id NUMBER) IS
8350: SELECT override_flag
8355: v_override_flag VARCHAR2(1);
8356:
8357: CURSOR c_get_tax_category_id(p_requisition_line_id IN NUMBER) IS
8358: SELECT tax_category_id
8359: FROM JAI_PO_REQ_LINES
8360: WHERE requisition_line_id = p_requisition_line_id;
8361:
8362:
8363: