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 617: pa_control_items pci

613: cursor c_get_project_id(c_ci_id number)
614: is
615: select pci.project_id
616: from
617: pa_control_items pci
618: where pci.ci_id = c_ci_id;
619:
620:
621: /*Cursor to check ci_id validity*/

Line 623: select ci_type_id from pa_control_items a , pa_ci_impacts b

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

Line 1732: l_summary pa_control_items.summary%type;

1728:
1729:
1730: l_any_err_occured_flg VARCHAR2(1);
1731:
1732: l_summary pa_control_items.summary%type;
1733: l_description pa_control_items.description%type;
1734: l_status_code pa_project_statuses.project_status_code%type;
1735: l_status_name pa_project_statuses.project_status_name%type;
1736: l_system_status_code pa_project_statuses.project_system_status_code%type;

Line 1733: l_description pa_control_items.description%type;

1729:
1730: l_any_err_occured_flg VARCHAR2(1);
1731:
1732: l_summary pa_control_items.summary%type;
1733: l_description pa_control_items.description%type;
1734: l_status_code pa_project_statuses.project_status_code%type;
1735: l_status_name pa_project_statuses.project_status_name%type;
1736: l_system_status_code pa_project_statuses.project_system_status_code%type;
1737:

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

1734: l_status_code pa_project_statuses.project_status_code%type;
1735: l_status_name pa_project_statuses.project_status_name%type;
1736: l_system_status_code pa_project_statuses.project_system_status_code%type;
1737:
1738: l_ci_number_char PA_CONTROL_ITEMS.ci_number%type := NULL;
1739: l_ci_number_num NUMBER(15) := NULL;
1740: l_system_number_id NUMBER(15) := NULL;
1741:
1742: l_owner_id per_all_people_f.party_id%type;

Line 1745: l_classification_code pa_control_items.classification_code_id%type;

1741:
1742: l_owner_id per_all_people_f.party_id%type;
1743: l_owner_name per_all_people_f.full_name%type;
1744: l_progress_status_code pa_project_statuses.project_status_code%type;
1745: l_classification_code pa_control_items.classification_code_id%type;
1746: l_reason_code pa_control_items.reason_code_id%type;
1747: l_object_id pa_proj_elements.proj_element_id%type;
1748: l_date_closed pa_control_items.date_closed%type;
1749: l_closed_by_id pa_control_items.closed_by_id%type;

Line 1746: l_reason_code pa_control_items.reason_code_id%type;

1742: l_owner_id per_all_people_f.party_id%type;
1743: l_owner_name per_all_people_f.full_name%type;
1744: l_progress_status_code pa_project_statuses.project_status_code%type;
1745: l_classification_code pa_control_items.classification_code_id%type;
1746: l_reason_code pa_control_items.reason_code_id%type;
1747: l_object_id pa_proj_elements.proj_element_id%type;
1748: l_date_closed pa_control_items.date_closed%type;
1749: l_closed_by_id pa_control_items.closed_by_id%type;
1750: l_valid_clsby_id VARCHAR2(1);

Line 1748: l_date_closed pa_control_items.date_closed%type;

1744: l_progress_status_code pa_project_statuses.project_status_code%type;
1745: l_classification_code pa_control_items.classification_code_id%type;
1746: l_reason_code pa_control_items.reason_code_id%type;
1747: l_object_id pa_proj_elements.proj_element_id%type;
1748: l_date_closed pa_control_items.date_closed%type;
1749: l_closed_by_id pa_control_items.closed_by_id%type;
1750: l_valid_clsby_id VARCHAR2(1);
1751: l_resolution_code pa_control_items.resolution_code_id%type;
1752: l_resolution pa_control_items.resolution%type;

Line 1749: l_closed_by_id pa_control_items.closed_by_id%type;

1745: l_classification_code pa_control_items.classification_code_id%type;
1746: l_reason_code pa_control_items.reason_code_id%type;
1747: l_object_id pa_proj_elements.proj_element_id%type;
1748: l_date_closed pa_control_items.date_closed%type;
1749: l_closed_by_id pa_control_items.closed_by_id%type;
1750: l_valid_clsby_id VARCHAR2(1);
1751: l_resolution_code pa_control_items.resolution_code_id%type;
1752: l_resolution pa_control_items.resolution%type;
1753: l_effort_level_code pa_control_items.effort_level_code%type;

