APPS.CZ_PB_MGR dependencies on V$SESSION

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

19980: PROCEDURE publish_model(publicationid IN NUMBER, x_run_id IN OUT NOCOPY NUMBER, x_pb_status IN OUT NOCOPY VARCHAR2)
19981: AS
19982: l_publication_proc CONSTANT VARCHAR2(10) := 'CZ_PB_MGR';
19983: l_migration_proc CONSTANT VARCHAR2(20) := 'CZ_MODEL_MIGRATION';
19984: l_proc_name v$session.module%TYPE;
19985: v_check_publication BOOLEAN;
19986: v_new_copy_pb_id cz_model_publications.publication_id%TYPE;
19987: v_new_model_id cz_model_publications.model_id%TYPE;
19988: v_prev_publication_id cz_model_publications.publication_id%TYPE;

Line 20063: SELECT module INTO l_proc_name FROM V$SESSION WHERE module=l_publication_proc

20059: BEGIN
20060: IF (vMultiServerPub = 'YES') THEN
20061: dbms_application_info.set_client_info(cz_pb_mgr.v_server_id);
20062: log_timing_message('Entered into Multi Server publication ');
20063: SELECT module INTO l_proc_name FROM V$SESSION WHERE module=l_publication_proc
20064: AND client_info = TO_CHAR(cz_pb_mgr.v_server_id);
20065: ELSE
20066: l_proc_name := cz_pb_sync_util.check_process;
20067: END IF;

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

20070: NULL;
20071: END;
20072: ELSE -- must be migration because no stand alone UIT publication
20073: BEGIN
20074: SELECT module INTO l_proc_name FROM V$SESSION WHERE module = l_migration_proc;
20075: EXCEPTION
20076: WHEN NO_DATA_FOUND THEN
20077: NULL;
20078: END;