APPS.PA_CONTROL_ITEMS_PVT dependencies on PA_CI_TYPES_B

Line 94: From PA_CI_TYPES_B

90:
91: cursor c_item_type is
92: Select ci_type_class_code, auto_number_flag,
93: start_date_active,end_date_active
94: From PA_CI_TYPES_B
95: Where ci_type_id = p_ci_type_id;
96:
97: cp_type c_item_type%ROWTYPE;
98: l_type_class_code PA_CI_TYPES_B.CI_TYPE_CLASS_CODE%TYPE;

Line 98: l_type_class_code PA_CI_TYPES_B.CI_TYPE_CLASS_CODE%TYPE;

94: From PA_CI_TYPES_B
95: Where ci_type_id = p_ci_type_id;
96:
97: cp_type c_item_type%ROWTYPE;
98: l_type_class_code PA_CI_TYPES_B.CI_TYPE_CLASS_CODE%TYPE;
99: l_system_status_code pa_project_statuses.project_system_status_code%TYPE;
100: DRAFT_STATUS pa_project_statuses.project_system_status_code%TYPE := 'CI_DRAFT';
101:
102: API_ERROR EXCEPTION;

Line 488: From PA_CI_TYPES_B type

484: l_prev_owner_id pa_control_items.owner_id%TYPE;
485:
486: cursor c_auto_num is
487: Select type.auto_number_flag
488: From PA_CI_TYPES_B type
489: ,pa_control_items ci
490: Where ci.ci_id = p_ci_id
491: AND ci.ci_type_id = type.ci_type_id;
492:

Line 1016: FROM pa_ci_types_b pctb, pa_class_codes pcc

1012: /* mwxx
1013: CURSOR c_from_classification
1014: is
1015: SELECT 'Y'
1016: FROM pa_ci_types_b pctb, pa_class_codes pcc
1017: WHERE pctb.ci_type_id = p_ci_type_id
1018: AND pctb.classification_category = pcc.class_category
1019: AND pcc.class_code = p_class_code;
1020: */

Line 1026: FROM pa_class_codes pcc,pa_ci_types_b pctb

1022:
1023: CURSOR c_from_classification
1024: is
1025: SELECT class_code_id
1026: FROM pa_class_codes pcc,pa_ci_types_b pctb
1027: WHERE pctb.ci_type_id = p_ci_type_id
1028: AND pctb.classification_category = pcc.class_category
1029: AND pcc.class_code in (select pcc1.class_code
1030: from pa_class_codes pcc1

Line 1036: FROM pa_class_codes pcc,pa_ci_types_b pctb

1032:
1033: CURSOR c_from_reason
1034: is
1035: SELECT class_code_id
1036: FROM pa_class_codes pcc,pa_ci_types_b pctb
1037: WHERE pctb.ci_type_id = p_ci_type_id
1038: AND pctb.reason_category = pcc.class_category
1039: AND pcc.class_code in (select pcc1.class_code
1040: from pa_class_codes pcc1

Line 1056: FROM pa_ci_types_b pctb, pa_class_codes pcc

1052:
1053: CURSOR c_from_reason
1054: is
1055: SELECT 'Y'
1056: FROM pa_ci_types_b pctb, pa_class_codes pcc
1057: WHERE pctb.ci_type_id = p_ci_type_id
1058: AND pctb.reason_category = pcc.class_category
1059: AND pcc.class_code = p_reason;
1060: */

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

1360:
1361: CURSOR check_params is
1362: SELECT pci.ci_type_id, pctb.ci_type_class_code,
1363: pci.project_id, pps.project_system_status_code
1364: FROM pa_control_items pci, pa_ci_types_b pctb, pa_project_statuses pps
1365: WHERE pci.ci_id = l_ci_id
1366: and pci.ci_type_id = pctb.ci_type_id
1367: and pci.status_code = pps.project_status_code(+);
1368:

Line 1728: l_type_id PA_CI_TYPES_B.ci_type_id%TYPE;

1724: l_ci_number_num NUMBER(15) := NULL;
1725: -- l_ci_number_char VARCHAR2(30) := NULL;
1726: l_ci_number_char PA_CONTROL_ITEMS.ci_number%type := NULL;
1727: l_auto_numbers VARCHAR2(1) := 'N';
1728: l_type_id PA_CI_TYPES_B.ci_type_id%TYPE;
1729: l_type_class PA_CI_TYPES_B.ci_type_class_code%TYPE;
1730: l_project_id PA_CONTROL_ITEMS.project_Id%TYPE;
1731: l_ci_id NUMBER;
1732:

Line 1729: l_type_class PA_CI_TYPES_B.ci_type_class_code%TYPE;

1725: -- l_ci_number_char VARCHAR2(30) := NULL;
1726: l_ci_number_char PA_CONTROL_ITEMS.ci_number%type := NULL;
1727: l_auto_numbers VARCHAR2(1) := 'N';
1728: l_type_id PA_CI_TYPES_B.ci_type_id%TYPE;
1729: l_type_class PA_CI_TYPES_B.ci_type_class_code%TYPE;
1730: l_project_id PA_CONTROL_ITEMS.project_Id%TYPE;
1731: l_ci_id NUMBER;
1732:
1733:

Line 1736: From PA_CI_TYPES_B type

1732:
1733:
1734: cursor c_auto_num is
1735: Select type.auto_number_flag, type.ci_type_id,type.ci_type_class_code
1736: From PA_CI_TYPES_B type
1737: ,pa_control_items ci
1738: Where ci.ci_id = p_ci_id
1739: AND ci.ci_type_id = type.ci_type_id;
1740: