[Home] [Help]
13: --08-Feb-08 sanagar BUG 6806974
14: --24-Feb-08 sanagar BUG 6816594
15: --03-Mar-08 sanagar BUG 6856618
16: --22-Apr-08 sanagar BUG 6988008, 6988312
17: --12-May-08 sanagar Changed ozf_sys_parameters_all to hr_operating_units
18: --14-May-08 sanagar Boundary Conditions for Change Value based on change type
19: --04-Jul-08 sanagar Change value & change type checks only for inbound
20: --08-Oct-08 rvkondur Added code for DPP Price Increase Enhancement
21: --19-May-09 anbbalas prior_price column in the interface table is not being used
116: SELECT hr.organization_id
117: ,hr.name
118: INTO p_txn_header_rec_type.org_id
119: ,p_txn_header_rec_type.operating_unit_name
120: FROM hr_operating_units hr
121: WHERE hr.name = nvl(p_txn_header_rec_type.operating_unit_name,hr.name) AND
122: hr.organization_id =nvl(to_number(p_txn_header_rec_type.org_id),hr.organization_id)
123: AND mo_global.check_access(hr.organization_id) = 'Y' ;
124: --MOAC
569:
570: SELECT gs.currency_code
571: INTO p_txn_header_rec_type.functional_currency
572: FROM gl_sets_of_books gs
573: , hr_operating_units hr
574: WHERE hr.set_of_books_id = gs.set_of_books_id
575: AND hr.organization_id = p_txn_header_rec_type.org_id;
576: EXCEPTION WHEN OTHERS THEN
577: fnd_message.set_name('DPP', 'DPP_TXN_FUNC_CURR_ERR');
5034: cv_supplier_site VARCHAR2,cv_supplier_site_id VARCHAR2,cv_operating_unit VARCHAR2,cv_org_id VARCHAR2 )
5035: IS
5036: SELECT transaction_int_header_id
5037: FROM dpp_txn_headers_int_all dtha ,
5038: hr_operating_units hr
5039: WHERE dtha.interface_status = 'N'
5040: AND nvl(dtha.ref_document_number, -1) = nvl(cv_doc_ref_no,nvl(dtha.ref_document_number,-1))
5041: AND (dtha.vendor_name = cv_supplier_name OR
5042: dtha.vendor_id = cv_supplier_id)
5100:
5101: IF p_operating_unit IS NOT NULL THEN
5102: SELECT organization_id
5103: INTO l_org_id
5104: FROM hr_operating_units
5105: WHERE name = p_operating_unit;
5106: END IF;
5107: IF DPP_DEBUG_HIGH_ON THEN
5108: fnd_file.put_line(fnd_file.log, 'Vendor Id '||l_supplier_id