Line 1751: l_resolution_code pa_control_items.resolution_code_id%type;

1747: l_object_id pa_proj_elements.proj_element_id%type;
1748: l_date_closed pa_control_items.date_closed%type;
1749: l_closed_by_id pa_control_items.closed_by_id%type;
1750: l_valid_clsby_id VARCHAR2(1);
1751: l_resolution_code pa_control_items.resolution_code_id%type;
1752: l_resolution pa_control_items.resolution%type;
1753: l_effort_level_code pa_control_items.effort_level_code%type;
1754: l_priority_code pa_control_items.priority_code%type;
1755: l_price_currency_code pa_control_items.price_currency_code%type;

Line 1752: l_resolution pa_control_items.resolution%type;

1748: l_date_closed pa_control_items.date_closed%type;
1749: l_closed_by_id pa_control_items.closed_by_id%type;
1750: l_valid_clsby_id VARCHAR2(1);
1751: l_resolution_code pa_control_items.resolution_code_id%type;
1752: l_resolution pa_control_items.resolution%type;
1753: l_effort_level_code pa_control_items.effort_level_code%type;
1754: l_priority_code pa_control_items.priority_code%type;
1755: l_price_currency_code pa_control_items.price_currency_code%type;
1756: l_price pa_control_items.price%type;

Line 1753: l_effort_level_code pa_control_items.effort_level_code%type;

1749: l_closed_by_id pa_control_items.closed_by_id%type;
1750: l_valid_clsby_id VARCHAR2(1);
1751: l_resolution_code pa_control_items.resolution_code_id%type;
1752: l_resolution pa_control_items.resolution%type;
1753: l_effort_level_code pa_control_items.effort_level_code%type;
1754: l_priority_code pa_control_items.priority_code%type;
1755: l_price_currency_code pa_control_items.price_currency_code%type;
1756: l_price pa_control_items.price%type;
1757:

Line 1754: l_priority_code pa_control_items.priority_code%type;

1750: l_valid_clsby_id VARCHAR2(1);
1751: l_resolution_code pa_control_items.resolution_code_id%type;
1752: l_resolution pa_control_items.resolution%type;
1753: l_effort_level_code pa_control_items.effort_level_code%type;
1754: l_priority_code pa_control_items.priority_code%type;
1755: l_price_currency_code pa_control_items.price_currency_code%type;
1756: l_price pa_control_items.price%type;
1757:
1758: l_attribute_category pa_control_items.attribute_category%type;

Line 1755: l_price_currency_code pa_control_items.price_currency_code%type;

1751: l_resolution_code pa_control_items.resolution_code_id%type;
1752: l_resolution pa_control_items.resolution%type;
1753: l_effort_level_code pa_control_items.effort_level_code%type;
1754: l_priority_code pa_control_items.priority_code%type;
1755: l_price_currency_code pa_control_items.price_currency_code%type;
1756: l_price pa_control_items.price%type;
1757:
1758: l_attribute_category pa_control_items.attribute_category%type;
1759: l_attribute1 pa_control_items.attribute1%type;

Line 1756: l_price pa_control_items.price%type;

1752: l_resolution pa_control_items.resolution%type;
1753: l_effort_level_code pa_control_items.effort_level_code%type;
1754: l_priority_code pa_control_items.priority_code%type;
1755: l_price_currency_code pa_control_items.price_currency_code%type;
1756: l_price pa_control_items.price%type;
1757:
1758: l_attribute_category pa_control_items.attribute_category%type;
1759: l_attribute1 pa_control_items.attribute1%type;
1760: l_attribute2 pa_control_items.attribute1%type;

Line 1758: l_attribute_category pa_control_items.attribute_category%type;

1754: l_priority_code pa_control_items.priority_code%type;
1755: l_price_currency_code pa_control_items.price_currency_code%type;
1756: l_price pa_control_items.price%type;
1757:
1758: l_attribute_category pa_control_items.attribute_category%type;
1759: l_attribute1 pa_control_items.attribute1%type;
1760: l_attribute2 pa_control_items.attribute1%type;
1761: l_attribute3 pa_control_items.attribute1%type;
1762: l_attribute4 pa_control_items.attribute1%type;

