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_PVT dependencies on PA_CONTROL_ITEMS

Line 18: FROM pa_control_items

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

Line 31: FROM pa_control_items ci,

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

Line 48: FROM pa_project_statuses pps, pa_control_items ci

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

Line 86: pa_control_items pci,

82: --pl.predefined_flag,
83: --pl.meaning impact_name,
84: --pci.project_id project_id
85: from
86: pa_control_items pci,
87: pa_ci_impact_type_usage pcit,
88: pa_lookups pl
89: where pci.ci_type_id = pcit.ci_type_id
90: and pl.lookup_type = 'PA_CI_IMPACT_TYPES'

Line 111: l_ci_id pa_control_items.ci_id%TYPE := null;

107:
108: --Declaring local Variables
109:
110: l_status_code pa_ci_impacts.status_code%TYPE := null;
111: l_ci_id pa_control_items.ci_id%TYPE := null;
112: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;
113: l_project_id pa_control_items.project_id%TYPE;
114: l_ci_type_id pa_ci_types_b.ci_type_id%TYPE;
115: l_cr_status_code pa_control_items.status_code%type;

Line 113: l_project_id pa_control_items.project_id%TYPE;

109:
110: l_status_code pa_ci_impacts.status_code%TYPE := null;
111: l_ci_id pa_control_items.ci_id%TYPE := null;
112: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;
113: l_project_id pa_control_items.project_id%TYPE;
114: l_ci_type_id pa_ci_types_b.ci_type_id%TYPE;
115: l_cr_status_code pa_control_items.status_code%type;
116: l_ci_type_class_code pa_ci_types_b.ci_type_class_Code%TYPE;
117: l_ci_impact_id pa_ci_impacts.ci_impact_id%TYPE;

Line 115: l_cr_status_code pa_control_items.status_code%type;

111: l_ci_id pa_control_items.ci_id%TYPE := null;
112: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;
113: l_project_id pa_control_items.project_id%TYPE;
114: l_ci_type_id pa_ci_types_b.ci_type_id%TYPE;
115: l_cr_status_code pa_control_items.status_code%type;
116: l_ci_type_class_code pa_ci_types_b.ci_type_class_Code%TYPE;
117: l_ci_impact_id pa_ci_impacts.ci_impact_id%TYPE;
118: l_impact_description pa_ci_impacts.description%type;
119: l_impact_description1 pa_ci_impacts.description%type;

Line 313: has_access := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_cr_status_code, 'CONTROL_ITEM_ALLOW_UPDATE',p_ci_id);

309: end if;
310:
311: /* Check for the status control: check whether the action CONTROL_ITEM_ALLOW_UPDATE
312: is allowed on the current status of the issue. */
313: has_access := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_cr_status_code, 'CONTROL_ITEM_ALLOW_UPDATE',p_ci_id);
314: if has_access <> 'Y' then
315: PA_UTILS.add_Message( p_app_short_name => 'PA'
316: ,p_msg_name => 'PA_CI_NO_ALLOW_UPDATE');
317: x_return_status := FND_API.G_RET_STS_ERROR;

Line 487: l_project_id pa_control_items.project_id%TYPE;

483: l_line_num po_lines_all.line_num%TYPE;
484: l_currency_code fnd_currencies_vl.currency_code%type;
485: l_currency_code1 fnd_currencies_vl.currency_code%type;
486: l_currency_name fnd_currencies_vl.Name%TYPE;
487: l_project_id pa_control_items.project_id%TYPE;
488: l_ci_type_id pa_control_items.ci_type_id%type;
489: l_change_description pa_ci_supplier_details.change_description%type;
490: l_ci_impact_id pa_ci_impacts.ci_impact_id%type := NULL;
491: l_calling_mode VARCHAR2(30);

Line 488: l_ci_type_id pa_control_items.ci_type_id%type;

484: l_currency_code fnd_currencies_vl.currency_code%type;
485: l_currency_code1 fnd_currencies_vl.currency_code%type;
486: l_currency_name fnd_currencies_vl.Name%TYPE;
487: l_project_id pa_control_items.project_id%TYPE;
488: l_ci_type_id pa_control_items.ci_type_id%type;
489: l_change_description pa_ci_supplier_details.change_description%type;
490: l_ci_impact_id pa_ci_impacts.ci_impact_id%type := NULL;
491: l_calling_mode VARCHAR2(30);
492: l_po_line_Amount NUMBER ;

Line 621: pa_control_items pci

617: cursor c_get_project_id(c_ci_id number)
618: is
619: select pci.project_id
620: from
621: pa_control_items pci
622: where pci.ci_id = c_ci_id;
623:
624:
625: /*Cursor to check ci_id validity*/

Line 627: select ci_type_id from pa_control_items a , pa_ci_impacts b

