Hello,
I have a package declared as:
CREATE OR REPLACE PACKAGE TEST_PKG AS
PROCEDURE check_cascade_pricing (x_return_status OUT NOCOPY VARCHAR2
,p_chr_id IN NUMBER
);
END;
CREATE OR REPLACE PACKAGE BODY TEST_PKG AS
PROCEDURE check_cascade_pricing (x_return_status OUT NOCOPY VARCHAR2
,p_chr_id IN NUMBER
)
IS
BEGIN
--some activities done and then commited
END;
END;
I need to create another procedure which will be called after the check_cascade_pricing activity is done.But I don't want to create in Package Specification.
Is there any way to do so?