Line 1759: l_attribute1 pa_control_items.attribute1%type;

1755: l_price_currency_code pa_control_items.price_currency_code%type;
1756: l_price pa_control_items.price%type;
1757:
1758: l_attribute_category pa_control_items.attribute_category%type;
1759: l_attribute1 pa_control_items.attribute1%type;
1760: l_attribute2 pa_control_items.attribute1%type;
1761: l_attribute3 pa_control_items.attribute1%type;
1762: l_attribute4 pa_control_items.attribute1%type;
1763: l_attribute5 pa_control_items.attribute1%type;

Line 1760: l_attribute2 pa_control_items.attribute1%type;

1756: l_price pa_control_items.price%type;
1757:
1758: l_attribute_category pa_control_items.attribute_category%type;
1759: l_attribute1 pa_control_items.attribute1%type;
1760: l_attribute2 pa_control_items.attribute1%type;
1761: l_attribute3 pa_control_items.attribute1%type;
1762: l_attribute4 pa_control_items.attribute1%type;
1763: l_attribute5 pa_control_items.attribute1%type;
1764: l_attribute6 pa_control_items.attribute1%type;

Line 1761: l_attribute3 pa_control_items.attribute1%type;

1757:
1758: l_attribute_category pa_control_items.attribute_category%type;
1759: l_attribute1 pa_control_items.attribute1%type;
1760: l_attribute2 pa_control_items.attribute1%type;
1761: l_attribute3 pa_control_items.attribute1%type;
1762: l_attribute4 pa_control_items.attribute1%type;
1763: l_attribute5 pa_control_items.attribute1%type;
1764: l_attribute6 pa_control_items.attribute1%type;
1765: l_attribute7 pa_control_items.attribute1%type;

Line 1762: l_attribute4 pa_control_items.attribute1%type;

1758: l_attribute_category pa_control_items.attribute_category%type;
1759: l_attribute1 pa_control_items.attribute1%type;
1760: l_attribute2 pa_control_items.attribute1%type;
1761: l_attribute3 pa_control_items.attribute1%type;
1762: l_attribute4 pa_control_items.attribute1%type;
1763: l_attribute5 pa_control_items.attribute1%type;
1764: l_attribute6 pa_control_items.attribute1%type;
1765: l_attribute7 pa_control_items.attribute1%type;
1766: l_attribute8 pa_control_items.attribute1%type;

Line 1763: l_attribute5 pa_control_items.attribute1%type;

1759: l_attribute1 pa_control_items.attribute1%type;
1760: l_attribute2 pa_control_items.attribute1%type;
1761: l_attribute3 pa_control_items.attribute1%type;
1762: l_attribute4 pa_control_items.attribute1%type;
1763: l_attribute5 pa_control_items.attribute1%type;
1764: l_attribute6 pa_control_items.attribute1%type;
1765: l_attribute7 pa_control_items.attribute1%type;
1766: l_attribute8 pa_control_items.attribute1%type;
1767: l_attribute9 pa_control_items.attribute1%type;

Line 1764: l_attribute6 pa_control_items.attribute1%type;

1760: l_attribute2 pa_control_items.attribute1%type;
1761: l_attribute3 pa_control_items.attribute1%type;
1762: l_attribute4 pa_control_items.attribute1%type;
1763: l_attribute5 pa_control_items.attribute1%type;
1764: l_attribute6 pa_control_items.attribute1%type;
1765: l_attribute7 pa_control_items.attribute1%type;
1766: l_attribute8 pa_control_items.attribute1%type;
1767: l_attribute9 pa_control_items.attribute1%type;
1768: l_attribute10 pa_control_items.attribute1%type;

Line 1765: l_attribute7 pa_control_items.attribute1%type;

1761: l_attribute3 pa_control_items.attribute1%type;
1762: l_attribute4 pa_control_items.attribute1%type;
1763: l_attribute5 pa_control_items.attribute1%type;
1764: l_attribute6 pa_control_items.attribute1%type;
1765: l_attribute7 pa_control_items.attribute1%type;
1766: l_attribute8 pa_control_items.attribute1%type;
1767: l_attribute9 pa_control_items.attribute1%type;
1768: l_attribute10 pa_control_items.attribute1%type;
1769: l_attribute11 pa_control_items.attribute1%type;

