APPS.GMD_SAMPLES_PUB dependencies on GMD_QUALITY_CONFIG

Line 50: * and replaced with call to gmd_quality_config.

46: * 20-MAY-2005 Susan Feinstein Bug 4165704 Inventory Convergence
47: * 18-OCT-2005 Susan Feinstein Bug 4640143 Added material detail id to gmd_wip_spec_vrs table
48: * 05-JAN-2006 Joe DiIorio Bug#4691545 Removed profile reference to
49: * NVL(fnd_profile.value('QC$EXACTSPECMATCH'),'N');
50: * and replaced with call to gmd_quality_config.
51: * Added FUNCTION GET_CONF_MATCH_VALUE as
52: * profile needs to be retrieved for each org that
53: * is passed.
54: * 18-Jan-2006 Saikiran Fixed bug# 4916871

Line 188: quality_config GMD_QUALITY_CONFIG%ROWTYPE;

184: l_spec_type GMD_SPECIFICATIONS.SPEC_TYPE%TYPE;
185: l_sampling_event_exist VARCHAR2(1);
186:
187: -- Bug 4165704: needed to fetch values from quality config table
188: quality_config GMD_QUALITY_CONFIG%ROWTYPE;
189: found BOOLEAN;
190: l_batch_status NUMBER; -- Bug # 4619570
191: l_sample_inv_trans_ind VARCHAR2(1); -- Bug # 4619570
192: L_LOT_OPTIONAL_ON_SAMPLE VARCHAR2(1) := 'N'; -- 5283854

Line 985: FROM gmd_quality_config

981: IS
982:
983: CURSOR get_match_ind IS
984: SELECT exact_spec_match_ind
985: FROM gmd_quality_config
986: WHERE organization_id = p_org_id;
987:
988: l_exact_spec_match_ind gmd_quality_config.exact_spec_match_ind%TYPE;
989:

Line 988: l_exact_spec_match_ind gmd_quality_config.exact_spec_match_ind%TYPE;

984: SELECT exact_spec_match_ind
985: FROM gmd_quality_config
986: WHERE organization_id = p_org_id;
987:
988: l_exact_spec_match_ind gmd_quality_config.exact_spec_match_ind%TYPE;
989:
990: BEGIN
991: OPEN get_match_ind;
992: FETCH get_match_ind INTO l_exact_spec_match_ind;

Line 1041: BUG#4691545 - get gmd_quality_config match value.

1037: -- l_inv_spec.date_effective := NVL(p_samples_rec.creation_date,SYSDATE);
1038: l_inv_spec.date_effective := NVL(p_samples_rec.date_drawn,SYSDATE);
1039:
1040: /*====================================================
1041: BUG#4691545 - get gmd_quality_config match value.
1042: ====================================================*/
1043: l_inv_spec.exact_match := get_conf_match_value(p_samples_rec.organization_id);
1044:
1045: -- Find Inventory Spec.

Line 1075: BUG#4691545 - get gmd_quality_config match value.

1071: l_cust_spec.lot_number := p_samples_rec.lot_number;
1072: l_cust_spec.parent_lot_number := p_samples_rec.parent_lot_number;
1073:
1074: /*====================================================
1075: BUG#4691545 - get gmd_quality_config match value.
1076: ====================================================*/
1077: l_cust_spec.exact_match := get_conf_match_value(p_samples_rec.organization_id);
1078: -- Bug3151607
1079: l_cust_spec.date_effective := NVL(p_samples_rec.date_drawn,SYSDATE);

Line 1119: BUG#4691545 - get gmd_quality_config match value.

1115: l_wip_spec.lot_number := p_samples_rec.lot_number;
1116: l_wip_spec.parent_lot_number := p_samples_rec.parent_lot_number;
1117:
1118: /*====================================================
1119: BUG#4691545 - get gmd_quality_config match value.
1120: ====================================================*/
1121: l_wip_spec.exact_match := get_conf_match_value(p_samples_rec.organization_id);
1122:
1123:

Line 1160: BUG#4691545 - get gmd_quality_config match value.

1156: l_supp_spec.lot_number := p_samples_rec.lot_number;
1157: l_supp_spec.parent_lot_number := p_samples_rec.parent_lot_number;
1158:
1159: /*====================================================
1160: BUG#4691545 - get gmd_quality_config match value.
1161: ====================================================*/
1162: l_supp_spec.exact_match := get_conf_match_value(p_samples_rec.organization_id);
1163:
1164: -- Bug #3401377 : added rec_whse and rec_location to form MPL

Line 2622: gmd_quality_config g

2618: -- WHERE orgn_code = p_orgn_code
2619: -- AND delete_mark = 0;
2620: SELECT 1
2621: FROM mtl_parameters m,
2622: gmd_quality_config g
2623: WHERE g.organization_id = m.organization_id
2624: AND m.organization_id = p_organization_id
2625: AND m. process_enabled_flag = 'Y' ;
2626:

Line 2647: gmd_quality_config g

2643: -- AND plant_ind <> 0
2644: -- AND delete_mark = 0;
2645: SELECT 1
2646: FROM mtl_parameters m,
2647: gmd_quality_config g
2648: WHERE g.organization_id = m.organization_id
2649: AND g.quality_lab_ind = 'Y'
2650: AND m.organization_id = p_organization_id
2651: AND m. process_enabled_flag = 'Y' ;