623:
624:
625: /*Cursor to check ci_id validity*/
626: /*cursor c_get_ci_type_id is
627: select ci_type_id from pa_control_items a , pa_ci_impacts b
628: where a.ci_id = b.ci_id
629: and a.ci_id = p_ci_id
630: and b.IMPACT_TYPE_CODE = 'SUPPLIER';*/
631:

Line 1749: l_summary pa_control_items.summary%type;

1745:
1746:
1747: l_any_err_occured_flg VARCHAR2(1);
1748:
1749: l_summary pa_control_items.summary%type;
1750: l_description pa_control_items.description%type;
1751: l_status_code pa_project_statuses.project_status_code%type;
1752: l_status_name pa_project_statuses.project_status_name%type;
1753: l_system_status_code pa_project_statuses.project_system_status_code%type;

Line 1750: l_description pa_control_items.description%type;

1746:
1747: l_any_err_occured_flg VARCHAR2(1);
1748:
1749: l_summary pa_control_items.summary%type;
1750: l_description pa_control_items.description%type;
1751: l_status_code pa_project_statuses.project_status_code%type;
1752: l_status_name pa_project_statuses.project_status_name%type;
1753: l_system_status_code pa_project_statuses.project_system_status_code%type;
1754:

Line 1755: l_ci_number_char PA_CONTROL_ITEMS.ci_number%type := NULL;

1751: l_status_code pa_project_statuses.project_status_code%type;
1752: l_status_name pa_project_statuses.project_status_name%type;
1753: l_system_status_code pa_project_statuses.project_system_status_code%type;
1754:
1755: l_ci_number_char PA_CONTROL_ITEMS.ci_number%type := NULL;
1756: l_ci_number_num NUMBER(15) := NULL;
1757: l_system_number_id NUMBER(15) := NULL;
1758:
1759: l_owner_id per_all_people_f.party_id%type;

Line 1762: l_classification_code pa_control_items.classification_code_id%type;

1758:
1759: l_owner_id per_all_people_f.party_id%type;
1760: l_owner_name per_all_people_f.full_name%type;
1761: l_progress_status_code pa_project_statuses.project_status_code%type;
1762: l_classification_code pa_control_items.classification_code_id%type;
1763: l_reason_code pa_control_items.reason_code_id%type;
1764: l_object_id pa_proj_elements.proj_element_id%type;
1765: l_date_closed pa_control_items.date_closed%type;
1766: l_closed_by_id pa_control_items.closed_by_id%type;

Line 1763: l_reason_code pa_control_items.reason_code_id%type;

1759: l_owner_id per_all_people_f.party_id%type;
1760: l_owner_name per_all_people_f.full_name%type;
1761: l_progress_status_code pa_project_statuses.project_status_code%type;
1762: l_classification_code pa_control_items.classification_code_id%type;
1763: l_reason_code pa_control_items.reason_code_id%type;
1764: l_object_id pa_proj_elements.proj_element_id%type;
1765: l_date_closed pa_control_items.date_closed%type;
1766: l_closed_by_id pa_control_items.closed_by_id%type;
1767: l_valid_clsby_id VARCHAR2(1);

Line 1765: l_date_closed pa_control_items.date_closed%type;

1761: l_progress_status_code pa_project_statuses.project_status_code%type;
1762: l_classification_code pa_control_items.classification_code_id%type;
1763: l_reason_code pa_control_items.reason_code_id%type;
1764: l_object_id pa_proj_elements.proj_element_id%type;
1765: l_date_closed pa_control_items.date_closed%type;
1766: l_closed_by_id pa_control_items.closed_by_id%type;
1767: l_valid_clsby_id VARCHAR2(1);
1768: l_resolution_code pa_control_items.resolution_code_id%type;
1769: l_resolution pa_control_items.resolution%type;

Line 1766: l_closed_by_id pa_control_items.closed_by_id%type;

1762: l_classification_code pa_control_items.classification_code_id%type;
1763: l_reason_code pa_control_items.reason_code_id%type;
1764: l_object_id pa_proj_elements.proj_element_id%type;
1765: l_date_closed pa_control_items.date_closed%type;
1766: l_closed_by_id pa_control_items.closed_by_id%type;
1767: l_valid_clsby_id VARCHAR2(1);
1768: l_resolution_code pa_control_items.resolution_code_id%type;
1769: l_resolution pa_control_items.resolution%type;
1770: l_effort_level_code pa_control_items.effort_level_code%type;

Line 1768: l_resolution_code pa_control_items.resolution_code_id%type;

1764: l_object_id pa_proj_elements.proj_element_id%type;
1765: l_date_closed pa_control_items.date_closed%type;
1766: l_closed_by_id pa_control_items.closed_by_id%type;
1767: l_valid_clsby_id VARCHAR2(1);
1768: l_resolution_code pa_control_items.resolution_code_id%type;
1769: l_resolution pa_control_items.resolution%type;
1770: l_effort_level_code pa_control_items.effort_level_code%type;
1771: l_priority_code pa_control_items.priority_code%type;
1772: l_price_currency_code pa_control_items.price_currency_code%type;