Line 1766: l_attribute8 pa_control_items.attribute1%type;

1762: l_attribute4 pa_control_items.attribute1%type;
1763: l_attribute5 pa_control_items.attribute1%type;
1764: l_attribute6 pa_control_items.attribute1%type;
1765: l_attribute7 pa_control_items.attribute1%type;
1766: l_attribute8 pa_control_items.attribute1%type;
1767: l_attribute9 pa_control_items.attribute1%type;
1768: l_attribute10 pa_control_items.attribute1%type;
1769: l_attribute11 pa_control_items.attribute1%type;
1770: l_attribute12 pa_control_items.attribute1%type;

Line 1767: l_attribute9 pa_control_items.attribute1%type;

1763: l_attribute5 pa_control_items.attribute1%type;
1764: l_attribute6 pa_control_items.attribute1%type;
1765: l_attribute7 pa_control_items.attribute1%type;
1766: l_attribute8 pa_control_items.attribute1%type;
1767: l_attribute9 pa_control_items.attribute1%type;
1768: l_attribute10 pa_control_items.attribute1%type;
1769: l_attribute11 pa_control_items.attribute1%type;
1770: l_attribute12 pa_control_items.attribute1%type;
1771: l_attribute13 pa_control_items.attribute1%type;

Line 1768: l_attribute10 pa_control_items.attribute1%type;

1764: l_attribute6 pa_control_items.attribute1%type;
1765: l_attribute7 pa_control_items.attribute1%type;
1766: l_attribute8 pa_control_items.attribute1%type;
1767: l_attribute9 pa_control_items.attribute1%type;
1768: l_attribute10 pa_control_items.attribute1%type;
1769: l_attribute11 pa_control_items.attribute1%type;
1770: l_attribute12 pa_control_items.attribute1%type;
1771: l_attribute13 pa_control_items.attribute1%type;
1772: l_attribute14 pa_control_items.attribute1%type;

Line 1769: l_attribute11 pa_control_items.attribute1%type;

1765: l_attribute7 pa_control_items.attribute1%type;
1766: l_attribute8 pa_control_items.attribute1%type;
1767: l_attribute9 pa_control_items.attribute1%type;
1768: l_attribute10 pa_control_items.attribute1%type;
1769: l_attribute11 pa_control_items.attribute1%type;
1770: l_attribute12 pa_control_items.attribute1%type;
1771: l_attribute13 pa_control_items.attribute1%type;
1772: l_attribute14 pa_control_items.attribute1%type;
1773: l_attribute15 pa_control_items.attribute1%type;

Line 1770: l_attribute12 pa_control_items.attribute1%type;

1766: l_attribute8 pa_control_items.attribute1%type;
1767: l_attribute9 pa_control_items.attribute1%type;
1768: l_attribute10 pa_control_items.attribute1%type;
1769: l_attribute11 pa_control_items.attribute1%type;
1770: l_attribute12 pa_control_items.attribute1%type;
1771: l_attribute13 pa_control_items.attribute1%type;
1772: l_attribute14 pa_control_items.attribute1%type;
1773: l_attribute15 pa_control_items.attribute1%type;
1774:

Line 1771: l_attribute13 pa_control_items.attribute1%type;

1767: l_attribute9 pa_control_items.attribute1%type;
1768: l_attribute10 pa_control_items.attribute1%type;
1769: l_attribute11 pa_control_items.attribute1%type;
1770: l_attribute12 pa_control_items.attribute1%type;
1771: l_attribute13 pa_control_items.attribute1%type;
1772: l_attribute14 pa_control_items.attribute1%type;
1773: l_attribute15 pa_control_items.attribute1%type;
1774:
1775:

Line 1772: l_attribute14 pa_control_items.attribute1%type;

1768: l_attribute10 pa_control_items.attribute1%type;
1769: l_attribute11 pa_control_items.attribute1%type;
1770: l_attribute12 pa_control_items.attribute1%type;
1771: l_attribute13 pa_control_items.attribute1%type;
1772: l_attribute14 pa_control_items.attribute1%type;
1773: l_attribute15 pa_control_items.attribute1%type;
1774:
1775:
1776: l_source_type_name pa_lookups.meaning%type;

