APPS.PA_CONTROL_ITEMS_PVT dependencies on PA_CI_TYPES_B

Line 81: From PA_CI_TYPES_B

77:
78: cursor c_item_type is
79: Select ci_type_class_code, auto_number_flag,
80: start_date_active,end_date_active
81: From PA_CI_TYPES_B
82: Where ci_type_id = p_ci_type_id;
83:
84: cp_type c_item_type%ROWTYPE;
85: l_type_class_code PA_CI_TYPES_B.CI_TYPE_CLASS_CODE%TYPE;

Line 85: l_type_class_code PA_CI_TYPES_B.CI_TYPE_CLASS_CODE%TYPE;

81: From PA_CI_TYPES_B
82: Where ci_type_id = p_ci_type_id;
83:
84: cp_type c_item_type%ROWTYPE;
85: l_type_class_code PA_CI_TYPES_B.CI_TYPE_CLASS_CODE%TYPE;
86: l_system_status_code pa_project_statuses.project_system_status_code%TYPE;
87: DRAFT_STATUS pa_project_statuses.project_system_status_code%TYPE := 'CI_DRAFT';
88:
89: API_ERROR EXCEPTION;

Line 449: From PA_CI_TYPES_B type

445: l_prev_owner_id pa_control_items.owner_id%TYPE;
446:
447: cursor c_auto_num is
448: Select type.auto_number_flag
449: From PA_CI_TYPES_B type
450: ,pa_control_items ci
451: Where ci.ci_id = p_ci_id
452: AND ci.ci_type_id = type.ci_type_id;
453:

Line 937: FROM pa_ci_types_b pctb, pa_class_codes pcc

933: /* mwxx
934: CURSOR c_from_classification
935: is
936: SELECT 'Y'
937: FROM pa_ci_types_b pctb, pa_class_codes pcc
938: WHERE pctb.ci_type_id = p_ci_type_id
939: AND pctb.classification_category = pcc.class_category
940: AND pcc.class_code = p_class_code;
941: */

Line 947: FROM pa_class_codes pcc,pa_ci_types_b pctb

943:
944: CURSOR c_from_classification
945: is
946: SELECT class_code_id
947: FROM pa_class_codes pcc,pa_ci_types_b pctb
948: WHERE pctb.ci_type_id = p_ci_type_id
949: AND pctb.classification_category = pcc.class_category
950: AND pcc.class_code in (select pcc1.class_code
951: from pa_class_codes pcc1

Line 957: FROM pa_class_codes pcc,pa_ci_types_b pctb

953:
954: CURSOR c_from_reason
955: is
956: SELECT class_code_id
957: FROM pa_class_codes pcc,pa_ci_types_b pctb
958: WHERE pctb.ci_type_id = p_ci_type_id
959: AND pctb.reason_category = pcc.class_category
960: AND pcc.class_code in (select pcc1.class_code
961: from pa_class_codes pcc1

Line 968: FROM pa_ci_types_b pctb, pa_class_codes pcc

964:
965: CURSOR c_from_reason
966: is
967: SELECT 'Y'
968: FROM pa_ci_types_b pctb, pa_class_codes pcc
969: WHERE pctb.ci_type_id = p_ci_type_id
970: AND pctb.reason_category = pcc.class_category
971: AND pcc.class_code = p_reason;
972: */

Line 1231: FROM pa_control_items pci, pa_ci_types_b pctb, pa_project_statuses pps

1227:
1228: CURSOR check_params is
1229: SELECT pci.ci_type_id, pctb.ci_type_class_code,
1230: pci.project_id, pps.project_system_status_code
1231: FROM pa_control_items pci, pa_ci_types_b pctb, pa_project_statuses pps
1232: WHERE pci.ci_id = l_ci_id
1233: and pci.ci_type_id = pctb.ci_type_id
1234: and pci.status_code = pps.project_status_code(+);
1235:

Line 1579: l_type_id PA_CI_TYPES_B.ci_type_id%TYPE;

1575: l_ci_number_num NUMBER(15) := NULL;
1576: -- l_ci_number_char VARCHAR2(30) := NULL;
1577: l_ci_number_char PA_CONTROL_ITEMS.ci_number%type := NULL;
1578: l_auto_numbers VARCHAR2(1) := 'N';
1579: l_type_id PA_CI_TYPES_B.ci_type_id%TYPE;
1580: l_type_class PA_CI_TYPES_B.ci_type_class_code%TYPE;
1581: l_project_id PA_CONTROL_ITEMS.project_Id%TYPE;
1582: l_ci_id NUMBER;
1583:

Line 1580: l_type_class PA_CI_TYPES_B.ci_type_class_code%TYPE;

1576: -- l_ci_number_char VARCHAR2(30) := NULL;
1577: l_ci_number_char PA_CONTROL_ITEMS.ci_number%type := NULL;
1578: l_auto_numbers VARCHAR2(1) := 'N';
1579: l_type_id PA_CI_TYPES_B.ci_type_id%TYPE;
1580: l_type_class PA_CI_TYPES_B.ci_type_class_code%TYPE;
1581: l_project_id PA_CONTROL_ITEMS.project_Id%TYPE;
1582: l_ci_id NUMBER;
1583:
1584:

Line 1587: From PA_CI_TYPES_B type

1583:
1584:
1585: cursor c_auto_num is
1586: Select type.auto_number_flag, type.ci_type_id,type.ci_type_class_code
1587: From PA_CI_TYPES_B type
1588: ,pa_control_items ci
1589: Where ci.ci_id = p_ci_id
1590: AND ci.ci_type_id = type.ci_type_id;
1591: