I have a package which have two procedures. Finally i use a simple PLSQL block to call the package so that it calls the package.
the flow is like :
PLSQL Block --> Package.first_proceudre --> internally calls the second_procedure .
And finally the second procedure inserts the data into a temp table.
Attached here with the package which includes two procedure , the PLSQL block which is calling the package and finally the temp table structure.
I want to make this package and my block into one block , means I dont have to use any package any more . What ever the package is doing just to put them into one block and from the main plsql block it should call like the second block, and finally should insert the records.
Can any one help me in achieving this process.