Line 1773: l_attribute15 pa_control_items.attribute1%type;

1769: l_attribute11 pa_control_items.attribute1%type;
1770: l_attribute12 pa_control_items.attribute1%type;
1771: l_attribute13 pa_control_items.attribute1%type;
1772: l_attribute14 pa_control_items.attribute1%type;
1773: l_attribute15 pa_control_items.attribute1%type;
1774:
1775:
1776: l_source_type_name pa_lookups.meaning%type;
1777: l_source_type_code pa_control_items.source_type_code%type;

Line 1777: l_source_type_code pa_control_items.source_type_code%type;

1773: l_attribute15 pa_control_items.attribute1%type;
1774:
1775:
1776: l_source_type_name pa_lookups.meaning%type;
1777: l_source_type_code pa_control_items.source_type_code%type;
1778: l_source_number pa_control_items.source_number%type;
1779: l_source_comment pa_control_items.source_comment%type;
1780: l_source_date_received pa_control_items.source_date_received%type;
1781: l_source_organization pa_control_items.source_organization%type;

Line 1778: l_source_number pa_control_items.source_number%type;

1774:
1775:
1776: l_source_type_name pa_lookups.meaning%type;
1777: l_source_type_code pa_control_items.source_type_code%type;
1778: l_source_number pa_control_items.source_number%type;
1779: l_source_comment pa_control_items.source_comment%type;
1780: l_source_date_received pa_control_items.source_date_received%type;
1781: l_source_organization pa_control_items.source_organization%type;
1782: l_source_person pa_control_items.source_person%type;

Line 1779: l_source_comment pa_control_items.source_comment%type;

1775:
1776: l_source_type_name pa_lookups.meaning%type;
1777: l_source_type_code pa_control_items.source_type_code%type;
1778: l_source_number pa_control_items.source_number%type;
1779: l_source_comment pa_control_items.source_comment%type;
1780: l_source_date_received pa_control_items.source_date_received%type;
1781: l_source_organization pa_control_items.source_organization%type;
1782: l_source_person pa_control_items.source_person%type;
1783: l_ci_id pa_control_items.ci_id%type;

Line 1780: l_source_date_received pa_control_items.source_date_received%type;

1776: l_source_type_name pa_lookups.meaning%type;
1777: l_source_type_code pa_control_items.source_type_code%type;
1778: l_source_number pa_control_items.source_number%type;
1779: l_source_comment pa_control_items.source_comment%type;
1780: l_source_date_received pa_control_items.source_date_received%type;
1781: l_source_organization pa_control_items.source_organization%type;
1782: l_source_person pa_control_items.source_person%type;
1783: l_ci_id pa_control_items.ci_id%type;
1784: begin

Line 1781: l_source_organization pa_control_items.source_organization%type;

1777: l_source_type_code pa_control_items.source_type_code%type;
1778: l_source_number pa_control_items.source_number%type;
1779: l_source_comment pa_control_items.source_comment%type;
1780: l_source_date_received pa_control_items.source_date_received%type;
1781: l_source_organization pa_control_items.source_organization%type;
1782: l_source_person pa_control_items.source_person%type;
1783: l_ci_id pa_control_items.ci_id%type;
1784: begin
1785: -- initialize the return status to success

Line 1782: l_source_person pa_control_items.source_person%type;

1778: l_source_number pa_control_items.source_number%type;
1779: l_source_comment pa_control_items.source_comment%type;
1780: l_source_date_received pa_control_items.source_date_received%type;
1781: l_source_organization pa_control_items.source_organization%type;
1782: l_source_person pa_control_items.source_person%type;
1783: l_ci_id pa_control_items.ci_id%type;
1784: begin
1785: -- initialize the return status to success
1786: x_return_status := fnd_api.g_ret_sts_success;

Line 1783: l_ci_id pa_control_items.ci_id%type;

1779: l_source_comment pa_control_items.source_comment%type;
1780: l_source_date_received pa_control_items.source_date_received%type;
1781: l_source_organization pa_control_items.source_organization%type;
1782: l_source_person pa_control_items.source_person%type;
1783: l_ci_id pa_control_items.ci_id%type;
1784: begin
1785: -- initialize the return status to success
1786: x_return_status := fnd_api.g_ret_sts_success;
1787: x_msg_count := 0;

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

