[Home] [Help]
5115: x_msg_count OUT NOCOPY NUMBER,
5116: x_msg_data OUT NOCOPY VARCHAR2
5117: ) IS
5118:
5119: lOperUnit inv_organization_info_v.operating_unit%TYPE;
5120: xModelItemId bom_cto_src_orgs.model_item_id%TYPE;
5121: l_model_vendors PO_AUTOSOURCE_SV.vendor_record_details;
5122: l_doc_header_id Number;
5123: l_doc_type_code Varchar2(20);
5196:
5197: lstmt_num := 1;
5198:
5199: -- rkaza. 3742393. 08/12/2004.
5200: -- Repalcing org_organization_definitions with inv_organization_info_v
5201:
5202: select distinct ou_id
5203: BULK COLLECT INTO xOrgLst
5204: from
5202: select distinct ou_id
5203: BULK COLLECT INTO xOrgLst
5204: from
5205: ( select distinct to_number(nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',ood.operating_unit),-99)) ou_id
5206: from inv_organization_info_v ood,
5207: bom_cto_src_orgs bcso
5208: where ( ood.organization_id = bcso.organization_id
5209: or
5210: ood.organization_id = bcso.rcv_org_id
5215: from financials_system_params_all
5216: where org_id in
5217: (
5218: select distinct ood.operating_unit
5219: from inv_organization_info_v ood,
5220: bom_cto_src_orgs bcso
5221: where ( ood.organization_id = bcso.organization_id
5222: or
5223: ood.organization_id = bcso.rcv_org_id
5375: if l_ga_flag = 'Y' then
5376:
5377: begin
5378: -- rkaza. 3742393. 08/12/2004.
5379: -- Repalcing org_organization_definitions with inv_organization_info_v
5380: select 'Y' into l_chk_own_oper_unit
5381: from dual
5382: where EXISTS (
5383: select po_header_id
5384: from po_ga_org_assignments
5385: where enabled_flag = 'Y'
5386: and organization_id in (
5387: select odd.operating_unit
5388: from inv_organization_info_v odd,
5389: bom_cto_src_orgs bcso
5390: where bcso.line_id = pModelLineId
5391: and bcso.organization_type in (3,5)
5392: and odd.organization_id = bcso.organization_id));