Line 1769: l_resolution pa_control_items.resolution%type;

1765: l_date_closed pa_control_items.date_closed%type;
1766: l_closed_by_id pa_control_items.closed_by_id%type;
1767: l_valid_clsby_id VARCHAR2(1);
1768: l_resolution_code pa_control_items.resolution_code_id%type;
1769: l_resolution pa_control_items.resolution%type;
1770: l_effort_level_code pa_control_items.effort_level_code%type;
1771: l_priority_code pa_control_items.priority_code%type;
1772: l_price_currency_code pa_control_items.price_currency_code%type;
1773: l_price pa_control_items.price%type;

Line 1770: l_effort_level_code pa_control_items.effort_level_code%type;

1766: l_closed_by_id pa_control_items.closed_by_id%type;
1767: l_valid_clsby_id VARCHAR2(1);
1768: l_resolution_code pa_control_items.resolution_code_id%type;
1769: l_resolution pa_control_items.resolution%type;
1770: l_effort_level_code pa_control_items.effort_level_code%type;
1771: l_priority_code pa_control_items.priority_code%type;
1772: l_price_currency_code pa_control_items.price_currency_code%type;
1773: l_price pa_control_items.price%type;
1774:

Line 1771: l_priority_code pa_control_items.priority_code%type;

1767: l_valid_clsby_id VARCHAR2(1);
1768: l_resolution_code pa_control_items.resolution_code_id%type;
1769: l_resolution pa_control_items.resolution%type;
1770: l_effort_level_code pa_control_items.effort_level_code%type;
1771: l_priority_code pa_control_items.priority_code%type;
1772: l_price_currency_code pa_control_items.price_currency_code%type;
1773: l_price pa_control_items.price%type;
1774:
1775: l_attribute_category pa_control_items.attribute_category%type;

Line 1772: l_price_currency_code pa_control_items.price_currency_code%type;

1768: l_resolution_code pa_control_items.resolution_code_id%type;
1769: l_resolution pa_control_items.resolution%type;
1770: l_effort_level_code pa_control_items.effort_level_code%type;
1771: l_priority_code pa_control_items.priority_code%type;
1772: l_price_currency_code pa_control_items.price_currency_code%type;
1773: l_price pa_control_items.price%type;
1774:
1775: l_attribute_category pa_control_items.attribute_category%type;
1776: l_attribute1 pa_control_items.attribute1%type;

Line 1773: l_price pa_control_items.price%type;

1769: l_resolution pa_control_items.resolution%type;
1770: l_effort_level_code pa_control_items.effort_level_code%type;
1771: l_priority_code pa_control_items.priority_code%type;
1772: l_price_currency_code pa_control_items.price_currency_code%type;
1773: l_price pa_control_items.price%type;
1774:
1775: l_attribute_category pa_control_items.attribute_category%type;
1776: l_attribute1 pa_control_items.attribute1%type;
1777: l_attribute2 pa_control_items.attribute1%type;

Line 1775: l_attribute_category pa_control_items.attribute_category%type;

1771: l_priority_code pa_control_items.priority_code%type;
1772: l_price_currency_code pa_control_items.price_currency_code%type;
1773: l_price pa_control_items.price%type;
1774:
1775: l_attribute_category pa_control_items.attribute_category%type;
1776: l_attribute1 pa_control_items.attribute1%type;
1777: l_attribute2 pa_control_items.attribute1%type;
1778: l_attribute3 pa_control_items.attribute1%type;
1779: l_attribute4 pa_control_items.attribute1%type;

Line 1776: l_attribute1 pa_control_items.attribute1%type;

1772: l_price_currency_code pa_control_items.price_currency_code%type;
1773: l_price pa_control_items.price%type;
1774:
1775: l_attribute_category pa_control_items.attribute_category%type;
1776: l_attribute1 pa_control_items.attribute1%type;
1777: l_attribute2 pa_control_items.attribute1%type;
1778: l_attribute3 pa_control_items.attribute1%type;
1779: l_attribute4 pa_control_items.attribute1%type;
1780: l_attribute5 pa_control_items.attribute1%type;

Line 1777: l_attribute2 pa_control_items.attribute1%type;

1773: l_price pa_control_items.price%type;
1774:
1775: l_attribute_category pa_control_items.attribute_category%type;
1776: l_attribute1 pa_control_items.attribute1%type;
1777: l_attribute2 pa_control_items.attribute1%type;
1778: l_attribute3 pa_control_items.attribute1%type;
1779: l_attribute4 pa_control_items.attribute1%type;
1780: l_attribute5 pa_control_items.attribute1%type;
1781: l_attribute6 pa_control_items.attribute1%type;

Line 1778: l_attribute3 pa_control_items.attribute1%type;

