[Home] [Help]
4585: x_msg_count OUT NOCOPY NUMBER,
4586: x_msg_data OUT NOCOPY VARCHAR2
4587: ) IS
4588:
4589: lOperUnit inv_organization_info_v.operating_unit%TYPE;
4590: xModelItemId bom_cto_src_orgs.model_item_id%TYPE;
4591: l_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;
4592: l_doc_header_id Number;
4593: l_doc_type_code Varchar2(20);
4666:
4667: lstmt_num := 1;
4668:
4669: -- rkaza. 3742393. 08/12/2004.
4670: -- Repalcing org_organization_definitions with inv_organization_info_v
4671:
4672: select distinct ou_id
4673: BULK COLLECT INTO xOrgLst
4674: from
4672: select distinct ou_id
4673: BULK COLLECT INTO xOrgLst
4674: from
4675: ( select distinct to_number(nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',ood.operating_unit),-99)) ou_id
4676: from inv_organization_info_v ood,
4677: bom_cto_src_orgs bcso
4678: where ( ood.organization_id = bcso.organization_id
4679: or
4680: ood.organization_id = bcso.rcv_org_id
4685: from financials_system_params_all
4686: where org_id in
4687: (
4688: select distinct ood.operating_unit
4689: from inv_organization_info_v ood,
4690: bom_cto_src_orgs bcso
4691: where ( ood.organization_id = bcso.organization_id
4692: or
4693: ood.organization_id = bcso.rcv_org_id
4845: if l_ga_flag = 'Y' then
4846:
4847: begin
4848: -- rkaza. 3742393. 08/12/2004.
4849: -- Repalcing org_organization_definitions with inv_organization_info_v
4850: select 'Y' into l_chk_own_oper_unit
4851: from dual
4852: where EXISTS (
4853: select po_header_id
4854: from po_ga_org_assignments
4855: where enabled_flag = 'Y'
4856: and organization_id in (
4857: select odd.operating_unit
4858: from inv_organization_info_v odd,
4859: bom_cto_src_orgs bcso
4860: where bcso.line_id = pModelLineId
4861: and bcso.organization_type in (3,5)
4862: and odd.organization_id = bcso.organization_id));