eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.VEA_TPA_UTIL_PVT dependencies on ECE_XREF_DATA

Line 2388: PROCEDURE NAME: insert_ece_xref_data

2384: --
2385: --
2386: /*========================================================================
2387:
2388: PROCEDURE NAME: insert_ece_xref_data
2389:
2390: PURPOSE: Inserts a code conversion value into EDI table
2391: ECE_XREF_DATA.
2392:

Line 2391: ECE_XREF_DATA.

2387:
2388: PROCEDURE NAME: insert_ece_xref_data
2389:
2390: PURPOSE: Inserts a code conversion value into EDI table
2391: ECE_XREF_DATA.
2392:
2393: ========================================================================*/
2394: PROCEDURE insert_ece_xref_data
2395: (

Line 2394: PROCEDURE insert_ece_xref_data

2390: PURPOSE: Inserts a code conversion value into EDI table
2391: ECE_XREF_DATA.
2392:
2393: ========================================================================*/
2394: PROCEDURE insert_ece_xref_data
2395: (
2396: p_data_id IN ece_xref_data.xref_data_id%TYPE,
2397: p_category_id IN ece_xref_data.xref_category_id%TYPE,
2398: p_category_code IN ece_xref_data.xref_category_code%TYPE,

Line 2396: p_data_id IN ece_xref_data.xref_data_id%TYPE,

2392:
2393: ========================================================================*/
2394: PROCEDURE insert_ece_xref_data
2395: (
2396: p_data_id IN ece_xref_data.xref_data_id%TYPE,
2397: p_category_id IN ece_xref_data.xref_category_id%TYPE,
2398: p_category_code IN ece_xref_data.xref_category_code%TYPE,
2399: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,
2400: p_key1 IN ece_xref_data.xref_key1%TYPE,

Line 2397: p_category_id IN ece_xref_data.xref_category_id%TYPE,

2393: ========================================================================*/
2394: PROCEDURE insert_ece_xref_data
2395: (
2396: p_data_id IN ece_xref_data.xref_data_id%TYPE,
2397: p_category_id IN ece_xref_data.xref_category_id%TYPE,
2398: p_category_code IN ece_xref_data.xref_category_code%TYPE,
2399: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,
2400: p_key1 IN ece_xref_data.xref_key1%TYPE,
2401: p_description IN ece_xref_data.description%TYPE

Line 2398: p_category_code IN ece_xref_data.xref_category_code%TYPE,

2394: PROCEDURE insert_ece_xref_data
2395: (
2396: p_data_id IN ece_xref_data.xref_data_id%TYPE,
2397: p_category_id IN ece_xref_data.xref_category_id%TYPE,
2398: p_category_code IN ece_xref_data.xref_category_code%TYPE,
2399: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,
2400: p_key1 IN ece_xref_data.xref_key1%TYPE,
2401: p_description IN ece_xref_data.description%TYPE
2402: )

Line 2399: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,

2395: (
2396: p_data_id IN ece_xref_data.xref_data_id%TYPE,
2397: p_category_id IN ece_xref_data.xref_category_id%TYPE,
2398: p_category_code IN ece_xref_data.xref_category_code%TYPE,
2399: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,
2400: p_key1 IN ece_xref_data.xref_key1%TYPE,
2401: p_description IN ece_xref_data.description%TYPE
2402: )
2403: IS

Line 2400: p_key1 IN ece_xref_data.xref_key1%TYPE,

2396: p_data_id IN ece_xref_data.xref_data_id%TYPE,
2397: p_category_id IN ece_xref_data.xref_category_id%TYPE,
2398: p_category_code IN ece_xref_data.xref_category_code%TYPE,
2399: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,
2400: p_key1 IN ece_xref_data.xref_key1%TYPE,
2401: p_description IN ece_xref_data.description%TYPE
2402: )
2403: IS
2404: --{

Line 2401: p_description IN ece_xref_data.description%TYPE

2397: p_category_id IN ece_xref_data.xref_category_id%TYPE,
2398: p_category_code IN ece_xref_data.xref_category_code%TYPE,
2399: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,
2400: p_key1 IN ece_xref_data.xref_key1%TYPE,
2401: p_description IN ece_xref_data.description%TYPE
2402: )
2403: IS
2404: --{
2405: l_api_name CONSTANT VARCHAR2(30) := 'insert_ece_xref_data';

Line 2405: l_api_name CONSTANT VARCHAR2(30) := 'insert_ece_xref_data';

2401: p_description IN ece_xref_data.description%TYPE
2402: )
2403: IS
2404: --{
2405: l_api_name CONSTANT VARCHAR2(30) := 'insert_ece_xref_data';
2406: l_location VARCHAR2(32767);
2407: --
2408: --
2409: --}

Line 2414: INSERT INTO ece_xref_data

2410: BEGIN
2411: --{
2412: l_location := '0010';
2413: --
2414: INSERT INTO ece_xref_data
2415: (
2416: xref_data_id,
2417: xref_category_id,
2418: xref_category_code,

Line 2460: END insert_ece_xref_data;

2456: p_location => l_location
2457: );
2458: --}
2459: --}
2460: END insert_ece_xref_data;
2461: --
2462: --
2463: /*========================================================================
2464:

Line 2465: PROCEDURE NAME: process_ece_xref_data

2461: --
2462: --
2463: /*========================================================================
2464:
2465: PROCEDURE NAME: process_ece_xref_data
2466:
2467: PURPOSE: Inserts a code conversion value into EDI table ECE_XREF_DATA,
2468: if record does not existing for the correspoding category,
2469: layer provider code(key1) and external value(branching

Line 2467: PURPOSE: Inserts a code conversion value into EDI table ECE_XREF_DATA,

2463: /*========================================================================
2464:
2465: PROCEDURE NAME: process_ece_xref_data
2466:
2467: PURPOSE: Inserts a code conversion value into EDI table ECE_XREF_DATA,
2468: if record does not existing for the correspoding category,
2469: layer provider code(key1) and external value(branching
2470: condition value). IF a record is inserted then appends a
2471: message to log file informing user to specify code conversion

Line 2475: PROCEDURE process_ece_xref_data

2471: message to log file informing user to specify code conversion
2472: for the inserted record.
2473:
2474: ========================================================================*/
2475: PROCEDURE process_ece_xref_data
2476: (
2477: p_category_id IN ece_xref_data.xref_category_id%TYPE,
2478: p_category_code IN ece_xref_data.xref_category_code%TYPE,
2479: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,

Line 2477: p_category_id IN ece_xref_data.xref_category_id%TYPE,

2473:
2474: ========================================================================*/
2475: PROCEDURE process_ece_xref_data
2476: (
2477: p_category_id IN ece_xref_data.xref_category_id%TYPE,
2478: p_category_code IN ece_xref_data.xref_category_code%TYPE,
2479: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,
2480: p_key1 IN ece_xref_data.xref_key1%TYPE,
2481: p_description IN ece_xref_data.description%TYPE DEFAULT NULL

Line 2478: p_category_code IN ece_xref_data.xref_category_code%TYPE,

2474: ========================================================================*/
2475: PROCEDURE process_ece_xref_data
2476: (
2477: p_category_id IN ece_xref_data.xref_category_id%TYPE,
2478: p_category_code IN ece_xref_data.xref_category_code%TYPE,
2479: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,
2480: p_key1 IN ece_xref_data.xref_key1%TYPE,
2481: p_description IN ece_xref_data.description%TYPE DEFAULT NULL
2482: )

Line 2479: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,

2475: PROCEDURE process_ece_xref_data
2476: (
2477: p_category_id IN ece_xref_data.xref_category_id%TYPE,
2478: p_category_code IN ece_xref_data.xref_category_code%TYPE,
2479: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,
2480: p_key1 IN ece_xref_data.xref_key1%TYPE,
2481: p_description IN ece_xref_data.description%TYPE DEFAULT NULL
2482: )
2483: IS

Line 2480: p_key1 IN ece_xref_data.xref_key1%TYPE,

2476: (
2477: p_category_id IN ece_xref_data.xref_category_id%TYPE,
2478: p_category_code IN ece_xref_data.xref_category_code%TYPE,
2479: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,
2480: p_key1 IN ece_xref_data.xref_key1%TYPE,
2481: p_description IN ece_xref_data.description%TYPE DEFAULT NULL
2482: )
2483: IS
2484: --{

Line 2481: p_description IN ece_xref_data.description%TYPE DEFAULT NULL

2477: p_category_id IN ece_xref_data.xref_category_id%TYPE,
2478: p_category_code IN ece_xref_data.xref_category_code%TYPE,
2479: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,
2480: p_key1 IN ece_xref_data.xref_key1%TYPE,
2481: p_description IN ece_xref_data.description%TYPE DEFAULT NULL
2482: )
2483: IS
2484: --{
2485: l_api_name CONSTANT VARCHAR2(30) := 'process_ece_xref_data';

Line 2485: l_api_name CONSTANT VARCHAR2(30) := 'process_ece_xref_data';

2481: p_description IN ece_xref_data.description%TYPE DEFAULT NULL
2482: )
2483: IS
2484: --{
2485: l_api_name CONSTANT VARCHAR2(30) := 'process_ece_xref_data';
2486: l_location VARCHAR2(32767);
2487: --
2488: --
2489: l_xref_data_id ece_xref_data.xref_data_id%TYPE;

Line 2489: l_xref_data_id ece_xref_data.xref_data_id%TYPE;

2485: l_api_name CONSTANT VARCHAR2(30) := 'process_ece_xref_data';
2486: l_location VARCHAR2(32767);
2487: --
2488: --
2489: l_xref_data_id ece_xref_data.xref_data_id%TYPE;
2490: --
2491: --
2492: CURSOR xref_data_cur
2493: (

Line 2494: p_category_id IN ece_xref_data.xref_category_id%TYPE,

2490: --
2491: --
2492: CURSOR xref_data_cur
2493: (
2494: p_category_id IN ece_xref_data.xref_category_id%TYPE,
2495: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,
2496: p_key1 IN ece_xref_data.xref_key1%TYPE
2497: )
2498: IS

Line 2495: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,

2491: --
2492: CURSOR xref_data_cur
2493: (
2494: p_category_id IN ece_xref_data.xref_category_id%TYPE,
2495: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,
2496: p_key1 IN ece_xref_data.xref_key1%TYPE
2497: )
2498: IS
2499: SELECT xref_data_id

Line 2496: p_key1 IN ece_xref_data.xref_key1%TYPE

2492: CURSOR xref_data_cur
2493: (
2494: p_category_id IN ece_xref_data.xref_category_id%TYPE,
2495: p_ext_value IN ece_xref_data.xref_ext_value1%TYPE,
2496: p_key1 IN ece_xref_data.xref_key1%TYPE
2497: )
2498: IS
2499: SELECT xref_data_id
2500: FROM ece_xref_data

Line 2500: FROM ece_xref_data

2496: p_key1 IN ece_xref_data.xref_key1%TYPE
2497: )
2498: IS
2499: SELECT xref_data_id
2500: FROM ece_xref_data
2501: WHERE xref_category_id = p_category_id
2502: AND xref_ext_value1 = p_ext_value
2503: AND xref_key1 = p_key1;
2504: --}

Line 2536: SELECT ECE_XREF_DATA_S1.nextval

2532: THEN
2533: --{
2534: l_location := '0050';
2535: --
2536: SELECT ECE_XREF_DATA_S1.nextval
2537: INTO l_xref_data_id
2538: FROM DUAL;
2539: --
2540: --

Line 2543: vea_tpa_util_pvt.insert_ece_xref_data

2539: --
2540: --
2541: l_location := '0060';
2542: --
2543: vea_tpa_util_pvt.insert_ece_xref_data
2544: (
2545: p_data_id => l_xref_data_id,
2546: p_category_id => p_category_id,
2547: p_category_code => p_category_code,

Line 2558: p_error_name => 'VEA_LM_NEW_ECE_XREF_DATA',

2554: l_location := '0070';
2555: --
2556: vea_tpa_util_pvt.add_message
2557: (
2558: p_error_name => 'VEA_LM_NEW_ECE_XREF_DATA',
2559: p_token1 => 'ECE_XREF_CATEGORY_CODE',
2560: p_value1 => p_category_code,
2561: p_token2 => 'EXT_VALUE',
2562: p_value2 => p_ext_value,

Line 2582: END process_ece_xref_data;

2578: p_location => l_location
2579: );
2580: --}
2581: --}
2582: END process_ece_xref_data;
2583: --
2584: --
2585: /*========================================================================
2586:

Line 2807: vea_tpa_util_pvt.process_ece_xref_data

2803: --
2804: --
2805: l_location := '0050';
2806: --
2807: vea_tpa_util_pvt.process_ece_xref_data
2808: (
2809: p_category_id => l_xref_category_id,
2810: p_category_code => l_ece_xref_category_code,
2811: p_key1 => p_layer_provider_code,

Line 2847: p_external_value IN ece_xref_data.xref_ext_value1%TYPE,

2843: FUNCTION convertBranchCriteria
2844: (
2845: p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE,
2846: p_parameter_name IN vea_parameters.name%TYPE,
2847: p_external_value IN ece_xref_data.xref_ext_value1%TYPE,
2848: x_code_conversion_tbl IN OUT NOCOPY vea_tpa_util_pvt.g_code_conversion_tbl_type
2849: )
2850: RETURN ece_xref_data.xref_int_value%TYPE
2851: IS

Line 2850: RETURN ece_xref_data.xref_int_value%TYPE

2846: p_parameter_name IN vea_parameters.name%TYPE,
2847: p_external_value IN ece_xref_data.xref_ext_value1%TYPE,
2848: x_code_conversion_tbl IN OUT NOCOPY vea_tpa_util_pvt.g_code_conversion_tbl_type
2849: )
2850: RETURN ece_xref_data.xref_int_value%TYPE
2851: IS
2852: --{
2853: l_index NUMBER;
2854: --

Line 2859: l_internal_value ece_xref_data.xref_int_value%TYPE;

2855: --
2856: l_parameter_name vea_parameters.name%TYPE;
2857: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;
2858: l_code_conversion_rec vea_tpa_util_pvt.g_code_conversion_rec_type;
2859: l_internal_value ece_xref_data.xref_int_value%TYPE;
2860: --
2861: --
2862: l_return_status VARCHAR2(32767);
2863: l_msg_count NUMBER;

Line 3008: p_external_value IN ece_xref_data.xref_ext_value1%TYPE

3004: FUNCTION Convert_from_ext_to_int
3005: (
3006: p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE,
3007: p_parameter_name IN vea_parameters.name%TYPE,
3008: p_external_value IN ece_xref_data.xref_ext_value1%TYPE
3009: )
3010: RETURN ece_xref_data.xref_int_value%TYPE
3011: IS
3012: --{

Line 3010: RETURN ece_xref_data.xref_int_value%TYPE

3006: p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE,
3007: p_parameter_name IN vea_parameters.name%TYPE,
3008: p_external_value IN ece_xref_data.xref_ext_value1%TYPE
3009: )
3010: RETURN ece_xref_data.xref_int_value%TYPE
3011: IS
3012: --{
3013: l_parameter_name vea_parameters.name%TYPE;
3014: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;

Line 3015: l_external_value ece_xref_data.xref_ext_value1%TYPE;

3011: IS
3012: --{
3013: l_parameter_name vea_parameters.name%TYPE;
3014: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;
3015: l_external_value ece_xref_data.xref_ext_value1%TYPE;
3016: l_external_value2 ece_xref_data.xref_ext_value2%TYPE;
3017: l_external_value3 ece_xref_data.xref_ext_value3%TYPE;
3018: l_external_value4 ece_xref_data.xref_ext_value4%TYPE;
3019: l_external_value5 ece_xref_data.xref_ext_value5%TYPE;

Line 3016: l_external_value2 ece_xref_data.xref_ext_value2%TYPE;

3012: --{
3013: l_parameter_name vea_parameters.name%TYPE;
3014: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;
3015: l_external_value ece_xref_data.xref_ext_value1%TYPE;
3016: l_external_value2 ece_xref_data.xref_ext_value2%TYPE;
3017: l_external_value3 ece_xref_data.xref_ext_value3%TYPE;
3018: l_external_value4 ece_xref_data.xref_ext_value4%TYPE;
3019: l_external_value5 ece_xref_data.xref_ext_value5%TYPE;
3020: l_internal_value ece_xref_data.xref_int_value%TYPE;

Line 3017: l_external_value3 ece_xref_data.xref_ext_value3%TYPE;

3013: l_parameter_name vea_parameters.name%TYPE;
3014: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;
3015: l_external_value ece_xref_data.xref_ext_value1%TYPE;
3016: l_external_value2 ece_xref_data.xref_ext_value2%TYPE;
3017: l_external_value3 ece_xref_data.xref_ext_value3%TYPE;
3018: l_external_value4 ece_xref_data.xref_ext_value4%TYPE;
3019: l_external_value5 ece_xref_data.xref_ext_value5%TYPE;
3020: l_internal_value ece_xref_data.xref_int_value%TYPE;
3021: --

Line 3018: l_external_value4 ece_xref_data.xref_ext_value4%TYPE;

3014: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;
3015: l_external_value ece_xref_data.xref_ext_value1%TYPE;
3016: l_external_value2 ece_xref_data.xref_ext_value2%TYPE;
3017: l_external_value3 ece_xref_data.xref_ext_value3%TYPE;
3018: l_external_value4 ece_xref_data.xref_ext_value4%TYPE;
3019: l_external_value5 ece_xref_data.xref_ext_value5%TYPE;
3020: l_internal_value ece_xref_data.xref_int_value%TYPE;
3021: --
3022: --

Line 3019: l_external_value5 ece_xref_data.xref_ext_value5%TYPE;

3015: l_external_value ece_xref_data.xref_ext_value1%TYPE;
3016: l_external_value2 ece_xref_data.xref_ext_value2%TYPE;
3017: l_external_value3 ece_xref_data.xref_ext_value3%TYPE;
3018: l_external_value4 ece_xref_data.xref_ext_value4%TYPE;
3019: l_external_value5 ece_xref_data.xref_ext_value5%TYPE;
3020: l_internal_value ece_xref_data.xref_int_value%TYPE;
3021: --
3022: --
3023: l_return_status VARCHAR2(32767);

Line 3020: l_internal_value ece_xref_data.xref_int_value%TYPE;

3016: l_external_value2 ece_xref_data.xref_ext_value2%TYPE;
3017: l_external_value3 ece_xref_data.xref_ext_value3%TYPE;
3018: l_external_value4 ece_xref_data.xref_ext_value4%TYPE;
3019: l_external_value5 ece_xref_data.xref_ext_value5%TYPE;
3020: l_internal_value ece_xref_data.xref_int_value%TYPE;
3021: --
3022: --
3023: l_return_status VARCHAR2(32767);
3024: l_msg_count NUMBER;

Line 3135: p_internal_value IN ece_xref_data.xref_int_value%TYPE

3131: FUNCTION Convert_from_int_to_ext
3132: (
3133: p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE,
3134: p_parameter_name IN vea_parameters.name%TYPE,
3135: p_internal_value IN ece_xref_data.xref_int_value%TYPE
3136: )
3137: RETURN ece_xref_data.xref_ext_value1%TYPE
3138: IS
3139: --{

Line 3137: RETURN ece_xref_data.xref_ext_value1%TYPE

3133: p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE,
3134: p_parameter_name IN vea_parameters.name%TYPE,
3135: p_internal_value IN ece_xref_data.xref_int_value%TYPE
3136: )
3137: RETURN ece_xref_data.xref_ext_value1%TYPE
3138: IS
3139: --{
3140: l_parameter_name vea_parameters.name%TYPE;
3141: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;

Line 3142: l_external_value ece_xref_data.xref_ext_value1%TYPE;

3138: IS
3139: --{
3140: l_parameter_name vea_parameters.name%TYPE;
3141: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;
3142: l_external_value ece_xref_data.xref_ext_value1%TYPE;
3143: l_external_value2 ece_xref_data.xref_ext_value2%TYPE;
3144: l_external_value3 ece_xref_data.xref_ext_value3%TYPE;
3145: l_external_value4 ece_xref_data.xref_ext_value4%TYPE;
3146: l_external_value5 ece_xref_data.xref_ext_value5%TYPE;

Line 3143: l_external_value2 ece_xref_data.xref_ext_value2%TYPE;

3139: --{
3140: l_parameter_name vea_parameters.name%TYPE;
3141: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;
3142: l_external_value ece_xref_data.xref_ext_value1%TYPE;
3143: l_external_value2 ece_xref_data.xref_ext_value2%TYPE;
3144: l_external_value3 ece_xref_data.xref_ext_value3%TYPE;
3145: l_external_value4 ece_xref_data.xref_ext_value4%TYPE;
3146: l_external_value5 ece_xref_data.xref_ext_value5%TYPE;
3147: --

Line 3144: l_external_value3 ece_xref_data.xref_ext_value3%TYPE;

3140: l_parameter_name vea_parameters.name%TYPE;
3141: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;
3142: l_external_value ece_xref_data.xref_ext_value1%TYPE;
3143: l_external_value2 ece_xref_data.xref_ext_value2%TYPE;
3144: l_external_value3 ece_xref_data.xref_ext_value3%TYPE;
3145: l_external_value4 ece_xref_data.xref_ext_value4%TYPE;
3146: l_external_value5 ece_xref_data.xref_ext_value5%TYPE;
3147: --
3148: --

Line 3145: l_external_value4 ece_xref_data.xref_ext_value4%TYPE;

3141: l_ece_xref_category_code ece_xref_categories.xref_category_code%TYPE;
3142: l_external_value ece_xref_data.xref_ext_value1%TYPE;
3143: l_external_value2 ece_xref_data.xref_ext_value2%TYPE;
3144: l_external_value3 ece_xref_data.xref_ext_value3%TYPE;
3145: l_external_value4 ece_xref_data.xref_ext_value4%TYPE;
3146: l_external_value5 ece_xref_data.xref_ext_value5%TYPE;
3147: --
3148: --
3149: l_return_status VARCHAR2(32767);

Line 3146: l_external_value5 ece_xref_data.xref_ext_value5%TYPE;

3142: l_external_value ece_xref_data.xref_ext_value1%TYPE;
3143: l_external_value2 ece_xref_data.xref_ext_value2%TYPE;
3144: l_external_value3 ece_xref_data.xref_ext_value3%TYPE;
3145: l_external_value4 ece_xref_data.xref_ext_value4%TYPE;
3146: l_external_value5 ece_xref_data.xref_ext_value5%TYPE;
3147: --
3148: --
3149: l_return_status VARCHAR2(32767);
3150: l_msg_count NUMBER;