1774:
1775: l_attribute_category pa_control_items.attribute_category%type;
1776: l_attribute1 pa_control_items.attribute1%type;
1777: l_attribute2 pa_control_items.attribute1%type;
1778: l_attribute3 pa_control_items.attribute1%type;
1779: l_attribute4 pa_control_items.attribute1%type;
1780: l_attribute5 pa_control_items.attribute1%type;
1781: l_attribute6 pa_control_items.attribute1%type;
1782: l_attribute7 pa_control_items.attribute1%type;

Line 1779: l_attribute4 pa_control_items.attribute1%type;

1775: l_attribute_category pa_control_items.attribute_category%type;
1776: l_attribute1 pa_control_items.attribute1%type;
1777: l_attribute2 pa_control_items.attribute1%type;
1778: l_attribute3 pa_control_items.attribute1%type;
1779: l_attribute4 pa_control_items.attribute1%type;
1780: l_attribute5 pa_control_items.attribute1%type;
1781: l_attribute6 pa_control_items.attribute1%type;
1782: l_attribute7 pa_control_items.attribute1%type;
1783: l_attribute8 pa_control_items.attribute1%type;

Line 1780: l_attribute5 pa_control_items.attribute1%type;

1776: l_attribute1 pa_control_items.attribute1%type;
1777: l_attribute2 pa_control_items.attribute1%type;
1778: l_attribute3 pa_control_items.attribute1%type;
1779: l_attribute4 pa_control_items.attribute1%type;
1780: l_attribute5 pa_control_items.attribute1%type;
1781: l_attribute6 pa_control_items.attribute1%type;
1782: l_attribute7 pa_control_items.attribute1%type;
1783: l_attribute8 pa_control_items.attribute1%type;
1784: l_attribute9 pa_control_items.attribute1%type;

Line 1781: l_attribute6 pa_control_items.attribute1%type;

1777: l_attribute2 pa_control_items.attribute1%type;
1778: l_attribute3 pa_control_items.attribute1%type;
1779: l_attribute4 pa_control_items.attribute1%type;
1780: l_attribute5 pa_control_items.attribute1%type;
1781: l_attribute6 pa_control_items.attribute1%type;
1782: l_attribute7 pa_control_items.attribute1%type;
1783: l_attribute8 pa_control_items.attribute1%type;
1784: l_attribute9 pa_control_items.attribute1%type;
1785: l_attribute10 pa_control_items.attribute1%type;

Line 1782: l_attribute7 pa_control_items.attribute1%type;

1778: l_attribute3 pa_control_items.attribute1%type;
1779: l_attribute4 pa_control_items.attribute1%type;
1780: l_attribute5 pa_control_items.attribute1%type;
1781: l_attribute6 pa_control_items.attribute1%type;
1782: l_attribute7 pa_control_items.attribute1%type;
1783: l_attribute8 pa_control_items.attribute1%type;
1784: l_attribute9 pa_control_items.attribute1%type;
1785: l_attribute10 pa_control_items.attribute1%type;
1786: l_attribute11 pa_control_items.attribute1%type;

Line 1783: l_attribute8 pa_control_items.attribute1%type;

1779: l_attribute4 pa_control_items.attribute1%type;
1780: l_attribute5 pa_control_items.attribute1%type;
1781: l_attribute6 pa_control_items.attribute1%type;
1782: l_attribute7 pa_control_items.attribute1%type;
1783: l_attribute8 pa_control_items.attribute1%type;
1784: l_attribute9 pa_control_items.attribute1%type;
1785: l_attribute10 pa_control_items.attribute1%type;
1786: l_attribute11 pa_control_items.attribute1%type;
1787: l_attribute12 pa_control_items.attribute1%type;

Line 1784: l_attribute9 pa_control_items.attribute1%type;

1780: l_attribute5 pa_control_items.attribute1%type;
1781: l_attribute6 pa_control_items.attribute1%type;
1782: l_attribute7 pa_control_items.attribute1%type;
1783: l_attribute8 pa_control_items.attribute1%type;
1784: l_attribute9 pa_control_items.attribute1%type;
1785: l_attribute10 pa_control_items.attribute1%type;
1786: l_attribute11 pa_control_items.attribute1%type;
1787: l_attribute12 pa_control_items.attribute1%type;
1788: l_attribute13 pa_control_items.attribute1%type;

Line 1785: l_attribute10 pa_control_items.attribute1%type;

1781: l_attribute6 pa_control_items.attribute1%type;
1782: l_attribute7 pa_control_items.attribute1%type;
1783: l_attribute8 pa_control_items.attribute1%type;
1784: l_attribute9 pa_control_items.attribute1%type;
1785: l_attribute10 pa_control_items.attribute1%type;
1786: l_attribute11 pa_control_items.attribute1%type;
1787: l_attribute12 pa_control_items.attribute1%type;
1788: l_attribute13 pa_control_items.attribute1%type;
1789: l_attribute14 pa_control_items.attribute1%type;

Line 1786: l_attribute11 pa_control_items.attribute1%type;

