DBA Data[Home] [Help]

APPS.VEA_TPA_UTIL_PVT dependencies on VEA_PROGRAM_UNITS

Line 1696: VEA_PROGRAM_UNITS_SV.deleteUnreferencedProgramUnits

1692: --
1693: --
1694: l_location := '0060';
1695: --
1696: VEA_PROGRAM_UNITS_SV.deleteUnreferencedProgramUnits
1697: (
1698: p_layer_provider_code => p_layer_provider_code,
1699: p_program_unit_id => l_program_unit_id,
1700: p_tpa_program_unit_id => l_tpa_program_unit_id

Line 1706: UPDATE vea_program_units

1702: --
1703: --
1704: l_location := '0070';
1705: --
1706: UPDATE vea_program_units
1707: SET tpa_program_unit_id = l_tpa_program_unit_id
1708: WHERE layer_provider_code = p_layer_provider_code
1709: AND program_unit_id = l_program_unit_id;
1710: --

Line 1744: VEA_PROGRAM_UNITS_SV.deleteUnreferencedProgramUnits

1740: --
1741: --
1742: l_location := '0110';
1743: --
1744: VEA_PROGRAM_UNITS_SV.deleteUnreferencedProgramUnits
1745: (
1746: p_layer_provider_code => p_layer_provider_code,
1747: p_program_unit_id => l_program_unit_id,
1748: p_tpa_program_unit_id => l_tpa_program_unit_id

Line 1754: UPDATE vea_program_units

1750: --
1751: --
1752: l_location := '0120';
1753: --
1754: UPDATE vea_program_units
1755: SET tpa_program_unit_id = l_tpa_program_unit_id
1756: WHERE layer_provider_code = p_layer_provider_code
1757: AND program_unit_id = l_program_unit_id;
1758: --

Line 1943: p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE,

1939: ========================================================================*/
1940: PROCEDURE
1941: populateLayerActiveTable
1942: (
1943: p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE,
1944: p_program_unit_id IN vea_program_units.program_unit_id%TYPE,
1945: x_layer_table IN OUT NOCOPY g_layer_tbl_type
1946: )
1947: IS

Line 1944: p_program_unit_id IN vea_program_units.program_unit_id%TYPE,

1940: PROCEDURE
1941: populateLayerActiveTable
1942: (
1943: p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE,
1944: p_program_unit_id IN vea_program_units.program_unit_id%TYPE,
1945: x_layer_table IN OUT NOCOPY g_layer_tbl_type
1946: )
1947: IS
1948: --{

Line 1962: vea_program_units PU,

1958: SELECT LA.layer_provider_code,
1959: LA.layer_id,
1960: DECODE(TLA.ACTIVE_FLAG, 'N', 'N', LA.ACTIVE_FLAG) IS_LAYER_ACTIVE
1961: FROM vea_layers LA,
1962: vea_program_units PU,
1963: vea_layer_headers LH,
1964: vea_program_units APU,
1965: vea_packages PK,
1966: vea_tp_layers TLA

Line 1964: vea_program_units APU,

1960: DECODE(TLA.ACTIVE_FLAG, 'N', 'N', LA.ACTIVE_FLAG) IS_LAYER_ACTIVE
1961: FROM vea_layers LA,
1962: vea_program_units PU,
1963: vea_layer_headers LH,
1964: vea_program_units APU,
1965: vea_packages PK,
1966: vea_tp_layers TLA
1967: WHERE PU.program_unit_id = p_program_unit_id
1968: AND PU.layer_provider_code = p_layer_provider_code

Line 2174: p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE

2170: FUNCTION isLayerActive
2171: (
2172: p_layer_table IN g_layer_tbl_type,
2173: p_layer_id IN vea_layers.layer_id%TYPE,
2174: p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE
2175: )
2176: RETURN BOOLEAN
2177: IS
2178: --{

Line 2687: vea_program_units PU,

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
2691: AND LH.layer_header_id = p_layer_header_id

Line 2845: p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE,

2841:
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: )

Line 3006: p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE,

3002:
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

Line 3133: p_layer_provider_code IN vea_program_units.layer_provider_code%TYPE,

3129:
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