APPS.GMD_QM_CONC_REPLACE_PKG dependencies on GMD_ALL_SPEC_VRS_VL

Line 354: l_end_date gmd_all_spec_vrs_vl.end_date%TYPE;

350: l_new_owner gmd_specifications_b.owner_id%TYPE;
351: l_new_owner_id gmd_specifications_b.owner_id%TYPE;
352: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
353: l_new_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
354: l_end_date gmd_all_spec_vrs_vl.end_date%TYPE;
355: l_start_date gmd_all_spec_vrs_vl.start_date%TYPE;
356: l_test_values_rec gmd_qm_conc_replace_pkg.test_values;
357: l_rep_test_values_rec gmd_qm_conc_replace_pkg.test_values;
358: l_obj_id NUMBER;

Line 355: l_start_date gmd_all_spec_vrs_vl.start_date%TYPE;

351: l_new_owner_id gmd_specifications_b.owner_id%TYPE;
352: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
353: l_new_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
354: l_end_date gmd_all_spec_vrs_vl.end_date%TYPE;
355: l_start_date gmd_all_spec_vrs_vl.start_date%TYPE;
356: l_test_values_rec gmd_qm_conc_replace_pkg.test_values;
357: l_rep_test_values_rec gmd_qm_conc_replace_pkg.test_values;
358: l_obj_id NUMBER;
359: l_exist NUMBER;

Line 2200: FROM gmd_all_spec_vrs_vl

2196: WHERE organization_id = p_orgn_id;
2197:
2198: CURSOR get_vrs_rec (p_spec_id IN NUMBER) IS
2199: SELECT spec_vr_status
2200: FROM gmd_all_spec_vrs_vl
2201: WHERE spec_id = p_spec_id;
2202: BEGIN
2203: x_return_status := fnd_api.g_ret_sts_success;
2204:

Line 2750: FROM gmd_all_spec_vrs_vl

2746: CURSOR get_vrs_rec (p_spec_id IN NUMBER, p_spec_name IN VARCHAR2, p_orgn_id IN NUMBER) IS
2747: SELECT spec_vr_id
2748: , spec_type
2749: , spec_vr_status
2750: FROM gmd_all_spec_vrs_vl
2751: WHERE spec_id = p_spec_id
2752: AND spec_name = p_spec_name
2753: AND owner_organization_id = p_orgn_id;
2754: BEGIN

Line 2862: FROM gmd_all_spec_vrs_vl

2858: l_vr_id := p_spec_vr_id;
2859:
2860: SELECT spec_type
2861: INTO l_spec_type
2862: FROM gmd_all_spec_vrs_vl
2863: WHERE spec_vr_id = l_vr_id;
2864:
2865: update_validity_rule (p_vr_id => l_vr_id
2866: , p_spec_type => l_spec_type

Line 3136: FROM gmd_all_spec_vrs_vl

3132: l_return BOOLEAN;
3133:
3134: CURSOR get_spec_status (p_vr_id IN NUMBER) IS
3135: SELECT spec_status
3136: FROM gmd_all_spec_vrs_vl
3137: WHERE spec_vr_id = p_vr_id;
3138: BEGIN
3139: x_return_status := fnd_api.g_ret_sts_success;
3140: l_spec_type := p_spec_type;