1782: l_attribute7 pa_control_items.attribute1%type;
1783: l_attribute8 pa_control_items.attribute1%type;
1784: l_attribute9 pa_control_items.attribute1%type;
1785: l_attribute10 pa_control_items.attribute1%type;
1786: l_attribute11 pa_control_items.attribute1%type;
1787: l_attribute12 pa_control_items.attribute1%type;
1788: l_attribute13 pa_control_items.attribute1%type;
1789: l_attribute14 pa_control_items.attribute1%type;
1790: l_attribute15 pa_control_items.attribute1%type;

Line 1787: l_attribute12 pa_control_items.attribute1%type;

1783: l_attribute8 pa_control_items.attribute1%type;
1784: l_attribute9 pa_control_items.attribute1%type;
1785: l_attribute10 pa_control_items.attribute1%type;
1786: l_attribute11 pa_control_items.attribute1%type;
1787: l_attribute12 pa_control_items.attribute1%type;
1788: l_attribute13 pa_control_items.attribute1%type;
1789: l_attribute14 pa_control_items.attribute1%type;
1790: l_attribute15 pa_control_items.attribute1%type;
1791:

Line 1788: l_attribute13 pa_control_items.attribute1%type;

1784: l_attribute9 pa_control_items.attribute1%type;
1785: l_attribute10 pa_control_items.attribute1%type;
1786: l_attribute11 pa_control_items.attribute1%type;
1787: l_attribute12 pa_control_items.attribute1%type;
1788: l_attribute13 pa_control_items.attribute1%type;
1789: l_attribute14 pa_control_items.attribute1%type;
1790: l_attribute15 pa_control_items.attribute1%type;
1791:
1792:

Line 1789: l_attribute14 pa_control_items.attribute1%type;

1785: l_attribute10 pa_control_items.attribute1%type;
1786: l_attribute11 pa_control_items.attribute1%type;
1787: l_attribute12 pa_control_items.attribute1%type;
1788: l_attribute13 pa_control_items.attribute1%type;
1789: l_attribute14 pa_control_items.attribute1%type;
1790: l_attribute15 pa_control_items.attribute1%type;
1791:
1792:
1793: l_source_type_name pa_lookups.meaning%type;

Line 1790: l_attribute15 pa_control_items.attribute1%type;

1786: l_attribute11 pa_control_items.attribute1%type;
1787: l_attribute12 pa_control_items.attribute1%type;
1788: l_attribute13 pa_control_items.attribute1%type;
1789: l_attribute14 pa_control_items.attribute1%type;
1790: l_attribute15 pa_control_items.attribute1%type;
1791:
1792:
1793: l_source_type_name pa_lookups.meaning%type;
1794: l_source_type_code pa_control_items.source_type_code%type;

Line 1794: l_source_type_code pa_control_items.source_type_code%type;

1790: l_attribute15 pa_control_items.attribute1%type;
1791:
1792:
1793: l_source_type_name pa_lookups.meaning%type;
1794: l_source_type_code pa_control_items.source_type_code%type;
1795: l_source_number pa_control_items.source_number%type;
1796: l_source_comment pa_control_items.source_comment%type;
1797: l_source_date_received pa_control_items.source_date_received%type;
1798: l_source_organization pa_control_items.source_organization%type;

Line 1795: l_source_number pa_control_items.source_number%type;

1791:
1792:
1793: l_source_type_name pa_lookups.meaning%type;
1794: l_source_type_code pa_control_items.source_type_code%type;
1795: l_source_number pa_control_items.source_number%type;
1796: l_source_comment pa_control_items.source_comment%type;
1797: l_source_date_received pa_control_items.source_date_received%type;
1798: l_source_organization pa_control_items.source_organization%type;
1799: l_source_person pa_control_items.source_person%type;

Line 1796: l_source_comment pa_control_items.source_comment%type;

1792:
1793: l_source_type_name pa_lookups.meaning%type;
1794: l_source_type_code pa_control_items.source_type_code%type;
1795: l_source_number pa_control_items.source_number%type;
1796: l_source_comment pa_control_items.source_comment%type;
1797: l_source_date_received pa_control_items.source_date_received%type;
1798: l_source_organization pa_control_items.source_organization%type;
1799: l_source_person pa_control_items.source_person%type;
1800: l_ci_id pa_control_items.ci_id%type;

Line 1797: l_source_date_received pa_control_items.source_date_received%type;

1793: l_source_type_name pa_lookups.meaning%type;
1794: l_source_type_code pa_control_items.source_type_code%type;
1795: l_source_number pa_control_items.source_number%type;
1796: l_source_comment pa_control_items.source_comment%type;
1797: l_source_date_received pa_control_items.source_date_received%type;
1798: l_source_organization pa_control_items.source_organization%type;
1799: l_source_person pa_control_items.source_person%type;
1800: l_ci_id pa_control_items.ci_id%type;
1801: begin

Line 1798: l_source_organization pa_control_items.source_organization%type;