1801: l_any_err_occured_flg := 'N';
1802:
1803: --get the user id and the party id for the current logged in user.
1804: l_user_id := fnd_global.user_id;
1805: l_party_id := pa_control_items_utils.getpartyid(l_user_id);
1806: l_resp_id := fnd_global.resp_id;
1807:
1808: if(p_summary is null) then
1809: PA_UTILS.ADD_MESSAGE

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

1820: l_description := p_description;
1821:
1822: if (p_status_code is null and p_status is null) then
1823: /*get the default starting status*/
1824: l_status_code := PA_CONTROL_ITEMS_UTILS.Get_Initial_Ci_Status(p_ci_type_id);
1825: /*l_status_code would always be CI_WORKING here and below select would always give CI_WORKING
1826: for project_system_status_code. So */
1827: select project_system_status_code
1828: into l_system_status_code

Line 2198: select pa_control_items_s.nextval

2194: l_attribute15 := p_attribute15;
2195:
2196: /* if we reach here in code then all the attributes have been validated.
2197: So get the next value from the sequence which will be used as the ci_id*/
2198: select pa_control_items_s.nextval
2199: into l_ci_id
2200: from dual;
2201:
2202: /* now generate the ci_number;*/

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

2235: ,x_return_status => x_return_status
2236: ,x_msg_count => x_msg_count
2237: ,x_msg_data => x_msg_data);
2238:
2239: exit when pa_control_items_pvt.ci_number_exists(p_project_id, l_ci_number_char
2240: ,p_ci_type_id) = FALSE;
2241: end loop;
2242: else --p_auto_number_flag = 'Y' and l_system_status_code <> 'CI_DRAFT'
2243: /*For manual numbering check if passed ci_number already exist.*/

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

2241: end loop;
2242: else --p_auto_number_flag = 'Y' and l_system_status_code <> 'CI_DRAFT'
2243: /*For manual numbering check if passed ci_number already exist.*/
2244: l_ci_number_char := p_ci_number;
2245: if pa_control_items_pvt.ci_number_exists(p_project_id, l_ci_number_char ,p_ci_type_id) = TRUE then
2246: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2247: ,p_msg_name => 'PA_CI_DUPLICATE_CI_NUMBER');--msg already there
2248: if l_debug_mode = 'Y' then
2249: pa_debug.g_err_stage:= 'Duplicate ci_number passed.';

