APPS.GMD_QM_CONC_REPLACE_PKG dependencies on GMD_QUALITY_CONFIG

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

578: REPSTATUS , REPOWNER, REPOWNERORG
579: REPTESTVAL, ADDTEST, DELTEST, REPTEST
580: */
581:
582: -- Bug# 5882074 get the version control indicator from gmd_quality_config
583: -- l_spec_vers_ctl := fnd_profile.value('GMD_SPEC_VERSION_CONTROL');
584: l_query_test_name := pnew_name;
585: l_select := 'select spts.* '; --Bug#5973270. Included spts.
586:

Line 608: FROM gmd_quality_config

604: /* should new spec version be created? */
605: -- Bug# 5882074 get the version control flag from quality config instead of profile.
606: SELECT spec_version_control_ind
607: INTO l_state
608: FROM gmd_quality_config
609: WHERE organization_id = (SELECT owner_organization_id
610: FROM gmd_specifications_b
611: WHERE spec_id = get_object_rec.object_id);
612:

Line 2195: FROM gmd_quality_config

2191: -- Bug# 5882074 Changed orgn_code to orgn_id
2192: CURSOR get_default_status (p_orgn_id IN NUMBER) IS
2193: SELECT default_specification_status
2194: , manage_validity_rules_ind
2195: FROM gmd_quality_config
2196: WHERE organization_id = p_orgn_id;
2197:
2198: CURSOR get_vrs_rec (p_spec_id IN NUMBER) IS
2199: SELECT spec_vr_status

Line 2737: FROM gmd_quality_config

2733: -- Bug# 5882074 changed code to id
2734: CURSOR get_manage_validity (p_orgn_id IN NUMBER) IS
2735: SELECT manage_validity_rules_ind
2736: , default_specification_status
2737: FROM gmd_quality_config
2738: WHERE organization_id = p_orgn_id;
2739:
2740: CURSOR get_spec_rec (p_spec_id IN NUMBER) IS
2741: SELECT *