APPS.CZ_PB_MGR dependencies on V$SESSION

Line 18847: l_proc_name v$session.module%TYPE;

18843: PROCEDURE publish_model(publicationid IN NUMBER, x_run_id IN OUT NOCOPY NUMBER, x_pb_status IN OUT NOCOPY VARCHAR2)
18844: AS
18845: l_publication_proc CONSTANT VARCHAR2(10) := 'CZ_PB_MGR';
18846: l_migration_proc CONSTANT VARCHAR2(20) := 'CZ_MODEL_MIGRATION';
18847: l_proc_name v$session.module%TYPE;
18848: v_check_publication BOOLEAN;
18849: v_new_copy_pb_id cz_model_publications.publication_id%TYPE;
18850: v_new_model_id cz_model_publications.model_id%TYPE;
18851: v_prev_publication_id cz_model_publications.publication_id%TYPE;

Line 18915: SELECT module INTO l_proc_name FROM V$SESSION WHERE module = l_migration_proc;

18911: IF g_object_type = cz_pb_mgr.MODEL_PUBLICATION THEN
18912: l_proc_name := cz_pb_sync_util.check_process;
18913: ELSE -- must be migration because no stand alone UIT publication
18914: BEGIN
18915: SELECT module INTO l_proc_name FROM V$SESSION WHERE module = l_migration_proc;
18916: EXCEPTION
18917: WHEN NO_DATA_FOUND THEN
18918: NULL;
18919: END;