DBA Data[Home] [Help]

APPS.CZ_DIAGNOSTICS_PVT dependencies on CZ_DIAGNOSTICS_PVT

Line 1: PACKAGE BODY CZ_DIAGNOSTICS_PVT AS

1: PACKAGE BODY CZ_DIAGNOSTICS_PVT AS
2: /* $Header: czdiagb.pls 120.3 2007/11/26 08:20:51 kdande ship $ */
3: ---------------------------------------------------------------------------------------
4: --This procedure traverses product structure and explosion in parallel, and reports the
5: --first encountered problem. It does not continue after the first problems because most

Line 92: VALUES (x_run_id, SYSDATE, inMessage, 'CZ_DIAGNOSTICS_PVT.VERIFY_STRUCTURE', g_message_id);

88:
89: IF(p_debug_flag = 1)THEN
90:
91: INSERT INTO cz_db_logs (run_id, logtime, message, caller, message_id)
92: VALUES (x_run_id, SYSDATE, inMessage, 'CZ_DIAGNOSTICS_PVT.VERIFY_STRUCTURE', g_message_id);
93:
94: g_message_id := g_message_id + 1;
95:
96: COMMIT;

Line 529: -- SELECT cz_diagnostics_pvt.fast_verify(623160) FROM DUAL;

525: x_run_id, x_return_status, x_msg_count, x_msg_data);
526: END verify_structure; --(standard API)
527: ---------------------------------------------------------------------------------------
528: --Example if use:
529: -- SELECT cz_diagnostics_pvt.fast_verify(623160) FROM DUAL;
530:
531: FUNCTION fast_verify(p_devl_project_id IN NUMBER) RETURN VARCHAR2
532: IS
533:

Line 546: -- BEGIN DBMS_OUTPUT.PUT_LINE(cz_diagnostics_pvt.fast_debug(623160)); END;

542: END fast_verify;
543: ---------------------------------------------------------------------------------------
544: --Example if use:
545: -- SET SERVEROUTPUT ON
546: -- BEGIN DBMS_OUTPUT.PUT_LINE(cz_diagnostics_pvt.fast_debug(623160)); END;
547: -- /
548: -- SELECT message FROM cz_db_logs WHERE run_id = ORDER BY message_id;
549:
550: FUNCTION fast_debug(p_devl_project_id IN NUMBER) RETURN NUMBER

Line 574: --Example of use: EXECUTE cz_diagnostics_pvt.fast_fix_extra(623160, '7');

570: --before the run - this makes it easy to rollback the changes.
571: --
572: --Because the procedure may run many times, the debug output is disabled.
573: --
574: --Example of use: EXECUTE cz_diagnostics_pvt.fast_fix_extra(623160, '7');
575:
576: PROCEDURE fast_fix_extra(p_devl_project_id IN NUMBER, p_mark_fixed_char IN VARCHAR2)
577: IS
578:

Line 593: END CZ_DIAGNOSTICS_PVT;

589: l_run_id, l_return_status, l_msg_count, l_msg_data);
590: END LOOP;
591: END fast_fix_extra;
592: ---------------------------------------------------------------------------------------
593: END CZ_DIAGNOSTICS_PVT;