eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CONTROL_API_PUB dependencies on PA_CONTROL_ITEMS

Line 16: FROM pa_control_items

12:
13:
14: CURSOR Check_Valid_CI (c_Ci_Id NUMBER) IS
15: SELECT ci_id
16: FROM pa_control_items
17: WHERE ci_id = c_Ci_Id;
18:
19: /*
20: Cursor Get_CI_Data.

Line 29: FROM pa_control_items ci,

25: SELECT ci.project_id,
26: s.project_system_status_code,
27: cib.ci_type_class_code,
28: ci.record_version_number
29: FROM pa_control_items ci,
30: pa_ci_types_b cib,
31: (select
32: project_status_code,
33: project_system_status_code

Line 47: FROM pa_project_statuses pps, pa_control_items ci

43: is passed in.
44: */
45: CURSOR Check_Workflow_On_CI (c_Ci_Id NUMBER) IS
46: SELECT ci.ci_id
47: FROM pa_project_statuses pps, pa_control_items ci
48: WHERE pps.status_type = 'CONTROL_ITEM'
49: AND pps.project_status_code = ci.status_code
50: AND pps.enable_wf_flag = 'Y'
51: AND pps.wf_success_status_code is not null

Line 62: FROM pa_control_items pci, pa_ci_types_b pcit

58: or CHANGE_ORDER) for a particular Control Item.
59: */
60: CURSOR Get_CI_Type_Class_Code (c_Ci_Id NUMBER) IS
61: SELECT pcit.ci_type_class_code
62: FROM pa_control_items pci, pa_ci_types_b pcit
63: WHERE pci.ci_id = c_Ci_Id
64: AND pcit.ci_type_id = pci.ci_type_id;
65:
66: /*Procedure to add workplan impact*/

Line 1424: l_ci_id pa_control_items.ci_id%type;

1420: l_module_name VARCHAR2(200):='PA_CONTROL_API_PUB.Delete_Supplier_Impact_Details';
1421: -- End: Local Variables.
1422:
1423: l_chk_status_ctrl VARCHAR2(1);
1424: l_ci_id pa_control_items.ci_id%type;
1425: l_transaction_id pa_ci_supplier_details.ci_transaction_id%type;
1426: l_status_code pa_control_items.status_code%type;
1427:
1428: CURSOR Check_Valid_CI_TRANS_ID IS

Line 1426: l_status_code pa_control_items.status_code%type;

1422:
1423: l_chk_status_ctrl VARCHAR2(1);
1424: l_ci_id pa_control_items.ci_id%type;
1425: l_transaction_id pa_ci_supplier_details.ci_transaction_id%type;
1426: l_status_code pa_control_items.status_code%type;
1427:
1428: CURSOR Check_Valid_CI_TRANS_ID IS
1429: SELECT ci_transaction_id ,ci_id
1430: FROM pa_ci_supplier_details

Line 1435: FROM pa_control_items

1431: WHERE ci_transaction_id = P_CI_TRANSACTION_ID;
1432:
1433: CURSOR c_get_status(c_ci_id NUMBER) IS
1434: SELECT status_code
1435: FROM pa_control_items
1436: WHERE ci_id = c_ci_id;
1437:
1438: BEGIN
1439: -- Initialize the Error Stack.

Line 1509: l_chk_status_ctrl := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_status_code, 'CONTROL_ITEM_ALLOW_UPDATE');

1505: raise FND_API.G_EXC_ERROR ;
1506: end if;
1507: close c_get_status;
1508:
1509: l_chk_status_ctrl := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_status_code, 'CONTROL_ITEM_ALLOW_UPDATE');
1510: IF (l_chk_status_ctrl = 'N') THEN
1511: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_ALLOW_UPDATE');
1512: RAISE FND_API.G_EXC_ERROR;
1513: END IF;

Line 1517: pa_debug.write(l_module_name, 'After call to pa_control_items_utils.CheckCIActionAllowed', l_debug_level3);

1513: END IF;
1514:
1515:
1516: IF l_debug_mode = 'Y' THEN
1517: pa_debug.write(l_module_name, 'After call to pa_control_items_utils.CheckCIActionAllowed', l_debug_level3);
1518: END IF;
1519:
1520:
1521: if X_RETURN_STATUS = FND_API.g_Ret_Sts_Success then

Line 1602: from pa_control_items

1598: /* Cursor to get the control item data*/
1599: cursor c_get_control_item_data
1600: is
1601: select *
1602: from pa_control_items
1603: where ci_id = p_ci_id;
1604:
1605: /*cursor to check the progress code is valid or not*/
1606: cursor c_check_Progress_code

Line 1617: cursor c_get_resolution_codes(c_ci_type_id pa_control_items.ci_type_id%type)

1613: and status_type = 'PROGRESS')
1614: and project_status_code = p_progress_status_code; --need to clarify whether this is a name or code
1615:
1616: /*cursor to check the resolution code is valid or not*/
1617: cursor c_get_resolution_codes(c_ci_type_id pa_control_items.ci_type_id%type)
1618: is
1619: select
1620: cat.class_category class_category,
1621: cat.class_code description,

Line 1636: FROM pa_control_items c,

1632: CURSOR c_info IS
1633: SELECT cit.ci_type_class_code,
1634: cit.approval_required_flag,
1635: s.next_allowable_status_flag
1636: FROM pa_control_items c,
1637: pa_ci_types_b cit,
1638: pa_project_statuses s
1639: WHERE c.ci_id = p_ci_id
1640: AND c.status_code = s.project_status_code

Line 1669: l_last_modified_by_id pa_control_items.last_modified_by_id%TYPE;

1665:
1666: check_s VARCHAR2(1); --For security checks.
1667:
1668: --declaring pa_control_item local variables
1669: l_last_modified_by_id pa_control_items.last_modified_by_id%TYPE;
1670: l_curr_status_code pa_control_items.status_code%TYPE;
1671: l_ci_status_code pa_control_items.status_code%TYPE;
1672: l_record_version_number pa_control_items.record_version_number%TYPE;
1673: l_summary pa_control_items.summary%TYPE;

Line 1670: l_curr_status_code pa_control_items.status_code%TYPE;

1666: check_s VARCHAR2(1); --For security checks.
1667:
1668: --declaring pa_control_item local variables
1669: l_last_modified_by_id pa_control_items.last_modified_by_id%TYPE;
1670: l_curr_status_code pa_control_items.status_code%TYPE;
1671: l_ci_status_code pa_control_items.status_code%TYPE;
1672: l_record_version_number pa_control_items.record_version_number%TYPE;
1673: l_summary pa_control_items.summary%TYPE;
1674: l_description pa_control_items.description%TYPE;

Line 1671: l_ci_status_code pa_control_items.status_code%TYPE;

1667:
1668: --declaring pa_control_item local variables
1669: l_last_modified_by_id pa_control_items.last_modified_by_id%TYPE;
1670: l_curr_status_code pa_control_items.status_code%TYPE;
1671: l_ci_status_code pa_control_items.status_code%TYPE;
1672: l_record_version_number pa_control_items.record_version_number%TYPE;
1673: l_summary pa_control_items.summary%TYPE;
1674: l_description pa_control_items.description%TYPE;
1675: l_owner_id pa_control_items.owner_id%TYPE;

Line 1672: l_record_version_number pa_control_items.record_version_number%TYPE;

1668: --declaring pa_control_item local variables
1669: l_last_modified_by_id pa_control_items.last_modified_by_id%TYPE;
1670: l_curr_status_code pa_control_items.status_code%TYPE;
1671: l_ci_status_code pa_control_items.status_code%TYPE;
1672: l_record_version_number pa_control_items.record_version_number%TYPE;
1673: l_summary pa_control_items.summary%TYPE;
1674: l_description pa_control_items.description%TYPE;
1675: l_owner_id pa_control_items.owner_id%TYPE;
1676: l_classification_code_id pa_control_items.classification_code_id%TYPE;

Line 1673: l_summary pa_control_items.summary%TYPE;

1669: l_last_modified_by_id pa_control_items.last_modified_by_id%TYPE;
1670: l_curr_status_code pa_control_items.status_code%TYPE;
1671: l_ci_status_code pa_control_items.status_code%TYPE;
1672: l_record_version_number pa_control_items.record_version_number%TYPE;
1673: l_summary pa_control_items.summary%TYPE;
1674: l_description pa_control_items.description%TYPE;
1675: l_owner_id pa_control_items.owner_id%TYPE;
1676: l_classification_code_id pa_control_items.classification_code_id%TYPE;
1677: l_reason_code_id pa_control_items.reason_code_id%TYPE;

Line 1674: l_description pa_control_items.description%TYPE;

1670: l_curr_status_code pa_control_items.status_code%TYPE;
1671: l_ci_status_code pa_control_items.status_code%TYPE;
1672: l_record_version_number pa_control_items.record_version_number%TYPE;
1673: l_summary pa_control_items.summary%TYPE;
1674: l_description pa_control_items.description%TYPE;
1675: l_owner_id pa_control_items.owner_id%TYPE;
1676: l_classification_code_id pa_control_items.classification_code_id%TYPE;
1677: l_reason_code_id pa_control_items.reason_code_id%TYPE;
1678: l_object_id pa_control_items.object_id%TYPE;

Line 1675: l_owner_id pa_control_items.owner_id%TYPE;

1671: l_ci_status_code pa_control_items.status_code%TYPE;
1672: l_record_version_number pa_control_items.record_version_number%TYPE;
1673: l_summary pa_control_items.summary%TYPE;
1674: l_description pa_control_items.description%TYPE;
1675: l_owner_id pa_control_items.owner_id%TYPE;
1676: l_classification_code_id pa_control_items.classification_code_id%TYPE;
1677: l_reason_code_id pa_control_items.reason_code_id%TYPE;
1678: l_object_id pa_control_items.object_id%TYPE;
1679: l_object_type pa_control_items.object_type%TYPE;

Line 1676: l_classification_code_id pa_control_items.classification_code_id%TYPE;

1672: l_record_version_number pa_control_items.record_version_number%TYPE;
1673: l_summary pa_control_items.summary%TYPE;
1674: l_description pa_control_items.description%TYPE;
1675: l_owner_id pa_control_items.owner_id%TYPE;
1676: l_classification_code_id pa_control_items.classification_code_id%TYPE;
1677: l_reason_code_id pa_control_items.reason_code_id%TYPE;
1678: l_object_id pa_control_items.object_id%TYPE;
1679: l_object_type pa_control_items.object_type%TYPE;
1680: l_date_required pa_control_items.date_required%TYPE;

Line 1677: l_reason_code_id pa_control_items.reason_code_id%TYPE;

1673: l_summary pa_control_items.summary%TYPE;
1674: l_description pa_control_items.description%TYPE;
1675: l_owner_id pa_control_items.owner_id%TYPE;
1676: l_classification_code_id pa_control_items.classification_code_id%TYPE;
1677: l_reason_code_id pa_control_items.reason_code_id%TYPE;
1678: l_object_id pa_control_items.object_id%TYPE;
1679: l_object_type pa_control_items.object_type%TYPE;
1680: l_date_required pa_control_items.date_required%TYPE;
1681: l_priority_code pa_control_items.priority_code%TYPE;

Line 1678: l_object_id pa_control_items.object_id%TYPE;

1674: l_description pa_control_items.description%TYPE;
1675: l_owner_id pa_control_items.owner_id%TYPE;
1676: l_classification_code_id pa_control_items.classification_code_id%TYPE;
1677: l_reason_code_id pa_control_items.reason_code_id%TYPE;
1678: l_object_id pa_control_items.object_id%TYPE;
1679: l_object_type pa_control_items.object_type%TYPE;
1680: l_date_required pa_control_items.date_required%TYPE;
1681: l_priority_code pa_control_items.priority_code%TYPE;
1682: l_effort_level_code pa_control_items.effort_level_code%TYPE;

Line 1679: l_object_type pa_control_items.object_type%TYPE;

1675: l_owner_id pa_control_items.owner_id%TYPE;
1676: l_classification_code_id pa_control_items.classification_code_id%TYPE;
1677: l_reason_code_id pa_control_items.reason_code_id%TYPE;
1678: l_object_id pa_control_items.object_id%TYPE;
1679: l_object_type pa_control_items.object_type%TYPE;
1680: l_date_required pa_control_items.date_required%TYPE;
1681: l_priority_code pa_control_items.priority_code%TYPE;
1682: l_effort_level_code pa_control_items.effort_level_code%TYPE;
1683: l_price pa_control_items.price%TYPE;

Line 1680: l_date_required pa_control_items.date_required%TYPE;

1676: l_classification_code_id pa_control_items.classification_code_id%TYPE;
1677: l_reason_code_id pa_control_items.reason_code_id%TYPE;
1678: l_object_id pa_control_items.object_id%TYPE;
1679: l_object_type pa_control_items.object_type%TYPE;
1680: l_date_required pa_control_items.date_required%TYPE;
1681: l_priority_code pa_control_items.priority_code%TYPE;
1682: l_effort_level_code pa_control_items.effort_level_code%TYPE;
1683: l_price pa_control_items.price%TYPE;
1684: l_price_currency_code pa_control_items.price_currency_code%TYPE;

Line 1681: l_priority_code pa_control_items.priority_code%TYPE;

1677: l_reason_code_id pa_control_items.reason_code_id%TYPE;
1678: l_object_id pa_control_items.object_id%TYPE;
1679: l_object_type pa_control_items.object_type%TYPE;
1680: l_date_required pa_control_items.date_required%TYPE;
1681: l_priority_code pa_control_items.priority_code%TYPE;
1682: l_effort_level_code pa_control_items.effort_level_code%TYPE;
1683: l_price pa_control_items.price%TYPE;
1684: l_price_currency_code pa_control_items.price_currency_code%TYPE;
1685: l_source_type_code pa_control_items.source_type_code%TYPE;

Line 1682: l_effort_level_code pa_control_items.effort_level_code%TYPE;

1678: l_object_id pa_control_items.object_id%TYPE;
1679: l_object_type pa_control_items.object_type%TYPE;
1680: l_date_required pa_control_items.date_required%TYPE;
1681: l_priority_code pa_control_items.priority_code%TYPE;
1682: l_effort_level_code pa_control_items.effort_level_code%TYPE;
1683: l_price pa_control_items.price%TYPE;
1684: l_price_currency_code pa_control_items.price_currency_code%TYPE;
1685: l_source_type_code pa_control_items.source_type_code%TYPE;
1686: l_source_comment pa_control_items.source_comment%TYPE;

Line 1683: l_price pa_control_items.price%TYPE;

1679: l_object_type pa_control_items.object_type%TYPE;
1680: l_date_required pa_control_items.date_required%TYPE;
1681: l_priority_code pa_control_items.priority_code%TYPE;
1682: l_effort_level_code pa_control_items.effort_level_code%TYPE;
1683: l_price pa_control_items.price%TYPE;
1684: l_price_currency_code pa_control_items.price_currency_code%TYPE;
1685: l_source_type_code pa_control_items.source_type_code%TYPE;
1686: l_source_comment pa_control_items.source_comment%TYPE;
1687: l_source_number pa_control_items.source_number%TYPE;

Line 1684: l_price_currency_code pa_control_items.price_currency_code%TYPE;

1680: l_date_required pa_control_items.date_required%TYPE;
1681: l_priority_code pa_control_items.priority_code%TYPE;
1682: l_effort_level_code pa_control_items.effort_level_code%TYPE;
1683: l_price pa_control_items.price%TYPE;
1684: l_price_currency_code pa_control_items.price_currency_code%TYPE;
1685: l_source_type_code pa_control_items.source_type_code%TYPE;
1686: l_source_comment pa_control_items.source_comment%TYPE;
1687: l_source_number pa_control_items.source_number%TYPE;
1688: l_source_date_received pa_control_items.source_date_received%TYPE;

Line 1685: l_source_type_code pa_control_items.source_type_code%TYPE;

1681: l_priority_code pa_control_items.priority_code%TYPE;
1682: l_effort_level_code pa_control_items.effort_level_code%TYPE;
1683: l_price pa_control_items.price%TYPE;
1684: l_price_currency_code pa_control_items.price_currency_code%TYPE;
1685: l_source_type_code pa_control_items.source_type_code%TYPE;
1686: l_source_comment pa_control_items.source_comment%TYPE;
1687: l_source_number pa_control_items.source_number%TYPE;
1688: l_source_date_received pa_control_items.source_date_received%TYPE;
1689: l_source_organization pa_control_items.source_organization%TYPE;

Line 1686: l_source_comment pa_control_items.source_comment%TYPE;

1682: l_effort_level_code pa_control_items.effort_level_code%TYPE;
1683: l_price pa_control_items.price%TYPE;
1684: l_price_currency_code pa_control_items.price_currency_code%TYPE;
1685: l_source_type_code pa_control_items.source_type_code%TYPE;
1686: l_source_comment pa_control_items.source_comment%TYPE;
1687: l_source_number pa_control_items.source_number%TYPE;
1688: l_source_date_received pa_control_items.source_date_received%TYPE;
1689: l_source_organization pa_control_items.source_organization%TYPE;
1690: l_source_person pa_control_items.source_person%TYPE;

Line 1687: l_source_number pa_control_items.source_number%TYPE;

1683: l_price pa_control_items.price%TYPE;
1684: l_price_currency_code pa_control_items.price_currency_code%TYPE;
1685: l_source_type_code pa_control_items.source_type_code%TYPE;
1686: l_source_comment pa_control_items.source_comment%TYPE;
1687: l_source_number pa_control_items.source_number%TYPE;
1688: l_source_date_received pa_control_items.source_date_received%TYPE;
1689: l_source_organization pa_control_items.source_organization%TYPE;
1690: l_source_person pa_control_items.source_person%TYPE;
1691: l_as_of_date pa_control_items.progress_as_of_date%TYPE;

Line 1688: l_source_date_received pa_control_items.source_date_received%TYPE;

1684: l_price_currency_code pa_control_items.price_currency_code%TYPE;
1685: l_source_type_code pa_control_items.source_type_code%TYPE;
1686: l_source_comment pa_control_items.source_comment%TYPE;
1687: l_source_number pa_control_items.source_number%TYPE;
1688: l_source_date_received pa_control_items.source_date_received%TYPE;
1689: l_source_organization pa_control_items.source_organization%TYPE;
1690: l_source_person pa_control_items.source_person%TYPE;
1691: l_as_of_date pa_control_items.progress_as_of_date%TYPE;
1692: l_ci_number pa_control_items.ci_number%TYPE;

Line 1689: l_source_organization pa_control_items.source_organization%TYPE;

1685: l_source_type_code pa_control_items.source_type_code%TYPE;
1686: l_source_comment pa_control_items.source_comment%TYPE;
1687: l_source_number pa_control_items.source_number%TYPE;
1688: l_source_date_received pa_control_items.source_date_received%TYPE;
1689: l_source_organization pa_control_items.source_organization%TYPE;
1690: l_source_person pa_control_items.source_person%TYPE;
1691: l_as_of_date pa_control_items.progress_as_of_date%TYPE;
1692: l_ci_number pa_control_items.ci_number%TYPE;
1693: l_progress_status_code pa_control_items.progress_status_code%TYPE;

Line 1690: l_source_person pa_control_items.source_person%TYPE;

1686: l_source_comment pa_control_items.source_comment%TYPE;
1687: l_source_number pa_control_items.source_number%TYPE;
1688: l_source_date_received pa_control_items.source_date_received%TYPE;
1689: l_source_organization pa_control_items.source_organization%TYPE;
1690: l_source_person pa_control_items.source_person%TYPE;
1691: l_as_of_date pa_control_items.progress_as_of_date%TYPE;
1692: l_ci_number pa_control_items.ci_number%TYPE;
1693: l_progress_status_code pa_control_items.progress_status_code%TYPE;
1694: l_progress_overview pa_control_items.status_overview%TYPE;

Line 1691: l_as_of_date pa_control_items.progress_as_of_date%TYPE;

1687: l_source_number pa_control_items.source_number%TYPE;
1688: l_source_date_received pa_control_items.source_date_received%TYPE;
1689: l_source_organization pa_control_items.source_organization%TYPE;
1690: l_source_person pa_control_items.source_person%TYPE;
1691: l_as_of_date pa_control_items.progress_as_of_date%TYPE;
1692: l_ci_number pa_control_items.ci_number%TYPE;
1693: l_progress_status_code pa_control_items.progress_status_code%TYPE;
1694: l_progress_overview pa_control_items.status_overview%TYPE;
1695: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;

Line 1692: l_ci_number pa_control_items.ci_number%TYPE;

1688: l_source_date_received pa_control_items.source_date_received%TYPE;
1689: l_source_organization pa_control_items.source_organization%TYPE;
1690: l_source_person pa_control_items.source_person%TYPE;
1691: l_as_of_date pa_control_items.progress_as_of_date%TYPE;
1692: l_ci_number pa_control_items.ci_number%TYPE;
1693: l_progress_status_code pa_control_items.progress_status_code%TYPE;
1694: l_progress_overview pa_control_items.status_overview%TYPE;
1695: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
1696: l_resolution_comment pa_control_items.resolution%TYPE;

Line 1693: l_progress_status_code pa_control_items.progress_status_code%TYPE;

1689: l_source_organization pa_control_items.source_organization%TYPE;
1690: l_source_person pa_control_items.source_person%TYPE;
1691: l_as_of_date pa_control_items.progress_as_of_date%TYPE;
1692: l_ci_number pa_control_items.ci_number%TYPE;
1693: l_progress_status_code pa_control_items.progress_status_code%TYPE;
1694: l_progress_overview pa_control_items.status_overview%TYPE;
1695: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
1696: l_resolution_comment pa_control_items.resolution%TYPE;
1697: l_date_closed pa_control_items.date_closed%TYPE;

Line 1694: l_progress_overview pa_control_items.status_overview%TYPE;

1690: l_source_person pa_control_items.source_person%TYPE;
1691: l_as_of_date pa_control_items.progress_as_of_date%TYPE;
1692: l_ci_number pa_control_items.ci_number%TYPE;
1693: l_progress_status_code pa_control_items.progress_status_code%TYPE;
1694: l_progress_overview pa_control_items.status_overview%TYPE;
1695: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
1696: l_resolution_comment pa_control_items.resolution%TYPE;
1697: l_date_closed pa_control_items.date_closed%TYPE;
1698: l_closed_by_id pa_control_items.closed_by_id%TYPE;

Line 1695: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;

1691: l_as_of_date pa_control_items.progress_as_of_date%TYPE;
1692: l_ci_number pa_control_items.ci_number%TYPE;
1693: l_progress_status_code pa_control_items.progress_status_code%TYPE;
1694: l_progress_overview pa_control_items.status_overview%TYPE;
1695: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
1696: l_resolution_comment pa_control_items.resolution%TYPE;
1697: l_date_closed pa_control_items.date_closed%TYPE;
1698: l_closed_by_id pa_control_items.closed_by_id%TYPE;
1699: l_project_id pa_control_items.project_id%TYPE;

Line 1696: l_resolution_comment pa_control_items.resolution%TYPE;

1692: l_ci_number pa_control_items.ci_number%TYPE;
1693: l_progress_status_code pa_control_items.progress_status_code%TYPE;
1694: l_progress_overview pa_control_items.status_overview%TYPE;
1695: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
1696: l_resolution_comment pa_control_items.resolution%TYPE;
1697: l_date_closed pa_control_items.date_closed%TYPE;
1698: l_closed_by_id pa_control_items.closed_by_id%TYPE;
1699: l_project_id pa_control_items.project_id%TYPE;
1700: l_ci_type_id pa_control_items.ci_type_id%TYPE;

Line 1697: l_date_closed pa_control_items.date_closed%TYPE;

1693: l_progress_status_code pa_control_items.progress_status_code%TYPE;
1694: l_progress_overview pa_control_items.status_overview%TYPE;
1695: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
1696: l_resolution_comment pa_control_items.resolution%TYPE;
1697: l_date_closed pa_control_items.date_closed%TYPE;
1698: l_closed_by_id pa_control_items.closed_by_id%TYPE;
1699: l_project_id pa_control_items.project_id%TYPE;
1700: l_ci_type_id pa_control_items.ci_type_id%TYPE;
1701: l_attribute_category pa_control_items.attribute_category%TYPE;

Line 1698: l_closed_by_id pa_control_items.closed_by_id%TYPE;

1694: l_progress_overview pa_control_items.status_overview%TYPE;
1695: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
1696: l_resolution_comment pa_control_items.resolution%TYPE;
1697: l_date_closed pa_control_items.date_closed%TYPE;
1698: l_closed_by_id pa_control_items.closed_by_id%TYPE;
1699: l_project_id pa_control_items.project_id%TYPE;
1700: l_ci_type_id pa_control_items.ci_type_id%TYPE;
1701: l_attribute_category pa_control_items.attribute_category%TYPE;
1702: l_attribute1 pa_control_items.attribute1%TYPE;

Line 1699: l_project_id pa_control_items.project_id%TYPE;

1695: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
1696: l_resolution_comment pa_control_items.resolution%TYPE;
1697: l_date_closed pa_control_items.date_closed%TYPE;
1698: l_closed_by_id pa_control_items.closed_by_id%TYPE;
1699: l_project_id pa_control_items.project_id%TYPE;
1700: l_ci_type_id pa_control_items.ci_type_id%TYPE;
1701: l_attribute_category pa_control_items.attribute_category%TYPE;
1702: l_attribute1 pa_control_items.attribute1%TYPE;
1703: l_attribute2 pa_control_items.attribute2%TYPE;

Line 1700: l_ci_type_id pa_control_items.ci_type_id%TYPE;

1696: l_resolution_comment pa_control_items.resolution%TYPE;
1697: l_date_closed pa_control_items.date_closed%TYPE;
1698: l_closed_by_id pa_control_items.closed_by_id%TYPE;
1699: l_project_id pa_control_items.project_id%TYPE;
1700: l_ci_type_id pa_control_items.ci_type_id%TYPE;
1701: l_attribute_category pa_control_items.attribute_category%TYPE;
1702: l_attribute1 pa_control_items.attribute1%TYPE;
1703: l_attribute2 pa_control_items.attribute2%TYPE;
1704: l_attribute3 pa_control_items.attribute3%TYPE;

Line 1701: l_attribute_category pa_control_items.attribute_category%TYPE;

1697: l_date_closed pa_control_items.date_closed%TYPE;
1698: l_closed_by_id pa_control_items.closed_by_id%TYPE;
1699: l_project_id pa_control_items.project_id%TYPE;
1700: l_ci_type_id pa_control_items.ci_type_id%TYPE;
1701: l_attribute_category pa_control_items.attribute_category%TYPE;
1702: l_attribute1 pa_control_items.attribute1%TYPE;
1703: l_attribute2 pa_control_items.attribute2%TYPE;
1704: l_attribute3 pa_control_items.attribute3%TYPE;
1705: l_attribute4 pa_control_items.attribute4%TYPE;

Line 1702: l_attribute1 pa_control_items.attribute1%TYPE;

1698: l_closed_by_id pa_control_items.closed_by_id%TYPE;
1699: l_project_id pa_control_items.project_id%TYPE;
1700: l_ci_type_id pa_control_items.ci_type_id%TYPE;
1701: l_attribute_category pa_control_items.attribute_category%TYPE;
1702: l_attribute1 pa_control_items.attribute1%TYPE;
1703: l_attribute2 pa_control_items.attribute2%TYPE;
1704: l_attribute3 pa_control_items.attribute3%TYPE;
1705: l_attribute4 pa_control_items.attribute4%TYPE;
1706: l_attribute5 pa_control_items.attribute5%TYPE;

Line 1703: l_attribute2 pa_control_items.attribute2%TYPE;

1699: l_project_id pa_control_items.project_id%TYPE;
1700: l_ci_type_id pa_control_items.ci_type_id%TYPE;
1701: l_attribute_category pa_control_items.attribute_category%TYPE;
1702: l_attribute1 pa_control_items.attribute1%TYPE;
1703: l_attribute2 pa_control_items.attribute2%TYPE;
1704: l_attribute3 pa_control_items.attribute3%TYPE;
1705: l_attribute4 pa_control_items.attribute4%TYPE;
1706: l_attribute5 pa_control_items.attribute5%TYPE;
1707: l_attribute6 pa_control_items.attribute6%TYPE;

Line 1704: l_attribute3 pa_control_items.attribute3%TYPE;

1700: l_ci_type_id pa_control_items.ci_type_id%TYPE;
1701: l_attribute_category pa_control_items.attribute_category%TYPE;
1702: l_attribute1 pa_control_items.attribute1%TYPE;
1703: l_attribute2 pa_control_items.attribute2%TYPE;
1704: l_attribute3 pa_control_items.attribute3%TYPE;
1705: l_attribute4 pa_control_items.attribute4%TYPE;
1706: l_attribute5 pa_control_items.attribute5%TYPE;
1707: l_attribute6 pa_control_items.attribute6%TYPE;
1708: l_attribute7 pa_control_items.attribute7%TYPE;

Line 1705: l_attribute4 pa_control_items.attribute4%TYPE;

1701: l_attribute_category pa_control_items.attribute_category%TYPE;
1702: l_attribute1 pa_control_items.attribute1%TYPE;
1703: l_attribute2 pa_control_items.attribute2%TYPE;
1704: l_attribute3 pa_control_items.attribute3%TYPE;
1705: l_attribute4 pa_control_items.attribute4%TYPE;
1706: l_attribute5 pa_control_items.attribute5%TYPE;
1707: l_attribute6 pa_control_items.attribute6%TYPE;
1708: l_attribute7 pa_control_items.attribute7%TYPE;
1709: l_attribute8 pa_control_items.attribute8%TYPE;

Line 1706: l_attribute5 pa_control_items.attribute5%TYPE;

1702: l_attribute1 pa_control_items.attribute1%TYPE;
1703: l_attribute2 pa_control_items.attribute2%TYPE;
1704: l_attribute3 pa_control_items.attribute3%TYPE;
1705: l_attribute4 pa_control_items.attribute4%TYPE;
1706: l_attribute5 pa_control_items.attribute5%TYPE;
1707: l_attribute6 pa_control_items.attribute6%TYPE;
1708: l_attribute7 pa_control_items.attribute7%TYPE;
1709: l_attribute8 pa_control_items.attribute8%TYPE;
1710: l_attribute9 pa_control_items.attribute9%TYPE;

Line 1707: l_attribute6 pa_control_items.attribute6%TYPE;

1703: l_attribute2 pa_control_items.attribute2%TYPE;
1704: l_attribute3 pa_control_items.attribute3%TYPE;
1705: l_attribute4 pa_control_items.attribute4%TYPE;
1706: l_attribute5 pa_control_items.attribute5%TYPE;
1707: l_attribute6 pa_control_items.attribute6%TYPE;
1708: l_attribute7 pa_control_items.attribute7%TYPE;
1709: l_attribute8 pa_control_items.attribute8%TYPE;
1710: l_attribute9 pa_control_items.attribute9%TYPE;
1711: l_attribute10 pa_control_items.attribute10%TYPE;

Line 1708: l_attribute7 pa_control_items.attribute7%TYPE;

