APPS.CZ_PSFT_INTEGRATION_PVT dependencies on CZ_CONFIG_HDRS

Line 365: l_config_status cz_config_hdrs.config_status%TYPE;

361: l_log_stmt BOOLEAN;
362: l_msg VARCHAR2(2000);
363: l_count INTEGER;
364:
365: l_config_status cz_config_hdrs.config_status%TYPE;
366: l_has_failures cz_config_hdrs.has_failures%TYPE;
367: l_model_id NUMBER;
368: l_creation_date DATE;
369: l_lookup_date DATE;

Line 366: l_has_failures cz_config_hdrs.has_failures%TYPE;

362: l_msg VARCHAR2(2000);
363: l_count INTEGER;
364:
365: l_config_status cz_config_hdrs.config_status%TYPE;
366: l_has_failures cz_config_hdrs.has_failures%TYPE;
367: l_model_id NUMBER;
368: l_creation_date DATE;
369: l_lookup_date DATE;
370: l_effective_date DATE;

Line 1071: FROM cz_config_hdrs

1067:
1068: BEGIN
1069: SELECT component_id, config_status, has_failures
1070: INTO l_model_id, l_config_status, l_has_failures
1071: FROM cz_config_hdrs
1072: WHERE config_hdr_id = p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr
1073: AND deleted_flag = '0' AND component_instance_type = ROOT;
1074: EXCEPTION
1075: WHEN NO_DATA_FOUND THEN

Line 1162: FROM cz_config_hdrs

1158: IF p_baseline_config_hdr_id IS NOT NULL AND p_baseline_config_rev_nbr IS NOT NULL THEN
1159: l_check_delta := TRUE;
1160: BEGIN
1161: SELECT 1 INTO l_count
1162: FROM cz_config_hdrs
1163: WHERE config_hdr_id = p_baseline_config_hdr_id AND config_rev_nbr = p_baseline_config_rev_nbr
1164: AND deleted_flag = '0' AND component_instance_type = ROOT;
1165: EXCEPTION
1166: WHEN NO_DATA_FOUND THEN