APPS.GMD_QUALITY_PARAMETERS_GRP dependencies on GMD_QUALITY_CONFIG

Line 50: x_quality_parameters OUT NOCOPY GMD_QUALITY_CONFIG%ROWTYPE,

46:
47:
48: PROCEDURE get_quality_parameters
49: (p_organization_id IN NUMBER,
50: x_quality_parameters OUT NOCOPY GMD_QUALITY_CONFIG%ROWTYPE,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_orgn_found OUT NOCOPY BOOLEAN
53: )
54: IS

Line 57: SELECT * FROM GMD_QUALITY_CONFIG

53: )
54: IS
55:
56: CURSOR cr_get_process_parameters (p_orgn_id NUMBER) IS
57: SELECT * FROM GMD_QUALITY_CONFIG
58: WHERE organization_id = p_orgn_id;
59:
60: BEGIN
61: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 113: gmd_quality_config

109: CURSOR cr_get_sample_seq IS
110: SELECT
111: sample_last_assigned
112: FROM
113: gmd_quality_config
114: WHERE
115: organization_id = p_organization_id;
116:
117: BEGIN

Line 119: -- Update gmd_quality_config

115: organization_id = p_organization_id;
116:
117: BEGIN
118:
119: -- Update gmd_quality_config
120: UPDATE gmd_quality_config
121: SET
122: sample_last_assigned = sample_last_assigned + 1
123: WHERE

Line 120: UPDATE gmd_quality_config

116:
117: BEGIN
118:
119: -- Update gmd_quality_config
120: UPDATE gmd_quality_config
121: SET
122: sample_last_assigned = sample_last_assigned + 1
123: WHERE
124: organization_id = p_organization_id;

Line 171: gmd_quality_config

167: CURSOR cr_get_ss_seq IS
168: SELECT
169: ss_last_assigned
170: FROM
171: gmd_quality_config
172: WHERE
173: organization_id = p_organization_id;
174:
175: BEGIN

Line 177: -- Update gmd_quality_config

173: organization_id = p_organization_id;
174:
175: BEGIN
176:
177: -- Update gmd_quality_config
178: UPDATE gmd_quality_config
179: SET
180: ss_last_assigned = ss_last_assigned + 1
181: WHERE

Line 178: UPDATE gmd_quality_config

174:
175: BEGIN
176:
177: -- Update gmd_quality_config
178: UPDATE gmd_quality_config
179: SET
180: ss_last_assigned = ss_last_assigned + 1
181: WHERE
182: organization_id = p_organization_id;