APPS.GMD_QM_CONC_REPLACE_PKG dependencies on GMD_ALL_SPEC_VRS_VL

Line 362: l_end_date gmd_all_spec_vrs_vl.end_date%TYPE;

358: l_new_owner gmd_specifications_b.owner_id%TYPE;
359: l_new_owner_id gmd_specifications_b.owner_id%TYPE;
360: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
361: l_new_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
362: l_end_date gmd_all_spec_vrs_vl.end_date%TYPE;
363: l_start_date gmd_all_spec_vrs_vl.start_date%TYPE;
364: l_test_values_rec gmd_qm_conc_replace_pkg.test_values;
365: l_rep_test_values_rec gmd_qm_conc_replace_pkg.test_values;
366: l_obj_id NUMBER;

Line 363: l_start_date gmd_all_spec_vrs_vl.start_date%TYPE;

359: l_new_owner_id gmd_specifications_b.owner_id%TYPE;
360: l_old_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
361: l_new_ownerorg gmd_specifications_b.owner_organization_id%TYPE; -- Bug# 5882074
362: l_end_date gmd_all_spec_vrs_vl.end_date%TYPE;
363: l_start_date gmd_all_spec_vrs_vl.start_date%TYPE;
364: l_test_values_rec gmd_qm_conc_replace_pkg.test_values;
365: l_rep_test_values_rec gmd_qm_conc_replace_pkg.test_values;
366: l_obj_id NUMBER;
367: l_exist NUMBER;

Line 2309: FROM gmd_all_spec_vrs_vl

2305: WHERE organization_id = p_orgn_id;
2306:
2307: CURSOR get_vrs_rec (p_spec_id IN NUMBER) IS
2308: SELECT spec_vr_status
2309: FROM gmd_all_spec_vrs_vl
2310: WHERE spec_id = p_spec_id;
2311: BEGIN
2312: x_return_status := fnd_api.g_ret_sts_success;
2313:

Line 2862: FROM gmd_all_spec_vrs_vl

2858: CURSOR get_vrs_rec (p_spec_id IN NUMBER, p_spec_name IN VARCHAR2, p_orgn_id IN NUMBER) IS
2859: SELECT spec_vr_id
2860: , spec_type
2861: , spec_vr_status
2862: FROM gmd_all_spec_vrs_vl
2863: WHERE spec_id = p_spec_id
2864: AND spec_name = p_spec_name
2865: AND owner_organization_id = p_orgn_id;
2866: BEGIN

Line 2974: FROM gmd_all_spec_vrs_vl

2970: l_vr_id := p_spec_vr_id;
2971:
2972: SELECT spec_type
2973: INTO l_spec_type
2974: FROM gmd_all_spec_vrs_vl
2975: WHERE spec_vr_id = l_vr_id;
2976:
2977: update_validity_rule (p_vr_id => l_vr_id
2978: , p_spec_type => l_spec_type

Line 3248: FROM gmd_all_spec_vrs_vl

3244: l_return BOOLEAN;
3245:
3246: CURSOR get_spec_status (p_vr_id IN NUMBER) IS
3247: SELECT spec_status
3248: FROM gmd_all_spec_vrs_vl
3249: WHERE spec_vr_id = p_vr_id;
3250: BEGIN
3251: x_return_status := fnd_api.g_ret_sts_success;
3252: l_spec_type := p_spec_type;