1794: l_source_type_code pa_control_items.source_type_code%type;
1795: l_source_number pa_control_items.source_number%type;
1796: l_source_comment pa_control_items.source_comment%type;
1797: l_source_date_received pa_control_items.source_date_received%type;
1798: l_source_organization pa_control_items.source_organization%type;
1799: l_source_person pa_control_items.source_person%type;
1800: l_ci_id pa_control_items.ci_id%type;
1801: begin
1802: -- initialize the return status to success

Line 1799: l_source_person pa_control_items.source_person%type;

1795: l_source_number pa_control_items.source_number%type;
1796: l_source_comment pa_control_items.source_comment%type;
1797: l_source_date_received pa_control_items.source_date_received%type;
1798: l_source_organization pa_control_items.source_organization%type;
1799: l_source_person pa_control_items.source_person%type;
1800: l_ci_id pa_control_items.ci_id%type;
1801: begin
1802: -- initialize the return status to success
1803: x_return_status := fnd_api.g_ret_sts_success;

Line 1800: l_ci_id pa_control_items.ci_id%type;

1796: l_source_comment pa_control_items.source_comment%type;
1797: l_source_date_received pa_control_items.source_date_received%type;
1798: l_source_organization pa_control_items.source_organization%type;
1799: l_source_person pa_control_items.source_person%type;
1800: l_ci_id pa_control_items.ci_id%type;
1801: begin
1802: -- initialize the return status to success
1803: x_return_status := fnd_api.g_ret_sts_success;
1804: x_msg_count := 0;

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

1818: l_any_err_occured_flg := 'N';
1819:
1820: --get the user id and the party id for the current logged in user.
1821: l_user_id := fnd_global.user_id;
1822: l_party_id := pa_control_items_utils.getpartyid(l_user_id);
1823: l_resp_id := fnd_global.resp_id;
1824:
1825: if(p_summary is null) then
1826: PA_UTILS.ADD_MESSAGE

Line 1841: l_status_code := PA_CONTROL_ITEMS_UTILS.Get_Initial_Ci_Status(p_ci_type_id);

1837: l_description := p_description;
1838:
1839: if (p_status_code is null and p_status is null) then
1840: /*get the default starting status*/
1841: l_status_code := PA_CONTROL_ITEMS_UTILS.Get_Initial_Ci_Status(p_ci_type_id);
1842: /*l_status_code would always be CI_WORKING here and below select would always give CI_WORKING
1843: for project_system_status_code. So */
1844: select project_system_status_code
1845: into l_system_status_code

Line 2215: select pa_control_items_s.nextval

2211: l_attribute15 := p_attribute15;
2212:
2213: /* if we reach here in code then all the attributes have been validated.
2214: So get the next value from the sequence which will be used as the ci_id*/
2215: select pa_control_items_s.nextval
2216: into l_ci_id
2217: from dual;
2218:
2219: /* now generate the ci_number;*/

Line 2256: exit when pa_control_items_pvt.ci_number_exists(p_project_id, l_ci_number_char

2252: ,x_return_status => x_return_status
2253: ,x_msg_count => x_msg_count
2254: ,x_msg_data => x_msg_data);
2255:
2256: exit when pa_control_items_pvt.ci_number_exists(p_project_id, l_ci_number_char
2257: ,p_ci_type_id) = FALSE;
2258: end loop;
2259: else --p_auto_number_flag = 'Y' and l_system_status_code <> 'CI_DRAFT'
2260: /*For manual numbering check if passed ci_number already exist.*/

Line 2262: if pa_control_items_pvt.ci_number_exists(p_project_id, l_ci_number_char ,p_ci_type_id) = TRUE then

2258: end loop;
2259: else --p_auto_number_flag = 'Y' and l_system_status_code <> 'CI_DRAFT'
2260: /*For manual numbering check if passed ci_number already exist.*/
2261: l_ci_number_char := p_ci_number;
2262: if pa_control_items_pvt.ci_number_exists(p_project_id, l_ci_number_char ,p_ci_type_id) = TRUE then
2263: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2264: ,p_msg_name => 'PA_CI_DUPLICATE_CI_NUMBER');--msg already there
2265: if l_debug_mode = 'Y' then
2266: pa_debug.g_err_stage:= 'Duplicate ci_number passed.';