1704: l_attribute3 pa_control_items.attribute3%TYPE;
1705: l_attribute4 pa_control_items.attribute4%TYPE;
1706: l_attribute5 pa_control_items.attribute5%TYPE;
1707: l_attribute6 pa_control_items.attribute6%TYPE;
1708: l_attribute7 pa_control_items.attribute7%TYPE;
1709: l_attribute8 pa_control_items.attribute8%TYPE;
1710: l_attribute9 pa_control_items.attribute9%TYPE;
1711: l_attribute10 pa_control_items.attribute10%TYPE;
1712: l_attribute11 pa_control_items.attribute11%TYPE;

Line 1709: l_attribute8 pa_control_items.attribute8%TYPE;

1705: l_attribute4 pa_control_items.attribute4%TYPE;
1706: l_attribute5 pa_control_items.attribute5%TYPE;
1707: l_attribute6 pa_control_items.attribute6%TYPE;
1708: l_attribute7 pa_control_items.attribute7%TYPE;
1709: l_attribute8 pa_control_items.attribute8%TYPE;
1710: l_attribute9 pa_control_items.attribute9%TYPE;
1711: l_attribute10 pa_control_items.attribute10%TYPE;
1712: l_attribute11 pa_control_items.attribute11%TYPE;
1713: l_attribute12 pa_control_items.attribute12%TYPE;

Line 1710: l_attribute9 pa_control_items.attribute9%TYPE;

1706: l_attribute5 pa_control_items.attribute5%TYPE;
1707: l_attribute6 pa_control_items.attribute6%TYPE;
1708: l_attribute7 pa_control_items.attribute7%TYPE;
1709: l_attribute8 pa_control_items.attribute8%TYPE;
1710: l_attribute9 pa_control_items.attribute9%TYPE;
1711: l_attribute10 pa_control_items.attribute10%TYPE;
1712: l_attribute11 pa_control_items.attribute11%TYPE;
1713: l_attribute12 pa_control_items.attribute12%TYPE;
1714: l_attribute13 pa_control_items.attribute13%TYPE;

Line 1711: l_attribute10 pa_control_items.attribute10%TYPE;

1707: l_attribute6 pa_control_items.attribute6%TYPE;
1708: l_attribute7 pa_control_items.attribute7%TYPE;
1709: l_attribute8 pa_control_items.attribute8%TYPE;
1710: l_attribute9 pa_control_items.attribute9%TYPE;
1711: l_attribute10 pa_control_items.attribute10%TYPE;
1712: l_attribute11 pa_control_items.attribute11%TYPE;
1713: l_attribute12 pa_control_items.attribute12%TYPE;
1714: l_attribute13 pa_control_items.attribute13%TYPE;
1715: l_attribute14 pa_control_items.attribute14%TYPE;

Line 1712: l_attribute11 pa_control_items.attribute11%TYPE;

1708: l_attribute7 pa_control_items.attribute7%TYPE;
1709: l_attribute8 pa_control_items.attribute8%TYPE;
1710: l_attribute9 pa_control_items.attribute9%TYPE;
1711: l_attribute10 pa_control_items.attribute10%TYPE;
1712: l_attribute11 pa_control_items.attribute11%TYPE;
1713: l_attribute12 pa_control_items.attribute12%TYPE;
1714: l_attribute13 pa_control_items.attribute13%TYPE;
1715: l_attribute14 pa_control_items.attribute14%TYPE;
1716: l_attribute15 pa_control_items.attribute15%TYPE;

Line 1713: l_attribute12 pa_control_items.attribute12%TYPE;

1709: l_attribute8 pa_control_items.attribute8%TYPE;
1710: l_attribute9 pa_control_items.attribute9%TYPE;
1711: l_attribute10 pa_control_items.attribute10%TYPE;
1712: l_attribute11 pa_control_items.attribute11%TYPE;
1713: l_attribute12 pa_control_items.attribute12%TYPE;
1714: l_attribute13 pa_control_items.attribute13%TYPE;
1715: l_attribute14 pa_control_items.attribute14%TYPE;
1716: l_attribute15 pa_control_items.attribute15%TYPE;
1717:

Line 1714: l_attribute13 pa_control_items.attribute13%TYPE;

1710: l_attribute9 pa_control_items.attribute9%TYPE;
1711: l_attribute10 pa_control_items.attribute10%TYPE;
1712: l_attribute11 pa_control_items.attribute11%TYPE;
1713: l_attribute12 pa_control_items.attribute12%TYPE;
1714: l_attribute13 pa_control_items.attribute13%TYPE;
1715: l_attribute14 pa_control_items.attribute14%TYPE;
1716: l_attribute15 pa_control_items.attribute15%TYPE;
1717:
1718: l_projectid pa_control_items.project_id%TYPE;

Line 1715: l_attribute14 pa_control_items.attribute14%TYPE;

1711: l_attribute10 pa_control_items.attribute10%TYPE;
1712: l_attribute11 pa_control_items.attribute11%TYPE;
1713: l_attribute12 pa_control_items.attribute12%TYPE;
1714: l_attribute13 pa_control_items.attribute13%TYPE;
1715: l_attribute14 pa_control_items.attribute14%TYPE;
1716: l_attribute15 pa_control_items.attribute15%TYPE;
1717:
1718: l_projectid pa_control_items.project_id%TYPE;
1719: l_proj_status_code pa_project_statuses.project_system_status_code%TYPE;

Line 1716: l_attribute15 pa_control_items.attribute15%TYPE;

1712: l_attribute11 pa_control_items.attribute11%TYPE;
1713: l_attribute12 pa_control_items.attribute12%TYPE;
1714: l_attribute13 pa_control_items.attribute13%TYPE;
1715: l_attribute14 pa_control_items.attribute14%TYPE;
1716: l_attribute15 pa_control_items.attribute15%TYPE;
1717:
1718: l_projectid pa_control_items.project_id%TYPE;
1719: l_proj_status_code pa_project_statuses.project_system_status_code%TYPE;
1720: l_citypeclasscode pa_ci_types_b.ci_type_class_Code%TYPE;

Line 1718: l_projectid pa_control_items.project_id%TYPE;

1714: l_attribute13 pa_control_items.attribute13%TYPE;
1715: l_attribute14 pa_control_items.attribute14%TYPE;
1716: l_attribute15 pa_control_items.attribute15%TYPE;
1717:
1718: l_projectid pa_control_items.project_id%TYPE;
1719: l_proj_status_code pa_project_statuses.project_system_status_code%TYPE;
1720: l_citypeclasscode pa_ci_types_b.ci_type_class_Code%TYPE;
1721:
1722: l_curr_system_status pa_project_statuses.project_system_status_code%TYPE;

Line 1869: user statuses are not considered in pa_control_items status code*/

1865:
1866:
1867:
1868: /* cursor to get the project system status code to pass the value in checkciActionallowed as
1869: user statuses are not considered in pa_control_items status code*/
1870: -- Open Cursor Get_CI_Data and fetch the data into out local variables.
1871: OPEN get_ci_data (p_ci_id);
1872: FETCH Get_CI_Data INTO l_projectid, l_proj_status_code, l_citypeclasscode, l_recordversionnumber;
1873: -- If NO_DATA_FOUND then report Error.

Line 1885: check_s := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_curr_status_code , 'CONTROL_ITEM_ALLOW_UPDATE');

1881:
1882:
1883: /* Check for the status control: check whether the action CONTROL_ITEM_ALLOW_UPDST is allowed on the current status of the issue. */
1884:
1885: check_s := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_curr_status_code , 'CONTROL_ITEM_ALLOW_UPDATE');
1886:
1887: if check_s <> 'Y' then
1888: PA_UTILS.add_Message( p_app_short_name => 'PA'
1889: ,p_msg_name => 'PA_CI_NO_ALLOW_UPDATE');

Line 1907: l_curr_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_curr_status_code);

1903: /*Validating the p_ci_status_code -
1904: This is taken from Update_issue procedure. So If any changes happen in update_issue then this code needs to
1905: be looked in to*/
1906:
1907: l_curr_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_curr_status_code);
1908:
1909: IF p_ci_status_code = G_PA_MISS_CHAR THEN
1910: l_ci_status_code := l_curr_status_code;
1911: ELSIF p_ci_status_code IS NOT NULL THEN

Line 1948: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

1944: '''CONTROL_ITEM'''||' and wf_success_status_code is not null and wf_failure_status_code is not null)'||
1945: ' AND ps.project_status_code not in (select wf_failure_status_code from pa_project_statuses where status_type = '||
1946: '''CONTROL_ITEM'''||' and wf_success_status_code is not null and wf_failure_status_code is not null)'||
1947: ' AND decode(ps.project_system_status_code, '||'''CI_CANCELED'''||
1948: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
1949: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
1950: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
1951: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
1952: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||

Line 1951: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

1947: ' AND decode(ps.project_system_status_code, '||'''CI_CANCELED'''||
1948: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
1949: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
1950: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
1951: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
1952: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
1953: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
1954: '''CONTROL_ITEM_ALLOW_UPDST'''||' ,null),'||'''N'''||' ) = '||'''Y'''||
1955: ' AND decode(ps.project_system_status_code,'||'''CI_DRAFT'''||

Line 1953: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

