APPS.PA_CI_TYPES_PVT dependencies on PA_CONTROL_ITEMS

Line 354: from pa_control_items ci,

350: -- if the current change request approval type code is EXTERNAL_APPROVAL and control item's pco status
351: -- has been recorded, then user is not allowed to change the approval type.
352: cursor c_pco_st_exists is
353: select 1
354: from pa_control_items ci,
355: pa_ci_types_b cip
356: where ci.ci_type_id = cip.ci_type_id
357: and cip.ci_type_class_code = 'CHANGE_REQUEST'
358: and cip.ci_type_id = p_ci_type_id

Line 381: from pa_control_items pci,

377:
378: -- check if impacts exists for control item type
379: CURSOR validate_impacts_csr (p_ci_type_id pa_ci_types_b.CI_TYPE_ID%type) is
380: select 1
381: from pa_control_items pci,
382: pa_ci_impacts pc
383: where pci.ci_type_id = p_ci_type_id
384: and pci.ci_id = pc.ci_id;
385:

Line 406: from pa_control_items pci,

402: CURSOR val_impacts_csr (p_ci_type_id pa_ci_types_b.CI_TYPE_ID%type,
403: p_impact_type_code varchar2) is
404: select pc.impact_type_code,
405: luk.meaning impact_type_name
406: from pa_control_items pci,
407: pa_ci_impacts pc,
408: pa_lookups luk
409: where pci.ci_type_id = p_ci_type_id
410: and pci.ci_id = pc.ci_id

Line 421: from pa_control_items pci,

417: CURSOR val_Dir_impacts_csr (p_ci_type_id pa_ci_types_b.CI_TYPE_ID%type,
418: p_impact_type_code varchar2) is
419: select pc.impact_type_code,
420: luk.meaning impact_type_name
421: from pa_control_items pci,
422: pa_ci_impacts pc,
423: pa_lookups luk,
424: pa_budget_versions pbv,
425: pa_resource_assignments pra

Line 446: from pa_control_items pci,

442: CURSOR val_Supp_impacts_csr (p_ci_type_id pa_ci_types_b.CI_TYPE_ID%type,
443: p_impact_type_code varchar2) is
444: select pc.impact_type_code,
445: luk.meaning impact_type_name
446: from pa_control_items pci,
447: pa_ci_impacts pc,
448: pa_lookups luk,
449: pa_budget_versions pbv,
450: pa_resource_assignments pra

Line 472: pa_control_items pci,

468: -- Check if direct/supplier cost regions have been created in budgets?
469: CURSOR new_fin_impacts_csr (p_ci_type_id pa_ci_types_b.CI_TYPE_ID%type) is
470: select 1
471: from pa_ci_types_v pct,
472: pa_control_items pci,
473: pa_budget_versions pbv
474: where pct.ci_type_id = pci.ci_type_id
475: and pci.ci_id = pbv.ci_id
476: and pct.ci_type_id = p_ci_type_id;

Line 815: FROM PA_CONTROL_ITEMS

811: IF x_return_status = 'S' AND
812: l_classification_category <> p_classification_category THEN
813: BEGIN
814: SELECT 'X' INTO l_temp
815: FROM PA_CONTROL_ITEMS
816: WHERE ci_type_id = p_ci_type_id
817: AND classification_code_id IS NOT NULL
818: AND ROWNUM < 2;
819:

Line 833: FROM PA_CONTROL_ITEMS

829: IF x_return_status = 'S' AND
830: l_reason_category <> p_reason_category THEN
831: BEGIN
832: SELECT 'X' INTO l_temp
833: FROM PA_CONTROL_ITEMS
834: WHERE ci_type_id = p_ci_type_id
835: AND reason_code_id IS NOT NULL
836: AND ROWNUM < 2;
837:

Line 851: FROM PA_CONTROL_ITEMS

847: IF x_return_status = 'S' AND
848: l_resolution_category <> p_resolution_category THEN
849: BEGIN
850: SELECT 'X' INTO l_temp
851: FROM PA_CONTROL_ITEMS
852: WHERE ci_type_id = p_ci_type_id
853: AND resolution_code_id IS NOT NULL
854: AND ROWNUM < 2;
855:

Line 879: pa_control_items ci

875: BEGIN
876: SELECT 'X'
877: INTO l_temp
878: FROM pa_ci_types_b cit,
879: pa_control_items ci
880: WHERE cit.ci_type_id = p_ci_type_id
881: AND cit.auto_number_flag <> 'Y'
882: AND ci.ci_type_id = p_ci_type_id
883: AND ROWNUM=1;

Line 1076: FROM pa_control_items

1072:
1073: -- Cannot delete CI Type if CI exists
1074: BEGIN
1075: SELECT 'X' INTO l_temp
1076: FROM pa_control_items
1077: WHERE ci_type_id = p_ci_type_id
1078: AND ROWNUM=1;
1079:
1080: x_return_status := 'E';