[Home] [Help]
146: '*')),
147: NULL, 'Y', -- set to Y (VALID) if all characters are within the specified range.
148: 'N') -- set to N (INVALID) if any other characters are contained in the string.
149: INTO VN_CODE_LENGTH, VV_VALID_FLAG
150: FROM DUAL;
151:
152:
153: ------------------------------------------------------------------------------------------------
154: -- Logic in above SQL explained:
4419: -- FUNCTION: DELETE_ALL_INTEGRATORS --
4420: -- --
4421: -- DESCRIPTION: Delete all integrators for the given application id. --
4422: -- This will delete each integrator for the application id --
4423: -- individually as per DELETE_INTEGRATOR(). --
4424: -- This will include all subsiduary structures: --
4425: -- - Integrator and attached Parameter Lists --
4426: -- - Interfaces as per DELETE_ALL_INTERFACES() --
4427: -- - Contents as per DELETE_ALL_CONTENTS() --
4637: -- FUNCTION: DELETE_ALL_INTERFACES --
4638: -- --
4639: -- DESCRIPTION: Delete all interfaces for the given integrator. --
4640: -- This will delete each interface for the integrator --
4641: -- individually as per DELETE_INTERFACE(). --
4642: -- The number of interfaces deleted is returned (0 or greater). --
4643: -- No commits are done. --
4644: -- --
4645: -- MODIFICATION HISTORY --
4669: -- FUNCTION: DELETE_ALL_DUP_PROFILES --
4670: -- --
4671: -- DESCRIPTION: Delete all duplicate profiles for the given integrator. --
4672: -- This will delete each duplicate profile for the integrator --
4673: -- individually as per DELETE_DUP_PROFILE(). --
4674: -- The number of profiles deleted is returned (0 or greater). --
4675: -- No commits are done. --
4676: -- --
4677: -- MODIFICATION HISTORY --
4828: -- FUNCTION: DELETE_ALL_CONTENTS --
4829: -- --
4830: -- DESCRIPTION: Delete all contents for the given integrator. --
4831: -- This will delete each content for the integrator --
4832: -- individually as per DELETE_CONTENT(). --
4833: -- It will NOT delete any mappings that reference the content. --
4834: -- use DELETE_MAPPING or DELETE_INTEGRATOR for consistent --
4835: -- deletion. --
4836: -- The number of contents deleted is returned (0 or greater). --
4913: -- FUNCTION: DELETE_ALL_MAPPINGS --
4914: -- --
4915: -- DESCRIPTION: Delete all mappings for the given integrator. --
4916: -- This will delete each mapping for the integrator --
4917: -- individually as per DELETE_MAPPING(). --
4918: -- The number of mappings deleted is returned (0 or greater). --
4919: -- No commits are done. --
4920: -- --
4921: -- MODIFICATION HISTORY --
4947: -- FUNCTION: DELETE_ALL_LAYOUTS --
4948: -- --
4949: -- DESCRIPTION: Delete all layouts for the given integrator. --
4950: -- This will delete each layouts for the integrator --
4951: -- individually as per DELETE_LAYOUT(). --
4952: -- The number of layouts deleted is returned (0 or greater). --
4953: -- No commits are done. --
4954: -- --
4955: -- MODIFICATION HISTORY --