DBA Data[Home] [Help]

APPS.MSD_EOL_PLAN dependencies on MSD_DP_SEEDED_DOC_DIMENSIONS

Line 205: from msd_dp_seeded_doc_dimensions

201: and nvl(parameter_name,'@#$') = nvl(p_parameter_name,'@#$');
202:
203: cursor c6 is
204: select selection_script
205: from msd_dp_seeded_doc_dimensions
206: where demand_plan_id=p_demand_plan_id
207: and dimension_code='MEAS'
208: and document_id=(select document_id from msd_dp_seeded_documents where document_name='MSD_SD_EOL_LWF' and demand_plan_id=p_demand_plan_id);
209:

Line 608: update msd_dp_seeded_doc_dimensions

604: loop
605:
606: l_pos := instr(nvl(l_selection_script,'@#$'),c5_rec.parameter_id);
607: if l_pos = 0 then
608: update msd_dp_seeded_doc_dimensions
609: set selection_script=selection_script||'V.'||c2_rec.selection_component||c5_rec.parameter_id||fnd_global.local_chr(10)
610: where demand_plan_id=p_demand_plan_id
611: and document_id=(select document_id from msd_dp_seeded_documents where document_name='MSD_SD_EOL_LWF' and demand_plan_id=p_demand_plan_id)
612: and dimension_code='MEAS';