APPS.GMD_QM_CONC_REPLACE_PKG dependencies on GMD_QUALITY_CONFIG

Line 603: -- Bug# 5882074 get the version control indicator from gmd_quality_config

599: REPSTATUS , REPOWNER, REPOWNERORG
600: REPTESTVAL, ADDTEST, DELTEST, REPTEST
601: */
602:
603: -- Bug# 5882074 get the version control indicator from gmd_quality_config
604: -- l_spec_vers_ctl := fnd_profile.value('GMD_SPEC_VERSION_CONTROL');
605: l_query_test_name := pnew_name;
606: l_select := 'select spts.* '; --Bug#5973270. Included spts.
607:

Line 636: FROM gmd_quality_config

632: /* should new spec version be created? */
633: -- Bug# 5882074 get the version control flag from quality config instead of profile.
634: SELECT spec_version_control_ind
635: INTO l_state
636: FROM gmd_quality_config
637: WHERE organization_id = (SELECT owner_organization_id
638: FROM gmd_specifications_b
639: WHERE spec_id = get_object_rec.object_id);
640:

Line 2304: FROM gmd_quality_config

2300: -- Bug# 5882074 Changed orgn_code to orgn_id
2301: CURSOR get_default_status (p_orgn_id IN NUMBER) IS
2302: SELECT default_specification_status
2303: , manage_validity_rules_ind
2304: FROM gmd_quality_config
2305: WHERE organization_id = p_orgn_id;
2306:
2307: CURSOR get_vrs_rec (p_spec_id IN NUMBER) IS
2308: SELECT spec_vr_status

Line 2849: FROM gmd_quality_config

2845: -- Bug# 5882074 changed code to id
2846: CURSOR get_manage_validity (p_orgn_id IN NUMBER) IS
2847: SELECT manage_validity_rules_ind
2848: , default_specification_status
2849: FROM gmd_quality_config
2850: WHERE organization_id = p_orgn_id;
2851:
2852: CURSOR get_spec_rec (p_spec_id IN NUMBER) IS
2853: SELECT *