DBA Data[Home] [Help]

APPS.CZ_RUNTIME dependencies on CZ_CONFIG_HDRS

Line 599: l_config_status cz_config_hdrs.config_status%TYPE;

595: ,x_valid_flag OUT NOCOPY VARCHAR2
596: ,x_return_status OUT NOCOPY VARCHAR2
597: ,x_msg_data OUT NOCOPY VARCHAR2)
598: IS
599: l_config_status cz_config_hdrs.config_status%TYPE;
600: l_node_identifier cz_config_items.node_identifier%TYPE;
601: l_config_item_id cz_config_items.config_item_id%TYPE := NULL;
602: l_column_name VARCHAR2(80);
603: l_dummy NUMBER;

Line 611: FROM cz_config_hdrs hdr, cz_model_usages usg

607:
608: BEGIN
609: SELECT component_id, config_status, config_date_created, effective_date, usg.name
610: INTO x_component_id, l_config_status, x_config_date_created, x_effective_date, x_usage_name
611: FROM cz_config_hdrs hdr, cz_model_usages usg
612: WHERE config_hdr_id = p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr
613: AND deleted_flag = '0'
614: AND hdr.effective_usage_id = usg.model_usage_id;
615: