DBA Data[Home] [Help]

APPS.DPP_TRANSACTION_PVT dependencies on HR_OPERATING_UNITS

Line 17: --12-May-08 sanagar Changed ozf_sys_parameters_all to hr_operating_units

13: --08-Feb-2008 sanagar BUG 6806974
14: --24-Feb-2008 sanagar BUG 6816594
15: --03-Mar-2008 sanagar BUG 6856618
16: --22-Apr-2008 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-July-08 sanagar Change value & change type checks only for inbound
20: --08-Oct-08 rvkondur Added code for DPP Price Increase Enhancement
21:

Line 115: FROM hr_operating_units hr

111: SELECT hr.organization_id
112: ,hr.name
113: INTO p_txn_header_rec_type.org_id
114: ,p_txn_header_rec_type.operating_unit_name
115: FROM hr_operating_units hr
116: WHERE hr.name = nvl(p_txn_header_rec_type.operating_unit_name,hr.name) AND
117: hr.organization_id =nvl(to_number(p_txn_header_rec_type.org_id),hr.organization_id)
118: AND mo_global.check_access(hr.organization_id) = 'Y' ;
119: --MOAC

Line 424: , hr_operating_units hr

420:
421: SELECT gs.currency_code
422: INTO p_txn_header_rec_type.functional_currency
423: FROM gl_sets_of_books gs
424: , hr_operating_units hr
425: WHERE hr.set_of_books_id = gs.set_of_books_id
426: AND hr.organization_id = p_txn_header_rec_type.org_id;
427: EXCEPTION WHEN OTHERS THEN
428: fnd_message.set_name('DPP', 'DPP_TXN_FUNC_CURR_ERR');

Line 4751: hr_operating_units hr

4747: cv_supplier_site VARCHAR2,cv_supplier_site_id VARCHAR2,cv_operating_unit VARCHAR2,cv_org_id VARCHAR2 )
4748: IS
4749: SELECT transaction_int_header_id
4750: FROM dpp_txn_headers_int_all dtha ,
4751: hr_operating_units hr
4752: WHERE dtha.interface_status = 'N'
4753: AND nvl(dtha.ref_document_number, -1) = nvl(cv_doc_ref_no,nvl(dtha.ref_document_number,-1))
4754: AND (dtha.vendor_name = cv_supplier_name OR
4755: dtha.vendor_id = cv_supplier_id)

Line 4817: FROM hr_operating_units

4813:
4814: IF p_operating_unit IS NOT NULL THEN
4815: SELECT organization_id
4816: INTO l_org_id
4817: FROM hr_operating_units
4818: WHERE name = p_operating_unit;
4819: END IF;
4820: IF DPP_DEBUG_HIGH_ON THEN
4821: fnd_file.put_line(fnd_file.log, 'Vendor Id '||l_supplier_id