453: WHERE CLE_ID=p_cle_id AND ID<>p_id
454: AND Greatest( p_from, Nvl(value_from,0)) <= Least( p_to, Nvl(value_to,l_MAX_NUM) );
455: BEGIN
456: IF (l_debug = 'Y') THEN
457: okc_debug.Set_Indentation('OKC_PHL_PVT');
458: okc_debug.log('500: Entered validate_values_from_to', 2);
459: END IF;
460:
461: -- initialize return status
454: AND Greatest( p_from, Nvl(value_from,0)) <= Least( p_to, Nvl(value_to,l_MAX_NUM) );
455: BEGIN
456: IF (l_debug = 'Y') THEN
457: okc_debug.Set_Indentation('OKC_PHL_PVT');
458: okc_debug.log('500: Entered validate_values_from_to', 2);
459: END IF;
460:
461: -- initialize return status
462: x_return_status := OKC_API.G_RET_STS_SUCCESS;
484: x_return_status := OKC_API.G_RET_STS_ERROR;
485: End If;
486:
487: IF (l_debug = 'Y') THEN
488: okc_debug.log('600: Leaving validate_values_from_to', 2);
489: okc_debug.Reset_Indentation;
490: END IF;
491: EXCEPTION
492: WHEN G_EXCEPTION_HALT_VALIDATION THEN
485: End If;
486:
487: IF (l_debug = 'Y') THEN
488: okc_debug.log('600: Leaving validate_values_from_to', 2);
489: okc_debug.Reset_Indentation;
490: END IF;
491: EXCEPTION
492: WHEN G_EXCEPTION_HALT_VALIDATION THEN
493: null;
2734:
2735: BEGIN
2736:
2737: IF (l_debug = 'Y') THEN
2738: okc_debug.Set_Indentation('OKC_PHL_PVT');
2739: okc_debug.log('10700: Entered create_version', 2);
2740: END IF;
2741:
2742: INSERT INTO okc_ph_line_breaks_h
2735: BEGIN
2736:
2737: IF (l_debug = 'Y') THEN
2738: okc_debug.Set_Indentation('OKC_PHL_PVT');
2739: okc_debug.log('10700: Entered create_version', 2);
2740: END IF;
2741:
2742: INSERT INTO okc_ph_line_breaks_h
2743: (
2798: WHERE dnz_chr_id = p_chr_id --price hold sub-line
2799: );
2800:
2801: IF (l_debug = 'Y') THEN
2802: okc_debug.log('10800: Leaving create_version', 2);
2803: okc_debug.Reset_Indentation;
2804: END IF;
2805:
2806: RETURN l_return_status;
2799: );
2800:
2801: IF (l_debug = 'Y') THEN
2802: okc_debug.log('10800: Leaving create_version', 2);
2803: okc_debug.Reset_Indentation;
2804: END IF;
2805:
2806: RETURN l_return_status;
2807:
2809: -- other appropriate handlers
2810: WHEN OTHERS THEN
2811:
2812: IF (l_debug = 'Y') THEN
2813: okc_debug.log('10900: Exiting create_version:OTHERS Exception', 2);
2814: okc_debug.Reset_Indentation;
2815: END IF;
2816:
2817: -- store SQL error message on message stack
2810: WHEN OTHERS THEN
2811:
2812: IF (l_debug = 'Y') THEN
2813: okc_debug.log('10900: Exiting create_version:OTHERS Exception', 2);
2814: okc_debug.Reset_Indentation;
2815: END IF;
2816:
2817: -- store SQL error message on message stack
2818: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2838:
2839: BEGIN
2840:
2841: IF (l_debug = 'Y') THEN
2842: okc_debug.Set_Indentation('OKC_PHL_PVT');
2843: okc_debug.log('11000: Entered restore_version', 2);
2844: END IF;
2845:
2846: INSERT INTO okc_ph_line_breaks
2839: BEGIN
2840:
2841: IF (l_debug = 'Y') THEN
2842: okc_debug.Set_Indentation('OKC_PHL_PVT');
2843: okc_debug.log('11000: Entered restore_version', 2);
2844: END IF;
2845:
2846: INSERT INTO okc_ph_line_breaks
2847: (
2903: )
2904: AND major_version = p_major_version;
2905:
2906: IF (l_debug = 'Y') THEN
2907: okc_debug.log('11100: Leaving restore_version', 2);
2908: okc_debug.Reset_Indentation;
2909: END IF;
2910:
2911: RETURN l_return_status;
2904: AND major_version = p_major_version;
2905:
2906: IF (l_debug = 'Y') THEN
2907: okc_debug.log('11100: Leaving restore_version', 2);
2908: okc_debug.Reset_Indentation;
2909: END IF;
2910:
2911: RETURN l_return_status;
2912:
2914: -- other appropriate handlers
2915: WHEN OTHERS THEN
2916:
2917: IF (l_debug = 'Y') THEN
2918: okc_debug.log('11200: Exiting restore_version:OTHERS Exception', 2);
2919: okc_debug.Reset_Indentation;
2920: END IF;
2921:
2922: -- store SQL error message on message stack
2915: WHEN OTHERS THEN
2916:
2917: IF (l_debug = 'Y') THEN
2918: okc_debug.log('11200: Exiting restore_version:OTHERS Exception', 2);
2919: okc_debug.Reset_Indentation;
2920: END IF;
2921:
2922: -- store SQL error message on message stack
2923: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,