Line 2299: pa_control_items_pkg.insert_row (

2295: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2296: end if;
2297:
2298: if (l_any_err_occured_flg is not null and l_any_err_occured_flg <> 'Y') then
2299: pa_control_items_pkg.insert_row (
2300: p_ci_type_id => p_ci_type_id,
2301: p_summary => l_summary,
2302: p_status_code => l_status_code,
2303: p_owner_id => l_owner_id,

Line 2452: from pa_control_items

2448: IS
2449:
2450: cursor check_valid_ci_id(p_ci_id number) is
2451: select ci_id, project_id
2452: from pa_control_items
2453: where ci_id = p_ci_id;
2454:
2455:
2456: l_msg_count NUMBER := 0;

Line 2463: l_ci_id pa_control_items.ci_id%type;

2459: l_msg_index_out NUMBER;
2460: l_module_name VARCHAR2(200);
2461: l_any_err_occured_flg VARCHAR2(1);
2462: l_create_action_flg VARCHAR2(1) := null;
2463: l_ci_id pa_control_items.ci_id%type;
2464: l_check_valid_ci_id_rec check_valid_ci_id%rowtype;
2465: BEGIN
2466:
2467: -- initialize the return status to success

Line 2779: pa_control_items pci

2775: cursor act_sts_allw_for_ci_sts(p_ci_id NUMBER)
2776: is
2777: select pps.project_system_status_code
2778: from pa_project_statuses pps,
2779: pa_control_items pci
2780: where pps.status_type = 'CONTROL_ITEM'
2781: and pps.project_status_code = pci.status_code
2782: and pci.ci_id = p_ci_id;
2783:

Line 2798: l_ci_status_code pa_control_items.status_code%type;

2794: l_any_err_occured_flg VARCHAR2(1);
2795: l_return_status VARCHAR2(1);
2796:
2797: l_action_status_code pa_project_statuses.project_status_code%type;
2798: l_ci_status_code pa_control_items.status_code%type;
2799: --l_src_ci_action_id pa_ci_actions.ci_action_id%type;
2800: l_action_tbl pa_control_api_pub.ci_actions_in_tbl_type;
2801: chk_valid_src_ci_action_id_rec check_valid_src_ci_action_id%rowtype;
2802:

Line 3106: from pa_control_items

3102:
3103: Cursor getRecordVersionNumber(p_ci_id number)
3104: is
3105: select record_version_number
3106: from pa_control_items
3107: where ci_id = p_ci_id;
3108:
3109:
3110: l_msg_count NUMBER := 0;

Line 3120: l_ci_record_version_number pa_control_items.record_version_number%type;

3116: l_action_number pa_ci_actions.ci_action_number%type;
3117: l_ci_comment_id pa_ci_comments.ci_comment_id%type;
3118: l_type_code pa_ci_comments.type_code%type;
3119: l_ci_action_id pa_ci_actions.ci_action_id%type;
3120: l_ci_record_version_number pa_control_items.record_version_number%type;
3121: l_process_name varchar(100);
3122: l_item_key pa_wf_processes.item_key%TYPE;
3123: l_num_of_actions number;
3124: l_num_open_action pa_control_items.open_action_num%type;

Line 3124: l_num_open_action pa_control_items.open_action_num%type;

3120: l_ci_record_version_number pa_control_items.record_version_number%type;
3121: l_process_name varchar(100);
3122: l_item_key pa_wf_processes.item_key%TYPE;
3123: l_num_of_actions number;
3124: l_num_open_action pa_control_items.open_action_num%type;
3125: BEGIN
3126: -- initialize the return status to success
3127: x_return_status := fnd_api.g_ret_sts_success;
3128: x_msg_count := 0;

Line 3220: /now update the number of actions in pa_control_items_table /

3216: if l_debug_mode = 'Y' then
3217: pa_debug.g_err_stage := 'Updating number of actions for a control item';
3218: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3219: end if;
3220: /*now update the number of actions in pa_control_items_table */
3221: if(p_action_tbl(i).action_status = 'CI_ACTION_OPEN') then
3222: l_num_open_action := l_num_open_action + 1;
3223: end if;
3224:

Line 3225: /* pa_control_items_pvt.update_number_of_actions (

3221: if(p_action_tbl(i).action_status = 'CI_ACTION_OPEN') then
3222: l_num_open_action := l_num_open_action + 1;
3223: end if;
3224:
3225: /* pa_control_items_pvt.update_number_of_actions (
3226: p_ci_id => p_ci_id,
3227: p_num_of_actions => 1,
3228: p_record_version_number => l_ci_record_version_number,
3229: x_num_of_actions => l_num_of_actions,

Line 3252: pa_control_items_workflow.start_notification_wf

3248: else
3249: l_process_name := 'PA_CI_ACTION_ASMT_NO_SIGN_OFF';
3250: end if;
3251:
3252: pa_control_items_workflow.start_notification_wf
3253: ( p_item_type => 'PAWFCIAC'
3254: ,p_process_name => l_process_name
3255: ,p_ci_id => p_ci_id
3256: ,p_action_id => l_ci_action_id

Line 3269: pa_control_items_workflow.start_notification_wf

3265:
3266: elsif( p_action_tbl(i).action_status = 'CI_ACTION_CLOSED') then
3267: /*need to check if we should send the notification while creating closed actions*/
3268: /*Most likely we shd not be sending this. Can be commented later*/
3269: pa_control_items_workflow.start_notification_wf
3270: ( p_item_type => 'PAWFCIAC'
3271: ,p_process_name => 'PA_CI_ACTION_CLOSE_FYI'
3272: ,p_ci_id => p_ci_id
3273: ,p_action_id => l_ci_action_id

Line 3286: --if there were any open actions update the no of open action in pa_control_items

3282: end if;--(p_action_tbl(i).start_wf = 'Y')
3283:
3284: end loop;-- For i in 1..p_action_tbl.count
3285:
3286: --if there were any open actions update the no of open action in pa_control_items
3287: --this has to be done outside the loop only once for all the open actions in table.
3288: if(l_num_open_action is not null and l_num_open_action > 0 ) then
3289: pa_control_items_pvt.update_number_of_actions (
3290: p_ci_id => p_ci_id,

Line 3289: pa_control_items_pvt.update_number_of_actions (

3285:
3286: --if there were any open actions update the no of open action in pa_control_items
3287: --this has to be done outside the loop only once for all the open actions in table.
3288: if(l_num_open_action is not null and l_num_open_action > 0 ) then
3289: pa_control_items_pvt.update_number_of_actions (
3290: p_ci_id => p_ci_id,
3291: p_num_of_actions => l_num_open_action,
3292: p_record_version_number => l_ci_record_version_number,
3293: x_num_of_actions => l_num_of_actions,

Line 3360: pa_control_items pci

3356: cursor get_ci_action_id(p_ci_id number, p_action_number number)
3357: is
3358: select pca.ci_action_id, pca.assigned_to, pci.project_id
3359: from pa_ci_actions pca,
3360: pa_control_items pci
3361: where pca.ci_id = p_ci_id
3362: and pca.ci_action_number = p_action_number
3363: and pci.ci_id = p_ci_id;
3364:

Line 3369: pa_control_items pci

3365: cursor validate_ci_action_id(p_action_id number)
3366: is
3367: select pca.ci_action_id, pca.assigned_to, pci.project_id
3368: from pa_ci_actions pca,
3369: pa_control_items pci
3370: where pca.ci_action_id = p_action_id
3371: and pci.ci_id = pca.ci_id;
3372:
3373: l_validate_ci_action_id_rec validate_ci_action_id%rowtype;

Line 3562: l_CiId PA_CONTROL_ITEMS.Ci_Id%TYPE;

3558: l_Msg_Count NUMBER := 0;
3559: l_Data VARCHAR2(2000);
3560: l_Msg_Data VARCHAR2(2000);
3561: l_Msg_Index_Out NUMBER;
3562: l_CiId PA_CONTROL_ITEMS.Ci_Id%TYPE;
3563: -- End: Local Variables.
3564: BEGIN
3565: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
3566: l_module_name := 'Delete_CI' || g_module_name;

Line 3653: l_DeleteAllowed := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_StatusCode, 'CONTROL_ITEM_ALLOW_DELETE', p_Ci_Id);

3649: -- If the User has View Access to this Control Item and
3650: -- delete is allowed on this Control Item then call the
3651: -- API to delete it.
3652: l_ViewAccess := PA_CI_SECURITY_PKG.Check_View_Access (p_Ci_Id, l_ProjectId, l_StatusCode, l_CiTypeClassCode);
3653: l_DeleteAllowed := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_StatusCode, 'CONTROL_ITEM_ALLOW_DELETE', p_Ci_Id);
3654: IF (l_ViewAccess = 'T' AND l_DeleteAllowed = 'Y') THEN
3655: if (l_debug_mode = 'Y') then
3656: pa_debug.g_err_stage := 'Before Calling PA_CONTROL_ITEMS_PUB.Delete_Control_Item';
3657: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 3656: pa_debug.g_err_stage := 'Before Calling PA_CONTROL_ITEMS_PUB.Delete_Control_Item';

3652: l_ViewAccess := PA_CI_SECURITY_PKG.Check_View_Access (p_Ci_Id, l_ProjectId, l_StatusCode, l_CiTypeClassCode);
3653: l_DeleteAllowed := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_StatusCode, 'CONTROL_ITEM_ALLOW_DELETE', p_Ci_Id);
3654: IF (l_ViewAccess = 'T' AND l_DeleteAllowed = 'Y') THEN
3655: if (l_debug_mode = 'Y') then
3656: pa_debug.g_err_stage := 'Before Calling PA_CONTROL_ITEMS_PUB.Delete_Control_Item';
3657: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3658: end if;
3659: PA_CONTROL_ITEMS_PUB.Delete_Control_Item (
3660: p_Api_Version => p_Api_Version_Number

Line 3659: PA_CONTROL_ITEMS_PUB.Delete_Control_Item (

3655: if (l_debug_mode = 'Y') then
3656: pa_debug.g_err_stage := 'Before Calling PA_CONTROL_ITEMS_PUB.Delete_Control_Item';
3657: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3658: end if;
3659: PA_CONTROL_ITEMS_PUB.Delete_Control_Item (
3660: p_Api_Version => p_Api_Version_Number
3661: , p_Init_Msg_List => 'F'
3662: , p_Commit => p_Commit
3663: , p_Validate_Only => 'F'