1949: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
1950: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
1951: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
1952: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
1953: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
1954: '''CONTROL_ITEM_ALLOW_UPDST'''||' ,null),'||'''N'''||' ) = '||'''Y'''||
1955: ' AND decode(ps.project_system_status_code,'||'''CI_DRAFT'''||
1956: ' ,decode('||''''||l_curr_system_status||''''||', '||'''CI_DRAFT'''||', '||
1957: '''Y'''||' ,'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||

Line 2024: l_last_modified_by_id := PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id );

2020: /*end of status_code validation*/
2021:
2022:
2023: --get hz_parties.party_id of the logged in user
2024: l_last_modified_by_id := PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id );
2025:
2026: if p_as_of_date <> G_PA_MISS_DATE and p_as_of_date is not null then
2027: l_as_of_date := p_as_of_date;
2028: else

Line 2098: pa_debug.write(l_module_name, 'Before call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate', l_debug_level3);

2094: l_curr_status_code <> l_ci_status_code AND
2095: l_to_status_flag = 'Y' and x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2096:
2097: IF l_debug_mode = 'Y' THEN
2098: pa_debug.write(l_module_name, 'Before call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate', l_debug_level3);
2099: END IF;
2100:
2101: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (
2102: p_init_msg_list => p_init_msg_list

Line 2101: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (

2097: IF l_debug_mode = 'Y' THEN
2098: pa_debug.write(l_module_name, 'Before call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate', l_debug_level3);
2099: END IF;
2100:
2101: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (
2102: p_init_msg_list => p_init_msg_list
2103: ,p_commit => p_commit
2104: ,p_validate_only => l_validate_only
2105: ,p_max_msg_count => l_max_msg_count

Line 2124: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: x_return_status = '||x_return_status, l_debug_level3);

2120: In case of CR/CO, if Auto Approve on Submission is enabled and while changing the status to submitted,
2121: then the new status would be the success status code defined for the workflow */
2122:
2123: IF l_debug_mode = 'Y' THEN
2124: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: x_return_status = '||x_return_status, l_debug_level3);
2125: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_ci_status_code = '||l_ci_status_code, l_debug_level3);
2126: END IF;
2127:
2128: IF x_return_status = 'S' THEN

Line 2125: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_ci_status_code = '||l_ci_status_code, l_debug_level3);

2121: then the new status would be the success status code defined for the workflow */
2122:
2123: IF l_debug_mode = 'Y' THEN
2124: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: x_return_status = '||x_return_status, l_debug_level3);
2125: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_ci_status_code = '||l_ci_status_code, l_debug_level3);
2126: END IF;
2127:
2128: IF x_return_status = 'S' THEN
2129: l_status_change_flag := 'Y';

Line 2133: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_status_change_flag = '||l_status_change_flag, l_debug_level3);

2129: l_status_change_flag := 'Y';
2130: END IF;
2131:
2132: IF l_debug_mode = 'Y' THEN
2133: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_status_change_flag = '||l_status_change_flag, l_debug_level3);
2134: END IF;
2135:
2136:
2137:

Line 2139: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

2135:
2136:
2137:
2138: IF (l_resolution_req IS NOT NULL AND l_resolution_req = 'Y') THEN
2139: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN
2140: IF (l_resolution_code_id IS NULL) THEN
2141: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2142: ,p_msg_name => 'PA_CI_RESOLUTION_OPEN');
2143: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2155: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

2151: END IF;
2152: END IF;
2153:
2154: IF (l_resolution_req_cls IS NOT NULL AND l_resolution_req_cls = 'Y') THEN
2155: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN
2156: IF (l_resolution_code_id IS NULL) THEN
2157: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2158: ,p_msg_name => 'PA_CI_CLOSE_INV_RES');
2159: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2173: pa_debug.g_err_stage:= 'Before caliing the PA_CONTROL_ITEMS_PKG.UPDATE_ROW procedure';

2169:
2170: END IF;
2171:
2172: if l_debug_mode = 'Y' then
2173: pa_debug.g_err_stage:= 'Before caliing the PA_CONTROL_ITEMS_PKG.UPDATE_ROW procedure';
2174: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2175: end if;
2176:
2177:

Line 2179: PA_CONTROL_ITEMS_PKG.UPDATE_ROW(

2175: end if;
2176:
2177:
2178: if x_return_status = FND_API.G_RET_STS_SUCCESS then
2179: PA_CONTROL_ITEMS_PKG.UPDATE_ROW(
2180: p_ci_id => p_ci_id
2181: ,p_ci_type_id => l_ci_type_id
2182: ,p_summary => l_summary
2183: ,p_status_code => l_ci_status_code

Line 2242: pa_debug.write(l_module_name, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);

2238:
2239: IF (l_status_change_flag = 'Y' AND l_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2240:
2241: IF l_debug_mode = 'Y' THEN
2242: pa_debug.write(l_module_name, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
2243: END IF;
2244:
2245: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
2246:

Line 2247: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'

2243: END IF;
2244:
2245: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
2246:
2247: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'
2248: ,p_object_id => p_ci_id
2249: ,p_type_code => 'CHANGE_STATUS'
2250: ,p_status_type => 'CONTROL_ITEM'
2251: ,p_new_project_status => l_ci_status_code

Line 2259: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);

2255: ,x_msg_count => x_msg_count
2256: ,x_msg_data => x_msg_data );
2257:
2258: IF l_debug_mode = 'Y' THEN
2259: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
2260: END IF;
2261:
2262: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (
2263: p_init_msg_list

Line 2262: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (

2258: IF l_debug_mode = 'Y' THEN
2259: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
2260: END IF;
2261:
2262: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (
2263: p_init_msg_list
2264: ,p_commit
2265: ,l_validate_only
2266: ,l_max_msg_count

Line 2279: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus', l_debug_level3);

2275: ,x_msg_data );
2276:
2277:
2278: IF l_debug_mode = 'Y' THEN
2279: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus', l_debug_level3);
2280: END IF;
2281:
2282: END IF;
2283:

Line 2425: l_summary pa_control_items.summary%type;

2421: l_project_id pa_projects_all.project_id%type;
2422: l_project_name pa_projects_all.name%type;
2423: l_project_number pa_projects_all.segment1%type;
2424: l_ci_type_id pa_ci_types_b.ci_type_id%type;
2425: l_summary pa_control_items.summary%type;
2426: l_ci_number pa_control_items.ci_number%type;
2427: l_description pa_control_items.description%type;
2428: l_status_code pa_project_statuses.project_status_code%type;
2429: l_status pa_project_statuses.project_status_name%type;

Line 2426: l_ci_number pa_control_items.ci_number%type;

2422: l_project_name pa_projects_all.name%type;
2423: l_project_number pa_projects_all.segment1%type;
2424: l_ci_type_id pa_ci_types_b.ci_type_id%type;
2425: l_summary pa_control_items.summary%type;
2426: l_ci_number pa_control_items.ci_number%type;
2427: l_description pa_control_items.description%type;
2428: l_status_code pa_project_statuses.project_status_code%type;
2429: l_status pa_project_statuses.project_status_name%type;
2430: l_owner_id pa_control_items.owner_id%type;

Line 2427: l_description pa_control_items.description%type;

2423: l_project_number pa_projects_all.segment1%type;
2424: l_ci_type_id pa_ci_types_b.ci_type_id%type;
2425: l_summary pa_control_items.summary%type;
2426: l_ci_number pa_control_items.ci_number%type;
2427: l_description pa_control_items.description%type;
2428: l_status_code pa_project_statuses.project_status_code%type;
2429: l_status pa_project_statuses.project_status_name%type;
2430: l_owner_id pa_control_items.owner_id%type;
2431: l_progress_status_code pa_control_items.progress_status_code%type;

Line 2430: l_owner_id pa_control_items.owner_id%type;

2426: l_ci_number pa_control_items.ci_number%type;
2427: l_description pa_control_items.description%type;
2428: l_status_code pa_project_statuses.project_status_code%type;
2429: l_status pa_project_statuses.project_status_name%type;
2430: l_owner_id pa_control_items.owner_id%type;
2431: l_progress_status_code pa_control_items.progress_status_code%type;
2432: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
2433: l_status_overview pa_control_items.status_overview%type;
2434: l_classification_code pa_control_items.classification_code_id%type;

Line 2431: l_progress_status_code pa_control_items.progress_status_code%type;

2427: l_description pa_control_items.description%type;
2428: l_status_code pa_project_statuses.project_status_code%type;
2429: l_status pa_project_statuses.project_status_name%type;
2430: l_owner_id pa_control_items.owner_id%type;
2431: l_progress_status_code pa_control_items.progress_status_code%type;
2432: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
2433: l_status_overview pa_control_items.status_overview%type;
2434: l_classification_code pa_control_items.classification_code_id%type;
2435: l_reason_code pa_control_items.reason_code_id%type;

Line 2432: l_progress_as_of_date pa_control_items.progress_as_of_date%type;

2428: l_status_code pa_project_statuses.project_status_code%type;
2429: l_status pa_project_statuses.project_status_name%type;
2430: l_owner_id pa_control_items.owner_id%type;
2431: l_progress_status_code pa_control_items.progress_status_code%type;
2432: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
2433: l_status_overview pa_control_items.status_overview%type;
2434: l_classification_code pa_control_items.classification_code_id%type;
2435: l_reason_code pa_control_items.reason_code_id%type;
2436: l_object_id pa_control_items.object_id%type;

Line 2433: l_status_overview pa_control_items.status_overview%type;

2429: l_status pa_project_statuses.project_status_name%type;
2430: l_owner_id pa_control_items.owner_id%type;
2431: l_progress_status_code pa_control_items.progress_status_code%type;
2432: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
2433: l_status_overview pa_control_items.status_overview%type;
2434: l_classification_code pa_control_items.classification_code_id%type;
2435: l_reason_code pa_control_items.reason_code_id%type;
2436: l_object_id pa_control_items.object_id%type;
2437: l_object_type pa_control_items.object_type%type;

Line 2434: l_classification_code pa_control_items.classification_code_id%type;

2430: l_owner_id pa_control_items.owner_id%type;
2431: l_progress_status_code pa_control_items.progress_status_code%type;
2432: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
2433: l_status_overview pa_control_items.status_overview%type;
2434: l_classification_code pa_control_items.classification_code_id%type;
2435: l_reason_code pa_control_items.reason_code_id%type;
2436: l_object_id pa_control_items.object_id%type;
2437: l_object_type pa_control_items.object_type%type;
2438: l_date_required pa_control_items.date_required%type;

Line 2435: l_reason_code pa_control_items.reason_code_id%type;

2431: l_progress_status_code pa_control_items.progress_status_code%type;
2432: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
2433: l_status_overview pa_control_items.status_overview%type;
2434: l_classification_code pa_control_items.classification_code_id%type;
2435: l_reason_code pa_control_items.reason_code_id%type;
2436: l_object_id pa_control_items.object_id%type;
2437: l_object_type pa_control_items.object_type%type;
2438: l_date_required pa_control_items.date_required%type;
2439: l_date_closed pa_control_items.date_closed%type;

Line 2436: l_object_id pa_control_items.object_id%type;

2432: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
2433: l_status_overview pa_control_items.status_overview%type;
2434: l_classification_code pa_control_items.classification_code_id%type;
2435: l_reason_code pa_control_items.reason_code_id%type;
2436: l_object_id pa_control_items.object_id%type;
2437: l_object_type pa_control_items.object_type%type;
2438: l_date_required pa_control_items.date_required%type;
2439: l_date_closed pa_control_items.date_closed%type;
2440: l_closed_by_id pa_control_items.closed_by_id%type;

Line 2437: l_object_type pa_control_items.object_type%type;

2433: l_status_overview pa_control_items.status_overview%type;
2434: l_classification_code pa_control_items.classification_code_id%type;
2435: l_reason_code pa_control_items.reason_code_id%type;
2436: l_object_id pa_control_items.object_id%type;
2437: l_object_type pa_control_items.object_type%type;
2438: l_date_required pa_control_items.date_required%type;
2439: l_date_closed pa_control_items.date_closed%type;
2440: l_closed_by_id pa_control_items.closed_by_id%type;
2441: l_resolution pa_control_items.resolution%type;

Line 2438: l_date_required pa_control_items.date_required%type;

2434: l_classification_code pa_control_items.classification_code_id%type;
2435: l_reason_code pa_control_items.reason_code_id%type;
2436: l_object_id pa_control_items.object_id%type;
2437: l_object_type pa_control_items.object_type%type;
2438: l_date_required pa_control_items.date_required%type;
2439: l_date_closed pa_control_items.date_closed%type;
2440: l_closed_by_id pa_control_items.closed_by_id%type;
2441: l_resolution pa_control_items.resolution%type;
2442: l_resolution_code pa_control_items.resolution_code_id%type;

Line 2439: l_date_closed pa_control_items.date_closed%type;

2435: l_reason_code pa_control_items.reason_code_id%type;
2436: l_object_id pa_control_items.object_id%type;
2437: l_object_type pa_control_items.object_type%type;
2438: l_date_required pa_control_items.date_required%type;
2439: l_date_closed pa_control_items.date_closed%type;
2440: l_closed_by_id pa_control_items.closed_by_id%type;
2441: l_resolution pa_control_items.resolution%type;
2442: l_resolution_code pa_control_items.resolution_code_id%type;
2443: l_priority_code pa_control_items.priority_code%type;

Line 2440: l_closed_by_id pa_control_items.closed_by_id%type;

2436: l_object_id pa_control_items.object_id%type;
2437: l_object_type pa_control_items.object_type%type;
2438: l_date_required pa_control_items.date_required%type;
2439: l_date_closed pa_control_items.date_closed%type;
2440: l_closed_by_id pa_control_items.closed_by_id%type;
2441: l_resolution pa_control_items.resolution%type;
2442: l_resolution_code pa_control_items.resolution_code_id%type;
2443: l_priority_code pa_control_items.priority_code%type;
2444: l_effort_level_code pa_control_items.effort_level_code%type;

Line 2441: l_resolution pa_control_items.resolution%type;

2437: l_object_type pa_control_items.object_type%type;
2438: l_date_required pa_control_items.date_required%type;
2439: l_date_closed pa_control_items.date_closed%type;
2440: l_closed_by_id pa_control_items.closed_by_id%type;
2441: l_resolution pa_control_items.resolution%type;
2442: l_resolution_code pa_control_items.resolution_code_id%type;
2443: l_priority_code pa_control_items.priority_code%type;
2444: l_effort_level_code pa_control_items.effort_level_code%type;
2445: l_price pa_control_items.price%type;

Line 2442: l_resolution_code pa_control_items.resolution_code_id%type;

2438: l_date_required pa_control_items.date_required%type;
2439: l_date_closed pa_control_items.date_closed%type;
2440: l_closed_by_id pa_control_items.closed_by_id%type;
2441: l_resolution pa_control_items.resolution%type;
2442: l_resolution_code pa_control_items.resolution_code_id%type;
2443: l_priority_code pa_control_items.priority_code%type;
2444: l_effort_level_code pa_control_items.effort_level_code%type;
2445: l_price pa_control_items.price%type;
2446: l_price_currency_code pa_control_items.price_currency_code%type;

Line 2443: l_priority_code pa_control_items.priority_code%type;

2439: l_date_closed pa_control_items.date_closed%type;
2440: l_closed_by_id pa_control_items.closed_by_id%type;
2441: l_resolution pa_control_items.resolution%type;
2442: l_resolution_code pa_control_items.resolution_code_id%type;
2443: l_priority_code pa_control_items.priority_code%type;
2444: l_effort_level_code pa_control_items.effort_level_code%type;
2445: l_price pa_control_items.price%type;
2446: l_price_currency_code pa_control_items.price_currency_code%type;
2447: l_source_type_name pa_lookups.meaning%type;

Line 2444: l_effort_level_code pa_control_items.effort_level_code%type;

2440: l_closed_by_id pa_control_items.closed_by_id%type;
2441: l_resolution pa_control_items.resolution%type;
2442: l_resolution_code pa_control_items.resolution_code_id%type;
2443: l_priority_code pa_control_items.priority_code%type;
2444: l_effort_level_code pa_control_items.effort_level_code%type;
2445: l_price pa_control_items.price%type;
2446: l_price_currency_code pa_control_items.price_currency_code%type;
2447: l_source_type_name pa_lookups.meaning%type;
2448: l_source_type_code pa_control_items.source_type_code%type;

Line 2445: l_price pa_control_items.price%type;

2441: l_resolution pa_control_items.resolution%type;
2442: l_resolution_code pa_control_items.resolution_code_id%type;
2443: l_priority_code pa_control_items.priority_code%type;
2444: l_effort_level_code pa_control_items.effort_level_code%type;
2445: l_price pa_control_items.price%type;
2446: l_price_currency_code pa_control_items.price_currency_code%type;
2447: l_source_type_name pa_lookups.meaning%type;
2448: l_source_type_code pa_control_items.source_type_code%type;
2449: l_source_number pa_control_items.source_number%type;

Line 2446: l_price_currency_code pa_control_items.price_currency_code%type;

2442: l_resolution_code pa_control_items.resolution_code_id%type;
2443: l_priority_code pa_control_items.priority_code%type;
2444: l_effort_level_code pa_control_items.effort_level_code%type;
2445: l_price pa_control_items.price%type;
2446: l_price_currency_code pa_control_items.price_currency_code%type;
2447: l_source_type_name pa_lookups.meaning%type;
2448: l_source_type_code pa_control_items.source_type_code%type;
2449: l_source_number pa_control_items.source_number%type;
2450: l_source_comment pa_control_items.source_comment%type;

Line 2448: l_source_type_code pa_control_items.source_type_code%type;

2444: l_effort_level_code pa_control_items.effort_level_code%type;
2445: l_price pa_control_items.price%type;
2446: l_price_currency_code pa_control_items.price_currency_code%type;
2447: l_source_type_name pa_lookups.meaning%type;
2448: l_source_type_code pa_control_items.source_type_code%type;
2449: l_source_number pa_control_items.source_number%type;
2450: l_source_comment pa_control_items.source_comment%type;
2451: l_source_date_received pa_control_items.source_date_received%type;
2452: l_source_organization pa_control_items.source_organization%type;

Line 2449: l_source_number pa_control_items.source_number%type;

2445: l_price pa_control_items.price%type;
2446: l_price_currency_code pa_control_items.price_currency_code%type;
2447: l_source_type_name pa_lookups.meaning%type;
2448: l_source_type_code pa_control_items.source_type_code%type;
2449: l_source_number pa_control_items.source_number%type;
2450: l_source_comment pa_control_items.source_comment%type;
2451: l_source_date_received pa_control_items.source_date_received%type;
2452: l_source_organization pa_control_items.source_organization%type;
2453: l_source_person pa_control_items.source_person%type;

Line 2450: l_source_comment pa_control_items.source_comment%type;

2446: l_price_currency_code pa_control_items.price_currency_code%type;
2447: l_source_type_name pa_lookups.meaning%type;
2448: l_source_type_code pa_control_items.source_type_code%type;
2449: l_source_number pa_control_items.source_number%type;
2450: l_source_comment pa_control_items.source_comment%type;
2451: l_source_date_received pa_control_items.source_date_received%type;
2452: l_source_organization pa_control_items.source_organization%type;
2453: l_source_person pa_control_items.source_person%type;
2454: l_attribute_category pa_control_items.attribute_category%type;

Line 2451: l_source_date_received pa_control_items.source_date_received%type;

2447: l_source_type_name pa_lookups.meaning%type;
2448: l_source_type_code pa_control_items.source_type_code%type;
2449: l_source_number pa_control_items.source_number%type;
2450: l_source_comment pa_control_items.source_comment%type;
2451: l_source_date_received pa_control_items.source_date_received%type;
2452: l_source_organization pa_control_items.source_organization%type;
2453: l_source_person pa_control_items.source_person%type;
2454: l_attribute_category pa_control_items.attribute_category%type;
2455: l_attribute1 pa_control_items.attribute1%type;

Line 2452: l_source_organization pa_control_items.source_organization%type;

2448: l_source_type_code pa_control_items.source_type_code%type;
2449: l_source_number pa_control_items.source_number%type;
2450: l_source_comment pa_control_items.source_comment%type;
2451: l_source_date_received pa_control_items.source_date_received%type;
2452: l_source_organization pa_control_items.source_organization%type;
2453: l_source_person pa_control_items.source_person%type;
2454: l_attribute_category pa_control_items.attribute_category%type;
2455: l_attribute1 pa_control_items.attribute1%type;
2456: l_attribute2 pa_control_items.attribute1%type;

Line 2453: l_source_person pa_control_items.source_person%type;

2449: l_source_number pa_control_items.source_number%type;
2450: l_source_comment pa_control_items.source_comment%type;
2451: l_source_date_received pa_control_items.source_date_received%type;
2452: l_source_organization pa_control_items.source_organization%type;
2453: l_source_person pa_control_items.source_person%type;
2454: l_attribute_category pa_control_items.attribute_category%type;
2455: l_attribute1 pa_control_items.attribute1%type;
2456: l_attribute2 pa_control_items.attribute1%type;
2457: l_attribute3 pa_control_items.attribute1%type;

Line 2454: l_attribute_category pa_control_items.attribute_category%type;

2450: l_source_comment pa_control_items.source_comment%type;
2451: l_source_date_received pa_control_items.source_date_received%type;
2452: l_source_organization pa_control_items.source_organization%type;
2453: l_source_person pa_control_items.source_person%type;
2454: l_attribute_category pa_control_items.attribute_category%type;
2455: l_attribute1 pa_control_items.attribute1%type;
2456: l_attribute2 pa_control_items.attribute1%type;
2457: l_attribute3 pa_control_items.attribute1%type;
2458: l_attribute4 pa_control_items.attribute1%type;

Line 2455: l_attribute1 pa_control_items.attribute1%type;

2451: l_source_date_received pa_control_items.source_date_received%type;
2452: l_source_organization pa_control_items.source_organization%type;
2453: l_source_person pa_control_items.source_person%type;
2454: l_attribute_category pa_control_items.attribute_category%type;
2455: l_attribute1 pa_control_items.attribute1%type;
2456: l_attribute2 pa_control_items.attribute1%type;
2457: l_attribute3 pa_control_items.attribute1%type;
2458: l_attribute4 pa_control_items.attribute1%type;
2459: l_attribute5 pa_control_items.attribute1%type;

Line 2456: l_attribute2 pa_control_items.attribute1%type;

2452: l_source_organization pa_control_items.source_organization%type;
2453: l_source_person pa_control_items.source_person%type;
2454: l_attribute_category pa_control_items.attribute_category%type;
2455: l_attribute1 pa_control_items.attribute1%type;
2456: l_attribute2 pa_control_items.attribute1%type;
2457: l_attribute3 pa_control_items.attribute1%type;
2458: l_attribute4 pa_control_items.attribute1%type;
2459: l_attribute5 pa_control_items.attribute1%type;
2460: l_attribute6 pa_control_items.attribute1%type;

Line 2457: l_attribute3 pa_control_items.attribute1%type;

2453: l_source_person pa_control_items.source_person%type;
2454: l_attribute_category pa_control_items.attribute_category%type;
2455: l_attribute1 pa_control_items.attribute1%type;
2456: l_attribute2 pa_control_items.attribute1%type;
2457: l_attribute3 pa_control_items.attribute1%type;
2458: l_attribute4 pa_control_items.attribute1%type;
2459: l_attribute5 pa_control_items.attribute1%type;
2460: l_attribute6 pa_control_items.attribute1%type;
2461: l_attribute7 pa_control_items.attribute1%type;

Line 2458: l_attribute4 pa_control_items.attribute1%type;

2454: l_attribute_category pa_control_items.attribute_category%type;
2455: l_attribute1 pa_control_items.attribute1%type;
2456: l_attribute2 pa_control_items.attribute1%type;
2457: l_attribute3 pa_control_items.attribute1%type;
2458: l_attribute4 pa_control_items.attribute1%type;
2459: l_attribute5 pa_control_items.attribute1%type;
2460: l_attribute6 pa_control_items.attribute1%type;
2461: l_attribute7 pa_control_items.attribute1%type;
2462: l_attribute8 pa_control_items.attribute1%type;

Line 2459: l_attribute5 pa_control_items.attribute1%type;

2455: l_attribute1 pa_control_items.attribute1%type;
2456: l_attribute2 pa_control_items.attribute1%type;
2457: l_attribute3 pa_control_items.attribute1%type;
2458: l_attribute4 pa_control_items.attribute1%type;
2459: l_attribute5 pa_control_items.attribute1%type;
2460: l_attribute6 pa_control_items.attribute1%type;
2461: l_attribute7 pa_control_items.attribute1%type;
2462: l_attribute8 pa_control_items.attribute1%type;
2463: l_attribute9 pa_control_items.attribute1%type;

Line 2460: l_attribute6 pa_control_items.attribute1%type;

2456: l_attribute2 pa_control_items.attribute1%type;
2457: l_attribute3 pa_control_items.attribute1%type;
2458: l_attribute4 pa_control_items.attribute1%type;
2459: l_attribute5 pa_control_items.attribute1%type;
2460: l_attribute6 pa_control_items.attribute1%type;
2461: l_attribute7 pa_control_items.attribute1%type;
2462: l_attribute8 pa_control_items.attribute1%type;
2463: l_attribute9 pa_control_items.attribute1%type;
2464: l_attribute10 pa_control_items.attribute1%type;

Line 2461: l_attribute7 pa_control_items.attribute1%type;

2457: l_attribute3 pa_control_items.attribute1%type;
2458: l_attribute4 pa_control_items.attribute1%type;
2459: l_attribute5 pa_control_items.attribute1%type;
2460: l_attribute6 pa_control_items.attribute1%type;
2461: l_attribute7 pa_control_items.attribute1%type;
2462: l_attribute8 pa_control_items.attribute1%type;
2463: l_attribute9 pa_control_items.attribute1%type;
2464: l_attribute10 pa_control_items.attribute1%type;
2465: l_attribute11 pa_control_items.attribute1%type;

Line 2462: l_attribute8 pa_control_items.attribute1%type;

2458: l_attribute4 pa_control_items.attribute1%type;
2459: l_attribute5 pa_control_items.attribute1%type;
2460: l_attribute6 pa_control_items.attribute1%type;
2461: l_attribute7 pa_control_items.attribute1%type;
2462: l_attribute8 pa_control_items.attribute1%type;
2463: l_attribute9 pa_control_items.attribute1%type;
2464: l_attribute10 pa_control_items.attribute1%type;
2465: l_attribute11 pa_control_items.attribute1%type;
2466: l_attribute12 pa_control_items.attribute1%type;

Line 2463: l_attribute9 pa_control_items.attribute1%type;

2459: l_attribute5 pa_control_items.attribute1%type;
2460: l_attribute6 pa_control_items.attribute1%type;
2461: l_attribute7 pa_control_items.attribute1%type;
2462: l_attribute8 pa_control_items.attribute1%type;
2463: l_attribute9 pa_control_items.attribute1%type;
2464: l_attribute10 pa_control_items.attribute1%type;
2465: l_attribute11 pa_control_items.attribute1%type;
2466: l_attribute12 pa_control_items.attribute1%type;
2467: l_attribute13 pa_control_items.attribute1%type;

Line 2464: l_attribute10 pa_control_items.attribute1%type;

2460: l_attribute6 pa_control_items.attribute1%type;
2461: l_attribute7 pa_control_items.attribute1%type;
2462: l_attribute8 pa_control_items.attribute1%type;
2463: l_attribute9 pa_control_items.attribute1%type;
2464: l_attribute10 pa_control_items.attribute1%type;
2465: l_attribute11 pa_control_items.attribute1%type;
2466: l_attribute12 pa_control_items.attribute1%type;
2467: l_attribute13 pa_control_items.attribute1%type;
2468: l_attribute14 pa_control_items.attribute1%type;

Line 2465: l_attribute11 pa_control_items.attribute1%type;

2461: l_attribute7 pa_control_items.attribute1%type;
2462: l_attribute8 pa_control_items.attribute1%type;
2463: l_attribute9 pa_control_items.attribute1%type;
2464: l_attribute10 pa_control_items.attribute1%type;
2465: l_attribute11 pa_control_items.attribute1%type;
2466: l_attribute12 pa_control_items.attribute1%type;
2467: l_attribute13 pa_control_items.attribute1%type;
2468: l_attribute14 pa_control_items.attribute1%type;
2469: l_attribute15 pa_control_items.attribute1%type;

Line 2466: l_attribute12 pa_control_items.attribute1%type;

2462: l_attribute8 pa_control_items.attribute1%type;
2463: l_attribute9 pa_control_items.attribute1%type;
2464: l_attribute10 pa_control_items.attribute1%type;
2465: l_attribute11 pa_control_items.attribute1%type;
2466: l_attribute12 pa_control_items.attribute1%type;
2467: l_attribute13 pa_control_items.attribute1%type;
2468: l_attribute14 pa_control_items.attribute1%type;
2469: l_attribute15 pa_control_items.attribute1%type;
2470: l_class_code constant varchar2(20) := 'ISSUE';

Line 2467: l_attribute13 pa_control_items.attribute1%type;

2463: l_attribute9 pa_control_items.attribute1%type;
2464: l_attribute10 pa_control_items.attribute1%type;
2465: l_attribute11 pa_control_items.attribute1%type;
2466: l_attribute12 pa_control_items.attribute1%type;
2467: l_attribute13 pa_control_items.attribute1%type;
2468: l_attribute14 pa_control_items.attribute1%type;
2469: l_attribute15 pa_control_items.attribute1%type;
2470: l_class_code constant varchar2(20) := 'ISSUE';
2471:

Line 2468: l_attribute14 pa_control_items.attribute1%type;

2464: l_attribute10 pa_control_items.attribute1%type;
2465: l_attribute11 pa_control_items.attribute1%type;
2466: l_attribute12 pa_control_items.attribute1%type;
2467: l_attribute13 pa_control_items.attribute1%type;
2468: l_attribute14 pa_control_items.attribute1%type;
2469: l_attribute15 pa_control_items.attribute1%type;
2470: l_class_code constant varchar2(20) := 'ISSUE';
2471:
2472: BEGIN

Line 2469: l_attribute15 pa_control_items.attribute1%type;

2465: l_attribute11 pa_control_items.attribute1%type;
2466: l_attribute12 pa_control_items.attribute1%type;
2467: l_attribute13 pa_control_items.attribute1%type;
2468: l_attribute14 pa_control_items.attribute1%type;
2469: l_attribute15 pa_control_items.attribute1%type;
2470: l_class_code constant varchar2(20) := 'ISSUE';
2471:
2472: BEGIN
2473:

Line 3060: l_summary pa_control_items.summary%type;

3056: l_project_id pa_projects_all.project_id%type;
3057: l_project_name pa_projects_all.name%type;
3058: l_project_number pa_projects_all.segment1%type;
3059: l_ci_type_id pa_ci_types_b.ci_type_id%type;
3060: l_summary pa_control_items.summary%type;
3061: l_ci_number pa_control_items.ci_number%type;
3062: l_description pa_control_items.description%type;
3063: l_status_code pa_project_statuses.project_status_code%type;
3064: l_status pa_project_statuses.project_status_name%type;

Line 3061: l_ci_number pa_control_items.ci_number%type;

3057: l_project_name pa_projects_all.name%type;
3058: l_project_number pa_projects_all.segment1%type;
3059: l_ci_type_id pa_ci_types_b.ci_type_id%type;
3060: l_summary pa_control_items.summary%type;
3061: l_ci_number pa_control_items.ci_number%type;
3062: l_description pa_control_items.description%type;
3063: l_status_code pa_project_statuses.project_status_code%type;
3064: l_status pa_project_statuses.project_status_name%type;
3065: l_owner_id pa_control_items.owner_id%type;

Line 3062: l_description pa_control_items.description%type;

3058: l_project_number pa_projects_all.segment1%type;
3059: l_ci_type_id pa_ci_types_b.ci_type_id%type;
3060: l_summary pa_control_items.summary%type;
3061: l_ci_number pa_control_items.ci_number%type;
3062: l_description pa_control_items.description%type;
3063: l_status_code pa_project_statuses.project_status_code%type;
3064: l_status pa_project_statuses.project_status_name%type;
3065: l_owner_id pa_control_items.owner_id%type;
3066: l_progress_status_code pa_control_items.progress_status_code%type;

Line 3065: l_owner_id pa_control_items.owner_id%type;

3061: l_ci_number pa_control_items.ci_number%type;
3062: l_description pa_control_items.description%type;
3063: l_status_code pa_project_statuses.project_status_code%type;
3064: l_status pa_project_statuses.project_status_name%type;
3065: l_owner_id pa_control_items.owner_id%type;
3066: l_progress_status_code pa_control_items.progress_status_code%type;
3067: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
3068: l_status_overview pa_control_items.status_overview%type;
3069: l_classification_code pa_control_items.classification_code_id%type;

Line 3066: l_progress_status_code pa_control_items.progress_status_code%type;

3062: l_description pa_control_items.description%type;
3063: l_status_code pa_project_statuses.project_status_code%type;
3064: l_status pa_project_statuses.project_status_name%type;
3065: l_owner_id pa_control_items.owner_id%type;
3066: l_progress_status_code pa_control_items.progress_status_code%type;
3067: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
3068: l_status_overview pa_control_items.status_overview%type;
3069: l_classification_code pa_control_items.classification_code_id%type;
3070: l_reason_code pa_control_items.reason_code_id%type;

Line 3067: l_progress_as_of_date pa_control_items.progress_as_of_date%type;

3063: l_status_code pa_project_statuses.project_status_code%type;
3064: l_status pa_project_statuses.project_status_name%type;
3065: l_owner_id pa_control_items.owner_id%type;
3066: l_progress_status_code pa_control_items.progress_status_code%type;
3067: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
3068: l_status_overview pa_control_items.status_overview%type;
3069: l_classification_code pa_control_items.classification_code_id%type;
3070: l_reason_code pa_control_items.reason_code_id%type;
3071: l_object_id pa_control_items.object_id%type;

Line 3068: l_status_overview pa_control_items.status_overview%type;

3064: l_status pa_project_statuses.project_status_name%type;
3065: l_owner_id pa_control_items.owner_id%type;
3066: l_progress_status_code pa_control_items.progress_status_code%type;
3067: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
3068: l_status_overview pa_control_items.status_overview%type;
3069: l_classification_code pa_control_items.classification_code_id%type;
3070: l_reason_code pa_control_items.reason_code_id%type;
3071: l_object_id pa_control_items.object_id%type;
3072: l_object_type pa_control_items.object_type%type;

Line 3069: l_classification_code pa_control_items.classification_code_id%type;

3065: l_owner_id pa_control_items.owner_id%type;
3066: l_progress_status_code pa_control_items.progress_status_code%type;
3067: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
3068: l_status_overview pa_control_items.status_overview%type;
3069: l_classification_code pa_control_items.classification_code_id%type;
3070: l_reason_code pa_control_items.reason_code_id%type;
3071: l_object_id pa_control_items.object_id%type;
3072: l_object_type pa_control_items.object_type%type;
3073: l_date_required pa_control_items.date_required%type;

Line 3070: l_reason_code pa_control_items.reason_code_id%type;

3066: l_progress_status_code pa_control_items.progress_status_code%type;
3067: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
3068: l_status_overview pa_control_items.status_overview%type;
3069: l_classification_code pa_control_items.classification_code_id%type;
3070: l_reason_code pa_control_items.reason_code_id%type;
3071: l_object_id pa_control_items.object_id%type;
3072: l_object_type pa_control_items.object_type%type;
3073: l_date_required pa_control_items.date_required%type;
3074: l_date_closed pa_control_items.date_closed%type;

Line 3071: l_object_id pa_control_items.object_id%type;

3067: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
3068: l_status_overview pa_control_items.status_overview%type;
3069: l_classification_code pa_control_items.classification_code_id%type;
3070: l_reason_code pa_control_items.reason_code_id%type;
3071: l_object_id pa_control_items.object_id%type;
3072: l_object_type pa_control_items.object_type%type;
3073: l_date_required pa_control_items.date_required%type;
3074: l_date_closed pa_control_items.date_closed%type;
3075: l_closed_by_id pa_control_items.closed_by_id%type;

Line 3072: l_object_type pa_control_items.object_type%type;

3068: l_status_overview pa_control_items.status_overview%type;
3069: l_classification_code pa_control_items.classification_code_id%type;
3070: l_reason_code pa_control_items.reason_code_id%type;
3071: l_object_id pa_control_items.object_id%type;
3072: l_object_type pa_control_items.object_type%type;
3073: l_date_required pa_control_items.date_required%type;
3074: l_date_closed pa_control_items.date_closed%type;
3075: l_closed_by_id pa_control_items.closed_by_id%type;
3076: l_resolution pa_control_items.resolution%type;

Line 3073: l_date_required pa_control_items.date_required%type;

3069: l_classification_code pa_control_items.classification_code_id%type;
3070: l_reason_code pa_control_items.reason_code_id%type;
3071: l_object_id pa_control_items.object_id%type;
3072: l_object_type pa_control_items.object_type%type;
3073: l_date_required pa_control_items.date_required%type;
3074: l_date_closed pa_control_items.date_closed%type;
3075: l_closed_by_id pa_control_items.closed_by_id%type;
3076: l_resolution pa_control_items.resolution%type;
3077: l_resolution_code pa_control_items.resolution_code_id%type;

Line 3074: l_date_closed pa_control_items.date_closed%type;

3070: l_reason_code pa_control_items.reason_code_id%type;
3071: l_object_id pa_control_items.object_id%type;
3072: l_object_type pa_control_items.object_type%type;
3073: l_date_required pa_control_items.date_required%type;
3074: l_date_closed pa_control_items.date_closed%type;
3075: l_closed_by_id pa_control_items.closed_by_id%type;
3076: l_resolution pa_control_items.resolution%type;
3077: l_resolution_code pa_control_items.resolution_code_id%type;
3078: l_priority_code pa_control_items.priority_code%type;

Line 3075: l_closed_by_id pa_control_items.closed_by_id%type;

3071: l_object_id pa_control_items.object_id%type;
3072: l_object_type pa_control_items.object_type%type;
3073: l_date_required pa_control_items.date_required%type;
3074: l_date_closed pa_control_items.date_closed%type;
3075: l_closed_by_id pa_control_items.closed_by_id%type;
3076: l_resolution pa_control_items.resolution%type;
3077: l_resolution_code pa_control_items.resolution_code_id%type;
3078: l_priority_code pa_control_items.priority_code%type;
3079: l_effort_level_code pa_control_items.effort_level_code%type;

Line 3076: l_resolution pa_control_items.resolution%type;

3072: l_object_type pa_control_items.object_type%type;
3073: l_date_required pa_control_items.date_required%type;
3074: l_date_closed pa_control_items.date_closed%type;
3075: l_closed_by_id pa_control_items.closed_by_id%type;
3076: l_resolution pa_control_items.resolution%type;
3077: l_resolution_code pa_control_items.resolution_code_id%type;
3078: l_priority_code pa_control_items.priority_code%type;
3079: l_effort_level_code pa_control_items.effort_level_code%type;
3080: l_price pa_control_items.price%type;

Line 3077: l_resolution_code pa_control_items.resolution_code_id%type;

3073: l_date_required pa_control_items.date_required%type;
3074: l_date_closed pa_control_items.date_closed%type;
3075: l_closed_by_id pa_control_items.closed_by_id%type;
3076: l_resolution pa_control_items.resolution%type;
3077: l_resolution_code pa_control_items.resolution_code_id%type;
3078: l_priority_code pa_control_items.priority_code%type;
3079: l_effort_level_code pa_control_items.effort_level_code%type;
3080: l_price pa_control_items.price%type;
3081: l_price_currency_code pa_control_items.price_currency_code%type;

Line 3078: l_priority_code pa_control_items.priority_code%type;

3074: l_date_closed pa_control_items.date_closed%type;
3075: l_closed_by_id pa_control_items.closed_by_id%type;
3076: l_resolution pa_control_items.resolution%type;
3077: l_resolution_code pa_control_items.resolution_code_id%type;
3078: l_priority_code pa_control_items.priority_code%type;
3079: l_effort_level_code pa_control_items.effort_level_code%type;
3080: l_price pa_control_items.price%type;
3081: l_price_currency_code pa_control_items.price_currency_code%type;
3082: l_source_type_name pa_lookups.meaning%type;

Line 3079: l_effort_level_code pa_control_items.effort_level_code%type;

3075: l_closed_by_id pa_control_items.closed_by_id%type;
3076: l_resolution pa_control_items.resolution%type;
3077: l_resolution_code pa_control_items.resolution_code_id%type;
3078: l_priority_code pa_control_items.priority_code%type;
3079: l_effort_level_code pa_control_items.effort_level_code%type;
3080: l_price pa_control_items.price%type;
3081: l_price_currency_code pa_control_items.price_currency_code%type;
3082: l_source_type_name pa_lookups.meaning%type;
3083: l_source_type_code pa_control_items.source_type_code%type;

Line 3080: l_price pa_control_items.price%type;

3076: l_resolution pa_control_items.resolution%type;
3077: l_resolution_code pa_control_items.resolution_code_id%type;
3078: l_priority_code pa_control_items.priority_code%type;
3079: l_effort_level_code pa_control_items.effort_level_code%type;
3080: l_price pa_control_items.price%type;
3081: l_price_currency_code pa_control_items.price_currency_code%type;
3082: l_source_type_name pa_lookups.meaning%type;
3083: l_source_type_code pa_control_items.source_type_code%type;
3084: l_source_number pa_control_items.source_number%type;

Line 3081: l_price_currency_code pa_control_items.price_currency_code%type;

3077: l_resolution_code pa_control_items.resolution_code_id%type;
3078: l_priority_code pa_control_items.priority_code%type;
3079: l_effort_level_code pa_control_items.effort_level_code%type;
3080: l_price pa_control_items.price%type;
3081: l_price_currency_code pa_control_items.price_currency_code%type;
3082: l_source_type_name pa_lookups.meaning%type;
3083: l_source_type_code pa_control_items.source_type_code%type;
3084: l_source_number pa_control_items.source_number%type;
3085: l_source_comment pa_control_items.source_comment%type;

Line 3083: l_source_type_code pa_control_items.source_type_code%type;

3079: l_effort_level_code pa_control_items.effort_level_code%type;
3080: l_price pa_control_items.price%type;
3081: l_price_currency_code pa_control_items.price_currency_code%type;
3082: l_source_type_name pa_lookups.meaning%type;
3083: l_source_type_code pa_control_items.source_type_code%type;
3084: l_source_number pa_control_items.source_number%type;
3085: l_source_comment pa_control_items.source_comment%type;
3086: l_source_date_received pa_control_items.source_date_received%type;
3087: l_source_organization pa_control_items.source_organization%type;

Line 3084: l_source_number pa_control_items.source_number%type;

3080: l_price pa_control_items.price%type;
3081: l_price_currency_code pa_control_items.price_currency_code%type;
3082: l_source_type_name pa_lookups.meaning%type;
3083: l_source_type_code pa_control_items.source_type_code%type;
3084: l_source_number pa_control_items.source_number%type;
3085: l_source_comment pa_control_items.source_comment%type;
3086: l_source_date_received pa_control_items.source_date_received%type;
3087: l_source_organization pa_control_items.source_organization%type;
3088: l_source_person pa_control_items.source_person%type;

Line 3085: l_source_comment pa_control_items.source_comment%type;

3081: l_price_currency_code pa_control_items.price_currency_code%type;
3082: l_source_type_name pa_lookups.meaning%type;
3083: l_source_type_code pa_control_items.source_type_code%type;
3084: l_source_number pa_control_items.source_number%type;
3085: l_source_comment pa_control_items.source_comment%type;
3086: l_source_date_received pa_control_items.source_date_received%type;
3087: l_source_organization pa_control_items.source_organization%type;
3088: l_source_person pa_control_items.source_person%type;
3089: l_attribute_category pa_control_items.attribute_category%type;

Line 3086: l_source_date_received pa_control_items.source_date_received%type;

3082: l_source_type_name pa_lookups.meaning%type;
3083: l_source_type_code pa_control_items.source_type_code%type;
3084: l_source_number pa_control_items.source_number%type;
3085: l_source_comment pa_control_items.source_comment%type;
3086: l_source_date_received pa_control_items.source_date_received%type;
3087: l_source_organization pa_control_items.source_organization%type;
3088: l_source_person pa_control_items.source_person%type;
3089: l_attribute_category pa_control_items.attribute_category%type;
3090: l_attribute1 pa_control_items.attribute1%type;

Line 3087: l_source_organization pa_control_items.source_organization%type;

3083: l_source_type_code pa_control_items.source_type_code%type;
3084: l_source_number pa_control_items.source_number%type;
3085: l_source_comment pa_control_items.source_comment%type;
3086: l_source_date_received pa_control_items.source_date_received%type;
3087: l_source_organization pa_control_items.source_organization%type;
3088: l_source_person pa_control_items.source_person%type;
3089: l_attribute_category pa_control_items.attribute_category%type;
3090: l_attribute1 pa_control_items.attribute1%type;
3091: l_attribute2 pa_control_items.attribute1%type;

Line 3088: l_source_person pa_control_items.source_person%type;

3084: l_source_number pa_control_items.source_number%type;
3085: l_source_comment pa_control_items.source_comment%type;
3086: l_source_date_received pa_control_items.source_date_received%type;
3087: l_source_organization pa_control_items.source_organization%type;
3088: l_source_person pa_control_items.source_person%type;
3089: l_attribute_category pa_control_items.attribute_category%type;
3090: l_attribute1 pa_control_items.attribute1%type;
3091: l_attribute2 pa_control_items.attribute1%type;
3092: l_attribute3 pa_control_items.attribute1%type;

Line 3089: l_attribute_category pa_control_items.attribute_category%type;

3085: l_source_comment pa_control_items.source_comment%type;
3086: l_source_date_received pa_control_items.source_date_received%type;
3087: l_source_organization pa_control_items.source_organization%type;
3088: l_source_person pa_control_items.source_person%type;
3089: l_attribute_category pa_control_items.attribute_category%type;
3090: l_attribute1 pa_control_items.attribute1%type;
3091: l_attribute2 pa_control_items.attribute1%type;
3092: l_attribute3 pa_control_items.attribute1%type;
3093: l_attribute4 pa_control_items.attribute1%type;

Line 3090: l_attribute1 pa_control_items.attribute1%type;

3086: l_source_date_received pa_control_items.source_date_received%type;
3087: l_source_organization pa_control_items.source_organization%type;
3088: l_source_person pa_control_items.source_person%type;
3089: l_attribute_category pa_control_items.attribute_category%type;
3090: l_attribute1 pa_control_items.attribute1%type;
3091: l_attribute2 pa_control_items.attribute1%type;
3092: l_attribute3 pa_control_items.attribute1%type;
3093: l_attribute4 pa_control_items.attribute1%type;
3094: l_attribute5 pa_control_items.attribute1%type;

Line 3091: l_attribute2 pa_control_items.attribute1%type;

3087: l_source_organization pa_control_items.source_organization%type;
3088: l_source_person pa_control_items.source_person%type;
3089: l_attribute_category pa_control_items.attribute_category%type;
3090: l_attribute1 pa_control_items.attribute1%type;
3091: l_attribute2 pa_control_items.attribute1%type;
3092: l_attribute3 pa_control_items.attribute1%type;
3093: l_attribute4 pa_control_items.attribute1%type;
3094: l_attribute5 pa_control_items.attribute1%type;
3095: l_attribute6 pa_control_items.attribute1%type;

Line 3092: l_attribute3 pa_control_items.attribute1%type;

3088: l_source_person pa_control_items.source_person%type;
3089: l_attribute_category pa_control_items.attribute_category%type;
3090: l_attribute1 pa_control_items.attribute1%type;
3091: l_attribute2 pa_control_items.attribute1%type;
3092: l_attribute3 pa_control_items.attribute1%type;
3093: l_attribute4 pa_control_items.attribute1%type;
3094: l_attribute5 pa_control_items.attribute1%type;
3095: l_attribute6 pa_control_items.attribute1%type;
3096: l_attribute7 pa_control_items.attribute1%type;

Line 3093: l_attribute4 pa_control_items.attribute1%type;

3089: l_attribute_category pa_control_items.attribute_category%type;
3090: l_attribute1 pa_control_items.attribute1%type;
3091: l_attribute2 pa_control_items.attribute1%type;
3092: l_attribute3 pa_control_items.attribute1%type;
3093: l_attribute4 pa_control_items.attribute1%type;
3094: l_attribute5 pa_control_items.attribute1%type;
3095: l_attribute6 pa_control_items.attribute1%type;
3096: l_attribute7 pa_control_items.attribute1%type;
3097: l_attribute8 pa_control_items.attribute1%type;

Line 3094: l_attribute5 pa_control_items.attribute1%type;

3090: l_attribute1 pa_control_items.attribute1%type;
3091: l_attribute2 pa_control_items.attribute1%type;
3092: l_attribute3 pa_control_items.attribute1%type;
3093: l_attribute4 pa_control_items.attribute1%type;
3094: l_attribute5 pa_control_items.attribute1%type;
3095: l_attribute6 pa_control_items.attribute1%type;
3096: l_attribute7 pa_control_items.attribute1%type;
3097: l_attribute8 pa_control_items.attribute1%type;
3098: l_attribute9 pa_control_items.attribute1%type;

Line 3095: l_attribute6 pa_control_items.attribute1%type;

3091: l_attribute2 pa_control_items.attribute1%type;
3092: l_attribute3 pa_control_items.attribute1%type;
3093: l_attribute4 pa_control_items.attribute1%type;
3094: l_attribute5 pa_control_items.attribute1%type;
3095: l_attribute6 pa_control_items.attribute1%type;
3096: l_attribute7 pa_control_items.attribute1%type;
3097: l_attribute8 pa_control_items.attribute1%type;
3098: l_attribute9 pa_control_items.attribute1%type;
3099: l_attribute10 pa_control_items.attribute1%type;

Line 3096: l_attribute7 pa_control_items.attribute1%type;

3092: l_attribute3 pa_control_items.attribute1%type;
3093: l_attribute4 pa_control_items.attribute1%type;
3094: l_attribute5 pa_control_items.attribute1%type;
3095: l_attribute6 pa_control_items.attribute1%type;
3096: l_attribute7 pa_control_items.attribute1%type;
3097: l_attribute8 pa_control_items.attribute1%type;
3098: l_attribute9 pa_control_items.attribute1%type;
3099: l_attribute10 pa_control_items.attribute1%type;
3100: l_attribute11 pa_control_items.attribute1%type;

Line 3097: l_attribute8 pa_control_items.attribute1%type;

3093: l_attribute4 pa_control_items.attribute1%type;
3094: l_attribute5 pa_control_items.attribute1%type;
3095: l_attribute6 pa_control_items.attribute1%type;
3096: l_attribute7 pa_control_items.attribute1%type;
3097: l_attribute8 pa_control_items.attribute1%type;
3098: l_attribute9 pa_control_items.attribute1%type;
3099: l_attribute10 pa_control_items.attribute1%type;
3100: l_attribute11 pa_control_items.attribute1%type;
3101: l_attribute12 pa_control_items.attribute1%type;

Line 3098: l_attribute9 pa_control_items.attribute1%type;

3094: l_attribute5 pa_control_items.attribute1%type;
3095: l_attribute6 pa_control_items.attribute1%type;
3096: l_attribute7 pa_control_items.attribute1%type;
3097: l_attribute8 pa_control_items.attribute1%type;
3098: l_attribute9 pa_control_items.attribute1%type;
3099: l_attribute10 pa_control_items.attribute1%type;
3100: l_attribute11 pa_control_items.attribute1%type;
3101: l_attribute12 pa_control_items.attribute1%type;
3102: l_attribute13 pa_control_items.attribute1%type;

Line 3099: l_attribute10 pa_control_items.attribute1%type;

3095: l_attribute6 pa_control_items.attribute1%type;
3096: l_attribute7 pa_control_items.attribute1%type;
3097: l_attribute8 pa_control_items.attribute1%type;
3098: l_attribute9 pa_control_items.attribute1%type;
3099: l_attribute10 pa_control_items.attribute1%type;
3100: l_attribute11 pa_control_items.attribute1%type;
3101: l_attribute12 pa_control_items.attribute1%type;
3102: l_attribute13 pa_control_items.attribute1%type;
3103: l_attribute14 pa_control_items.attribute1%type;

Line 3100: l_attribute11 pa_control_items.attribute1%type;

3096: l_attribute7 pa_control_items.attribute1%type;
3097: l_attribute8 pa_control_items.attribute1%type;
3098: l_attribute9 pa_control_items.attribute1%type;
3099: l_attribute10 pa_control_items.attribute1%type;
3100: l_attribute11 pa_control_items.attribute1%type;
3101: l_attribute12 pa_control_items.attribute1%type;
3102: l_attribute13 pa_control_items.attribute1%type;
3103: l_attribute14 pa_control_items.attribute1%type;
3104: l_attribute15 pa_control_items.attribute1%type;

Line 3101: l_attribute12 pa_control_items.attribute1%type;

3097: l_attribute8 pa_control_items.attribute1%type;
3098: l_attribute9 pa_control_items.attribute1%type;
3099: l_attribute10 pa_control_items.attribute1%type;
3100: l_attribute11 pa_control_items.attribute1%type;
3101: l_attribute12 pa_control_items.attribute1%type;
3102: l_attribute13 pa_control_items.attribute1%type;
3103: l_attribute14 pa_control_items.attribute1%type;
3104: l_attribute15 pa_control_items.attribute1%type;
3105: l_class_code constant varchar2(20) := 'CHANGE_REQUEST';

Line 3102: l_attribute13 pa_control_items.attribute1%type;

3098: l_attribute9 pa_control_items.attribute1%type;
3099: l_attribute10 pa_control_items.attribute1%type;
3100: l_attribute11 pa_control_items.attribute1%type;
3101: l_attribute12 pa_control_items.attribute1%type;
3102: l_attribute13 pa_control_items.attribute1%type;
3103: l_attribute14 pa_control_items.attribute1%type;
3104: l_attribute15 pa_control_items.attribute1%type;
3105: l_class_code constant varchar2(20) := 'CHANGE_REQUEST';
3106:

Line 3103: l_attribute14 pa_control_items.attribute1%type;

3099: l_attribute10 pa_control_items.attribute1%type;
3100: l_attribute11 pa_control_items.attribute1%type;
3101: l_attribute12 pa_control_items.attribute1%type;
3102: l_attribute13 pa_control_items.attribute1%type;
3103: l_attribute14 pa_control_items.attribute1%type;
3104: l_attribute15 pa_control_items.attribute1%type;
3105: l_class_code constant varchar2(20) := 'CHANGE_REQUEST';
3106:
3107: BEGIN

Line 3104: l_attribute15 pa_control_items.attribute1%type;

3100: l_attribute11 pa_control_items.attribute1%type;
3101: l_attribute12 pa_control_items.attribute1%type;
3102: l_attribute13 pa_control_items.attribute1%type;
3103: l_attribute14 pa_control_items.attribute1%type;
3104: l_attribute15 pa_control_items.attribute1%type;
3105: l_class_code constant varchar2(20) := 'CHANGE_REQUEST';
3106:
3107: BEGIN
3108:

Line 3695: l_summary pa_control_items.summary%type;

3691: l_project_id pa_projects_all.project_id%type;
3692: l_project_name pa_projects_all.name%type;
3693: l_project_number pa_projects_all.segment1%type;
3694: l_ci_type_id pa_ci_types_b.ci_type_id%type;
3695: l_summary pa_control_items.summary%type;
3696: l_ci_number pa_control_items.ci_number%type;
3697: l_description pa_control_items.description%type;
3698: l_status_code pa_project_statuses.project_status_code%type;
3699: l_status pa_project_statuses.project_status_name%type;

Line 3696: l_ci_number pa_control_items.ci_number%type;

3692: l_project_name pa_projects_all.name%type;
3693: l_project_number pa_projects_all.segment1%type;
3694: l_ci_type_id pa_ci_types_b.ci_type_id%type;
3695: l_summary pa_control_items.summary%type;
3696: l_ci_number pa_control_items.ci_number%type;
3697: l_description pa_control_items.description%type;
3698: l_status_code pa_project_statuses.project_status_code%type;
3699: l_status pa_project_statuses.project_status_name%type;
3700: l_owner_id pa_control_items.owner_id%type;

Line 3697: l_description pa_control_items.description%type;

3693: l_project_number pa_projects_all.segment1%type;
3694: l_ci_type_id pa_ci_types_b.ci_type_id%type;
3695: l_summary pa_control_items.summary%type;
3696: l_ci_number pa_control_items.ci_number%type;
3697: l_description pa_control_items.description%type;
3698: l_status_code pa_project_statuses.project_status_code%type;
3699: l_status pa_project_statuses.project_status_name%type;
3700: l_owner_id pa_control_items.owner_id%type;
3701: l_progress_status_code pa_control_items.progress_status_code%type;

Line 3700: l_owner_id pa_control_items.owner_id%type;

3696: l_ci_number pa_control_items.ci_number%type;
3697: l_description pa_control_items.description%type;
3698: l_status_code pa_project_statuses.project_status_code%type;
3699: l_status pa_project_statuses.project_status_name%type;
3700: l_owner_id pa_control_items.owner_id%type;
3701: l_progress_status_code pa_control_items.progress_status_code%type;
3702: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
3703: l_status_overview pa_control_items.status_overview%type;
3704: l_classification_code pa_control_items.classification_code_id%type;

Line 3701: l_progress_status_code pa_control_items.progress_status_code%type;

3697: l_description pa_control_items.description%type;
3698: l_status_code pa_project_statuses.project_status_code%type;
3699: l_status pa_project_statuses.project_status_name%type;
3700: l_owner_id pa_control_items.owner_id%type;
3701: l_progress_status_code pa_control_items.progress_status_code%type;
3702: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
3703: l_status_overview pa_control_items.status_overview%type;
3704: l_classification_code pa_control_items.classification_code_id%type;
3705: l_reason_code pa_control_items.reason_code_id%type;

Line 3702: l_progress_as_of_date pa_control_items.progress_as_of_date%type;

3698: l_status_code pa_project_statuses.project_status_code%type;
3699: l_status pa_project_statuses.project_status_name%type;
3700: l_owner_id pa_control_items.owner_id%type;
3701: l_progress_status_code pa_control_items.progress_status_code%type;
3702: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
3703: l_status_overview pa_control_items.status_overview%type;
3704: l_classification_code pa_control_items.classification_code_id%type;
3705: l_reason_code pa_control_items.reason_code_id%type;
3706: l_object_id pa_control_items.object_id%type;

Line 3703: l_status_overview pa_control_items.status_overview%type;

3699: l_status pa_project_statuses.project_status_name%type;
3700: l_owner_id pa_control_items.owner_id%type;
3701: l_progress_status_code pa_control_items.progress_status_code%type;
3702: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
3703: l_status_overview pa_control_items.status_overview%type;
3704: l_classification_code pa_control_items.classification_code_id%type;
3705: l_reason_code pa_control_items.reason_code_id%type;
3706: l_object_id pa_control_items.object_id%type;
3707: l_object_type pa_control_items.object_type%type;

Line 3704: l_classification_code pa_control_items.classification_code_id%type;

3700: l_owner_id pa_control_items.owner_id%type;
3701: l_progress_status_code pa_control_items.progress_status_code%type;
3702: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
3703: l_status_overview pa_control_items.status_overview%type;
3704: l_classification_code pa_control_items.classification_code_id%type;
3705: l_reason_code pa_control_items.reason_code_id%type;
3706: l_object_id pa_control_items.object_id%type;
3707: l_object_type pa_control_items.object_type%type;
3708: l_date_required pa_control_items.date_required%type;

Line 3705: l_reason_code pa_control_items.reason_code_id%type;

3701: l_progress_status_code pa_control_items.progress_status_code%type;
3702: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
3703: l_status_overview pa_control_items.status_overview%type;
3704: l_classification_code pa_control_items.classification_code_id%type;
3705: l_reason_code pa_control_items.reason_code_id%type;
3706: l_object_id pa_control_items.object_id%type;
3707: l_object_type pa_control_items.object_type%type;
3708: l_date_required pa_control_items.date_required%type;
3709: l_date_closed pa_control_items.date_closed%type;

Line 3706: l_object_id pa_control_items.object_id%type;

3702: l_progress_as_of_date pa_control_items.progress_as_of_date%type;
3703: l_status_overview pa_control_items.status_overview%type;
3704: l_classification_code pa_control_items.classification_code_id%type;
3705: l_reason_code pa_control_items.reason_code_id%type;
3706: l_object_id pa_control_items.object_id%type;
3707: l_object_type pa_control_items.object_type%type;
3708: l_date_required pa_control_items.date_required%type;
3709: l_date_closed pa_control_items.date_closed%type;
3710: l_closed_by_id pa_control_items.closed_by_id%type;

Line 3707: l_object_type pa_control_items.object_type%type;

3703: l_status_overview pa_control_items.status_overview%type;
3704: l_classification_code pa_control_items.classification_code_id%type;
3705: l_reason_code pa_control_items.reason_code_id%type;
3706: l_object_id pa_control_items.object_id%type;
3707: l_object_type pa_control_items.object_type%type;
3708: l_date_required pa_control_items.date_required%type;
3709: l_date_closed pa_control_items.date_closed%type;
3710: l_closed_by_id pa_control_items.closed_by_id%type;
3711: l_resolution pa_control_items.resolution%type;

Line 3708: l_date_required pa_control_items.date_required%type;

3704: l_classification_code pa_control_items.classification_code_id%type;
3705: l_reason_code pa_control_items.reason_code_id%type;
3706: l_object_id pa_control_items.object_id%type;
3707: l_object_type pa_control_items.object_type%type;
3708: l_date_required pa_control_items.date_required%type;
3709: l_date_closed pa_control_items.date_closed%type;
3710: l_closed_by_id pa_control_items.closed_by_id%type;
3711: l_resolution pa_control_items.resolution%type;
3712: l_resolution_code pa_control_items.resolution_code_id%type;

Line 3709: l_date_closed pa_control_items.date_closed%type;

3705: l_reason_code pa_control_items.reason_code_id%type;
3706: l_object_id pa_control_items.object_id%type;
3707: l_object_type pa_control_items.object_type%type;
3708: l_date_required pa_control_items.date_required%type;
3709: l_date_closed pa_control_items.date_closed%type;
3710: l_closed_by_id pa_control_items.closed_by_id%type;
3711: l_resolution pa_control_items.resolution%type;
3712: l_resolution_code pa_control_items.resolution_code_id%type;
3713: l_priority_code pa_control_items.priority_code%type;

Line 3710: l_closed_by_id pa_control_items.closed_by_id%type;

3706: l_object_id pa_control_items.object_id%type;
3707: l_object_type pa_control_items.object_type%type;
3708: l_date_required pa_control_items.date_required%type;
3709: l_date_closed pa_control_items.date_closed%type;
3710: l_closed_by_id pa_control_items.closed_by_id%type;
3711: l_resolution pa_control_items.resolution%type;
3712: l_resolution_code pa_control_items.resolution_code_id%type;
3713: l_priority_code pa_control_items.priority_code%type;
3714: l_effort_level_code pa_control_items.effort_level_code%type;

Line 3711: l_resolution pa_control_items.resolution%type;

3707: l_object_type pa_control_items.object_type%type;
3708: l_date_required pa_control_items.date_required%type;
3709: l_date_closed pa_control_items.date_closed%type;
3710: l_closed_by_id pa_control_items.closed_by_id%type;
3711: l_resolution pa_control_items.resolution%type;
3712: l_resolution_code pa_control_items.resolution_code_id%type;
3713: l_priority_code pa_control_items.priority_code%type;
3714: l_effort_level_code pa_control_items.effort_level_code%type;
3715: l_price pa_control_items.price%type;

Line 3712: l_resolution_code pa_control_items.resolution_code_id%type;

3708: l_date_required pa_control_items.date_required%type;
3709: l_date_closed pa_control_items.date_closed%type;
3710: l_closed_by_id pa_control_items.closed_by_id%type;
3711: l_resolution pa_control_items.resolution%type;
3712: l_resolution_code pa_control_items.resolution_code_id%type;
3713: l_priority_code pa_control_items.priority_code%type;
3714: l_effort_level_code pa_control_items.effort_level_code%type;
3715: l_price pa_control_items.price%type;
3716: l_price_currency_code pa_control_items.price_currency_code%type;

Line 3713: l_priority_code pa_control_items.priority_code%type;

3709: l_date_closed pa_control_items.date_closed%type;
3710: l_closed_by_id pa_control_items.closed_by_id%type;
3711: l_resolution pa_control_items.resolution%type;
3712: l_resolution_code pa_control_items.resolution_code_id%type;
3713: l_priority_code pa_control_items.priority_code%type;
3714: l_effort_level_code pa_control_items.effort_level_code%type;
3715: l_price pa_control_items.price%type;
3716: l_price_currency_code pa_control_items.price_currency_code%type;
3717: l_source_type_name pa_lookups.meaning%type;

Line 3714: l_effort_level_code pa_control_items.effort_level_code%type;

3710: l_closed_by_id pa_control_items.closed_by_id%type;
3711: l_resolution pa_control_items.resolution%type;
3712: l_resolution_code pa_control_items.resolution_code_id%type;
3713: l_priority_code pa_control_items.priority_code%type;
3714: l_effort_level_code pa_control_items.effort_level_code%type;
3715: l_price pa_control_items.price%type;
3716: l_price_currency_code pa_control_items.price_currency_code%type;
3717: l_source_type_name pa_lookups.meaning%type;
3718: l_source_type_code pa_control_items.source_type_code%type;

Line 3715: l_price pa_control_items.price%type;

3711: l_resolution pa_control_items.resolution%type;
3712: l_resolution_code pa_control_items.resolution_code_id%type;
3713: l_priority_code pa_control_items.priority_code%type;
3714: l_effort_level_code pa_control_items.effort_level_code%type;
3715: l_price pa_control_items.price%type;
3716: l_price_currency_code pa_control_items.price_currency_code%type;
3717: l_source_type_name pa_lookups.meaning%type;
3718: l_source_type_code pa_control_items.source_type_code%type;
3719: l_source_number pa_control_items.source_number%type;

Line 3716: l_price_currency_code pa_control_items.price_currency_code%type;

3712: l_resolution_code pa_control_items.resolution_code_id%type;
3713: l_priority_code pa_control_items.priority_code%type;
3714: l_effort_level_code pa_control_items.effort_level_code%type;
3715: l_price pa_control_items.price%type;
3716: l_price_currency_code pa_control_items.price_currency_code%type;
3717: l_source_type_name pa_lookups.meaning%type;
3718: l_source_type_code pa_control_items.source_type_code%type;
3719: l_source_number pa_control_items.source_number%type;
3720: l_source_comment pa_control_items.source_comment%type;

Line 3718: l_source_type_code pa_control_items.source_type_code%type;

3714: l_effort_level_code pa_control_items.effort_level_code%type;
3715: l_price pa_control_items.price%type;
3716: l_price_currency_code pa_control_items.price_currency_code%type;
3717: l_source_type_name pa_lookups.meaning%type;
3718: l_source_type_code pa_control_items.source_type_code%type;
3719: l_source_number pa_control_items.source_number%type;
3720: l_source_comment pa_control_items.source_comment%type;
3721: l_source_date_received pa_control_items.source_date_received%type;
3722: l_source_organization pa_control_items.source_organization%type;

Line 3719: l_source_number pa_control_items.source_number%type;

3715: l_price pa_control_items.price%type;
3716: l_price_currency_code pa_control_items.price_currency_code%type;
3717: l_source_type_name pa_lookups.meaning%type;
3718: l_source_type_code pa_control_items.source_type_code%type;
3719: l_source_number pa_control_items.source_number%type;
3720: l_source_comment pa_control_items.source_comment%type;
3721: l_source_date_received pa_control_items.source_date_received%type;
3722: l_source_organization pa_control_items.source_organization%type;
3723: l_source_person pa_control_items.source_person%type;

Line 3720: l_source_comment pa_control_items.source_comment%type;

3716: l_price_currency_code pa_control_items.price_currency_code%type;
3717: l_source_type_name pa_lookups.meaning%type;
3718: l_source_type_code pa_control_items.source_type_code%type;
3719: l_source_number pa_control_items.source_number%type;
3720: l_source_comment pa_control_items.source_comment%type;
3721: l_source_date_received pa_control_items.source_date_received%type;
3722: l_source_organization pa_control_items.source_organization%type;
3723: l_source_person pa_control_items.source_person%type;
3724: l_attribute_category pa_control_items.attribute_category%type;

Line 3721: l_source_date_received pa_control_items.source_date_received%type;

3717: l_source_type_name pa_lookups.meaning%type;
3718: l_source_type_code pa_control_items.source_type_code%type;
3719: l_source_number pa_control_items.source_number%type;
3720: l_source_comment pa_control_items.source_comment%type;
3721: l_source_date_received pa_control_items.source_date_received%type;
3722: l_source_organization pa_control_items.source_organization%type;
3723: l_source_person pa_control_items.source_person%type;
3724: l_attribute_category pa_control_items.attribute_category%type;
3725: l_attribute1 pa_control_items.attribute1%type;

Line 3722: l_source_organization pa_control_items.source_organization%type;

3718: l_source_type_code pa_control_items.source_type_code%type;
3719: l_source_number pa_control_items.source_number%type;
3720: l_source_comment pa_control_items.source_comment%type;
3721: l_source_date_received pa_control_items.source_date_received%type;
3722: l_source_organization pa_control_items.source_organization%type;
3723: l_source_person pa_control_items.source_person%type;
3724: l_attribute_category pa_control_items.attribute_category%type;
3725: l_attribute1 pa_control_items.attribute1%type;
3726: l_attribute2 pa_control_items.attribute1%type;

Line 3723: l_source_person pa_control_items.source_person%type;

3719: l_source_number pa_control_items.source_number%type;
3720: l_source_comment pa_control_items.source_comment%type;
3721: l_source_date_received pa_control_items.source_date_received%type;
3722: l_source_organization pa_control_items.source_organization%type;
3723: l_source_person pa_control_items.source_person%type;
3724: l_attribute_category pa_control_items.attribute_category%type;
3725: l_attribute1 pa_control_items.attribute1%type;
3726: l_attribute2 pa_control_items.attribute1%type;
3727: l_attribute3 pa_control_items.attribute1%type;

Line 3724: l_attribute_category pa_control_items.attribute_category%type;

3720: l_source_comment pa_control_items.source_comment%type;
3721: l_source_date_received pa_control_items.source_date_received%type;
3722: l_source_organization pa_control_items.source_organization%type;
3723: l_source_person pa_control_items.source_person%type;
3724: l_attribute_category pa_control_items.attribute_category%type;
3725: l_attribute1 pa_control_items.attribute1%type;
3726: l_attribute2 pa_control_items.attribute1%type;
3727: l_attribute3 pa_control_items.attribute1%type;
3728: l_attribute4 pa_control_items.attribute1%type;

Line 3725: l_attribute1 pa_control_items.attribute1%type;

3721: l_source_date_received pa_control_items.source_date_received%type;
3722: l_source_organization pa_control_items.source_organization%type;
3723: l_source_person pa_control_items.source_person%type;
3724: l_attribute_category pa_control_items.attribute_category%type;
3725: l_attribute1 pa_control_items.attribute1%type;
3726: l_attribute2 pa_control_items.attribute1%type;
3727: l_attribute3 pa_control_items.attribute1%type;
3728: l_attribute4 pa_control_items.attribute1%type;
3729: l_attribute5 pa_control_items.attribute1%type;

Line 3726: l_attribute2 pa_control_items.attribute1%type;

3722: l_source_organization pa_control_items.source_organization%type;
3723: l_source_person pa_control_items.source_person%type;
3724: l_attribute_category pa_control_items.attribute_category%type;
3725: l_attribute1 pa_control_items.attribute1%type;
3726: l_attribute2 pa_control_items.attribute1%type;
3727: l_attribute3 pa_control_items.attribute1%type;
3728: l_attribute4 pa_control_items.attribute1%type;
3729: l_attribute5 pa_control_items.attribute1%type;
3730: l_attribute6 pa_control_items.attribute1%type;

Line 3727: l_attribute3 pa_control_items.attribute1%type;

3723: l_source_person pa_control_items.source_person%type;
3724: l_attribute_category pa_control_items.attribute_category%type;
3725: l_attribute1 pa_control_items.attribute1%type;
3726: l_attribute2 pa_control_items.attribute1%type;
3727: l_attribute3 pa_control_items.attribute1%type;
3728: l_attribute4 pa_control_items.attribute1%type;
3729: l_attribute5 pa_control_items.attribute1%type;
3730: l_attribute6 pa_control_items.attribute1%type;
3731: l_attribute7 pa_control_items.attribute1%type;

Line 3728: l_attribute4 pa_control_items.attribute1%type;

3724: l_attribute_category pa_control_items.attribute_category%type;
3725: l_attribute1 pa_control_items.attribute1%type;
3726: l_attribute2 pa_control_items.attribute1%type;
3727: l_attribute3 pa_control_items.attribute1%type;
3728: l_attribute4 pa_control_items.attribute1%type;
3729: l_attribute5 pa_control_items.attribute1%type;
3730: l_attribute6 pa_control_items.attribute1%type;
3731: l_attribute7 pa_control_items.attribute1%type;
3732: l_attribute8 pa_control_items.attribute1%type;

Line 3729: l_attribute5 pa_control_items.attribute1%type;

3725: l_attribute1 pa_control_items.attribute1%type;
3726: l_attribute2 pa_control_items.attribute1%type;
3727: l_attribute3 pa_control_items.attribute1%type;
3728: l_attribute4 pa_control_items.attribute1%type;
3729: l_attribute5 pa_control_items.attribute1%type;
3730: l_attribute6 pa_control_items.attribute1%type;
3731: l_attribute7 pa_control_items.attribute1%type;
3732: l_attribute8 pa_control_items.attribute1%type;
3733: l_attribute9 pa_control_items.attribute1%type;

Line 3730: l_attribute6 pa_control_items.attribute1%type;

3726: l_attribute2 pa_control_items.attribute1%type;
3727: l_attribute3 pa_control_items.attribute1%type;
3728: l_attribute4 pa_control_items.attribute1%type;
3729: l_attribute5 pa_control_items.attribute1%type;
3730: l_attribute6 pa_control_items.attribute1%type;
3731: l_attribute7 pa_control_items.attribute1%type;
3732: l_attribute8 pa_control_items.attribute1%type;
3733: l_attribute9 pa_control_items.attribute1%type;
3734: l_attribute10 pa_control_items.attribute1%type;

Line 3731: l_attribute7 pa_control_items.attribute1%type;

3727: l_attribute3 pa_control_items.attribute1%type;
3728: l_attribute4 pa_control_items.attribute1%type;
3729: l_attribute5 pa_control_items.attribute1%type;
3730: l_attribute6 pa_control_items.attribute1%type;
3731: l_attribute7 pa_control_items.attribute1%type;
3732: l_attribute8 pa_control_items.attribute1%type;
3733: l_attribute9 pa_control_items.attribute1%type;
3734: l_attribute10 pa_control_items.attribute1%type;
3735: l_attribute11 pa_control_items.attribute1%type;

Line 3732: l_attribute8 pa_control_items.attribute1%type;

3728: l_attribute4 pa_control_items.attribute1%type;
3729: l_attribute5 pa_control_items.attribute1%type;
3730: l_attribute6 pa_control_items.attribute1%type;
3731: l_attribute7 pa_control_items.attribute1%type;
3732: l_attribute8 pa_control_items.attribute1%type;
3733: l_attribute9 pa_control_items.attribute1%type;
3734: l_attribute10 pa_control_items.attribute1%type;
3735: l_attribute11 pa_control_items.attribute1%type;
3736: l_attribute12 pa_control_items.attribute1%type;

Line 3733: l_attribute9 pa_control_items.attribute1%type;

3729: l_attribute5 pa_control_items.attribute1%type;
3730: l_attribute6 pa_control_items.attribute1%type;
3731: l_attribute7 pa_control_items.attribute1%type;
3732: l_attribute8 pa_control_items.attribute1%type;
3733: l_attribute9 pa_control_items.attribute1%type;
3734: l_attribute10 pa_control_items.attribute1%type;
3735: l_attribute11 pa_control_items.attribute1%type;
3736: l_attribute12 pa_control_items.attribute1%type;
3737: l_attribute13 pa_control_items.attribute1%type;

Line 3734: l_attribute10 pa_control_items.attribute1%type;

3730: l_attribute6 pa_control_items.attribute1%type;
3731: l_attribute7 pa_control_items.attribute1%type;
3732: l_attribute8 pa_control_items.attribute1%type;
3733: l_attribute9 pa_control_items.attribute1%type;
3734: l_attribute10 pa_control_items.attribute1%type;
3735: l_attribute11 pa_control_items.attribute1%type;
3736: l_attribute12 pa_control_items.attribute1%type;
3737: l_attribute13 pa_control_items.attribute1%type;
3738: l_attribute14 pa_control_items.attribute1%type;

Line 3735: l_attribute11 pa_control_items.attribute1%type;

3731: l_attribute7 pa_control_items.attribute1%type;
3732: l_attribute8 pa_control_items.attribute1%type;
3733: l_attribute9 pa_control_items.attribute1%type;
3734: l_attribute10 pa_control_items.attribute1%type;
3735: l_attribute11 pa_control_items.attribute1%type;
3736: l_attribute12 pa_control_items.attribute1%type;
3737: l_attribute13 pa_control_items.attribute1%type;
3738: l_attribute14 pa_control_items.attribute1%type;
3739: l_attribute15 pa_control_items.attribute1%type;

Line 3736: l_attribute12 pa_control_items.attribute1%type;

3732: l_attribute8 pa_control_items.attribute1%type;
3733: l_attribute9 pa_control_items.attribute1%type;
3734: l_attribute10 pa_control_items.attribute1%type;
3735: l_attribute11 pa_control_items.attribute1%type;
3736: l_attribute12 pa_control_items.attribute1%type;
3737: l_attribute13 pa_control_items.attribute1%type;
3738: l_attribute14 pa_control_items.attribute1%type;
3739: l_attribute15 pa_control_items.attribute1%type;
3740: l_class_code constant varchar2(20) := 'CHANGE_ORDER';

Line 3737: l_attribute13 pa_control_items.attribute1%type;

3733: l_attribute9 pa_control_items.attribute1%type;
3734: l_attribute10 pa_control_items.attribute1%type;
3735: l_attribute11 pa_control_items.attribute1%type;
3736: l_attribute12 pa_control_items.attribute1%type;
3737: l_attribute13 pa_control_items.attribute1%type;
3738: l_attribute14 pa_control_items.attribute1%type;
3739: l_attribute15 pa_control_items.attribute1%type;
3740: l_class_code constant varchar2(20) := 'CHANGE_ORDER';
3741:

Line 3738: l_attribute14 pa_control_items.attribute1%type;

3734: l_attribute10 pa_control_items.attribute1%type;
3735: l_attribute11 pa_control_items.attribute1%type;
3736: l_attribute12 pa_control_items.attribute1%type;
3737: l_attribute13 pa_control_items.attribute1%type;
3738: l_attribute14 pa_control_items.attribute1%type;
3739: l_attribute15 pa_control_items.attribute1%type;
3740: l_class_code constant varchar2(20) := 'CHANGE_ORDER';
3741:
3742: BEGIN

Line 3739: l_attribute15 pa_control_items.attribute1%type;

3735: l_attribute11 pa_control_items.attribute1%type;
3736: l_attribute12 pa_control_items.attribute1%type;
3737: l_attribute13 pa_control_items.attribute1%type;
3738: l_attribute14 pa_control_items.attribute1%type;
3739: l_attribute15 pa_control_items.attribute1%type;
3740: l_class_code constant varchar2(20) := 'CHANGE_ORDER';
3741:
3742: BEGIN
3743:

Line 4272: l_ci_id pa_control_items.ci_id%type;

4268: l_msg_data VARCHAR2(2000);
4269: l_msg_index_out NUMBER;
4270: l_module_name VARCHAR2(200);
4271: l_action_tbl ci_actions_in_tbl_type;
4272: l_ci_id pa_control_items.ci_id%type;
4273: l_project_id pa_control_items.project_id%type;
4274: BEGIN
4275:
4276: -- initialize the return status to success

Line 4273: l_project_id pa_control_items.project_id%type;

4269: l_msg_index_out NUMBER;
4270: l_module_name VARCHAR2(200);
4271: l_action_tbl ci_actions_in_tbl_type;
4272: l_ci_id pa_control_items.ci_id%type;
4273: l_project_id pa_control_items.project_id%type;
4274: BEGIN
4275:
4276: -- initialize the return status to success
4277: x_return_status := fnd_api.g_ret_sts_success;

Line 4494: l_project_id pa_control_items.project_id%TYPE;

4490: l_response_text pa_ci_comments.comment_text%type;
4491: l_reassign_request_text pa_ci_comments.comment_text%type;
4492: l_required_by_date pa_ci_actions.date_required%type;
4493: l_reassign_to_id pa_ci_actions.assigned_to%type;
4494: l_project_id pa_control_items.project_id%TYPE;
4495:
4496: begin
4497:
4498: -- initialize the return status to success

Line 4523: l_party_id := pa_control_items_utils.getpartyid(l_user_id);

4519: end if;
4520:
4521: --Get the party_id for the logged in user
4522: l_user_id := fnd_global.user_id;
4523: l_party_id := pa_control_items_utils.getpartyid(l_user_id);
4524:
4525: /*Check whether the user has privilige to update this action or not and whether the passed action is valid or not*/
4526: /*for checking the privilege check the party id of the logged in user with party id of person to whom the action is assigned*/
4527: PA_CONTROL_API_PVT.validate_priv_and_action(

Line 4675: pa_control_items_workflow.close_notification(

4671: fetch close_notification into close_notification_rec;
4672: if(close_notification%notfound) then
4673: null;
4674: else
4675: pa_control_items_workflow.close_notification(
4676: p_item_type => close_notification_rec.item_type,
4677: p_item_key => close_notification_rec.item_key,
4678: p_nid => close_notification_rec.notification_id,
4679: p_action => l_perform_action,

Line 4819: pa_control_items_workflow.close_notification(

4815: fetch close_notification into close_notification_rec;
4816: if(close_notification%notfound) then
4817: null;
4818: else
4819: pa_control_items_workflow.close_notification(
4820: p_item_type => close_notification_rec.item_type,
4821: p_item_key => close_notification_rec.item_key,
4822: p_nid => close_notification_rec.notification_id,
4823: p_action => l_perform_action,

Line 4885: pa_control_items_workflow.close_notification(

4881: fetch close_notification into close_notification_rec;
4882: if(close_notification%notfound) then
4883: null;
4884: else
4885: pa_control_items_workflow.close_notification(
4886: p_item_type => close_notification_rec.item_type,
4887: p_item_key => close_notification_rec.item_key,
4888: p_nid => close_notification_rec.notification_id,
4889: p_action => l_perform_action,

Line 5033: l_ci_id pa_control_items.ci_id%type;

5029: l_module_name VARCHAR2(200):= 'PA_CONTROL_API_PUB.Cancel_Action';
5030: l_assignee_id NUMBER := null;
5031: l_user_id NUMBER := 0;
5032: l_action_id pa_ci_actions.ci_action_id%type;
5033: l_ci_id pa_control_items.ci_id%type;
5034: l_record_version_number pa_ci_actions.record_version_number%type;
5035: l_status_code pa_ci_actions.status_code%type;
5036: check_s VARCHAR2(1);
5037: l_created_by NUMBER;

Line 5038: l_project_id pa_control_items.project_id%TYPE;

5034: l_record_version_number pa_ci_actions.record_version_number%type;
5035: l_status_code pa_ci_actions.status_code%type;
5036: check_s VARCHAR2(1);
5037: l_created_by NUMBER;
5038: l_project_id pa_control_items.project_id%TYPE;
5039:
5040: begin
5041:
5042: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6049: l_UpdateAllowed := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_StatusCode, 'CONTROL_ITEM_ALLOW_UPDATE', p_Ci_Id);

6045: -- 1. The User has Update access on the Control Item.
6046: -- 2. Update is allowed on the Control Item in this particular
6047: -- status.
6048: l_UpdateAccess := PA_CI_SECURITY_PKG.Check_Update_Access (p_Ci_Id);
6049: l_UpdateAllowed := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_StatusCode, 'CONTROL_ITEM_ALLOW_UPDATE', p_Ci_Id);
6050: IF (l_UpdateAllowed = 'Y' AND l_UpdateAccess = 'T') THEN
6051: -- For each Related Item in the passed in array, insert it.
6052: FOR i IN 1..p_Related_Items_Tbl.COUNT LOOP
6053: -- If the Related Ci_Id that is passed in does not

Line 6079: pa_debug.g_err_stage:= 'Before Calling PA_CONTROL_ITEMS_PVT.Add_Related_Item for the related item ['||i||']';

6075: ELSE
6076: -- Close the Cursor.
6077: CLOSE Check_Valid_CI;
6078: if l_debug_mode = 'Y' then
6079: pa_debug.g_err_stage:= 'Before Calling PA_CONTROL_ITEMS_PVT.Add_Related_Item for the related item ['||i||']';
6080: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
6081: end if;
6082: -- Call our API for insertion.
6083: PA_CONTROL_ITEMS_PVT.Add_Related_Item (

Line 6083: PA_CONTROL_ITEMS_PVT.Add_Related_Item (

6079: pa_debug.g_err_stage:= 'Before Calling PA_CONTROL_ITEMS_PVT.Add_Related_Item for the related item ['||i||']';
6080: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
6081: end if;
6082: -- Call our API for insertion.
6083: PA_CONTROL_ITEMS_PVT.Add_Related_Item (
6084: p_Api_Version => p_Api_Version_Number
6085: , p_Init_Msg_List => 'F'
6086: , p_Commit => 'F'
6087: , p_Validate_Only => 'F'

Line 6376: l_UpdateAllowed := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_StatusCode, 'CONTROL_ITEM_ALLOW_UPDATE', p_Ci_Id);

6372: -- Deleting of Related Items is only allowed on a Control Item if
6373: -- 1. The User has Update access on the Control Item.
6374: -- 2. Update is allowed on the Control Item in this particular
6375: -- status.
6376: l_UpdateAllowed := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_StatusCode, 'CONTROL_ITEM_ALLOW_UPDATE', p_Ci_Id);
6377: l_UpdateAccess := PA_CI_SECURITY_PKG.Check_Update_Access (p_Ci_Id);
6378: IF (l_UpdateAllowed = 'Y' AND l_UpdateAccess = 'T') THEN
6379: if l_debug_mode = 'Y' then
6380: pa_debug.g_err_stage:= 'Before Calling PA_CONTROL_ITEMS_PVT.Delete_Related_Item';

Line 6380: pa_debug.g_err_stage:= 'Before Calling PA_CONTROL_ITEMS_PVT.Delete_Related_Item';

6376: l_UpdateAllowed := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_StatusCode, 'CONTROL_ITEM_ALLOW_UPDATE', p_Ci_Id);
6377: l_UpdateAccess := PA_CI_SECURITY_PKG.Check_Update_Access (p_Ci_Id);
6378: IF (l_UpdateAllowed = 'Y' AND l_UpdateAccess = 'T') THEN
6379: if l_debug_mode = 'Y' then
6380: pa_debug.g_err_stage:= 'Before Calling PA_CONTROL_ITEMS_PVT.Delete_Related_Item';
6381: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
6382: end if;
6383: -- Call our procedure to Delete the Item.
6384: PA_CONTROL_ITEMS_PVT.Delete_Related_Item (

Line 6384: PA_CONTROL_ITEMS_PVT.Delete_Related_Item (

6380: pa_debug.g_err_stage:= 'Before Calling PA_CONTROL_ITEMS_PVT.Delete_Related_Item';
6381: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
6382: end if;
6383: -- Call our procedure to Delete the Item.
6384: PA_CONTROL_ITEMS_PVT.Delete_Related_Item (
6385: p_Api_Version => p_Api_Version_Number
6386: , p_Init_Msg_List => 'F'
6387: , p_Commit => p_Commit
6388: , p_Validate_Only => 'F'

Line 6587: l_curr_status_code pa_control_items.status_code%TYPE;

6583: l_chk_status_ctrl VARCHAR2(1) := 'N';
6584: l_module VARCHAR2(100) := 'PA_CONTROL_API_PUB.UPDATE_ISSUE';
6585:
6586:
6587: l_curr_status_code pa_control_items.status_code%TYPE;
6588: l_ci_status_code pa_control_items.status_code%TYPE;
6589: l_record_version_number pa_control_items.record_version_number%TYPE;
6590: l_summary pa_control_items.summary%TYPE;
6591: l_description pa_control_items.description%TYPE;

Line 6588: l_ci_status_code pa_control_items.status_code%TYPE;

6584: l_module VARCHAR2(100) := 'PA_CONTROL_API_PUB.UPDATE_ISSUE';
6585:
6586:
6587: l_curr_status_code pa_control_items.status_code%TYPE;
6588: l_ci_status_code pa_control_items.status_code%TYPE;
6589: l_record_version_number pa_control_items.record_version_number%TYPE;
6590: l_summary pa_control_items.summary%TYPE;
6591: l_description pa_control_items.description%TYPE;
6592: l_curr_owner_id pa_control_items.owner_id%TYPE;

Line 6589: l_record_version_number pa_control_items.record_version_number%TYPE;

6585:
6586:
6587: l_curr_status_code pa_control_items.status_code%TYPE;
6588: l_ci_status_code pa_control_items.status_code%TYPE;
6589: l_record_version_number pa_control_items.record_version_number%TYPE;
6590: l_summary pa_control_items.summary%TYPE;
6591: l_description pa_control_items.description%TYPE;
6592: l_curr_owner_id pa_control_items.owner_id%TYPE;
6593: l_owner_id pa_control_items.owner_id%TYPE;

Line 6590: l_summary pa_control_items.summary%TYPE;

6586:
6587: l_curr_status_code pa_control_items.status_code%TYPE;
6588: l_ci_status_code pa_control_items.status_code%TYPE;
6589: l_record_version_number pa_control_items.record_version_number%TYPE;
6590: l_summary pa_control_items.summary%TYPE;
6591: l_description pa_control_items.description%TYPE;
6592: l_curr_owner_id pa_control_items.owner_id%TYPE;
6593: l_owner_id pa_control_items.owner_id%TYPE;
6594: l_classification_code_id pa_control_items.classification_code_id%TYPE;

Line 6591: l_description pa_control_items.description%TYPE;

6587: l_curr_status_code pa_control_items.status_code%TYPE;
6588: l_ci_status_code pa_control_items.status_code%TYPE;
6589: l_record_version_number pa_control_items.record_version_number%TYPE;
6590: l_summary pa_control_items.summary%TYPE;
6591: l_description pa_control_items.description%TYPE;
6592: l_curr_owner_id pa_control_items.owner_id%TYPE;
6593: l_owner_id pa_control_items.owner_id%TYPE;
6594: l_classification_code_id pa_control_items.classification_code_id%TYPE;
6595: l_reason_code_id pa_control_items.reason_code_id%TYPE;

Line 6592: l_curr_owner_id pa_control_items.owner_id%TYPE;

6588: l_ci_status_code pa_control_items.status_code%TYPE;
6589: l_record_version_number pa_control_items.record_version_number%TYPE;
6590: l_summary pa_control_items.summary%TYPE;
6591: l_description pa_control_items.description%TYPE;
6592: l_curr_owner_id pa_control_items.owner_id%TYPE;
6593: l_owner_id pa_control_items.owner_id%TYPE;
6594: l_classification_code_id pa_control_items.classification_code_id%TYPE;
6595: l_reason_code_id pa_control_items.reason_code_id%TYPE;
6596: l_object_id pa_control_items.object_id%TYPE;

Line 6593: l_owner_id pa_control_items.owner_id%TYPE;

6589: l_record_version_number pa_control_items.record_version_number%TYPE;
6590: l_summary pa_control_items.summary%TYPE;
6591: l_description pa_control_items.description%TYPE;
6592: l_curr_owner_id pa_control_items.owner_id%TYPE;
6593: l_owner_id pa_control_items.owner_id%TYPE;
6594: l_classification_code_id pa_control_items.classification_code_id%TYPE;
6595: l_reason_code_id pa_control_items.reason_code_id%TYPE;
6596: l_object_id pa_control_items.object_id%TYPE;
6597: l_object_type pa_control_items.object_type%TYPE;

Line 6594: l_classification_code_id pa_control_items.classification_code_id%TYPE;

6590: l_summary pa_control_items.summary%TYPE;
6591: l_description pa_control_items.description%TYPE;
6592: l_curr_owner_id pa_control_items.owner_id%TYPE;
6593: l_owner_id pa_control_items.owner_id%TYPE;
6594: l_classification_code_id pa_control_items.classification_code_id%TYPE;
6595: l_reason_code_id pa_control_items.reason_code_id%TYPE;
6596: l_object_id pa_control_items.object_id%TYPE;
6597: l_object_type pa_control_items.object_type%TYPE;
6598: l_ci_number pa_control_items.ci_number%TYPE;

Line 6595: l_reason_code_id pa_control_items.reason_code_id%TYPE;

6591: l_description pa_control_items.description%TYPE;
6592: l_curr_owner_id pa_control_items.owner_id%TYPE;
6593: l_owner_id pa_control_items.owner_id%TYPE;
6594: l_classification_code_id pa_control_items.classification_code_id%TYPE;
6595: l_reason_code_id pa_control_items.reason_code_id%TYPE;
6596: l_object_id pa_control_items.object_id%TYPE;
6597: l_object_type pa_control_items.object_type%TYPE;
6598: l_ci_number pa_control_items.ci_number%TYPE;
6599: l_date_required pa_control_items.date_required%TYPE;

Line 6596: l_object_id pa_control_items.object_id%TYPE;

6592: l_curr_owner_id pa_control_items.owner_id%TYPE;
6593: l_owner_id pa_control_items.owner_id%TYPE;
6594: l_classification_code_id pa_control_items.classification_code_id%TYPE;
6595: l_reason_code_id pa_control_items.reason_code_id%TYPE;
6596: l_object_id pa_control_items.object_id%TYPE;
6597: l_object_type pa_control_items.object_type%TYPE;
6598: l_ci_number pa_control_items.ci_number%TYPE;
6599: l_date_required pa_control_items.date_required%TYPE;
6600: l_priority_code pa_control_items.priority_code%TYPE;

Line 6597: l_object_type pa_control_items.object_type%TYPE;

6593: l_owner_id pa_control_items.owner_id%TYPE;
6594: l_classification_code_id pa_control_items.classification_code_id%TYPE;
6595: l_reason_code_id pa_control_items.reason_code_id%TYPE;
6596: l_object_id pa_control_items.object_id%TYPE;
6597: l_object_type pa_control_items.object_type%TYPE;
6598: l_ci_number pa_control_items.ci_number%TYPE;
6599: l_date_required pa_control_items.date_required%TYPE;
6600: l_priority_code pa_control_items.priority_code%TYPE;
6601: l_effort_level_code pa_control_items.effort_level_code%TYPE;

Line 6598: l_ci_number pa_control_items.ci_number%TYPE;

6594: l_classification_code_id pa_control_items.classification_code_id%TYPE;
6595: l_reason_code_id pa_control_items.reason_code_id%TYPE;
6596: l_object_id pa_control_items.object_id%TYPE;
6597: l_object_type pa_control_items.object_type%TYPE;
6598: l_ci_number pa_control_items.ci_number%TYPE;
6599: l_date_required pa_control_items.date_required%TYPE;
6600: l_priority_code pa_control_items.priority_code%TYPE;
6601: l_effort_level_code pa_control_items.effort_level_code%TYPE;
6602: l_price pa_control_items.price%TYPE;

Line 6599: l_date_required pa_control_items.date_required%TYPE;

6595: l_reason_code_id pa_control_items.reason_code_id%TYPE;
6596: l_object_id pa_control_items.object_id%TYPE;
6597: l_object_type pa_control_items.object_type%TYPE;
6598: l_ci_number pa_control_items.ci_number%TYPE;
6599: l_date_required pa_control_items.date_required%TYPE;
6600: l_priority_code pa_control_items.priority_code%TYPE;
6601: l_effort_level_code pa_control_items.effort_level_code%TYPE;
6602: l_price pa_control_items.price%TYPE;
6603: l_price_currency_code pa_control_items.price_currency_code%TYPE;

Line 6600: l_priority_code pa_control_items.priority_code%TYPE;

6596: l_object_id pa_control_items.object_id%TYPE;
6597: l_object_type pa_control_items.object_type%TYPE;
6598: l_ci_number pa_control_items.ci_number%TYPE;
6599: l_date_required pa_control_items.date_required%TYPE;
6600: l_priority_code pa_control_items.priority_code%TYPE;
6601: l_effort_level_code pa_control_items.effort_level_code%TYPE;
6602: l_price pa_control_items.price%TYPE;
6603: l_price_currency_code pa_control_items.price_currency_code%TYPE;
6604: l_source_type_code pa_control_items.source_type_code%TYPE;

Line 6601: l_effort_level_code pa_control_items.effort_level_code%TYPE;

6597: l_object_type pa_control_items.object_type%TYPE;
6598: l_ci_number pa_control_items.ci_number%TYPE;
6599: l_date_required pa_control_items.date_required%TYPE;
6600: l_priority_code pa_control_items.priority_code%TYPE;
6601: l_effort_level_code pa_control_items.effort_level_code%TYPE;
6602: l_price pa_control_items.price%TYPE;
6603: l_price_currency_code pa_control_items.price_currency_code%TYPE;
6604: l_source_type_code pa_control_items.source_type_code%TYPE;
6605: l_source_comment pa_control_items.source_comment%TYPE;

Line 6602: l_price pa_control_items.price%TYPE;

6598: l_ci_number pa_control_items.ci_number%TYPE;
6599: l_date_required pa_control_items.date_required%TYPE;
6600: l_priority_code pa_control_items.priority_code%TYPE;
6601: l_effort_level_code pa_control_items.effort_level_code%TYPE;
6602: l_price pa_control_items.price%TYPE;
6603: l_price_currency_code pa_control_items.price_currency_code%TYPE;
6604: l_source_type_code pa_control_items.source_type_code%TYPE;
6605: l_source_comment pa_control_items.source_comment%TYPE;
6606: l_source_number pa_control_items.source_number%TYPE;

Line 6603: l_price_currency_code pa_control_items.price_currency_code%TYPE;

6599: l_date_required pa_control_items.date_required%TYPE;
6600: l_priority_code pa_control_items.priority_code%TYPE;
6601: l_effort_level_code pa_control_items.effort_level_code%TYPE;
6602: l_price pa_control_items.price%TYPE;
6603: l_price_currency_code pa_control_items.price_currency_code%TYPE;
6604: l_source_type_code pa_control_items.source_type_code%TYPE;
6605: l_source_comment pa_control_items.source_comment%TYPE;
6606: l_source_number pa_control_items.source_number%TYPE;
6607: l_source_date_received pa_control_items.source_date_received%TYPE;

Line 6604: l_source_type_code pa_control_items.source_type_code%TYPE;

6600: l_priority_code pa_control_items.priority_code%TYPE;
6601: l_effort_level_code pa_control_items.effort_level_code%TYPE;
6602: l_price pa_control_items.price%TYPE;
6603: l_price_currency_code pa_control_items.price_currency_code%TYPE;
6604: l_source_type_code pa_control_items.source_type_code%TYPE;
6605: l_source_comment pa_control_items.source_comment%TYPE;
6606: l_source_number pa_control_items.source_number%TYPE;
6607: l_source_date_received pa_control_items.source_date_received%TYPE;
6608: l_source_organization pa_control_items.source_organization%TYPE;

Line 6605: l_source_comment pa_control_items.source_comment%TYPE;

6601: l_effort_level_code pa_control_items.effort_level_code%TYPE;
6602: l_price pa_control_items.price%TYPE;
6603: l_price_currency_code pa_control_items.price_currency_code%TYPE;
6604: l_source_type_code pa_control_items.source_type_code%TYPE;
6605: l_source_comment pa_control_items.source_comment%TYPE;
6606: l_source_number pa_control_items.source_number%TYPE;
6607: l_source_date_received pa_control_items.source_date_received%TYPE;
6608: l_source_organization pa_control_items.source_organization%TYPE;
6609: l_source_person pa_control_items.source_person%TYPE;

Line 6606: l_source_number pa_control_items.source_number%TYPE;

6602: l_price pa_control_items.price%TYPE;
6603: l_price_currency_code pa_control_items.price_currency_code%TYPE;
6604: l_source_type_code pa_control_items.source_type_code%TYPE;
6605: l_source_comment pa_control_items.source_comment%TYPE;
6606: l_source_number pa_control_items.source_number%TYPE;
6607: l_source_date_received pa_control_items.source_date_received%TYPE;
6608: l_source_organization pa_control_items.source_organization%TYPE;
6609: l_source_person pa_control_items.source_person%TYPE;
6610: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;

Line 6607: l_source_date_received pa_control_items.source_date_received%TYPE;

6603: l_price_currency_code pa_control_items.price_currency_code%TYPE;
6604: l_source_type_code pa_control_items.source_type_code%TYPE;
6605: l_source_comment pa_control_items.source_comment%TYPE;
6606: l_source_number pa_control_items.source_number%TYPE;
6607: l_source_date_received pa_control_items.source_date_received%TYPE;
6608: l_source_organization pa_control_items.source_organization%TYPE;
6609: l_source_person pa_control_items.source_person%TYPE;
6610: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
6611: l_progress_status_code pa_control_items.progress_status_code%TYPE;

Line 6608: l_source_organization pa_control_items.source_organization%TYPE;

6604: l_source_type_code pa_control_items.source_type_code%TYPE;
6605: l_source_comment pa_control_items.source_comment%TYPE;
6606: l_source_number pa_control_items.source_number%TYPE;
6607: l_source_date_received pa_control_items.source_date_received%TYPE;
6608: l_source_organization pa_control_items.source_organization%TYPE;
6609: l_source_person pa_control_items.source_person%TYPE;
6610: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
6611: l_progress_status_code pa_control_items.progress_status_code%TYPE;
6612: l_progress_overview pa_control_items.status_overview%TYPE;

Line 6609: l_source_person pa_control_items.source_person%TYPE;

6605: l_source_comment pa_control_items.source_comment%TYPE;
6606: l_source_number pa_control_items.source_number%TYPE;
6607: l_source_date_received pa_control_items.source_date_received%TYPE;
6608: l_source_organization pa_control_items.source_organization%TYPE;
6609: l_source_person pa_control_items.source_person%TYPE;
6610: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
6611: l_progress_status_code pa_control_items.progress_status_code%TYPE;
6612: l_progress_overview pa_control_items.status_overview%TYPE;
6613: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;

Line 6610: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;

6606: l_source_number pa_control_items.source_number%TYPE;
6607: l_source_date_received pa_control_items.source_date_received%TYPE;
6608: l_source_organization pa_control_items.source_organization%TYPE;
6609: l_source_person pa_control_items.source_person%TYPE;
6610: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
6611: l_progress_status_code pa_control_items.progress_status_code%TYPE;
6612: l_progress_overview pa_control_items.status_overview%TYPE;
6613: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
6614: l_resolution_comment pa_control_items.resolution%TYPE;

Line 6611: l_progress_status_code pa_control_items.progress_status_code%TYPE;

6607: l_source_date_received pa_control_items.source_date_received%TYPE;
6608: l_source_organization pa_control_items.source_organization%TYPE;
6609: l_source_person pa_control_items.source_person%TYPE;
6610: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
6611: l_progress_status_code pa_control_items.progress_status_code%TYPE;
6612: l_progress_overview pa_control_items.status_overview%TYPE;
6613: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
6614: l_resolution_comment pa_control_items.resolution%TYPE;
6615: l_date_closed pa_control_items.date_closed%TYPE;

Line 6612: l_progress_overview pa_control_items.status_overview%TYPE;

6608: l_source_organization pa_control_items.source_organization%TYPE;
6609: l_source_person pa_control_items.source_person%TYPE;
6610: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
6611: l_progress_status_code pa_control_items.progress_status_code%TYPE;
6612: l_progress_overview pa_control_items.status_overview%TYPE;
6613: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
6614: l_resolution_comment pa_control_items.resolution%TYPE;
6615: l_date_closed pa_control_items.date_closed%TYPE;
6616: l_closed_by_id pa_control_items.closed_by_id%TYPE;

Line 6613: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;

6609: l_source_person pa_control_items.source_person%TYPE;
6610: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
6611: l_progress_status_code pa_control_items.progress_status_code%TYPE;
6612: l_progress_overview pa_control_items.status_overview%TYPE;
6613: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
6614: l_resolution_comment pa_control_items.resolution%TYPE;
6615: l_date_closed pa_control_items.date_closed%TYPE;
6616: l_closed_by_id pa_control_items.closed_by_id%TYPE;
6617: l_project_id pa_control_items.project_id%TYPE;

Line 6614: l_resolution_comment pa_control_items.resolution%TYPE;

6610: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
6611: l_progress_status_code pa_control_items.progress_status_code%TYPE;
6612: l_progress_overview pa_control_items.status_overview%TYPE;
6613: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
6614: l_resolution_comment pa_control_items.resolution%TYPE;
6615: l_date_closed pa_control_items.date_closed%TYPE;
6616: l_closed_by_id pa_control_items.closed_by_id%TYPE;
6617: l_project_id pa_control_items.project_id%TYPE;
6618: l_ci_type_id pa_control_items.ci_type_id%TYPE;

Line 6615: l_date_closed pa_control_items.date_closed%TYPE;

6611: l_progress_status_code pa_control_items.progress_status_code%TYPE;
6612: l_progress_overview pa_control_items.status_overview%TYPE;
6613: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
6614: l_resolution_comment pa_control_items.resolution%TYPE;
6615: l_date_closed pa_control_items.date_closed%TYPE;
6616: l_closed_by_id pa_control_items.closed_by_id%TYPE;
6617: l_project_id pa_control_items.project_id%TYPE;
6618: l_ci_type_id pa_control_items.ci_type_id%TYPE;
6619: l_attribute_category pa_control_items.attribute_category%TYPE;

Line 6616: l_closed_by_id pa_control_items.closed_by_id%TYPE;

6612: l_progress_overview pa_control_items.status_overview%TYPE;
6613: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
6614: l_resolution_comment pa_control_items.resolution%TYPE;
6615: l_date_closed pa_control_items.date_closed%TYPE;
6616: l_closed_by_id pa_control_items.closed_by_id%TYPE;
6617: l_project_id pa_control_items.project_id%TYPE;
6618: l_ci_type_id pa_control_items.ci_type_id%TYPE;
6619: l_attribute_category pa_control_items.attribute_category%TYPE;
6620: l_attribute1 pa_control_items.attribute1%TYPE;

Line 6617: l_project_id pa_control_items.project_id%TYPE;

6613: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
6614: l_resolution_comment pa_control_items.resolution%TYPE;
6615: l_date_closed pa_control_items.date_closed%TYPE;
6616: l_closed_by_id pa_control_items.closed_by_id%TYPE;
6617: l_project_id pa_control_items.project_id%TYPE;
6618: l_ci_type_id pa_control_items.ci_type_id%TYPE;
6619: l_attribute_category pa_control_items.attribute_category%TYPE;
6620: l_attribute1 pa_control_items.attribute1%TYPE;
6621: l_attribute2 pa_control_items.attribute2%TYPE;

Line 6618: l_ci_type_id pa_control_items.ci_type_id%TYPE;

6614: l_resolution_comment pa_control_items.resolution%TYPE;
6615: l_date_closed pa_control_items.date_closed%TYPE;
6616: l_closed_by_id pa_control_items.closed_by_id%TYPE;
6617: l_project_id pa_control_items.project_id%TYPE;
6618: l_ci_type_id pa_control_items.ci_type_id%TYPE;
6619: l_attribute_category pa_control_items.attribute_category%TYPE;
6620: l_attribute1 pa_control_items.attribute1%TYPE;
6621: l_attribute2 pa_control_items.attribute2%TYPE;
6622: l_attribute3 pa_control_items.attribute3%TYPE;

Line 6619: l_attribute_category pa_control_items.attribute_category%TYPE;

6615: l_date_closed pa_control_items.date_closed%TYPE;
6616: l_closed_by_id pa_control_items.closed_by_id%TYPE;
6617: l_project_id pa_control_items.project_id%TYPE;
6618: l_ci_type_id pa_control_items.ci_type_id%TYPE;
6619: l_attribute_category pa_control_items.attribute_category%TYPE;
6620: l_attribute1 pa_control_items.attribute1%TYPE;
6621: l_attribute2 pa_control_items.attribute2%TYPE;
6622: l_attribute3 pa_control_items.attribute3%TYPE;
6623: l_attribute4 pa_control_items.attribute4%TYPE;

Line 6620: l_attribute1 pa_control_items.attribute1%TYPE;

6616: l_closed_by_id pa_control_items.closed_by_id%TYPE;
6617: l_project_id pa_control_items.project_id%TYPE;
6618: l_ci_type_id pa_control_items.ci_type_id%TYPE;
6619: l_attribute_category pa_control_items.attribute_category%TYPE;
6620: l_attribute1 pa_control_items.attribute1%TYPE;
6621: l_attribute2 pa_control_items.attribute2%TYPE;
6622: l_attribute3 pa_control_items.attribute3%TYPE;
6623: l_attribute4 pa_control_items.attribute4%TYPE;
6624: l_attribute5 pa_control_items.attribute5%TYPE;

Line 6621: l_attribute2 pa_control_items.attribute2%TYPE;

6617: l_project_id pa_control_items.project_id%TYPE;
6618: l_ci_type_id pa_control_items.ci_type_id%TYPE;
6619: l_attribute_category pa_control_items.attribute_category%TYPE;
6620: l_attribute1 pa_control_items.attribute1%TYPE;
6621: l_attribute2 pa_control_items.attribute2%TYPE;
6622: l_attribute3 pa_control_items.attribute3%TYPE;
6623: l_attribute4 pa_control_items.attribute4%TYPE;
6624: l_attribute5 pa_control_items.attribute5%TYPE;
6625: l_attribute6 pa_control_items.attribute6%TYPE;

Line 6622: l_attribute3 pa_control_items.attribute3%TYPE;

6618: l_ci_type_id pa_control_items.ci_type_id%TYPE;
6619: l_attribute_category pa_control_items.attribute_category%TYPE;
6620: l_attribute1 pa_control_items.attribute1%TYPE;
6621: l_attribute2 pa_control_items.attribute2%TYPE;
6622: l_attribute3 pa_control_items.attribute3%TYPE;
6623: l_attribute4 pa_control_items.attribute4%TYPE;
6624: l_attribute5 pa_control_items.attribute5%TYPE;
6625: l_attribute6 pa_control_items.attribute6%TYPE;
6626: l_attribute7 pa_control_items.attribute7%TYPE;

Line 6623: l_attribute4 pa_control_items.attribute4%TYPE;

6619: l_attribute_category pa_control_items.attribute_category%TYPE;
6620: l_attribute1 pa_control_items.attribute1%TYPE;
6621: l_attribute2 pa_control_items.attribute2%TYPE;
6622: l_attribute3 pa_control_items.attribute3%TYPE;
6623: l_attribute4 pa_control_items.attribute4%TYPE;
6624: l_attribute5 pa_control_items.attribute5%TYPE;
6625: l_attribute6 pa_control_items.attribute6%TYPE;
6626: l_attribute7 pa_control_items.attribute7%TYPE;
6627: l_attribute8 pa_control_items.attribute8%TYPE;

Line 6624: l_attribute5 pa_control_items.attribute5%TYPE;

6620: l_attribute1 pa_control_items.attribute1%TYPE;
6621: l_attribute2 pa_control_items.attribute2%TYPE;
6622: l_attribute3 pa_control_items.attribute3%TYPE;
6623: l_attribute4 pa_control_items.attribute4%TYPE;
6624: l_attribute5 pa_control_items.attribute5%TYPE;
6625: l_attribute6 pa_control_items.attribute6%TYPE;
6626: l_attribute7 pa_control_items.attribute7%TYPE;
6627: l_attribute8 pa_control_items.attribute8%TYPE;
6628: l_attribute9 pa_control_items.attribute9%TYPE;

Line 6625: l_attribute6 pa_control_items.attribute6%TYPE;

6621: l_attribute2 pa_control_items.attribute2%TYPE;
6622: l_attribute3 pa_control_items.attribute3%TYPE;
6623: l_attribute4 pa_control_items.attribute4%TYPE;
6624: l_attribute5 pa_control_items.attribute5%TYPE;
6625: l_attribute6 pa_control_items.attribute6%TYPE;
6626: l_attribute7 pa_control_items.attribute7%TYPE;
6627: l_attribute8 pa_control_items.attribute8%TYPE;
6628: l_attribute9 pa_control_items.attribute9%TYPE;
6629: l_attribute10 pa_control_items.attribute10%TYPE;

Line 6626: l_attribute7 pa_control_items.attribute7%TYPE;

6622: l_attribute3 pa_control_items.attribute3%TYPE;
6623: l_attribute4 pa_control_items.attribute4%TYPE;
6624: l_attribute5 pa_control_items.attribute5%TYPE;
6625: l_attribute6 pa_control_items.attribute6%TYPE;
6626: l_attribute7 pa_control_items.attribute7%TYPE;
6627: l_attribute8 pa_control_items.attribute8%TYPE;
6628: l_attribute9 pa_control_items.attribute9%TYPE;
6629: l_attribute10 pa_control_items.attribute10%TYPE;
6630: l_attribute11 pa_control_items.attribute11%TYPE;

Line 6627: l_attribute8 pa_control_items.attribute8%TYPE;

6623: l_attribute4 pa_control_items.attribute4%TYPE;
6624: l_attribute5 pa_control_items.attribute5%TYPE;
6625: l_attribute6 pa_control_items.attribute6%TYPE;
6626: l_attribute7 pa_control_items.attribute7%TYPE;
6627: l_attribute8 pa_control_items.attribute8%TYPE;
6628: l_attribute9 pa_control_items.attribute9%TYPE;
6629: l_attribute10 pa_control_items.attribute10%TYPE;
6630: l_attribute11 pa_control_items.attribute11%TYPE;
6631: l_attribute12 pa_control_items.attribute12%TYPE;

Line 6628: l_attribute9 pa_control_items.attribute9%TYPE;

6624: l_attribute5 pa_control_items.attribute5%TYPE;
6625: l_attribute6 pa_control_items.attribute6%TYPE;
6626: l_attribute7 pa_control_items.attribute7%TYPE;
6627: l_attribute8 pa_control_items.attribute8%TYPE;
6628: l_attribute9 pa_control_items.attribute9%TYPE;
6629: l_attribute10 pa_control_items.attribute10%TYPE;
6630: l_attribute11 pa_control_items.attribute11%TYPE;
6631: l_attribute12 pa_control_items.attribute12%TYPE;
6632: l_attribute13 pa_control_items.attribute13%TYPE;

Line 6629: l_attribute10 pa_control_items.attribute10%TYPE;

6625: l_attribute6 pa_control_items.attribute6%TYPE;
6626: l_attribute7 pa_control_items.attribute7%TYPE;
6627: l_attribute8 pa_control_items.attribute8%TYPE;
6628: l_attribute9 pa_control_items.attribute9%TYPE;
6629: l_attribute10 pa_control_items.attribute10%TYPE;
6630: l_attribute11 pa_control_items.attribute11%TYPE;
6631: l_attribute12 pa_control_items.attribute12%TYPE;
6632: l_attribute13 pa_control_items.attribute13%TYPE;
6633: l_attribute14 pa_control_items.attribute14%TYPE;

Line 6630: l_attribute11 pa_control_items.attribute11%TYPE;

6626: l_attribute7 pa_control_items.attribute7%TYPE;
6627: l_attribute8 pa_control_items.attribute8%TYPE;
6628: l_attribute9 pa_control_items.attribute9%TYPE;
6629: l_attribute10 pa_control_items.attribute10%TYPE;
6630: l_attribute11 pa_control_items.attribute11%TYPE;
6631: l_attribute12 pa_control_items.attribute12%TYPE;
6632: l_attribute13 pa_control_items.attribute13%TYPE;
6633: l_attribute14 pa_control_items.attribute14%TYPE;
6634: l_attribute15 pa_control_items.attribute15%TYPE;

Line 6631: l_attribute12 pa_control_items.attribute12%TYPE;

6627: l_attribute8 pa_control_items.attribute8%TYPE;
6628: l_attribute9 pa_control_items.attribute9%TYPE;
6629: l_attribute10 pa_control_items.attribute10%TYPE;
6630: l_attribute11 pa_control_items.attribute11%TYPE;
6631: l_attribute12 pa_control_items.attribute12%TYPE;
6632: l_attribute13 pa_control_items.attribute13%TYPE;
6633: l_attribute14 pa_control_items.attribute14%TYPE;
6634: l_attribute15 pa_control_items.attribute15%TYPE;
6635: l_class_code constant varchar2(20) := 'ISSUE';

Line 6632: l_attribute13 pa_control_items.attribute13%TYPE;

6628: l_attribute9 pa_control_items.attribute9%TYPE;
6629: l_attribute10 pa_control_items.attribute10%TYPE;
6630: l_attribute11 pa_control_items.attribute11%TYPE;
6631: l_attribute12 pa_control_items.attribute12%TYPE;
6632: l_attribute13 pa_control_items.attribute13%TYPE;
6633: l_attribute14 pa_control_items.attribute14%TYPE;
6634: l_attribute15 pa_control_items.attribute15%TYPE;
6635: l_class_code constant varchar2(20) := 'ISSUE';
6636:

Line 6633: l_attribute14 pa_control_items.attribute14%TYPE;

6629: l_attribute10 pa_control_items.attribute10%TYPE;
6630: l_attribute11 pa_control_items.attribute11%TYPE;
6631: l_attribute12 pa_control_items.attribute12%TYPE;
6632: l_attribute13 pa_control_items.attribute13%TYPE;
6633: l_attribute14 pa_control_items.attribute14%TYPE;
6634: l_attribute15 pa_control_items.attribute15%TYPE;
6635: l_class_code constant varchar2(20) := 'ISSUE';
6636:
6637: CURSOR curr_row is

Line 6634: l_attribute15 pa_control_items.attribute15%TYPE;

6630: l_attribute11 pa_control_items.attribute11%TYPE;
6631: l_attribute12 pa_control_items.attribute12%TYPE;
6632: l_attribute13 pa_control_items.attribute13%TYPE;
6633: l_attribute14 pa_control_items.attribute14%TYPE;
6634: l_attribute15 pa_control_items.attribute15%TYPE;
6635: l_class_code constant varchar2(20) := 'ISSUE';
6636:
6637: CURSOR curr_row is
6638: SELECT *

Line 6639: FROM pa_control_items

6635: l_class_code constant varchar2(20) := 'ISSUE';
6636:
6637: CURSOR curr_row is
6638: SELECT *
6639: FROM pa_control_items
6640: WHERE ci_id = p_ci_id;
6641:
6642: cp curr_row%rowtype;
6643:

Line 6694: pa_control_items ci

6690:
6691: CURSOR c_auto_num IS
6692: SELECT type.auto_number_flag
6693: FROM pa_ci_types_b type,
6694: pa_control_items ci
6695: WHERE ci.ci_id = p_ci_id
6696: AND ci.ci_type_id = type.ci_type_id;
6697:
6698: CURSOR c_ci_number (p_project_id NUMBER, p_ci_type_id NUMBER) IS

Line 6700: FROM pa_control_items

6696: AND ci.ci_type_id = type.ci_type_id;
6697:
6698: CURSOR c_ci_number (p_project_id NUMBER, p_ci_type_id NUMBER) IS
6699: SELECT ROWID
6700: FROM pa_control_items
6701: WHERE project_id = p_project_id
6702: AND ci_number = p_ci_number
6703: AND ci_id <> p_ci_id
6704: AND ci_type_id = p_ci_type_id;

Line 6710: FROM pa_control_items c,

6706: CURSOR c_info IS
6707: SELECT cit.ci_type_class_code,
6708: cit.approval_required_flag,
6709: s.next_allowable_status_flag
6710: FROM pa_control_items c,
6711: pa_ci_types_b cit,
6712: pa_project_statuses s
6713: WHERE c.ci_id = p_ci_id
6714: AND c.status_code = s.project_status_code

Line 6869: l_curr_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_curr_status_code);

6865: end if;
6866:
6867:
6868:
6869: l_curr_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_curr_status_code);
6870:
6871: /* Check if the user can update the item. This requires the user to be owner or to have project authority or
6872: to have open UPDATE actions and status controls are satisfied. */
6873:

Line 6889: l_chk_status_ctrl := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_curr_status_code, 'CONTROL_ITEM_ALLOW_UPDATE');

6885: END IF;
6886:
6887: /* Check for the status control: check whether the action CONTROL_ITEM_ALLOW_UPDATE is allowed on the current status of the issue. */
6888:
6889: l_chk_status_ctrl := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_curr_status_code, 'CONTROL_ITEM_ALLOW_UPDATE');
6890:
6891: IF (l_chk_status_ctrl = 'N') THEN
6892:
6893: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_ALLOW_UPDATE');

Line 6900: pa_debug.write(l_module, 'After call to pa_control_items_utils.CheckCIActionAllowed', l_debug_level3);

6896: END IF;
6897:
6898:
6899: IF l_debug_mode = 'Y' THEN
6900: pa_debug.write(l_module, 'After call to pa_control_items_utils.CheckCIActionAllowed', l_debug_level3);
6901: END IF;
6902:
6903: /* The control item will not be updateable if the current status has approval workflow attached. */
6904:

Line 6955: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

6951: '''CONTROL_ITEM'''||' and wf_success_status_code is not null and wf_failure_status_code is not null)'||
6952: ' AND ps.project_status_code not in (select wf_failure_status_code from pa_project_statuses where status_type = '||
6953: '''CONTROL_ITEM'''||' and wf_success_status_code is not null and wf_failure_status_code is not null)'||
6954: ' AND decode(ps.project_system_status_code, '||'''CI_CANCELED'''||
6955: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
6956: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
6957: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
6958: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
6959: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||

Line 6958: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

6954: ' AND decode(ps.project_system_status_code, '||'''CI_CANCELED'''||
6955: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
6956: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
6957: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
6958: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
6959: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
6960: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
6961: '''CONTROL_ITEM_ALLOW_UPDST'''||' ,null),'||'''N'''||' ) = '||'''Y'''||
6962: ' AND decode(ps.project_system_status_code,'||'''CI_DRAFT'''||

Line 6960: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

6956: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
6957: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
6958: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
6959: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
6960: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
6961: '''CONTROL_ITEM_ALLOW_UPDST'''||' ,null),'||'''N'''||' ) = '||'''Y'''||
6962: ' AND decode(ps.project_system_status_code,'||'''CI_DRAFT'''||
6963: ' ,decode('||''''||l_curr_system_status||''''||', '||'''CI_DRAFT'''||', '||
6964: '''Y'''||' ,'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||

Line 7246: /* Getting validated in pa_control_items_pvt.update_control_item API. */

7242: IF p_price_currency_code = G_PA_MISS_CHAR THEN
7243: NULL;
7244: ELSIF p_price_currency_code IS NOT NULL THEN
7245: l_price_currency_code := p_price_currency_code;
7246: /* Getting validated in pa_control_items_pvt.update_control_item API. */
7247: ELSIF p_price_currency_code IS NULL THEN
7248: l_price_currency_code := p_price_currency_code;
7249: END IF;
7250:

Line 7316: l_new_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_ci_status_code);

7312:
7313: IF (p_ci_number = G_PA_MISS_CHAR OR p_ci_number IS NULL) THEN
7314:
7315: IF l_ci_status_code IS NOT NULL THEN
7316: l_new_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_ci_status_code);
7317: END IF;
7318:
7319: IF p_ci_number = G_PA_MISS_CHAR THEN
7320: IF l_ci_number IS NULL THEN

Line 7510: pa_debug.write(l_module, 'Before call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate', l_debug_level3);

7506: l_curr_status_code <> l_ci_status_code AND
7507: l_to_status_flag = 'Y') THEN
7508:
7509: IF l_debug_mode = 'Y' THEN
7510: pa_debug.write(l_module, 'Before call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate', l_debug_level3);
7511: END IF;
7512:
7513: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (
7514: p_init_msg_list => p_init_msg_list

Line 7513: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (

7509: IF l_debug_mode = 'Y' THEN
7510: pa_debug.write(l_module, 'Before call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate', l_debug_level3);
7511: END IF;
7512:
7513: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (
7514: p_init_msg_list => p_init_msg_list
7515: ,p_commit => p_commit
7516: ,p_validate_only => l_validate_only
7517: ,p_max_msg_count => l_max_msg_count

Line 7536: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: x_return_status = '||x_return_status, l_debug_level3);

7532: In case of CR/CO, if Auto Approve on Submission is enabled and while changing the status to submitted,
7533: then the new status would be the success status code defined for the workflow */
7534:
7535: IF l_debug_mode = 'Y' THEN
7536: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: x_return_status = '||x_return_status, l_debug_level3);
7537: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_ci_status_code = '||l_ci_status_code, l_debug_level3);
7538: END IF;
7539:
7540: IF x_return_status = 'S' THEN

Line 7537: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_ci_status_code = '||l_ci_status_code, l_debug_level3);

7533: then the new status would be the success status code defined for the workflow */
7534:
7535: IF l_debug_mode = 'Y' THEN
7536: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: x_return_status = '||x_return_status, l_debug_level3);
7537: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_ci_status_code = '||l_ci_status_code, l_debug_level3);
7538: END IF;
7539:
7540: IF x_return_status = 'S' THEN
7541: l_status_change_flag := 'Y';

Line 7545: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_status_change_flag = '||l_status_change_flag, l_debug_level3);

7541: l_status_change_flag := 'Y';
7542: END IF;
7543:
7544: IF l_debug_mode = 'Y' THEN
7545: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_status_change_flag = '||l_status_change_flag, l_debug_level3);
7546: END IF;
7547:
7548: IF (l_resolution_req IS NOT NULL AND l_resolution_req = 'Y') THEN
7549: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

Line 7549: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

7545: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_status_change_flag = '||l_status_change_flag, l_debug_level3);
7546: END IF;
7547:
7548: IF (l_resolution_req IS NOT NULL AND l_resolution_req = 'Y') THEN
7549: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN
7550: IF (l_resolution_code_id IS NULL) THEN
7551: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7552: ,p_msg_name => 'PA_CI_RESOLUTION_OPEN');
7553: x_return_status := FND_API.G_RET_STS_ERROR;

Line 7565: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

7561: END IF;
7562: END IF;
7563:
7564: IF (l_resolution_req_cls IS NOT NULL AND l_resolution_req_cls = 'Y') THEN
7565: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN
7566: IF (l_resolution_code_id IS NULL) THEN
7567: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7568: ,p_msg_name => 'PA_CI_CLOSE_INV_RES');
7569: x_return_status := FND_API.G_RET_STS_ERROR;

Line 7586: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM', l_debug_level3);

7582:
7583: IF (l_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
7584:
7585: IF l_debug_mode = 'Y' THEN
7586: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM', l_debug_level3);
7587: END IF;
7588:
7589: PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM (
7590: p_api_version => 1.0

Line 7589: PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM (

7585: IF l_debug_mode = 'Y' THEN
7586: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM', l_debug_level3);
7587: END IF;
7588:
7589: PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM (
7590: p_api_version => 1.0
7591: ,p_init_msg_list => fnd_api.g_false
7592: ,p_commit => FND_API.g_false
7593: ,p_validate_only => FND_API.g_false

Line 7652: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM : x_return_status = '||x_return_status, l_debug_level3);

7648: ,x_msg_data => x_msg_data
7649: );
7650:
7651: IF l_debug_mode = 'Y' THEN
7652: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM : x_return_status = '||x_return_status, l_debug_level3);
7653: END IF;
7654:
7655: END IF;
7656:

Line 7660: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);

7656:
7657: IF (l_status_change_flag = 'Y' AND l_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
7658:
7659: IF l_debug_mode = 'Y' THEN
7660: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
7661: END IF;
7662:
7663: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
7664:

Line 7665: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'

7661: END IF;
7662:
7663: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
7664:
7665: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'
7666: ,p_object_id => p_ci_id
7667: ,p_type_code => 'CHANGE_STATUS'
7668: ,p_status_type => 'CONTROL_ITEM'
7669: ,p_new_project_status => l_ci_status_code

Line 7677: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);

7673: ,x_msg_count => x_msg_count
7674: ,x_msg_data => x_msg_data );
7675:
7676: IF l_debug_mode = 'Y' THEN
7677: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
7678: END IF;
7679:
7680: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (
7681: p_init_msg_list

Line 7680: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (

7676: IF l_debug_mode = 'Y' THEN
7677: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
7678: END IF;
7679:
7680: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (
7681: p_init_msg_list
7682: ,p_commit
7683: ,l_validate_only
7684: ,l_max_msg_count

Line 7697: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus', l_debug_level3);

7693: ,x_msg_data );
7694:
7695:
7696: IF l_debug_mode = 'Y' THEN
7697: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus', l_debug_level3);
7698: END IF;
7699:
7700: END IF;
7701:

Line 7847: l_curr_status_code pa_control_items.status_code%TYPE;

7843: l_chk_status_ctrl VARCHAR2(1) := 'N';
7844: l_module VARCHAR2(100) := 'PA_CONTROL_API_PUB.UPDATE_CHANGE_REQUEST';
7845:
7846:
7847: l_curr_status_code pa_control_items.status_code%TYPE;
7848: l_ci_status_code pa_control_items.status_code%TYPE;
7849: l_record_version_number pa_control_items.record_version_number%TYPE;
7850: l_summary pa_control_items.summary%TYPE;
7851: l_description pa_control_items.description%TYPE;

Line 7848: l_ci_status_code pa_control_items.status_code%TYPE;

7844: l_module VARCHAR2(100) := 'PA_CONTROL_API_PUB.UPDATE_CHANGE_REQUEST';
7845:
7846:
7847: l_curr_status_code pa_control_items.status_code%TYPE;
7848: l_ci_status_code pa_control_items.status_code%TYPE;
7849: l_record_version_number pa_control_items.record_version_number%TYPE;
7850: l_summary pa_control_items.summary%TYPE;
7851: l_description pa_control_items.description%TYPE;
7852: l_curr_owner_id pa_control_items.owner_id%TYPE;

Line 7849: l_record_version_number pa_control_items.record_version_number%TYPE;

7845:
7846:
7847: l_curr_status_code pa_control_items.status_code%TYPE;
7848: l_ci_status_code pa_control_items.status_code%TYPE;
7849: l_record_version_number pa_control_items.record_version_number%TYPE;
7850: l_summary pa_control_items.summary%TYPE;
7851: l_description pa_control_items.description%TYPE;
7852: l_curr_owner_id pa_control_items.owner_id%TYPE;
7853: l_owner_id pa_control_items.owner_id%TYPE;

Line 7850: l_summary pa_control_items.summary%TYPE;

7846:
7847: l_curr_status_code pa_control_items.status_code%TYPE;
7848: l_ci_status_code pa_control_items.status_code%TYPE;
7849: l_record_version_number pa_control_items.record_version_number%TYPE;
7850: l_summary pa_control_items.summary%TYPE;
7851: l_description pa_control_items.description%TYPE;
7852: l_curr_owner_id pa_control_items.owner_id%TYPE;
7853: l_owner_id pa_control_items.owner_id%TYPE;
7854: l_classification_code_id pa_control_items.classification_code_id%TYPE;

Line 7851: l_description pa_control_items.description%TYPE;

7847: l_curr_status_code pa_control_items.status_code%TYPE;
7848: l_ci_status_code pa_control_items.status_code%TYPE;
7849: l_record_version_number pa_control_items.record_version_number%TYPE;
7850: l_summary pa_control_items.summary%TYPE;
7851: l_description pa_control_items.description%TYPE;
7852: l_curr_owner_id pa_control_items.owner_id%TYPE;
7853: l_owner_id pa_control_items.owner_id%TYPE;
7854: l_classification_code_id pa_control_items.classification_code_id%TYPE;
7855: l_reason_code_id pa_control_items.reason_code_id%TYPE;

Line 7852: l_curr_owner_id pa_control_items.owner_id%TYPE;

7848: l_ci_status_code pa_control_items.status_code%TYPE;
7849: l_record_version_number pa_control_items.record_version_number%TYPE;
7850: l_summary pa_control_items.summary%TYPE;
7851: l_description pa_control_items.description%TYPE;
7852: l_curr_owner_id pa_control_items.owner_id%TYPE;
7853: l_owner_id pa_control_items.owner_id%TYPE;
7854: l_classification_code_id pa_control_items.classification_code_id%TYPE;
7855: l_reason_code_id pa_control_items.reason_code_id%TYPE;
7856: l_object_id pa_control_items.object_id%TYPE;

Line 7853: l_owner_id pa_control_items.owner_id%TYPE;

7849: l_record_version_number pa_control_items.record_version_number%TYPE;
7850: l_summary pa_control_items.summary%TYPE;
7851: l_description pa_control_items.description%TYPE;
7852: l_curr_owner_id pa_control_items.owner_id%TYPE;
7853: l_owner_id pa_control_items.owner_id%TYPE;
7854: l_classification_code_id pa_control_items.classification_code_id%TYPE;
7855: l_reason_code_id pa_control_items.reason_code_id%TYPE;
7856: l_object_id pa_control_items.object_id%TYPE;
7857: l_object_type pa_control_items.object_type%TYPE;

Line 7854: l_classification_code_id pa_control_items.classification_code_id%TYPE;

7850: l_summary pa_control_items.summary%TYPE;
7851: l_description pa_control_items.description%TYPE;
7852: l_curr_owner_id pa_control_items.owner_id%TYPE;
7853: l_owner_id pa_control_items.owner_id%TYPE;
7854: l_classification_code_id pa_control_items.classification_code_id%TYPE;
7855: l_reason_code_id pa_control_items.reason_code_id%TYPE;
7856: l_object_id pa_control_items.object_id%TYPE;
7857: l_object_type pa_control_items.object_type%TYPE;
7858: l_ci_number pa_control_items.ci_number%TYPE;

Line 7855: l_reason_code_id pa_control_items.reason_code_id%TYPE;

7851: l_description pa_control_items.description%TYPE;
7852: l_curr_owner_id pa_control_items.owner_id%TYPE;
7853: l_owner_id pa_control_items.owner_id%TYPE;
7854: l_classification_code_id pa_control_items.classification_code_id%TYPE;
7855: l_reason_code_id pa_control_items.reason_code_id%TYPE;
7856: l_object_id pa_control_items.object_id%TYPE;
7857: l_object_type pa_control_items.object_type%TYPE;
7858: l_ci_number pa_control_items.ci_number%TYPE;
7859: l_date_required pa_control_items.date_required%TYPE;

Line 7856: l_object_id pa_control_items.object_id%TYPE;

7852: l_curr_owner_id pa_control_items.owner_id%TYPE;
7853: l_owner_id pa_control_items.owner_id%TYPE;
7854: l_classification_code_id pa_control_items.classification_code_id%TYPE;
7855: l_reason_code_id pa_control_items.reason_code_id%TYPE;
7856: l_object_id pa_control_items.object_id%TYPE;
7857: l_object_type pa_control_items.object_type%TYPE;
7858: l_ci_number pa_control_items.ci_number%TYPE;
7859: l_date_required pa_control_items.date_required%TYPE;
7860: l_priority_code pa_control_items.priority_code%TYPE;

Line 7857: l_object_type pa_control_items.object_type%TYPE;

7853: l_owner_id pa_control_items.owner_id%TYPE;
7854: l_classification_code_id pa_control_items.classification_code_id%TYPE;
7855: l_reason_code_id pa_control_items.reason_code_id%TYPE;
7856: l_object_id pa_control_items.object_id%TYPE;
7857: l_object_type pa_control_items.object_type%TYPE;
7858: l_ci_number pa_control_items.ci_number%TYPE;
7859: l_date_required pa_control_items.date_required%TYPE;
7860: l_priority_code pa_control_items.priority_code%TYPE;
7861: l_effort_level_code pa_control_items.effort_level_code%TYPE;

Line 7858: l_ci_number pa_control_items.ci_number%TYPE;

7854: l_classification_code_id pa_control_items.classification_code_id%TYPE;
7855: l_reason_code_id pa_control_items.reason_code_id%TYPE;
7856: l_object_id pa_control_items.object_id%TYPE;
7857: l_object_type pa_control_items.object_type%TYPE;
7858: l_ci_number pa_control_items.ci_number%TYPE;
7859: l_date_required pa_control_items.date_required%TYPE;
7860: l_priority_code pa_control_items.priority_code%TYPE;
7861: l_effort_level_code pa_control_items.effort_level_code%TYPE;
7862: l_price pa_control_items.price%TYPE;

Line 7859: l_date_required pa_control_items.date_required%TYPE;

7855: l_reason_code_id pa_control_items.reason_code_id%TYPE;
7856: l_object_id pa_control_items.object_id%TYPE;
7857: l_object_type pa_control_items.object_type%TYPE;
7858: l_ci_number pa_control_items.ci_number%TYPE;
7859: l_date_required pa_control_items.date_required%TYPE;
7860: l_priority_code pa_control_items.priority_code%TYPE;
7861: l_effort_level_code pa_control_items.effort_level_code%TYPE;
7862: l_price pa_control_items.price%TYPE;
7863: l_price_currency_code pa_control_items.price_currency_code%TYPE;

Line 7860: l_priority_code pa_control_items.priority_code%TYPE;

7856: l_object_id pa_control_items.object_id%TYPE;
7857: l_object_type pa_control_items.object_type%TYPE;
7858: l_ci_number pa_control_items.ci_number%TYPE;
7859: l_date_required pa_control_items.date_required%TYPE;
7860: l_priority_code pa_control_items.priority_code%TYPE;
7861: l_effort_level_code pa_control_items.effort_level_code%TYPE;
7862: l_price pa_control_items.price%TYPE;
7863: l_price_currency_code pa_control_items.price_currency_code%TYPE;
7864: l_source_type_code pa_control_items.source_type_code%TYPE;

Line 7861: l_effort_level_code pa_control_items.effort_level_code%TYPE;

7857: l_object_type pa_control_items.object_type%TYPE;
7858: l_ci_number pa_control_items.ci_number%TYPE;
7859: l_date_required pa_control_items.date_required%TYPE;
7860: l_priority_code pa_control_items.priority_code%TYPE;
7861: l_effort_level_code pa_control_items.effort_level_code%TYPE;
7862: l_price pa_control_items.price%TYPE;
7863: l_price_currency_code pa_control_items.price_currency_code%TYPE;
7864: l_source_type_code pa_control_items.source_type_code%TYPE;
7865: l_source_comment pa_control_items.source_comment%TYPE;

Line 7862: l_price pa_control_items.price%TYPE;

7858: l_ci_number pa_control_items.ci_number%TYPE;
7859: l_date_required pa_control_items.date_required%TYPE;
7860: l_priority_code pa_control_items.priority_code%TYPE;
7861: l_effort_level_code pa_control_items.effort_level_code%TYPE;
7862: l_price pa_control_items.price%TYPE;
7863: l_price_currency_code pa_control_items.price_currency_code%TYPE;
7864: l_source_type_code pa_control_items.source_type_code%TYPE;
7865: l_source_comment pa_control_items.source_comment%TYPE;
7866: l_source_number pa_control_items.source_number%TYPE;

Line 7863: l_price_currency_code pa_control_items.price_currency_code%TYPE;

7859: l_date_required pa_control_items.date_required%TYPE;
7860: l_priority_code pa_control_items.priority_code%TYPE;
7861: l_effort_level_code pa_control_items.effort_level_code%TYPE;
7862: l_price pa_control_items.price%TYPE;
7863: l_price_currency_code pa_control_items.price_currency_code%TYPE;
7864: l_source_type_code pa_control_items.source_type_code%TYPE;
7865: l_source_comment pa_control_items.source_comment%TYPE;
7866: l_source_number pa_control_items.source_number%TYPE;
7867: l_source_date_received pa_control_items.source_date_received%TYPE;

Line 7864: l_source_type_code pa_control_items.source_type_code%TYPE;

7860: l_priority_code pa_control_items.priority_code%TYPE;
7861: l_effort_level_code pa_control_items.effort_level_code%TYPE;
7862: l_price pa_control_items.price%TYPE;
7863: l_price_currency_code pa_control_items.price_currency_code%TYPE;
7864: l_source_type_code pa_control_items.source_type_code%TYPE;
7865: l_source_comment pa_control_items.source_comment%TYPE;
7866: l_source_number pa_control_items.source_number%TYPE;
7867: l_source_date_received pa_control_items.source_date_received%TYPE;
7868: l_source_organization pa_control_items.source_organization%TYPE;

Line 7865: l_source_comment pa_control_items.source_comment%TYPE;

7861: l_effort_level_code pa_control_items.effort_level_code%TYPE;
7862: l_price pa_control_items.price%TYPE;
7863: l_price_currency_code pa_control_items.price_currency_code%TYPE;
7864: l_source_type_code pa_control_items.source_type_code%TYPE;
7865: l_source_comment pa_control_items.source_comment%TYPE;
7866: l_source_number pa_control_items.source_number%TYPE;
7867: l_source_date_received pa_control_items.source_date_received%TYPE;
7868: l_source_organization pa_control_items.source_organization%TYPE;
7869: l_source_person pa_control_items.source_person%TYPE;

Line 7866: l_source_number pa_control_items.source_number%TYPE;

7862: l_price pa_control_items.price%TYPE;
7863: l_price_currency_code pa_control_items.price_currency_code%TYPE;
7864: l_source_type_code pa_control_items.source_type_code%TYPE;
7865: l_source_comment pa_control_items.source_comment%TYPE;
7866: l_source_number pa_control_items.source_number%TYPE;
7867: l_source_date_received pa_control_items.source_date_received%TYPE;
7868: l_source_organization pa_control_items.source_organization%TYPE;
7869: l_source_person pa_control_items.source_person%TYPE;
7870: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;

Line 7867: l_source_date_received pa_control_items.source_date_received%TYPE;

7863: l_price_currency_code pa_control_items.price_currency_code%TYPE;
7864: l_source_type_code pa_control_items.source_type_code%TYPE;
7865: l_source_comment pa_control_items.source_comment%TYPE;
7866: l_source_number pa_control_items.source_number%TYPE;
7867: l_source_date_received pa_control_items.source_date_received%TYPE;
7868: l_source_organization pa_control_items.source_organization%TYPE;
7869: l_source_person pa_control_items.source_person%TYPE;
7870: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
7871: l_progress_status_code pa_control_items.progress_status_code%TYPE;

Line 7868: l_source_organization pa_control_items.source_organization%TYPE;

7864: l_source_type_code pa_control_items.source_type_code%TYPE;
7865: l_source_comment pa_control_items.source_comment%TYPE;
7866: l_source_number pa_control_items.source_number%TYPE;
7867: l_source_date_received pa_control_items.source_date_received%TYPE;
7868: l_source_organization pa_control_items.source_organization%TYPE;
7869: l_source_person pa_control_items.source_person%TYPE;
7870: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
7871: l_progress_status_code pa_control_items.progress_status_code%TYPE;
7872: l_progress_overview pa_control_items.status_overview%TYPE;

Line 7869: l_source_person pa_control_items.source_person%TYPE;

7865: l_source_comment pa_control_items.source_comment%TYPE;
7866: l_source_number pa_control_items.source_number%TYPE;
7867: l_source_date_received pa_control_items.source_date_received%TYPE;
7868: l_source_organization pa_control_items.source_organization%TYPE;
7869: l_source_person pa_control_items.source_person%TYPE;
7870: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
7871: l_progress_status_code pa_control_items.progress_status_code%TYPE;
7872: l_progress_overview pa_control_items.status_overview%TYPE;
7873: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;

Line 7870: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;

7866: l_source_number pa_control_items.source_number%TYPE;
7867: l_source_date_received pa_control_items.source_date_received%TYPE;
7868: l_source_organization pa_control_items.source_organization%TYPE;
7869: l_source_person pa_control_items.source_person%TYPE;
7870: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
7871: l_progress_status_code pa_control_items.progress_status_code%TYPE;
7872: l_progress_overview pa_control_items.status_overview%TYPE;
7873: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
7874: l_resolution_comment pa_control_items.resolution%TYPE;

Line 7871: l_progress_status_code pa_control_items.progress_status_code%TYPE;

7867: l_source_date_received pa_control_items.source_date_received%TYPE;
7868: l_source_organization pa_control_items.source_organization%TYPE;
7869: l_source_person pa_control_items.source_person%TYPE;
7870: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
7871: l_progress_status_code pa_control_items.progress_status_code%TYPE;
7872: l_progress_overview pa_control_items.status_overview%TYPE;
7873: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
7874: l_resolution_comment pa_control_items.resolution%TYPE;
7875: l_date_closed pa_control_items.date_closed%TYPE;

Line 7872: l_progress_overview pa_control_items.status_overview%TYPE;

7868: l_source_organization pa_control_items.source_organization%TYPE;
7869: l_source_person pa_control_items.source_person%TYPE;
7870: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
7871: l_progress_status_code pa_control_items.progress_status_code%TYPE;
7872: l_progress_overview pa_control_items.status_overview%TYPE;
7873: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
7874: l_resolution_comment pa_control_items.resolution%TYPE;
7875: l_date_closed pa_control_items.date_closed%TYPE;
7876: l_closed_by_id pa_control_items.closed_by_id%TYPE;

Line 7873: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;

7869: l_source_person pa_control_items.source_person%TYPE;
7870: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
7871: l_progress_status_code pa_control_items.progress_status_code%TYPE;
7872: l_progress_overview pa_control_items.status_overview%TYPE;
7873: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
7874: l_resolution_comment pa_control_items.resolution%TYPE;
7875: l_date_closed pa_control_items.date_closed%TYPE;
7876: l_closed_by_id pa_control_items.closed_by_id%TYPE;
7877: l_project_id pa_control_items.project_id%TYPE;

Line 7874: l_resolution_comment pa_control_items.resolution%TYPE;

7870: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
7871: l_progress_status_code pa_control_items.progress_status_code%TYPE;
7872: l_progress_overview pa_control_items.status_overview%TYPE;
7873: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
7874: l_resolution_comment pa_control_items.resolution%TYPE;
7875: l_date_closed pa_control_items.date_closed%TYPE;
7876: l_closed_by_id pa_control_items.closed_by_id%TYPE;
7877: l_project_id pa_control_items.project_id%TYPE;
7878: l_ci_type_id pa_control_items.ci_type_id%TYPE;

Line 7875: l_date_closed pa_control_items.date_closed%TYPE;

7871: l_progress_status_code pa_control_items.progress_status_code%TYPE;
7872: l_progress_overview pa_control_items.status_overview%TYPE;
7873: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
7874: l_resolution_comment pa_control_items.resolution%TYPE;
7875: l_date_closed pa_control_items.date_closed%TYPE;
7876: l_closed_by_id pa_control_items.closed_by_id%TYPE;
7877: l_project_id pa_control_items.project_id%TYPE;
7878: l_ci_type_id pa_control_items.ci_type_id%TYPE;
7879: l_attribute_category pa_control_items.attribute_category%TYPE;

Line 7876: l_closed_by_id pa_control_items.closed_by_id%TYPE;

7872: l_progress_overview pa_control_items.status_overview%TYPE;
7873: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
7874: l_resolution_comment pa_control_items.resolution%TYPE;
7875: l_date_closed pa_control_items.date_closed%TYPE;
7876: l_closed_by_id pa_control_items.closed_by_id%TYPE;
7877: l_project_id pa_control_items.project_id%TYPE;
7878: l_ci_type_id pa_control_items.ci_type_id%TYPE;
7879: l_attribute_category pa_control_items.attribute_category%TYPE;
7880: l_attribute1 pa_control_items.attribute1%TYPE;

Line 7877: l_project_id pa_control_items.project_id%TYPE;

7873: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
7874: l_resolution_comment pa_control_items.resolution%TYPE;
7875: l_date_closed pa_control_items.date_closed%TYPE;
7876: l_closed_by_id pa_control_items.closed_by_id%TYPE;
7877: l_project_id pa_control_items.project_id%TYPE;
7878: l_ci_type_id pa_control_items.ci_type_id%TYPE;
7879: l_attribute_category pa_control_items.attribute_category%TYPE;
7880: l_attribute1 pa_control_items.attribute1%TYPE;
7881: l_attribute2 pa_control_items.attribute2%TYPE;

Line 7878: l_ci_type_id pa_control_items.ci_type_id%TYPE;

7874: l_resolution_comment pa_control_items.resolution%TYPE;
7875: l_date_closed pa_control_items.date_closed%TYPE;
7876: l_closed_by_id pa_control_items.closed_by_id%TYPE;
7877: l_project_id pa_control_items.project_id%TYPE;
7878: l_ci_type_id pa_control_items.ci_type_id%TYPE;
7879: l_attribute_category pa_control_items.attribute_category%TYPE;
7880: l_attribute1 pa_control_items.attribute1%TYPE;
7881: l_attribute2 pa_control_items.attribute2%TYPE;
7882: l_attribute3 pa_control_items.attribute3%TYPE;

Line 7879: l_attribute_category pa_control_items.attribute_category%TYPE;

7875: l_date_closed pa_control_items.date_closed%TYPE;
7876: l_closed_by_id pa_control_items.closed_by_id%TYPE;
7877: l_project_id pa_control_items.project_id%TYPE;
7878: l_ci_type_id pa_control_items.ci_type_id%TYPE;
7879: l_attribute_category pa_control_items.attribute_category%TYPE;
7880: l_attribute1 pa_control_items.attribute1%TYPE;
7881: l_attribute2 pa_control_items.attribute2%TYPE;
7882: l_attribute3 pa_control_items.attribute3%TYPE;
7883: l_attribute4 pa_control_items.attribute4%TYPE;

Line 7880: l_attribute1 pa_control_items.attribute1%TYPE;

7876: l_closed_by_id pa_control_items.closed_by_id%TYPE;
7877: l_project_id pa_control_items.project_id%TYPE;
7878: l_ci_type_id pa_control_items.ci_type_id%TYPE;
7879: l_attribute_category pa_control_items.attribute_category%TYPE;
7880: l_attribute1 pa_control_items.attribute1%TYPE;
7881: l_attribute2 pa_control_items.attribute2%TYPE;
7882: l_attribute3 pa_control_items.attribute3%TYPE;
7883: l_attribute4 pa_control_items.attribute4%TYPE;
7884: l_attribute5 pa_control_items.attribute5%TYPE;

Line 7881: l_attribute2 pa_control_items.attribute2%TYPE;

7877: l_project_id pa_control_items.project_id%TYPE;
7878: l_ci_type_id pa_control_items.ci_type_id%TYPE;
7879: l_attribute_category pa_control_items.attribute_category%TYPE;
7880: l_attribute1 pa_control_items.attribute1%TYPE;
7881: l_attribute2 pa_control_items.attribute2%TYPE;
7882: l_attribute3 pa_control_items.attribute3%TYPE;
7883: l_attribute4 pa_control_items.attribute4%TYPE;
7884: l_attribute5 pa_control_items.attribute5%TYPE;
7885: l_attribute6 pa_control_items.attribute6%TYPE;

Line 7882: l_attribute3 pa_control_items.attribute3%TYPE;

7878: l_ci_type_id pa_control_items.ci_type_id%TYPE;
7879: l_attribute_category pa_control_items.attribute_category%TYPE;
7880: l_attribute1 pa_control_items.attribute1%TYPE;
7881: l_attribute2 pa_control_items.attribute2%TYPE;
7882: l_attribute3 pa_control_items.attribute3%TYPE;
7883: l_attribute4 pa_control_items.attribute4%TYPE;
7884: l_attribute5 pa_control_items.attribute5%TYPE;
7885: l_attribute6 pa_control_items.attribute6%TYPE;
7886: l_attribute7 pa_control_items.attribute7%TYPE;

Line 7883: l_attribute4 pa_control_items.attribute4%TYPE;

7879: l_attribute_category pa_control_items.attribute_category%TYPE;
7880: l_attribute1 pa_control_items.attribute1%TYPE;
7881: l_attribute2 pa_control_items.attribute2%TYPE;
7882: l_attribute3 pa_control_items.attribute3%TYPE;
7883: l_attribute4 pa_control_items.attribute4%TYPE;
7884: l_attribute5 pa_control_items.attribute5%TYPE;
7885: l_attribute6 pa_control_items.attribute6%TYPE;
7886: l_attribute7 pa_control_items.attribute7%TYPE;
7887: l_attribute8 pa_control_items.attribute8%TYPE;

Line 7884: l_attribute5 pa_control_items.attribute5%TYPE;

7880: l_attribute1 pa_control_items.attribute1%TYPE;
7881: l_attribute2 pa_control_items.attribute2%TYPE;
7882: l_attribute3 pa_control_items.attribute3%TYPE;
7883: l_attribute4 pa_control_items.attribute4%TYPE;
7884: l_attribute5 pa_control_items.attribute5%TYPE;
7885: l_attribute6 pa_control_items.attribute6%TYPE;
7886: l_attribute7 pa_control_items.attribute7%TYPE;
7887: l_attribute8 pa_control_items.attribute8%TYPE;
7888: l_attribute9 pa_control_items.attribute9%TYPE;

Line 7885: l_attribute6 pa_control_items.attribute6%TYPE;

7881: l_attribute2 pa_control_items.attribute2%TYPE;
7882: l_attribute3 pa_control_items.attribute3%TYPE;
7883: l_attribute4 pa_control_items.attribute4%TYPE;
7884: l_attribute5 pa_control_items.attribute5%TYPE;
7885: l_attribute6 pa_control_items.attribute6%TYPE;
7886: l_attribute7 pa_control_items.attribute7%TYPE;
7887: l_attribute8 pa_control_items.attribute8%TYPE;
7888: l_attribute9 pa_control_items.attribute9%TYPE;
7889: l_attribute10 pa_control_items.attribute10%TYPE;

Line 7886: l_attribute7 pa_control_items.attribute7%TYPE;

7882: l_attribute3 pa_control_items.attribute3%TYPE;
7883: l_attribute4 pa_control_items.attribute4%TYPE;
7884: l_attribute5 pa_control_items.attribute5%TYPE;
7885: l_attribute6 pa_control_items.attribute6%TYPE;
7886: l_attribute7 pa_control_items.attribute7%TYPE;
7887: l_attribute8 pa_control_items.attribute8%TYPE;
7888: l_attribute9 pa_control_items.attribute9%TYPE;
7889: l_attribute10 pa_control_items.attribute10%TYPE;
7890: l_attribute11 pa_control_items.attribute11%TYPE;

Line 7887: l_attribute8 pa_control_items.attribute8%TYPE;

7883: l_attribute4 pa_control_items.attribute4%TYPE;
7884: l_attribute5 pa_control_items.attribute5%TYPE;
7885: l_attribute6 pa_control_items.attribute6%TYPE;
7886: l_attribute7 pa_control_items.attribute7%TYPE;
7887: l_attribute8 pa_control_items.attribute8%TYPE;
7888: l_attribute9 pa_control_items.attribute9%TYPE;
7889: l_attribute10 pa_control_items.attribute10%TYPE;
7890: l_attribute11 pa_control_items.attribute11%TYPE;
7891: l_attribute12 pa_control_items.attribute12%TYPE;

Line 7888: l_attribute9 pa_control_items.attribute9%TYPE;

7884: l_attribute5 pa_control_items.attribute5%TYPE;
7885: l_attribute6 pa_control_items.attribute6%TYPE;
7886: l_attribute7 pa_control_items.attribute7%TYPE;
7887: l_attribute8 pa_control_items.attribute8%TYPE;
7888: l_attribute9 pa_control_items.attribute9%TYPE;
7889: l_attribute10 pa_control_items.attribute10%TYPE;
7890: l_attribute11 pa_control_items.attribute11%TYPE;
7891: l_attribute12 pa_control_items.attribute12%TYPE;
7892: l_attribute13 pa_control_items.attribute13%TYPE;

Line 7889: l_attribute10 pa_control_items.attribute10%TYPE;

7885: l_attribute6 pa_control_items.attribute6%TYPE;
7886: l_attribute7 pa_control_items.attribute7%TYPE;
7887: l_attribute8 pa_control_items.attribute8%TYPE;
7888: l_attribute9 pa_control_items.attribute9%TYPE;
7889: l_attribute10 pa_control_items.attribute10%TYPE;
7890: l_attribute11 pa_control_items.attribute11%TYPE;
7891: l_attribute12 pa_control_items.attribute12%TYPE;
7892: l_attribute13 pa_control_items.attribute13%TYPE;
7893: l_attribute14 pa_control_items.attribute14%TYPE;

Line 7890: l_attribute11 pa_control_items.attribute11%TYPE;

7886: l_attribute7 pa_control_items.attribute7%TYPE;
7887: l_attribute8 pa_control_items.attribute8%TYPE;
7888: l_attribute9 pa_control_items.attribute9%TYPE;
7889: l_attribute10 pa_control_items.attribute10%TYPE;
7890: l_attribute11 pa_control_items.attribute11%TYPE;
7891: l_attribute12 pa_control_items.attribute12%TYPE;
7892: l_attribute13 pa_control_items.attribute13%TYPE;
7893: l_attribute14 pa_control_items.attribute14%TYPE;
7894: l_attribute15 pa_control_items.attribute15%TYPE;

Line 7891: l_attribute12 pa_control_items.attribute12%TYPE;

7887: l_attribute8 pa_control_items.attribute8%TYPE;
7888: l_attribute9 pa_control_items.attribute9%TYPE;
7889: l_attribute10 pa_control_items.attribute10%TYPE;
7890: l_attribute11 pa_control_items.attribute11%TYPE;
7891: l_attribute12 pa_control_items.attribute12%TYPE;
7892: l_attribute13 pa_control_items.attribute13%TYPE;
7893: l_attribute14 pa_control_items.attribute14%TYPE;
7894: l_attribute15 pa_control_items.attribute15%TYPE;
7895: l_class_code constant varchar2(20) := 'CHANGE_REQUEST';

Line 7892: l_attribute13 pa_control_items.attribute13%TYPE;

7888: l_attribute9 pa_control_items.attribute9%TYPE;
7889: l_attribute10 pa_control_items.attribute10%TYPE;
7890: l_attribute11 pa_control_items.attribute11%TYPE;
7891: l_attribute12 pa_control_items.attribute12%TYPE;
7892: l_attribute13 pa_control_items.attribute13%TYPE;
7893: l_attribute14 pa_control_items.attribute14%TYPE;
7894: l_attribute15 pa_control_items.attribute15%TYPE;
7895: l_class_code constant varchar2(20) := 'CHANGE_REQUEST';
7896:

Line 7893: l_attribute14 pa_control_items.attribute14%TYPE;

7889: l_attribute10 pa_control_items.attribute10%TYPE;
7890: l_attribute11 pa_control_items.attribute11%TYPE;
7891: l_attribute12 pa_control_items.attribute12%TYPE;
7892: l_attribute13 pa_control_items.attribute13%TYPE;
7893: l_attribute14 pa_control_items.attribute14%TYPE;
7894: l_attribute15 pa_control_items.attribute15%TYPE;
7895: l_class_code constant varchar2(20) := 'CHANGE_REQUEST';
7896:
7897: CURSOR curr_row is

Line 7894: l_attribute15 pa_control_items.attribute15%TYPE;

7890: l_attribute11 pa_control_items.attribute11%TYPE;
7891: l_attribute12 pa_control_items.attribute12%TYPE;
7892: l_attribute13 pa_control_items.attribute13%TYPE;
7893: l_attribute14 pa_control_items.attribute14%TYPE;
7894: l_attribute15 pa_control_items.attribute15%TYPE;
7895: l_class_code constant varchar2(20) := 'CHANGE_REQUEST';
7896:
7897: CURSOR curr_row is
7898: SELECT *

Line 7899: FROM pa_control_items

7895: l_class_code constant varchar2(20) := 'CHANGE_REQUEST';
7896:
7897: CURSOR curr_row is
7898: SELECT *
7899: FROM pa_control_items
7900: WHERE ci_id = p_ci_id;
7901:
7902: cp curr_row%rowtype;
7903:

Line 7954: pa_control_items ci

7950:
7951: CURSOR c_auto_num IS
7952: SELECT type.auto_number_flag
7953: FROM pa_ci_types_b type,
7954: pa_control_items ci
7955: WHERE ci.ci_id = p_ci_id
7956: AND ci.ci_type_id = type.ci_type_id;
7957:
7958: CURSOR c_ci_number (p_project_id NUMBER, p_ci_type_id NUMBER) IS

Line 7960: FROM pa_control_items

7956: AND ci.ci_type_id = type.ci_type_id;
7957:
7958: CURSOR c_ci_number (p_project_id NUMBER, p_ci_type_id NUMBER) IS
7959: SELECT ROWID
7960: FROM pa_control_items
7961: WHERE project_id = p_project_id
7962: AND ci_number = p_ci_number
7963: AND ci_id <> p_ci_id
7964: AND ci_type_id = p_ci_type_id;

Line 7970: FROM pa_control_items c,

7966: CURSOR c_info IS
7967: SELECT cit.ci_type_class_code,
7968: cit.approval_required_flag,
7969: s.next_allowable_status_flag
7970: FROM pa_control_items c,
7971: pa_ci_types_b cit,
7972: pa_project_statuses s
7973: WHERE c.ci_id = p_ci_id
7974: AND c.status_code = s.project_status_code

Line 8130: l_curr_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_curr_status_code);

8126: end if;
8127:
8128:
8129:
8130: l_curr_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_curr_status_code);
8131:
8132: /* Check if the user can update the item. This requires the user to be owner or to have project authority or
8133: to have open UPDATE actions and status controls are satisfied. */
8134:

Line 8150: l_chk_status_ctrl := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_curr_status_code, 'CONTROL_ITEM_ALLOW_UPDATE');

8146: END IF;
8147:
8148: /* Check for the status control: check whether the action CONTROL_ITEM_ALLOW_UPDATE is allowed on the current status of the issue. */
8149:
8150: l_chk_status_ctrl := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_curr_status_code, 'CONTROL_ITEM_ALLOW_UPDATE');
8151:
8152: IF (l_chk_status_ctrl = 'N') THEN
8153:
8154: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_ALLOW_UPDATE');

Line 8161: pa_debug.write(l_module, 'After call to pa_control_items_utils.CheckCIActionAllowed', l_debug_level3);

8157: END IF;
8158:
8159:
8160: IF l_debug_mode = 'Y' THEN
8161: pa_debug.write(l_module, 'After call to pa_control_items_utils.CheckCIActionAllowed', l_debug_level3);
8162: END IF;
8163:
8164: /* The control item will not be updateable if the current status has approval workflow attached. */
8165:

Line 8217: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

8213: '''CONTROL_ITEM'''||' and wf_success_status_code is not null and wf_failure_status_code is not null)'||
8214: ' AND ps.project_status_code not in (select wf_failure_status_code from pa_project_statuses where status_type = '||
8215: '''CONTROL_ITEM'''||' and wf_success_status_code is not null and wf_failure_status_code is not null)'||
8216: ' AND decode(ps.project_system_status_code, '||'''CI_CANCELED'''||
8217: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
8218: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
8219: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
8220: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
8221: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||

Line 8220: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

8216: ' AND decode(ps.project_system_status_code, '||'''CI_CANCELED'''||
8217: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
8218: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
8219: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
8220: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
8221: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
8222: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
8223: '''CONTROL_ITEM_ALLOW_UPDST'''||' ,null),'||'''N'''||' ) = '||'''Y'''||
8224: ' AND decode(ps.project_system_status_code,'||'''CI_DRAFT'''||

Line 8222: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

8218: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
8219: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
8220: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
8221: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
8222: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
8223: '''CONTROL_ITEM_ALLOW_UPDST'''||' ,null),'||'''N'''||' ) = '||'''Y'''||
8224: ' AND decode(ps.project_system_status_code,'||'''CI_DRAFT'''||
8225: ' ,decode('||''''||l_curr_system_status||''''||', '||'''CI_DRAFT'''||', '||
8226: '''Y'''||' ,'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||

Line 8369: /* Getting validated in pa_control_items_pub.update_control_item API. */

8365: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8366: ,p_msg_name => 'PA_CI_CHANGE_OWNER_INVALID');
8367: x_return_status := 'E';
8368: END IF;
8369: /* Getting validated in pa_control_items_pub.update_control_item API. */
8370: ELSIF p_owner_id IS NULL THEN
8371: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8372: ,p_msg_name => 'PA_CI_OWNER_NULL');
8373: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8503: /* Getting validated in pa_control_items_pvt.update_control_item API. */

8499: IF p_price_currency_code = G_PA_MISS_CHAR THEN
8500: NULL;
8501: ELSIF p_price_currency_code IS NOT NULL THEN
8502: l_price_currency_code := p_price_currency_code;
8503: /* Getting validated in pa_control_items_pvt.update_control_item API. */
8504: ELSIF p_price_currency_code IS NULL THEN
8505: l_price_currency_code := p_price_currency_code;
8506: END IF;
8507:

Line 8573: l_new_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_ci_status_code);

8569:
8570: IF (p_ci_number = G_PA_MISS_CHAR OR p_ci_number IS NULL) THEN
8571:
8572: IF l_ci_status_code IS NOT NULL THEN
8573: l_new_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_ci_status_code);
8574: END IF;
8575:
8576: IF p_ci_number = G_PA_MISS_CHAR THEN
8577: IF l_ci_number IS NULL THEN

Line 8770: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (

8766: IF l_debug_mode = 'Y' THEN
8767: pa_debug.write(l_module, 'before call to ChangeCIStatusValidate', l_debug_level3);
8768: END IF;
8769:
8770: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (
8771: p_init_msg_list => p_init_msg_list
8772: ,p_commit => p_commit
8773: ,p_validate_only => l_validate_only
8774: ,p_max_msg_count => l_max_msg_count

Line 8806: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

8802: pa_debug.write(l_module, 'After call to ChangeCIStatusValidate :l_status_change_flag = '||l_status_change_flag, l_debug_level3);
8803: END IF;
8804:
8805: IF (l_resolution_req IS NOT NULL AND l_resolution_req = 'Y') THEN
8806: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN
8807: IF (l_resolution_code_id IS NULL) THEN
8808: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8809: ,p_msg_name => 'PA_CI_RESOLUTION_OPEN');
8810: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8822: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

8818: END IF;
8819: END IF;
8820:
8821: IF (l_resolution_req_cls IS NOT NULL AND l_resolution_req_cls = 'Y') THEN
8822: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN
8823: IF (l_resolution_code_id IS NULL) THEN
8824: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8825: ,p_msg_name => 'PA_CI_CLOSE_INV_RES');
8826: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8843: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM', l_debug_level3);

8839:
8840: IF (l_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
8841:
8842: IF l_debug_mode = 'Y' THEN
8843: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM', l_debug_level3);
8844: END IF;
8845:
8846: PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM (
8847: p_api_version => 1.0

Line 8846: PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM (

8842: IF l_debug_mode = 'Y' THEN
8843: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM', l_debug_level3);
8844: END IF;
8845:
8846: PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM (
8847: p_api_version => 1.0
8848: ,p_init_msg_list => fnd_api.g_false
8849: ,p_commit => FND_API.g_false
8850: ,p_validate_only => FND_API.g_false

Line 8909: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM : x_return_status = '||x_return_status, l_debug_level3);

8905: ,x_msg_data => x_msg_data
8906: );
8907:
8908: IF l_debug_mode = 'Y' THEN
8909: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM : x_return_status = '||x_return_status, l_debug_level3);
8910: END IF;
8911:
8912: END IF;
8913:

Line 8919: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);

8915:
8916: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
8917:
8918: IF l_debug_mode = 'Y' THEN
8919: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
8920: END IF;
8921:
8922: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'
8923: ,p_object_id => p_ci_id

Line 8922: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'

8918: IF l_debug_mode = 'Y' THEN
8919: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
8920: END IF;
8921:
8922: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'
8923: ,p_object_id => p_ci_id
8924: ,p_type_code => 'CHANGE_STATUS'
8925: ,p_status_type => 'CONTROL_ITEM'
8926: ,p_new_project_status => l_ci_status_code

Line 8935: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);

8931: ,x_msg_data => x_msg_data );
8932:
8933:
8934: IF l_debug_mode = 'Y' THEN
8935: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
8936: END IF;
8937:
8938: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (
8939: p_init_msg_list

Line 8938: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (

8934: IF l_debug_mode = 'Y' THEN
8935: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
8936: END IF;
8937:
8938: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (
8939: p_init_msg_list
8940: ,p_commit
8941: ,l_validate_only
8942: ,l_max_msg_count

Line 8955: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus', l_debug_level3);

8951: ,x_msg_data );
8952:
8953:
8954: IF l_debug_mode = 'Y' THEN
8955: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus', l_debug_level3);
8956: END IF;
8957:
8958: END IF;
8959:

Line 9105: l_curr_status_code pa_control_items.status_code%TYPE;

9101: l_chk_status_ctrl VARCHAR2(1) := 'N';
9102: l_module VARCHAR2(100) := 'PA_CONTROL_API_PUB.UPDATE_CHANGE_ORDER';
9103:
9104:
9105: l_curr_status_code pa_control_items.status_code%TYPE;
9106: l_ci_status_code pa_control_items.status_code%TYPE;
9107: l_record_version_number pa_control_items.record_version_number%TYPE;
9108: l_summary pa_control_items.summary%TYPE;
9109: l_description pa_control_items.description%TYPE;

Line 9106: l_ci_status_code pa_control_items.status_code%TYPE;

9102: l_module VARCHAR2(100) := 'PA_CONTROL_API_PUB.UPDATE_CHANGE_ORDER';
9103:
9104:
9105: l_curr_status_code pa_control_items.status_code%TYPE;
9106: l_ci_status_code pa_control_items.status_code%TYPE;
9107: l_record_version_number pa_control_items.record_version_number%TYPE;
9108: l_summary pa_control_items.summary%TYPE;
9109: l_description pa_control_items.description%TYPE;
9110: l_curr_owner_id pa_control_items.owner_id%TYPE;

Line 9107: l_record_version_number pa_control_items.record_version_number%TYPE;

9103:
9104:
9105: l_curr_status_code pa_control_items.status_code%TYPE;
9106: l_ci_status_code pa_control_items.status_code%TYPE;
9107: l_record_version_number pa_control_items.record_version_number%TYPE;
9108: l_summary pa_control_items.summary%TYPE;
9109: l_description pa_control_items.description%TYPE;
9110: l_curr_owner_id pa_control_items.owner_id%TYPE;
9111: l_owner_id pa_control_items.owner_id%TYPE;

Line 9108: l_summary pa_control_items.summary%TYPE;

9104:
9105: l_curr_status_code pa_control_items.status_code%TYPE;
9106: l_ci_status_code pa_control_items.status_code%TYPE;
9107: l_record_version_number pa_control_items.record_version_number%TYPE;
9108: l_summary pa_control_items.summary%TYPE;
9109: l_description pa_control_items.description%TYPE;
9110: l_curr_owner_id pa_control_items.owner_id%TYPE;
9111: l_owner_id pa_control_items.owner_id%TYPE;
9112: l_classification_code_id pa_control_items.classification_code_id%TYPE;

Line 9109: l_description pa_control_items.description%TYPE;

9105: l_curr_status_code pa_control_items.status_code%TYPE;
9106: l_ci_status_code pa_control_items.status_code%TYPE;
9107: l_record_version_number pa_control_items.record_version_number%TYPE;
9108: l_summary pa_control_items.summary%TYPE;
9109: l_description pa_control_items.description%TYPE;
9110: l_curr_owner_id pa_control_items.owner_id%TYPE;
9111: l_owner_id pa_control_items.owner_id%TYPE;
9112: l_classification_code_id pa_control_items.classification_code_id%TYPE;
9113: l_reason_code_id pa_control_items.reason_code_id%TYPE;

Line 9110: l_curr_owner_id pa_control_items.owner_id%TYPE;

9106: l_ci_status_code pa_control_items.status_code%TYPE;
9107: l_record_version_number pa_control_items.record_version_number%TYPE;
9108: l_summary pa_control_items.summary%TYPE;
9109: l_description pa_control_items.description%TYPE;
9110: l_curr_owner_id pa_control_items.owner_id%TYPE;
9111: l_owner_id pa_control_items.owner_id%TYPE;
9112: l_classification_code_id pa_control_items.classification_code_id%TYPE;
9113: l_reason_code_id pa_control_items.reason_code_id%TYPE;
9114: l_object_id pa_control_items.object_id%TYPE;

Line 9111: l_owner_id pa_control_items.owner_id%TYPE;

9107: l_record_version_number pa_control_items.record_version_number%TYPE;
9108: l_summary pa_control_items.summary%TYPE;
9109: l_description pa_control_items.description%TYPE;
9110: l_curr_owner_id pa_control_items.owner_id%TYPE;
9111: l_owner_id pa_control_items.owner_id%TYPE;
9112: l_classification_code_id pa_control_items.classification_code_id%TYPE;
9113: l_reason_code_id pa_control_items.reason_code_id%TYPE;
9114: l_object_id pa_control_items.object_id%TYPE;
9115: l_object_type pa_control_items.object_type%TYPE;

Line 9112: l_classification_code_id pa_control_items.classification_code_id%TYPE;

9108: l_summary pa_control_items.summary%TYPE;
9109: l_description pa_control_items.description%TYPE;
9110: l_curr_owner_id pa_control_items.owner_id%TYPE;
9111: l_owner_id pa_control_items.owner_id%TYPE;
9112: l_classification_code_id pa_control_items.classification_code_id%TYPE;
9113: l_reason_code_id pa_control_items.reason_code_id%TYPE;
9114: l_object_id pa_control_items.object_id%TYPE;
9115: l_object_type pa_control_items.object_type%TYPE;
9116: l_ci_number pa_control_items.ci_number%TYPE;

Line 9113: l_reason_code_id pa_control_items.reason_code_id%TYPE;

9109: l_description pa_control_items.description%TYPE;
9110: l_curr_owner_id pa_control_items.owner_id%TYPE;
9111: l_owner_id pa_control_items.owner_id%TYPE;
9112: l_classification_code_id pa_control_items.classification_code_id%TYPE;
9113: l_reason_code_id pa_control_items.reason_code_id%TYPE;
9114: l_object_id pa_control_items.object_id%TYPE;
9115: l_object_type pa_control_items.object_type%TYPE;
9116: l_ci_number pa_control_items.ci_number%TYPE;
9117: l_date_required pa_control_items.date_required%TYPE;

Line 9114: l_object_id pa_control_items.object_id%TYPE;

9110: l_curr_owner_id pa_control_items.owner_id%TYPE;
9111: l_owner_id pa_control_items.owner_id%TYPE;
9112: l_classification_code_id pa_control_items.classification_code_id%TYPE;
9113: l_reason_code_id pa_control_items.reason_code_id%TYPE;
9114: l_object_id pa_control_items.object_id%TYPE;
9115: l_object_type pa_control_items.object_type%TYPE;
9116: l_ci_number pa_control_items.ci_number%TYPE;
9117: l_date_required pa_control_items.date_required%TYPE;
9118: l_priority_code pa_control_items.priority_code%TYPE;

Line 9115: l_object_type pa_control_items.object_type%TYPE;

9111: l_owner_id pa_control_items.owner_id%TYPE;
9112: l_classification_code_id pa_control_items.classification_code_id%TYPE;
9113: l_reason_code_id pa_control_items.reason_code_id%TYPE;
9114: l_object_id pa_control_items.object_id%TYPE;
9115: l_object_type pa_control_items.object_type%TYPE;
9116: l_ci_number pa_control_items.ci_number%TYPE;
9117: l_date_required pa_control_items.date_required%TYPE;
9118: l_priority_code pa_control_items.priority_code%TYPE;
9119: l_effort_level_code pa_control_items.effort_level_code%TYPE;

Line 9116: l_ci_number pa_control_items.ci_number%TYPE;

9112: l_classification_code_id pa_control_items.classification_code_id%TYPE;
9113: l_reason_code_id pa_control_items.reason_code_id%TYPE;
9114: l_object_id pa_control_items.object_id%TYPE;
9115: l_object_type pa_control_items.object_type%TYPE;
9116: l_ci_number pa_control_items.ci_number%TYPE;
9117: l_date_required pa_control_items.date_required%TYPE;
9118: l_priority_code pa_control_items.priority_code%TYPE;
9119: l_effort_level_code pa_control_items.effort_level_code%TYPE;
9120: l_price pa_control_items.price%TYPE;

Line 9117: l_date_required pa_control_items.date_required%TYPE;

9113: l_reason_code_id pa_control_items.reason_code_id%TYPE;
9114: l_object_id pa_control_items.object_id%TYPE;
9115: l_object_type pa_control_items.object_type%TYPE;
9116: l_ci_number pa_control_items.ci_number%TYPE;
9117: l_date_required pa_control_items.date_required%TYPE;
9118: l_priority_code pa_control_items.priority_code%TYPE;
9119: l_effort_level_code pa_control_items.effort_level_code%TYPE;
9120: l_price pa_control_items.price%TYPE;
9121: l_price_currency_code pa_control_items.price_currency_code%TYPE;

Line 9118: l_priority_code pa_control_items.priority_code%TYPE;

9114: l_object_id pa_control_items.object_id%TYPE;
9115: l_object_type pa_control_items.object_type%TYPE;
9116: l_ci_number pa_control_items.ci_number%TYPE;
9117: l_date_required pa_control_items.date_required%TYPE;
9118: l_priority_code pa_control_items.priority_code%TYPE;
9119: l_effort_level_code pa_control_items.effort_level_code%TYPE;
9120: l_price pa_control_items.price%TYPE;
9121: l_price_currency_code pa_control_items.price_currency_code%TYPE;
9122: l_source_type_code pa_control_items.source_type_code%TYPE;

Line 9119: l_effort_level_code pa_control_items.effort_level_code%TYPE;

9115: l_object_type pa_control_items.object_type%TYPE;
9116: l_ci_number pa_control_items.ci_number%TYPE;
9117: l_date_required pa_control_items.date_required%TYPE;
9118: l_priority_code pa_control_items.priority_code%TYPE;
9119: l_effort_level_code pa_control_items.effort_level_code%TYPE;
9120: l_price pa_control_items.price%TYPE;
9121: l_price_currency_code pa_control_items.price_currency_code%TYPE;
9122: l_source_type_code pa_control_items.source_type_code%TYPE;
9123: l_source_comment pa_control_items.source_comment%TYPE;

Line 9120: l_price pa_control_items.price%TYPE;

9116: l_ci_number pa_control_items.ci_number%TYPE;
9117: l_date_required pa_control_items.date_required%TYPE;
9118: l_priority_code pa_control_items.priority_code%TYPE;
9119: l_effort_level_code pa_control_items.effort_level_code%TYPE;
9120: l_price pa_control_items.price%TYPE;
9121: l_price_currency_code pa_control_items.price_currency_code%TYPE;
9122: l_source_type_code pa_control_items.source_type_code%TYPE;
9123: l_source_comment pa_control_items.source_comment%TYPE;
9124: l_source_number pa_control_items.source_number%TYPE;

Line 9121: l_price_currency_code pa_control_items.price_currency_code%TYPE;

9117: l_date_required pa_control_items.date_required%TYPE;
9118: l_priority_code pa_control_items.priority_code%TYPE;
9119: l_effort_level_code pa_control_items.effort_level_code%TYPE;
9120: l_price pa_control_items.price%TYPE;
9121: l_price_currency_code pa_control_items.price_currency_code%TYPE;
9122: l_source_type_code pa_control_items.source_type_code%TYPE;
9123: l_source_comment pa_control_items.source_comment%TYPE;
9124: l_source_number pa_control_items.source_number%TYPE;
9125: l_source_date_received pa_control_items.source_date_received%TYPE;

Line 9122: l_source_type_code pa_control_items.source_type_code%TYPE;

9118: l_priority_code pa_control_items.priority_code%TYPE;
9119: l_effort_level_code pa_control_items.effort_level_code%TYPE;
9120: l_price pa_control_items.price%TYPE;
9121: l_price_currency_code pa_control_items.price_currency_code%TYPE;
9122: l_source_type_code pa_control_items.source_type_code%TYPE;
9123: l_source_comment pa_control_items.source_comment%TYPE;
9124: l_source_number pa_control_items.source_number%TYPE;
9125: l_source_date_received pa_control_items.source_date_received%TYPE;
9126: l_source_organization pa_control_items.source_organization%TYPE;

Line 9123: l_source_comment pa_control_items.source_comment%TYPE;

9119: l_effort_level_code pa_control_items.effort_level_code%TYPE;
9120: l_price pa_control_items.price%TYPE;
9121: l_price_currency_code pa_control_items.price_currency_code%TYPE;
9122: l_source_type_code pa_control_items.source_type_code%TYPE;
9123: l_source_comment pa_control_items.source_comment%TYPE;
9124: l_source_number pa_control_items.source_number%TYPE;
9125: l_source_date_received pa_control_items.source_date_received%TYPE;
9126: l_source_organization pa_control_items.source_organization%TYPE;
9127: l_source_person pa_control_items.source_person%TYPE;

Line 9124: l_source_number pa_control_items.source_number%TYPE;

9120: l_price pa_control_items.price%TYPE;
9121: l_price_currency_code pa_control_items.price_currency_code%TYPE;
9122: l_source_type_code pa_control_items.source_type_code%TYPE;
9123: l_source_comment pa_control_items.source_comment%TYPE;
9124: l_source_number pa_control_items.source_number%TYPE;
9125: l_source_date_received pa_control_items.source_date_received%TYPE;
9126: l_source_organization pa_control_items.source_organization%TYPE;
9127: l_source_person pa_control_items.source_person%TYPE;
9128: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;

Line 9125: l_source_date_received pa_control_items.source_date_received%TYPE;

9121: l_price_currency_code pa_control_items.price_currency_code%TYPE;
9122: l_source_type_code pa_control_items.source_type_code%TYPE;
9123: l_source_comment pa_control_items.source_comment%TYPE;
9124: l_source_number pa_control_items.source_number%TYPE;
9125: l_source_date_received pa_control_items.source_date_received%TYPE;
9126: l_source_organization pa_control_items.source_organization%TYPE;
9127: l_source_person pa_control_items.source_person%TYPE;
9128: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
9129: l_progress_status_code pa_control_items.progress_status_code%TYPE;

Line 9126: l_source_organization pa_control_items.source_organization%TYPE;

9122: l_source_type_code pa_control_items.source_type_code%TYPE;
9123: l_source_comment pa_control_items.source_comment%TYPE;
9124: l_source_number pa_control_items.source_number%TYPE;
9125: l_source_date_received pa_control_items.source_date_received%TYPE;
9126: l_source_organization pa_control_items.source_organization%TYPE;
9127: l_source_person pa_control_items.source_person%TYPE;
9128: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
9129: l_progress_status_code pa_control_items.progress_status_code%TYPE;
9130: l_progress_overview pa_control_items.status_overview%TYPE;

Line 9127: l_source_person pa_control_items.source_person%TYPE;

9123: l_source_comment pa_control_items.source_comment%TYPE;
9124: l_source_number pa_control_items.source_number%TYPE;
9125: l_source_date_received pa_control_items.source_date_received%TYPE;
9126: l_source_organization pa_control_items.source_organization%TYPE;
9127: l_source_person pa_control_items.source_person%TYPE;
9128: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
9129: l_progress_status_code pa_control_items.progress_status_code%TYPE;
9130: l_progress_overview pa_control_items.status_overview%TYPE;
9131: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;

Line 9128: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;

9124: l_source_number pa_control_items.source_number%TYPE;
9125: l_source_date_received pa_control_items.source_date_received%TYPE;
9126: l_source_organization pa_control_items.source_organization%TYPE;
9127: l_source_person pa_control_items.source_person%TYPE;
9128: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
9129: l_progress_status_code pa_control_items.progress_status_code%TYPE;
9130: l_progress_overview pa_control_items.status_overview%TYPE;
9131: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
9132: l_resolution_comment pa_control_items.resolution%TYPE;

Line 9129: l_progress_status_code pa_control_items.progress_status_code%TYPE;

9125: l_source_date_received pa_control_items.source_date_received%TYPE;
9126: l_source_organization pa_control_items.source_organization%TYPE;
9127: l_source_person pa_control_items.source_person%TYPE;
9128: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
9129: l_progress_status_code pa_control_items.progress_status_code%TYPE;
9130: l_progress_overview pa_control_items.status_overview%TYPE;
9131: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
9132: l_resolution_comment pa_control_items.resolution%TYPE;
9133: l_date_closed pa_control_items.date_closed%TYPE;

Line 9130: l_progress_overview pa_control_items.status_overview%TYPE;

9126: l_source_organization pa_control_items.source_organization%TYPE;
9127: l_source_person pa_control_items.source_person%TYPE;
9128: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
9129: l_progress_status_code pa_control_items.progress_status_code%TYPE;
9130: l_progress_overview pa_control_items.status_overview%TYPE;
9131: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
9132: l_resolution_comment pa_control_items.resolution%TYPE;
9133: l_date_closed pa_control_items.date_closed%TYPE;
9134: l_closed_by_id pa_control_items.closed_by_id%TYPE;

Line 9131: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;

9127: l_source_person pa_control_items.source_person%TYPE;
9128: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
9129: l_progress_status_code pa_control_items.progress_status_code%TYPE;
9130: l_progress_overview pa_control_items.status_overview%TYPE;
9131: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
9132: l_resolution_comment pa_control_items.resolution%TYPE;
9133: l_date_closed pa_control_items.date_closed%TYPE;
9134: l_closed_by_id pa_control_items.closed_by_id%TYPE;
9135: l_project_id pa_control_items.project_id%TYPE;

Line 9132: l_resolution_comment pa_control_items.resolution%TYPE;

9128: l_progress_as_of_date pa_control_items.progress_as_of_date%TYPE;
9129: l_progress_status_code pa_control_items.progress_status_code%TYPE;
9130: l_progress_overview pa_control_items.status_overview%TYPE;
9131: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
9132: l_resolution_comment pa_control_items.resolution%TYPE;
9133: l_date_closed pa_control_items.date_closed%TYPE;
9134: l_closed_by_id pa_control_items.closed_by_id%TYPE;
9135: l_project_id pa_control_items.project_id%TYPE;
9136: l_ci_type_id pa_control_items.ci_type_id%TYPE;

Line 9133: l_date_closed pa_control_items.date_closed%TYPE;

9129: l_progress_status_code pa_control_items.progress_status_code%TYPE;
9130: l_progress_overview pa_control_items.status_overview%TYPE;
9131: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
9132: l_resolution_comment pa_control_items.resolution%TYPE;
9133: l_date_closed pa_control_items.date_closed%TYPE;
9134: l_closed_by_id pa_control_items.closed_by_id%TYPE;
9135: l_project_id pa_control_items.project_id%TYPE;
9136: l_ci_type_id pa_control_items.ci_type_id%TYPE;
9137: l_attribute_category pa_control_items.attribute_category%TYPE;

Line 9134: l_closed_by_id pa_control_items.closed_by_id%TYPE;

9130: l_progress_overview pa_control_items.status_overview%TYPE;
9131: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
9132: l_resolution_comment pa_control_items.resolution%TYPE;
9133: l_date_closed pa_control_items.date_closed%TYPE;
9134: l_closed_by_id pa_control_items.closed_by_id%TYPE;
9135: l_project_id pa_control_items.project_id%TYPE;
9136: l_ci_type_id pa_control_items.ci_type_id%TYPE;
9137: l_attribute_category pa_control_items.attribute_category%TYPE;
9138: l_attribute1 pa_control_items.attribute1%TYPE;

Line 9135: l_project_id pa_control_items.project_id%TYPE;

9131: l_resolution_code_id pa_control_items.resolution_code_id%TYPE;
9132: l_resolution_comment pa_control_items.resolution%TYPE;
9133: l_date_closed pa_control_items.date_closed%TYPE;
9134: l_closed_by_id pa_control_items.closed_by_id%TYPE;
9135: l_project_id pa_control_items.project_id%TYPE;
9136: l_ci_type_id pa_control_items.ci_type_id%TYPE;
9137: l_attribute_category pa_control_items.attribute_category%TYPE;
9138: l_attribute1 pa_control_items.attribute1%TYPE;
9139: l_attribute2 pa_control_items.attribute2%TYPE;

Line 9136: l_ci_type_id pa_control_items.ci_type_id%TYPE;

9132: l_resolution_comment pa_control_items.resolution%TYPE;
9133: l_date_closed pa_control_items.date_closed%TYPE;
9134: l_closed_by_id pa_control_items.closed_by_id%TYPE;
9135: l_project_id pa_control_items.project_id%TYPE;
9136: l_ci_type_id pa_control_items.ci_type_id%TYPE;
9137: l_attribute_category pa_control_items.attribute_category%TYPE;
9138: l_attribute1 pa_control_items.attribute1%TYPE;
9139: l_attribute2 pa_control_items.attribute2%TYPE;
9140: l_attribute3 pa_control_items.attribute3%TYPE;

Line 9137: l_attribute_category pa_control_items.attribute_category%TYPE;

9133: l_date_closed pa_control_items.date_closed%TYPE;
9134: l_closed_by_id pa_control_items.closed_by_id%TYPE;
9135: l_project_id pa_control_items.project_id%TYPE;
9136: l_ci_type_id pa_control_items.ci_type_id%TYPE;
9137: l_attribute_category pa_control_items.attribute_category%TYPE;
9138: l_attribute1 pa_control_items.attribute1%TYPE;
9139: l_attribute2 pa_control_items.attribute2%TYPE;
9140: l_attribute3 pa_control_items.attribute3%TYPE;
9141: l_attribute4 pa_control_items.attribute4%TYPE;

Line 9138: l_attribute1 pa_control_items.attribute1%TYPE;

9134: l_closed_by_id pa_control_items.closed_by_id%TYPE;
9135: l_project_id pa_control_items.project_id%TYPE;
9136: l_ci_type_id pa_control_items.ci_type_id%TYPE;
9137: l_attribute_category pa_control_items.attribute_category%TYPE;
9138: l_attribute1 pa_control_items.attribute1%TYPE;
9139: l_attribute2 pa_control_items.attribute2%TYPE;
9140: l_attribute3 pa_control_items.attribute3%TYPE;
9141: l_attribute4 pa_control_items.attribute4%TYPE;
9142: l_attribute5 pa_control_items.attribute5%TYPE;

Line 9139: l_attribute2 pa_control_items.attribute2%TYPE;

9135: l_project_id pa_control_items.project_id%TYPE;
9136: l_ci_type_id pa_control_items.ci_type_id%TYPE;
9137: l_attribute_category pa_control_items.attribute_category%TYPE;
9138: l_attribute1 pa_control_items.attribute1%TYPE;
9139: l_attribute2 pa_control_items.attribute2%TYPE;
9140: l_attribute3 pa_control_items.attribute3%TYPE;
9141: l_attribute4 pa_control_items.attribute4%TYPE;
9142: l_attribute5 pa_control_items.attribute5%TYPE;
9143: l_attribute6 pa_control_items.attribute6%TYPE;

Line 9140: l_attribute3 pa_control_items.attribute3%TYPE;

9136: l_ci_type_id pa_control_items.ci_type_id%TYPE;
9137: l_attribute_category pa_control_items.attribute_category%TYPE;
9138: l_attribute1 pa_control_items.attribute1%TYPE;
9139: l_attribute2 pa_control_items.attribute2%TYPE;
9140: l_attribute3 pa_control_items.attribute3%TYPE;
9141: l_attribute4 pa_control_items.attribute4%TYPE;
9142: l_attribute5 pa_control_items.attribute5%TYPE;
9143: l_attribute6 pa_control_items.attribute6%TYPE;
9144: l_attribute7 pa_control_items.attribute7%TYPE;

Line 9141: l_attribute4 pa_control_items.attribute4%TYPE;

9137: l_attribute_category pa_control_items.attribute_category%TYPE;
9138: l_attribute1 pa_control_items.attribute1%TYPE;
9139: l_attribute2 pa_control_items.attribute2%TYPE;
9140: l_attribute3 pa_control_items.attribute3%TYPE;
9141: l_attribute4 pa_control_items.attribute4%TYPE;
9142: l_attribute5 pa_control_items.attribute5%TYPE;
9143: l_attribute6 pa_control_items.attribute6%TYPE;
9144: l_attribute7 pa_control_items.attribute7%TYPE;
9145: l_attribute8 pa_control_items.attribute8%TYPE;

Line 9142: l_attribute5 pa_control_items.attribute5%TYPE;

9138: l_attribute1 pa_control_items.attribute1%TYPE;
9139: l_attribute2 pa_control_items.attribute2%TYPE;
9140: l_attribute3 pa_control_items.attribute3%TYPE;
9141: l_attribute4 pa_control_items.attribute4%TYPE;
9142: l_attribute5 pa_control_items.attribute5%TYPE;
9143: l_attribute6 pa_control_items.attribute6%TYPE;
9144: l_attribute7 pa_control_items.attribute7%TYPE;
9145: l_attribute8 pa_control_items.attribute8%TYPE;
9146: l_attribute9 pa_control_items.attribute9%TYPE;

Line 9143: l_attribute6 pa_control_items.attribute6%TYPE;

9139: l_attribute2 pa_control_items.attribute2%TYPE;
9140: l_attribute3 pa_control_items.attribute3%TYPE;
9141: l_attribute4 pa_control_items.attribute4%TYPE;
9142: l_attribute5 pa_control_items.attribute5%TYPE;
9143: l_attribute6 pa_control_items.attribute6%TYPE;
9144: l_attribute7 pa_control_items.attribute7%TYPE;
9145: l_attribute8 pa_control_items.attribute8%TYPE;
9146: l_attribute9 pa_control_items.attribute9%TYPE;
9147: l_attribute10 pa_control_items.attribute10%TYPE;

Line 9144: l_attribute7 pa_control_items.attribute7%TYPE;

9140: l_attribute3 pa_control_items.attribute3%TYPE;
9141: l_attribute4 pa_control_items.attribute4%TYPE;
9142: l_attribute5 pa_control_items.attribute5%TYPE;
9143: l_attribute6 pa_control_items.attribute6%TYPE;
9144: l_attribute7 pa_control_items.attribute7%TYPE;
9145: l_attribute8 pa_control_items.attribute8%TYPE;
9146: l_attribute9 pa_control_items.attribute9%TYPE;
9147: l_attribute10 pa_control_items.attribute10%TYPE;
9148: l_attribute11 pa_control_items.attribute11%TYPE;

Line 9145: l_attribute8 pa_control_items.attribute8%TYPE;

9141: l_attribute4 pa_control_items.attribute4%TYPE;
9142: l_attribute5 pa_control_items.attribute5%TYPE;
9143: l_attribute6 pa_control_items.attribute6%TYPE;
9144: l_attribute7 pa_control_items.attribute7%TYPE;
9145: l_attribute8 pa_control_items.attribute8%TYPE;
9146: l_attribute9 pa_control_items.attribute9%TYPE;
9147: l_attribute10 pa_control_items.attribute10%TYPE;
9148: l_attribute11 pa_control_items.attribute11%TYPE;
9149: l_attribute12 pa_control_items.attribute12%TYPE;

Line 9146: l_attribute9 pa_control_items.attribute9%TYPE;

9142: l_attribute5 pa_control_items.attribute5%TYPE;
9143: l_attribute6 pa_control_items.attribute6%TYPE;
9144: l_attribute7 pa_control_items.attribute7%TYPE;
9145: l_attribute8 pa_control_items.attribute8%TYPE;
9146: l_attribute9 pa_control_items.attribute9%TYPE;
9147: l_attribute10 pa_control_items.attribute10%TYPE;
9148: l_attribute11 pa_control_items.attribute11%TYPE;
9149: l_attribute12 pa_control_items.attribute12%TYPE;
9150: l_attribute13 pa_control_items.attribute13%TYPE;

Line 9147: l_attribute10 pa_control_items.attribute10%TYPE;

9143: l_attribute6 pa_control_items.attribute6%TYPE;
9144: l_attribute7 pa_control_items.attribute7%TYPE;
9145: l_attribute8 pa_control_items.attribute8%TYPE;
9146: l_attribute9 pa_control_items.attribute9%TYPE;
9147: l_attribute10 pa_control_items.attribute10%TYPE;
9148: l_attribute11 pa_control_items.attribute11%TYPE;
9149: l_attribute12 pa_control_items.attribute12%TYPE;
9150: l_attribute13 pa_control_items.attribute13%TYPE;
9151: l_attribute14 pa_control_items.attribute14%TYPE;

Line 9148: l_attribute11 pa_control_items.attribute11%TYPE;

9144: l_attribute7 pa_control_items.attribute7%TYPE;
9145: l_attribute8 pa_control_items.attribute8%TYPE;
9146: l_attribute9 pa_control_items.attribute9%TYPE;
9147: l_attribute10 pa_control_items.attribute10%TYPE;
9148: l_attribute11 pa_control_items.attribute11%TYPE;
9149: l_attribute12 pa_control_items.attribute12%TYPE;
9150: l_attribute13 pa_control_items.attribute13%TYPE;
9151: l_attribute14 pa_control_items.attribute14%TYPE;
9152: l_attribute15 pa_control_items.attribute15%TYPE;

Line 9149: l_attribute12 pa_control_items.attribute12%TYPE;

9145: l_attribute8 pa_control_items.attribute8%TYPE;
9146: l_attribute9 pa_control_items.attribute9%TYPE;
9147: l_attribute10 pa_control_items.attribute10%TYPE;
9148: l_attribute11 pa_control_items.attribute11%TYPE;
9149: l_attribute12 pa_control_items.attribute12%TYPE;
9150: l_attribute13 pa_control_items.attribute13%TYPE;
9151: l_attribute14 pa_control_items.attribute14%TYPE;
9152: l_attribute15 pa_control_items.attribute15%TYPE;
9153: l_class_code constant varchar2(20) := 'CHANGE_ORDER';

Line 9150: l_attribute13 pa_control_items.attribute13%TYPE;

9146: l_attribute9 pa_control_items.attribute9%TYPE;
9147: l_attribute10 pa_control_items.attribute10%TYPE;
9148: l_attribute11 pa_control_items.attribute11%TYPE;
9149: l_attribute12 pa_control_items.attribute12%TYPE;
9150: l_attribute13 pa_control_items.attribute13%TYPE;
9151: l_attribute14 pa_control_items.attribute14%TYPE;
9152: l_attribute15 pa_control_items.attribute15%TYPE;
9153: l_class_code constant varchar2(20) := 'CHANGE_ORDER';
9154: CURSOR curr_row is

Line 9151: l_attribute14 pa_control_items.attribute14%TYPE;

9147: l_attribute10 pa_control_items.attribute10%TYPE;
9148: l_attribute11 pa_control_items.attribute11%TYPE;
9149: l_attribute12 pa_control_items.attribute12%TYPE;
9150: l_attribute13 pa_control_items.attribute13%TYPE;
9151: l_attribute14 pa_control_items.attribute14%TYPE;
9152: l_attribute15 pa_control_items.attribute15%TYPE;
9153: l_class_code constant varchar2(20) := 'CHANGE_ORDER';
9154: CURSOR curr_row is
9155: SELECT *

Line 9152: l_attribute15 pa_control_items.attribute15%TYPE;

9148: l_attribute11 pa_control_items.attribute11%TYPE;
9149: l_attribute12 pa_control_items.attribute12%TYPE;
9150: l_attribute13 pa_control_items.attribute13%TYPE;
9151: l_attribute14 pa_control_items.attribute14%TYPE;
9152: l_attribute15 pa_control_items.attribute15%TYPE;
9153: l_class_code constant varchar2(20) := 'CHANGE_ORDER';
9154: CURSOR curr_row is
9155: SELECT *
9156: FROM pa_control_items

Line 9156: FROM pa_control_items

9152: l_attribute15 pa_control_items.attribute15%TYPE;
9153: l_class_code constant varchar2(20) := 'CHANGE_ORDER';
9154: CURSOR curr_row is
9155: SELECT *
9156: FROM pa_control_items
9157: WHERE ci_id = p_ci_id;
9158:
9159: cp curr_row%rowtype;
9160:

Line 9211: pa_control_items ci

9207:
9208: CURSOR c_auto_num IS
9209: SELECT type.auto_number_flag
9210: FROM pa_ci_types_b type,
9211: pa_control_items ci
9212: WHERE ci.ci_id = p_ci_id
9213: AND ci.ci_type_id = type.ci_type_id;
9214:
9215: CURSOR c_ci_number (p_project_id NUMBER, p_ci_type_id NUMBER) IS

Line 9217: FROM pa_control_items

9213: AND ci.ci_type_id = type.ci_type_id;
9214:
9215: CURSOR c_ci_number (p_project_id NUMBER, p_ci_type_id NUMBER) IS
9216: SELECT ROWID
9217: FROM pa_control_items
9218: WHERE project_id = p_project_id
9219: AND ci_number = p_ci_number
9220: AND ci_id <> p_ci_id
9221: AND ci_type_id = p_ci_type_id;

Line 9227: FROM pa_control_items c,

9223: CURSOR c_info IS
9224: SELECT cit.ci_type_class_code,
9225: cit.approval_required_flag,
9226: s.next_allowable_status_flag
9227: FROM pa_control_items c,
9228: pa_ci_types_b cit,
9229: pa_project_statuses s
9230: WHERE c.ci_id = p_ci_id
9231: AND c.status_code = s.project_status_code

Line 9386: l_curr_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_curr_status_code);

9382: RAISE FND_API.G_EXC_ERROR;
9383: end if;
9384:
9385:
9386: l_curr_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_curr_status_code);
9387:
9388: /* Check if the user can update the item. This requires the user to be owner or to have project authority or
9389: to have open UPDATE actions and status controls are satisfied. */
9390:

Line 9406: l_chk_status_ctrl := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_curr_status_code, 'CONTROL_ITEM_ALLOW_UPDATE');

9402: END IF;
9403:
9404: /* Check for the status control: check whether the action CONTROL_ITEM_ALLOW_UPDATE is allowed on the current status of the issue. */
9405:
9406: l_chk_status_ctrl := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_curr_status_code, 'CONTROL_ITEM_ALLOW_UPDATE');
9407:
9408: IF (l_chk_status_ctrl = 'N') THEN
9409:
9410: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_ALLOW_UPDATE');

Line 9417: pa_debug.write(l_module, 'After call to pa_control_items_utils.CheckCIActionAllowed', l_debug_level3);

9413: END IF;
9414:
9415:
9416: IF l_debug_mode = 'Y' THEN
9417: pa_debug.write(l_module, 'After call to pa_control_items_utils.CheckCIActionAllowed', l_debug_level3);
9418: END IF;
9419:
9420: /* The control item will not be updateable if the current status has approval workflow attached. */
9421:

Line 9474: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

9470: '''CONTROL_ITEM'''||' and wf_success_status_code is not null and wf_failure_status_code is not null)'||
9471: ' AND ps.project_status_code not in (select wf_failure_status_code from pa_project_statuses where status_type = '||
9472: '''CONTROL_ITEM'''||' and wf_success_status_code is not null and wf_failure_status_code is not null)'||
9473: ' AND decode(ps.project_system_status_code, '||'''CI_CANCELED'''||
9474: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
9475: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
9476: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
9477: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
9478: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||

Line 9477: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

9473: ' AND decode(ps.project_system_status_code, '||'''CI_CANCELED'''||
9474: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
9475: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
9476: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
9477: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
9478: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
9479: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
9480: '''CONTROL_ITEM_ALLOW_UPDST'''||' ,null),'||'''N'''||' ) = '||'''Y'''||
9481: ' AND decode(ps.project_system_status_code,'||'''CI_DRAFT'''||

Line 9479: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

9475: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
9476: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
9477: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
9478: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
9479: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
9480: '''CONTROL_ITEM_ALLOW_UPDST'''||' ,null),'||'''N'''||' ) = '||'''Y'''||
9481: ' AND decode(ps.project_system_status_code,'||'''CI_DRAFT'''||
9482: ' ,decode('||''''||l_curr_system_status||''''||', '||'''CI_DRAFT'''||', '||
9483: '''Y'''||' ,'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||

Line 9627: /* Getting validated in pa_control_items_pub.update_control_item API. */

9623: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9624: ,p_msg_name => 'PA_CI_CHANGE_OWNER_INVALID');
9625: x_return_status := 'E';
9626: END IF;
9627: /* Getting validated in pa_control_items_pub.update_control_item API. */
9628: ELSIF p_owner_id IS NULL THEN
9629: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9630: ,p_msg_name => 'PA_CI_OWNER_NULL');
9631: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9761: /* Getting validated in pa_control_items_pvt.update_control_item API. */

9757: IF p_price_currency_code = G_PA_MISS_CHAR THEN
9758: NULL;
9759: ELSIF p_price_currency_code IS NOT NULL THEN
9760: l_price_currency_code := p_price_currency_code;
9761: /* Getting validated in pa_control_items_pvt.update_control_item API. */
9762: ELSIF p_price_currency_code IS NULL THEN
9763: l_price_currency_code := p_price_currency_code;
9764: END IF;
9765:

Line 9831: l_new_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_ci_status_code);

9827:
9828: IF (p_ci_number = G_PA_MISS_CHAR OR p_ci_number IS NULL) THEN
9829:
9830: IF l_ci_status_code IS NOT NULL THEN
9831: l_new_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_ci_status_code);
9832: END IF;
9833:
9834: IF p_ci_number = G_PA_MISS_CHAR THEN
9835: IF l_ci_number IS NULL THEN

Line 10028: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (

10024: IF l_debug_mode = 'Y' THEN
10025: pa_debug.write(l_module, 'before call to ChangeCIStatusValidate', l_debug_level3);
10026: END IF;
10027:
10028: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (
10029: p_init_msg_list => p_init_msg_list
10030: ,p_commit => p_commit
10031: ,p_validate_only => l_validate_only
10032: ,p_max_msg_count => l_max_msg_count

Line 10064: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

10060: pa_debug.write(l_module, 'After call to ChangeCIStatusValidate : l_status_change_flag = '||l_status_change_flag, l_debug_level3);
10061: END IF;
10062:
10063: IF (l_resolution_req IS NOT NULL AND l_resolution_req = 'Y') THEN
10064: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN
10065: IF (l_resolution_code_id IS NULL) THEN
10066: PA_UTILS.Add_Message( p_app_short_name => 'PA'
10067: ,p_msg_name => 'PA_CI_RESOLUTION_OPEN');
10068: x_return_status := FND_API.G_RET_STS_ERROR;

Line 10080: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

10076: END IF;
10077: END IF;
10078:
10079: IF (l_resolution_req_cls IS NOT NULL AND l_resolution_req_cls = 'Y') THEN
10080: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN
10081: IF (l_resolution_code_id IS NULL) THEN
10082: PA_UTILS.Add_Message( p_app_short_name => 'PA'
10083: ,p_msg_name => 'PA_CI_CLOSE_INV_RES');
10084: x_return_status := FND_API.G_RET_STS_ERROR;

Line 10101: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM', l_debug_level3);

10097:
10098: IF (l_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
10099:
10100: IF l_debug_mode = 'Y' THEN
10101: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM', l_debug_level3);
10102: END IF;
10103:
10104: PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM (
10105: p_api_version => 1.0

Line 10104: PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM (

10100: IF l_debug_mode = 'Y' THEN
10101: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM', l_debug_level3);
10102: END IF;
10103:
10104: PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM (
10105: p_api_version => 1.0
10106: ,p_init_msg_list => fnd_api.g_false
10107: ,p_commit => FND_API.g_false
10108: ,p_validate_only => FND_API.g_false

Line 10167: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM : x_return_status = '||x_return_status, l_debug_level3);

10163: ,x_msg_data => x_msg_data
10164: );
10165:
10166: IF l_debug_mode = 'Y' THEN
10167: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM : x_return_status = '||x_return_status, l_debug_level3);
10168: END IF;
10169:
10170: END IF;
10171:

Line 10177: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);

10173:
10174: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
10175:
10176: IF l_debug_mode = 'Y' THEN
10177: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
10178: END IF;
10179:
10180: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'
10181: ,p_object_id => p_ci_id

Line 10180: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'

10176: IF l_debug_mode = 'Y' THEN
10177: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
10178: END IF;
10179:
10180: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'
10181: ,p_object_id => p_ci_id
10182: ,p_type_code => 'CHANGE_STATUS'
10183: ,p_status_type => 'CONTROL_ITEM'
10184: ,p_new_project_status => l_ci_status_code

Line 10193: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);

10189: ,x_msg_data => x_msg_data );
10190:
10191:
10192: IF l_debug_mode = 'Y' THEN
10193: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
10194: END IF;
10195:
10196: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (
10197: p_init_msg_list

Line 10196: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (

10192: IF l_debug_mode = 'Y' THEN
10193: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
10194: END IF;
10195:
10196: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (
10197: p_init_msg_list
10198: ,p_commit
10199: ,l_validate_only
10200: ,l_max_msg_count

Line 10213: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus', l_debug_level3);

10209: ,x_msg_data );
10210:
10211:
10212: IF l_debug_mode = 'Y' THEN
10213: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus', l_debug_level3);
10214: END IF;
10215:
10216: END IF;
10217: