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: )
1435: IS
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: )
1622: IS
1783: --
1784: l_location :='0150';
1785: --
1786: --
1787: vea_packages_sv.deleteUnreferencedPackages;
1788: --
1789: l_location :='0155';
1790: --
1791: l_tp_layer_id :=
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
1969: AND LH.program_unit_id = PU.program_unit_id