Please advise what condition I use ..
ELSIF (p_scenario = 'FULL') THEN
full_load_p; (This procedure is inserting values after 2014).
I need to call same procedure of package_2 here in the above condition.
Please advise so that both insert will work i.e. after 2014 and using packg_2.Proc_2 the insert of before 2013.
You are asking me to evaluate a business logic of yours. But sorry I don't have the necessary details to give any suggestion.
Please read Re: 2. How do I ask a question on the forums? to know the details you need to provide for us to help.