1426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1427: x_return_status OUT NOCOPY VARCHAR2,
1428: x_msg_count OUT NOCOPY NUMBER,
1429: x_msg_data OUT NOCOPY VARCHAR2,
1430: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1431: p_application_short_name IN vea_packages.application_short_name%TYPE,
1432: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
1433: p_tp_layer_name IN vea_tp_layers.name%TYPE
1434: )
1494: --
1495: --
1496: l_location := '0040';
1497: --
1498: vea_layers_sv.populateLayerActiveTable
1499: (
1500: p_layer_provider_code => p_layer_provider_code
1501: );
1502: --
1613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1614: x_return_status OUT NOCOPY VARCHAR2,
1615: x_msg_count OUT NOCOPY NUMBER,
1616: x_msg_data OUT NOCOPY VARCHAR2,
1617: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
1618: p_application_short_name IN vea_packages.application_short_name%TYPE,
1619: p_tp_layer_id IN vea_tp_layers.tp_layer_id%TYPE,
1620: p_tp_layer_name IN vea_tp_layers.name%TYPE
1621: )
1802: --IF (( get_curr_layer_provider_code = 'CUST') AND (get_curr_customer_name != 'CUST')) THEN (This will not process layers belonging to a customer named "CUST")
1803: IF ( get_curr_layer_provider_code = 'CUST') THEN
1804: --
1805: --
1806: --vea_layers_sv.processConflictingLayers;
1807: vea_layers_sv.processConflictingLayers
1808: (
1809: p_tp_layer_id => l_tp_layer_id, --p_tp_layer_id,
1810: p_layer_provider_code => p_layer_provider_code
1803: IF ( get_curr_layer_provider_code = 'CUST') THEN
1804: --
1805: --
1806: --vea_layers_sv.processConflictingLayers;
1807: vea_layers_sv.processConflictingLayers
1808: (
1809: p_tp_layer_id => l_tp_layer_id, --p_tp_layer_id,
1810: p_layer_provider_code => p_layer_provider_code
1811: );
1957: IS
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,
2169: ========================================================================*/
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
2663: ========================================================================*/
2664: FUNCTION
2665: get_ece_xref_category_code
2666: (
2667: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2668: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2669: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE
2670: )
2671: RETURN VARCHAR2
2664: FUNCTION
2665: get_ece_xref_category_code
2666: (
2667: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2668: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2669: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE
2670: )
2671: RETURN VARCHAR2
2672: IS
2665: get_ece_xref_category_code
2666: (
2667: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2668: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2669: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE
2670: )
2671: RETURN VARCHAR2
2672: IS
2673: --{
2676: --
2677: --
2678: CURSOR parameter_cur
2679: (
2680: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2681: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2682: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE
2683: )
2684: IS
2677: --
2678: CURSOR parameter_cur
2679: (
2680: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2681: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2682: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE
2683: )
2684: IS
2685: SELECT PA.name
2678: CURSOR parameter_cur
2679: (
2680: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2681: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2682: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE
2683: )
2684: IS
2685: SELECT PA.name
2686: FROM vea_parameters PA,
2750: ========================================================================*/
2751: PROCEDURE
2752: process_code_conversion
2753: (
2754: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2755: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2756: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE,
2757: p_tps_parameter_value IN vea_layers.tps_parameter1_value%TYPE
2758: )
2751: PROCEDURE
2752: process_code_conversion
2753: (
2754: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2755: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2756: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE,
2757: p_tps_parameter_value IN vea_layers.tps_parameter1_value%TYPE
2758: )
2759: IS
2752: process_code_conversion
2753: (
2754: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2755: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2756: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE,
2757: p_tps_parameter_value IN vea_layers.tps_parameter1_value%TYPE
2758: )
2759: IS
2760: --{
2753: (
2754: p_layer_provider_code IN vea_layers.layer_provider_code%TYPE,
2755: p_layer_header_id IN vea_layers.layer_header_id%TYPE,
2756: p_tps_parameter_id IN vea_layers.tps_parameter1_id%TYPE,
2757: p_tps_parameter_value IN vea_layers.tps_parameter1_value%TYPE
2758: )
2759: IS
2760: --{
2761: l_api_name CONSTANT VARCHAR2(30) := 'process_code_conversion';