Line 2282: pa_control_items_pkg.insert_row (

2278: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2279: end if;
2280:
2281: if (l_any_err_occured_flg is not null and l_any_err_occured_flg <> 'Y') then
2282: pa_control_items_pkg.insert_row (
2283: p_ci_type_id => p_ci_type_id,
2284: p_summary => l_summary,
2285: p_status_code => l_status_code,
2286: p_owner_id => l_owner_id,

Line 2435: from pa_control_items

2431: IS
2432:
2433: cursor check_valid_ci_id(p_ci_id number) is
2434: select ci_id, project_id
2435: from pa_control_items
2436: where ci_id = p_ci_id;
2437:
2438:
2439: l_msg_count NUMBER := 0;

Line 2446: l_ci_id pa_control_items.ci_id%type;

2442: l_msg_index_out NUMBER;
2443: l_module_name VARCHAR2(200);
2444: l_any_err_occured_flg VARCHAR2(1);
2445: l_create_action_flg VARCHAR2(1) := null;
2446: l_ci_id pa_control_items.ci_id%type;
2447: l_check_valid_ci_id_rec check_valid_ci_id%rowtype;
2448: BEGIN
2449:
2450: -- initialize the return status to success

Line 2762: pa_control_items pci

2758: cursor act_sts_allw_for_ci_sts(p_ci_id NUMBER)
2759: is
2760: select pps.project_system_status_code
2761: from pa_project_statuses pps,
2762: pa_control_items pci
2763: where pps.status_type = 'CONTROL_ITEM'
2764: and pps.project_status_code = pci.status_code
2765: and pci.ci_id = p_ci_id;
2766:

Line 2781: l_ci_status_code pa_control_items.status_code%type;

2777: l_any_err_occured_flg VARCHAR2(1);
2778: l_return_status VARCHAR2(1);
2779:
2780: l_action_status_code pa_project_statuses.project_status_code%type;
2781: l_ci_status_code pa_control_items.status_code%type;
2782: --l_src_ci_action_id pa_ci_actions.ci_action_id%type;
2783: l_action_tbl pa_control_api_pub.ci_actions_in_tbl_type;
2784: chk_valid_src_ci_action_id_rec check_valid_src_ci_action_id%rowtype;
2785:

Line 3089: from pa_control_items

3085:
3086: Cursor getRecordVersionNumber(p_ci_id number)
3087: is
3088: select record_version_number
3089: from pa_control_items
3090: where ci_id = p_ci_id;
3091:
3092:
3093: l_msg_count NUMBER := 0;

Line 3103: l_ci_record_version_number pa_control_items.record_version_number%type;

3099: l_action_number pa_ci_actions.ci_action_number%type;
3100: l_ci_comment_id pa_ci_comments.ci_comment_id%type;
3101: l_type_code pa_ci_comments.type_code%type;
3102: l_ci_action_id pa_ci_actions.ci_action_id%type;
3103: l_ci_record_version_number pa_control_items.record_version_number%type;
3104: l_process_name varchar(100);
3105: l_item_key pa_wf_processes.item_key%TYPE;
3106: l_num_of_actions number;
3107: l_num_open_action pa_control_items.open_action_num%type;

Line 3107: l_num_open_action pa_control_items.open_action_num%type;

3103: l_ci_record_version_number pa_control_items.record_version_number%type;
3104: l_process_name varchar(100);
3105: l_item_key pa_wf_processes.item_key%TYPE;
3106: l_num_of_actions number;
3107: l_num_open_action pa_control_items.open_action_num%type;
3108: BEGIN
3109: -- initialize the return status to success
3110: x_return_status := fnd_api.g_ret_sts_success;
3111: x_msg_count := 0;

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

3199: if l_debug_mode = 'Y' then
3200: pa_debug.g_err_stage := 'Updating number of actions for a control item';
3201: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3202: end if;
3203: /*now update the number of actions in pa_control_items_table */
3204: if(p_action_tbl(i).action_status = 'CI_ACTION_OPEN') then
3205: l_num_open_action := l_num_open_action + 1;
3206: end if;
3207:

Line 3208: /* pa_control_items_pvt.update_number_of_actions (

3204: if(p_action_tbl(i).action_status = 'CI_ACTION_OPEN') then
3205: l_num_open_action := l_num_open_action + 1;
3206: end if;
3207:
3208: /* pa_control_items_pvt.update_number_of_actions (
3209: p_ci_id => p_ci_id,
3210: p_num_of_actions => 1,
3211: p_record_version_number => l_ci_record_version_number,
3212: x_num_of_actions => l_num_of_actions,

Line 3235: pa_control_items_workflow.start_notification_wf

3231: else
3232: l_process_name := 'PA_CI_ACTION_ASMT_NO_SIGN_OFF';
3233: end if;
3234:
3235: pa_control_items_workflow.start_notification_wf
3236: ( p_item_type => 'PAWFCIAC'
3237: ,p_process_name => l_process_name
3238: ,p_ci_id => p_ci_id
3239: ,p_action_id => l_ci_action_id

Line 3252: pa_control_items_workflow.start_notification_wf

3248:
3249: elsif( p_action_tbl(i).action_status = 'CI_ACTION_CLOSED') then
3250: /*need to check if we should send the notification while creating closed actions*/
3251: /*Most likely we shd not be sending this. Can be commented later*/
3252: pa_control_items_workflow.start_notification_wf
3253: ( p_item_type => 'PAWFCIAC'
3254: ,p_process_name => 'PA_CI_ACTION_CLOSE_FYI'
3255: ,p_ci_id => p_ci_id
3256: ,p_action_id => l_ci_action_id

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

3265: end if;--(p_action_tbl(i).start_wf = 'Y')
3266:
3267: end loop;-- For i in 1..p_action_tbl.count
3268:
3269: --if there were any open actions update the no of open action in pa_control_items
3270: --this has to be done outside the loop only once for all the open actions in table.
3271: if(l_num_open_action is not null and l_num_open_action > 0 ) then
3272: pa_control_items_pvt.update_number_of_actions (
3273: p_ci_id => p_ci_id,

Line 3272: pa_control_items_pvt.update_number_of_actions (

3268:
3269: --if there were any open actions update the no of open action in pa_control_items
3270: --this has to be done outside the loop only once for all the open actions in table.
3271: if(l_num_open_action is not null and l_num_open_action > 0 ) then
3272: pa_control_items_pvt.update_number_of_actions (
3273: p_ci_id => p_ci_id,
3274: p_num_of_actions => l_num_open_action,
3275: p_record_version_number => l_ci_record_version_number,
3276: x_num_of_actions => l_num_of_actions,

Line 3343: pa_control_items pci

3339: cursor get_ci_action_id(p_ci_id number, p_action_number number)
3340: is
3341: select pca.ci_action_id, pca.assigned_to, pci.project_id
3342: from pa_ci_actions pca,
3343: pa_control_items pci
3344: where pca.ci_id = p_ci_id
3345: and pca.ci_action_number = p_action_number
3346: and pci.ci_id = p_ci_id;
3347:

Line 3352: pa_control_items pci

3348: cursor validate_ci_action_id(p_action_id number)
3349: is
3350: select pca.ci_action_id, pca.assigned_to, pci.project_id
3351: from pa_ci_actions pca,
3352: pa_control_items pci
3353: where pca.ci_action_id = p_action_id
3354: and pci.ci_id = pca.ci_id;
3355:
3356: l_validate_ci_action_id_rec validate_ci_action_id%rowtype;

Line 3545: l_CiId PA_CONTROL_ITEMS.Ci_Id%TYPE;

3541: l_Msg_Count NUMBER := 0;
3542: l_Data VARCHAR2(2000);
3543: l_Msg_Data VARCHAR2(2000);
3544: l_Msg_Index_Out NUMBER;
3545: l_CiId PA_CONTROL_ITEMS.Ci_Id%TYPE;
3546: -- End: Local Variables.
3547: BEGIN
3548: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
3549: l_module_name := 'Delete_CI' || g_module_name;

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

3632: -- If the User has View Access to this Control Item and
3633: -- delete is allowed on this Control Item then call the
3634: -- API to delete it.
3635: l_ViewAccess := PA_CI_SECURITY_PKG.Check_View_Access (p_Ci_Id, l_ProjectId, l_StatusCode, l_CiTypeClassCode);
3636: l_DeleteAllowed := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_StatusCode, 'CONTROL_ITEM_ALLOW_DELETE', p_Ci_Id);
3637: IF (l_ViewAccess = 'T' AND l_DeleteAllowed = 'Y') THEN
3638: if (l_debug_mode = 'Y') then
3639: pa_debug.g_err_stage := 'Before Calling PA_CONTROL_ITEMS_PUB.Delete_Control_Item';
3640: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

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

3635: l_ViewAccess := PA_CI_SECURITY_PKG.Check_View_Access (p_Ci_Id, l_ProjectId, l_StatusCode, l_CiTypeClassCode);
3636: l_DeleteAllowed := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_StatusCode, 'CONTROL_ITEM_ALLOW_DELETE', p_Ci_Id);
3637: IF (l_ViewAccess = 'T' AND l_DeleteAllowed = 'Y') THEN
3638: if (l_debug_mode = 'Y') then
3639: pa_debug.g_err_stage := 'Before Calling PA_CONTROL_ITEMS_PUB.Delete_Control_Item';
3640: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3641: end if;
3642: PA_CONTROL_ITEMS_PUB.Delete_Control_Item (
3643: p_Api_Version => p_Api_Version_Number

Line 3642: PA_CONTROL_ITEMS_PUB.Delete_Control_Item (

3638: if (l_debug_mode = 'Y') then
3639: pa_debug.g_err_stage := 'Before Calling PA_CONTROL_ITEMS_PUB.Delete_Control_Item';
3640: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3641: end if;
3642: PA_CONTROL_ITEMS_PUB.Delete_Control_Item (
3643: p_Api_Version => p_Api_Version_Number
3644: , p_Init_Msg_List => 'F'
3645: , p_Commit => p_Commit
3646: , p_Validate_Only => 'F'