APPS.PA_CI_TYPES_PVT dependencies on PA_CONTROL_ITEMS

Line 327: FROM PA_CONTROL_ITEMS

323: IF x_return_status = 'S' AND
324: l_classification_category <> p_classification_category THEN
325: BEGIN
326: SELECT 'X' INTO l_temp
327: FROM PA_CONTROL_ITEMS
328: WHERE ci_type_id = p_ci_type_id
329: AND classification_code_id IS NOT NULL
330: AND ROWNUM < 2;
331:

Line 345: FROM PA_CONTROL_ITEMS

341: IF x_return_status = 'S' AND
342: l_reason_category <> p_reason_category THEN
343: BEGIN
344: SELECT 'X' INTO l_temp
345: FROM PA_CONTROL_ITEMS
346: WHERE ci_type_id = p_ci_type_id
347: AND reason_code_id IS NOT NULL
348: AND ROWNUM < 2;
349:

Line 363: FROM PA_CONTROL_ITEMS

359: IF x_return_status = 'S' AND
360: l_resolution_category <> p_resolution_category THEN
361: BEGIN
362: SELECT 'X' INTO l_temp
363: FROM PA_CONTROL_ITEMS
364: WHERE ci_type_id = p_ci_type_id
365: AND resolution_code_id IS NOT NULL
366: AND ROWNUM < 2;
367:

Line 391: pa_control_items ci

387: BEGIN
388: SELECT 'X'
389: INTO l_temp
390: FROM pa_ci_types_b cit,
391: pa_control_items ci
392: WHERE cit.ci_type_id = p_ci_type_id
393: AND cit.auto_number_flag <> 'Y'
394: AND ci.ci_type_id = p_ci_type_id
395: AND ROWNUM=1;

Line 553: FROM pa_control_items

549:
550: -- Cannot delete CI Type if CI exists
551: BEGIN
552: SELECT 'X' INTO l_temp
553: FROM pa_control_items
554: WHERE ci_type_id = p_ci_type_id
555: AND ROWNUM=1;
556:
557: x_return_status := 'E';