1: PACKAGE BODY CZ_REFS AS
2: /* $Header: czrefb.pls 120.5.12010000.2 2009/03/02 14:47:07 vsingava ship $*/
3:
4: PRODUCT_TYPE CONSTANT INTEGER:=258;
5: COMPONENT_TYPE CONSTANT INTEGER:=259;
2773: BEGIN
2774:
2775: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2776: v_ndebug := 0;
2777: cz_utils.log_report('CZ_REFS', 'check_Node', v_ndebug,
2778: 'Starting CZ_REFS.check_Node for model node with ps_node_id='||TO_CHAR(p_ps_node_id)||
2779: ' current time : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24:MI:SS'),
2780: fnd_log.LEVEL_PROCEDURE);
2781: cz_utils.log_report('CZ_REFS', 'check_Node', v_ndebug,
2774:
2775: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2776: v_ndebug := 0;
2777: cz_utils.log_report('CZ_REFS', 'check_Node', v_ndebug,
2778: 'Starting CZ_REFS.check_Node for model node with ps_node_id='||TO_CHAR(p_ps_node_id)||
2779: ' current time : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24:MI:SS'),
2780: fnd_log.LEVEL_PROCEDURE);
2781: cz_utils.log_report('CZ_REFS', 'check_Node', v_ndebug,
2782: 'Parameters : '||
2777: cz_utils.log_report('CZ_REFS', 'check_Node', v_ndebug,
2778: 'Starting CZ_REFS.check_Node for model node with ps_node_id='||TO_CHAR(p_ps_node_id)||
2779: ' current time : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24:MI:SS'),
2780: fnd_log.LEVEL_PROCEDURE);
2781: cz_utils.log_report('CZ_REFS', 'check_Node', v_ndebug,
2782: 'Parameters : '||
2783: 'p_ps_node_id = '||TO_CHAR(p_ps_node_id)||
2784: 'p_model_id = '||TO_CHAR(p_model_id)||
2785: 'p_maximum = '||TO_CHAR(p_maximum)||
3582: BEGIN
3583:
3584: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3585: v_ndebug := 0;
3586: cz_utils.log_report('CZ_REFS', 'move_Node', v_ndebug,
3587: 'Starting CZ_REFS.move_Node for model node with ps_node_id='||TO_CHAR(p_from_ps_node_id)||
3588: ' current time : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24:MI:SS'),
3589: fnd_log.LEVEL_PROCEDURE);
3590: cz_utils.log_report('CZ_REFS', 'move_Node', v_ndebug,
3583:
3584: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3585: v_ndebug := 0;
3586: cz_utils.log_report('CZ_REFS', 'move_Node', v_ndebug,
3587: 'Starting CZ_REFS.move_Node for model node with ps_node_id='||TO_CHAR(p_from_ps_node_id)||
3588: ' current time : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24:MI:SS'),
3589: fnd_log.LEVEL_PROCEDURE);
3590: cz_utils.log_report('CZ_REFS', 'move_Node', v_ndebug,
3591: 'Parameters : '||
3586: cz_utils.log_report('CZ_REFS', 'move_Node', v_ndebug,
3587: 'Starting CZ_REFS.move_Node for model node with ps_node_id='||TO_CHAR(p_from_ps_node_id)||
3588: ' current time : '||TO_CHAR(SYSDATE,'DD-MM-YYYY HH24:MI:SS'),
3589: fnd_log.LEVEL_PROCEDURE);
3590: cz_utils.log_report('CZ_REFS', 'move_Node', v_ndebug,
3591: 'Parameters : '||
3592: 'p_from_ps_node_id = '||TO_CHAR(p_from_ps_node_id)||
3593: 'p_to_ps_node_id = '||TO_CHAR(p_to_ps_node_id)||
3594: 'p_project_id = '||TO_CHAR(p_project_id)