171: FUNCTION IS_REGULAR_INSP (
172: p_collection_id IN NUMBER) RETURN VARCHAR2 IS
173:
174: BEGIN
175: if is_sampling_insp(p_collection_id) = fnd_api.g_true or
176: is_skiplot_insp (p_collection_id) = fnd_api.g_true then
177: return fnd_api.g_false;
178: else
179: return fnd_api.g_true;
172: p_collection_id IN NUMBER) RETURN VARCHAR2 IS
173:
174: BEGIN
175: if is_sampling_insp(p_collection_id) = fnd_api.g_true or
176: is_skiplot_insp (p_collection_id) = fnd_api.g_true then
177: return fnd_api.g_false;
178: else
179: return fnd_api.g_true;
180: end if;
173:
174: BEGIN
175: if is_sampling_insp(p_collection_id) = fnd_api.g_true or
176: is_skiplot_insp (p_collection_id) = fnd_api.g_true then
177: return fnd_api.g_false;
178: else
179: return fnd_api.g_true;
180: end if;
181: END IS_REGULAR_INSP;
175: if is_sampling_insp(p_collection_id) = fnd_api.g_true or
176: is_skiplot_insp (p_collection_id) = fnd_api.g_true then
177: return fnd_api.g_false;
178: else
179: return fnd_api.g_true;
180: end if;
181: END IS_REGULAR_INSP;
182:
183: FUNCTION IS_SAMPLING_INSP(
195: fetch sampling_flag into x_sampling_flag;
196: close sampling_flag;
197:
198: if x_sampling_flag = 'Y' then
199: return fnd_api.g_true;
200: else
201: return fnd_api.g_false;
202: end if;
203: END IS_SAMPLING_INSP;
197:
198: if x_sampling_flag = 'Y' then
199: return fnd_api.g_true;
200: else
201: return fnd_api.g_false;
202: end if;
203: END IS_SAMPLING_INSP;
204:
205: FUNCTION IS_SKIPLOT_INSP(
217: fetch skiplot_flag into x_skiplot_flag;
218: close skiplot_flag;
219:
220: if x_skiplot_flag = 'Y' then
221: return fnd_api.g_true;
222: else
223: return fnd_api.g_false;
224: end if;
225: END IS_SKIPLOT_INSP;
219:
220: if x_skiplot_flag = 'Y' then
221: return fnd_api.g_true;
222: else
223: return fnd_api.g_false;
224: end if;
225: END IS_SKIPLOT_INSP;
226:
227: FUNCTION QA_INSTALLATION RETURN VARCHAR2 IS
240: -- Bug 1685697. Status will be 'S' if shared installed.
241: --
242: if l_status in ('I', 'S') then
243:
244: return fnd_api.g_true;
245: else
246: return fnd_api.g_false;
247: end if;
248:
242: if l_status in ('I', 'S') then
243:
244: return fnd_api.g_true;
245: else
246: return fnd_api.g_false;
247: end if;
248:
249: END QA_INSTALLATION;
250:
251: FUNCTION QA_INSPECTION RETURN VARCHAR2 IS
252:
253: BEGIN
254: if FND_PROFILE.VALUE('QA_PO_INSPECTION') = 1 then
255: return fnd_api.g_true;
256: else
257: return fnd_api.g_false;
258: end if;
259: END QA_INSPECTION;
253: BEGIN
254: if FND_PROFILE.VALUE('QA_PO_INSPECTION') = 1 then
255: return fnd_api.g_true;
256: else
257: return fnd_api.g_false;
258: end if;
259: END QA_INSPECTION;
260:
261: END QA_INSPECTION_PKG;