DBA Data[Home] [Help]

APPS.VEA_TPA_UTIL_PVT dependencies on VEA_PARAMETERS

Line 2595: p_tps_parameter_name IN vea_parameters.name%TYPE

2591: ========================================================================*/
2592: FUNCTION
2593: get_ece_xref_category_code
2594: (
2595: p_tps_parameter_name IN vea_parameters.name%TYPE
2596: )
2597: RETURN VARCHAR2
2598: IS
2599: --{

Line 2686: FROM vea_parameters PA,

2682: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE
2683: )
2684: IS
2685: SELECT PA.name
2686: FROM vea_parameters PA,
2687: vea_program_units PU,
2688: vea_layer_headers LH
2689: WHERE PA.parameter_id = p_tps_parameter_id
2690: AND LH.layer_provider_code = p_layer_provider_code

Line 2846: p_parameter_name IN vea_parameters.name%TYPE,

2842: ========================================================================*/
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

Line 2856: l_parameter_name vea_parameters.name%TYPE;

2852: --{
2853: l_index NUMBER;
2854: --
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: --

Line 3007: p_parameter_name IN vea_parameters.name%TYPE,

3003: ========================================================================*/
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

Line 3013: l_parameter_name vea_parameters.name%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;
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;

Line 3134: p_parameter_name IN vea_parameters.name%TYPE,

3130: ========================================================================*/
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

Line 3140: l_parameter_name vea_parameters.name%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;
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;