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_ITEMS_UTILS dependencies on PA_PROJECT_STATUSES

Line 204: ,pa_project_statuses ps

200:
201: Cursor C_SYS_CONTROL is
202: Select enabled_flag
203: from pa_project_status_controls sc
204: ,pa_project_statuses ps
205: where ps.project_status_code = l_status_code
206: and ps.project_system_status_code = sc.project_system_status_code
207: and sc.status_type = l_status_type
208: and sc.action_code = p_action_code;

Line 274: ,pa_project_statuses ps

270: ,cit.ci_type_class_code ci_type_class
271: ,cit.approval_required_flag approval_required_flag
272: from pa_control_items ci
273: ,pa_ci_types_b cit
274: ,pa_project_statuses ps
275: where ci.ci_id = p_ci_id
276: and ci.ci_type_id = cit.ci_type_id
277: and ci.status_code = ps.project_status_code;
278:

Line 282: from pa_project_statuses

278:
279: CI_REC C_CI%ROWTYPE;
280: Cursor C_NEXT_SYS_STAT is
281: Select project_system_status_code
282: from pa_project_statuses
283: where project_status_code = p_next_status;
284:
285: l_return_value boolean := false;
286: l_curr_sys_status PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;

Line 286: l_curr_sys_status PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;

282: from pa_project_statuses
283: where project_status_code = p_next_status;
284:
285: l_return_value boolean := false;
286: l_curr_sys_status PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
287: l_next_sys_status PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
288:
289: Begin
290: open C_CI;

Line 287: l_next_sys_status PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;

283: where project_status_code = p_next_status;
284:
285: l_return_value boolean := false;
286: l_curr_sys_status PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
287: l_next_sys_status PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
288:
289: Begin
290: open C_CI;
291: fetch C_CI into CI_REC;

Line 658: FROM pa_project_statuses

654:
655: CURSOR get_wf_info
656: IS
657: SELECT workflow_item_type, workflow_process, enable_wf_flag
658: FROM pa_project_statuses
659: WHERE status_type = 'CONTROL_ITEM'
660: AND project_status_code = p_status_code;
661:
662: l_wf_item_type VARCHAR2(30);

Line 730: from pa_wf_processes pwp, pa_project_statuses pps

726:
727:
728: CURSOR get_item_key IS
729: SELECT MAX(pwp.item_key), max(pwp.item_type)
730: from pa_wf_processes pwp, pa_project_statuses pps
731: where pwp.item_type = pps.WORKFLOW_ITEM_TYPE
732: and pps.status_type = 'CONTROL_ITEM'
733: and pps.project_status_code = 'CI_SUBMITTED'
734: AND entity_key2 = p_ci_id

Line 743: from wf_item_activity_statuses wias, pa_project_statuses pps

739: CURSOR get_wf_status IS
740: select 'Y' FROM dual
741: WHERE exists
742: (SELECT *
743: from wf_item_activity_statuses wias, pa_project_statuses pps
744: WHERE wias.item_type = pps.WORKFLOW_ITEM_TYPE
745: AND wias.item_key = l_item_key
746: AND wias.activity_status = 'ACTIVE'
747: AND pps.status_type = 'CONTROL_ITEM'

Line 856: select 'Y', wf_success_status_code from pa_project_statuses

852: AND impact_type_code = 'FINPLAN'
853: );
854:
855: CURSOR c_submit_status(p_project_status_code varchar2) is
856: select 'Y', wf_success_status_code from pa_project_statuses
857: where project_status_code = p_project_status_code
858: and enable_wf_flag = 'Y'
859: and workflow_item_type is not null
860: and workflow_process is not null

Line 1282: l_ci_system_status pa_project_statuses.project_system_status_code%TYPE := NULL ;

1278: -----------------------------------------------------------------------------*/
1279: FUNCTION getCISystemStatus ( p_CI_id IN NUMBER)
1280: return VARCHAR2
1281: is
1282: l_ci_system_status pa_project_statuses.project_system_status_code%TYPE := NULL ;
1283:
1284: BEGIN
1285: IF p_CI_id is not NULL then
1286: select ps.project_system_status_code

Line 1289: ,pa_project_statuses ps

1285: IF p_CI_id is not NULL then
1286: select ps.project_system_status_code
1287: into l_ci_system_status
1288: from pa_control_items ci
1289: ,pa_project_statuses ps
1290: where ci_id = p_ci_id
1291: and ps.project_status_code = nvl(ci.status_code,' ');
1292: END IF ;
1293:

Line 1309: l_ci_system_status pa_project_statuses.project_system_status_code%TYPE := NULL ;

1305: -----------------------------------------------------------------------------*/
1306: FUNCTION getSystemStatus ( p_status_code IN VARCHAR2)
1307: return VARCHAR2
1308: is
1309: l_ci_system_status pa_project_statuses.project_system_status_code%TYPE := NULL ;
1310:
1311: BEGIN
1312: IF p_status_code is not NULL then
1313: select ps.project_system_status_code

Line 1316: pa_project_statuses ps

1312: IF p_status_code is not NULL then
1313: select ps.project_system_status_code
1314: into l_ci_system_status
1315: from
1316: pa_project_statuses ps
1317: where ps.project_status_code = nvl(p_status_code,' ');
1318: END IF ;
1319:
1320: return l_ci_system_status;

Line 1335: l_system_status pa_project_statuses.project_system_status_code%TYPE := NULL ;

1331: ,p_created_by_id IN NUMBER := NULL
1332: ,p_system_status IN VARCHAR2 := NULL)
1333: return VARCHAR2
1334: is
1335: l_system_status pa_project_statuses.project_system_status_code%TYPE := NULL ;
1336: BEGIN
1337: IF (p_system_status is not NULL AND p_system_status = 'CI_DRAFT') then
1338: return 'Y';
1339: END IF ;

Line 1439: ,pa_project_statuses

1435: cursor c_non_draft_ci is
1436: select
1437: ci_id
1438: from pa_control_items
1439: ,pa_project_statuses
1440: where pa_control_items.project_id = p_project_id
1441: and pa_control_items.status_code = pa_project_statuses.project_status_code
1442: and pa_project_statuses.project_system_status_code <> 'CI_DRAFT';
1443:

Line 1441: and pa_control_items.status_code = pa_project_statuses.project_status_code

1437: ci_id
1438: from pa_control_items
1439: ,pa_project_statuses
1440: where pa_control_items.project_id = p_project_id
1441: and pa_control_items.status_code = pa_project_statuses.project_status_code
1442: and pa_project_statuses.project_system_status_code <> 'CI_DRAFT';
1443:
1444: publishedCI c_non_draft_ci%rowtype;
1445: hasNonDraftCI VARCHAR2(1) := 'Y';

Line 1442: and pa_project_statuses.project_system_status_code <> 'CI_DRAFT';

1438: from pa_control_items
1439: ,pa_project_statuses
1440: where pa_control_items.project_id = p_project_id
1441: and pa_control_items.status_code = pa_project_statuses.project_status_code
1442: and pa_project_statuses.project_system_status_code <> 'CI_DRAFT';
1443:
1444: publishedCI c_non_draft_ci%rowtype;
1445: hasNonDraftCI VARCHAR2(1) := 'Y';
1446:

Line 1724: from pa_project_statuses

1720: and pci.object_id = p_object_id
1721: and pci.ci_type_id = pctb.ci_type_id
1722: and pctb.ci_type_class_Code = p_item_type --'ISSUE'
1723: and pci.status_code not in (select project_status_code /* changes start for Bug 5050836 */
1724: from pa_project_statuses
1725: where status_type = 'CONTROL_ITEM'
1726: and project_system_status_code
1727: in ('CI_DRAFT','CI_CLOSED','CI_CANCELED')); /* changes end for Bug 5050836 */
1728:

Line 1739: from pa_project_statuses

1735: and pci.object_id = p_object_id
1736: and pci.ci_type_id = pctb.ci_type_id
1737: and pctb.ci_type_class_Code in ('CHANGE_ORDER','CHANGE_REQUEST')
1738: and pci.status_code not in (select project_status_code /* changes start for Bug 5050836 */
1739: from pa_project_statuses
1740: where status_type = 'CONTROL_ITEM'
1741: and project_system_status_code
1742: in ('CI_DRAFT','CI_CLOSED','CI_CANCELED')); /* changes end for Bug 5050836 */
1743:

Line 1754: -- from pa_project_statuses

1750: -- and pci.object_id = p_object_id
1751: -- and pci.ci_type_id = pctb.ci_type_id
1752: -- and pctb.ci_type_class_Code = 'CHANGE_ORDER'
1753: -- and pci.status_code not in (select project_status_code /* changes start for Bug 5050836 */
1754: -- from pa_project_statuses
1755: -- where status_type = 'CONTROL_ITEM'
1756: -- and project_system_status_code
1757: -- in ('CI_DRAFT','CI_CLOSED','CI_CANCELED')); /* changes end for Bug 5050836 */
1758:

Line 1769: -- from pa_project_statuses

1765: -- and pci.object_id = p_object_id
1766: -- and pci.ci_type_id = pctb.ci_type_id
1767: -- and pctb.ci_type_class_Code = 'CHANGE_REQUEST'
1768: -- and pci.status_code not in (select project_status_code /* changes start for Bug 5050836 */
1769: -- from pa_project_statuses
1770: -- where status_type = 'CONTROL_ITEM'
1771: -- and project_system_status_code
1772: -- in ('CI_DRAFT','CI_CLOSED','CI_CANCELED')); /* changes end for Bug 5050836 */
1773: /*code changes for bug 5611926 ends here*/

Line 1794: FROM pa_project_statuses ps,

1790:
1791: cursor c_wf_type is
1792: SELECT ps.workflow_item_type,
1793: ps.workflow_process
1794: FROM pa_project_statuses ps,
1795: pa_control_items ci
1796: WHERE ci.ci_id = p_ci_id
1797: and ci.status_code = ps.project_status_code
1798: and ps.enable_wf_flag = 'Y'

Line 1812: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;

1808: AND entity_key1 = p_project_id
1809: AND wf_type_code = 'Control Item';
1810:
1811: l_diagramUrl VARCHAR2(2000);
1812: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;
1813: l_wf_process pa_project_statuses.workflow_process%TYPE;
1814: l_item_key pa_wf_processes.item_key%TYPE;
1815:
1816: BEGIN

Line 1813: l_wf_process pa_project_statuses.workflow_process%TYPE;

1809: AND wf_type_code = 'Control Item';
1810:
1811: l_diagramUrl VARCHAR2(2000);
1812: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;
1813: l_wf_process pa_project_statuses.workflow_process%TYPE;
1814: l_item_key pa_wf_processes.item_key%TYPE;
1815:
1816: BEGIN
1817:

Line 1855: FROM pa_project_statuses ps,

1851: IS
1852: cursor c_wf_type is
1853: SELECT ps.workflow_item_type,
1854: ps.workflow_process
1855: FROM pa_project_statuses ps,
1856: pa_control_items ci
1857: WHERE ci.ci_id = p_ci_id
1858: and ci.status_code = ps.project_status_code
1859: and ps.enable_wf_flag = 'Y'

Line 1884: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;

1880: order by obj_status_change_id desc) a
1881: where rownum = 1;
1882:
1883: l_diagramUrl VARCHAR2(2000);
1884: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;
1885: l_wf_process pa_project_statuses.workflow_process%TYPE;
1886: l_item_key pa_wf_processes.item_key%TYPE;
1887: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;
1888: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;

Line 1885: l_wf_process pa_project_statuses.workflow_process%TYPE;

1881: where rownum = 1;
1882:
1883: l_diagramUrl VARCHAR2(2000);
1884: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;
1885: l_wf_process pa_project_statuses.workflow_process%TYPE;
1886: l_item_key pa_wf_processes.item_key%TYPE;
1887: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;
1888: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;
1889: l_comment pa_ci_comments.comment_text%TYPE;

Line 1985: from pa_project_statuses

1981: IS
1982:
1983: cursor c_status_name(p_status VARCHAR2) is
1984: select project_status_name
1985: from pa_project_statuses
1986: where status_type = 'CONTROL_ITEM'
1987: and project_status_code = p_status;
1988:
1989: l_error_msg_code varchar2(30);

Line 1993: l_new_sysstatus pa_project_statuses.project_system_status_code%TYPE;

1989: l_error_msg_code varchar2(30);
1990: l_ci_comment_id NUMBER;
1991: l_ci_action_id NUMBER;
1992: l_rowid VARCHAR2(255);
1993: l_new_sysstatus pa_project_statuses.project_system_status_code%TYPE;
1994: l_old_sysstatus pa_project_statuses.project_system_status_code%TYPE;
1995: l_comment_text pa_ci_comments.comment_text%TYPE;
1996: l_obj_status_change_id NUMBER;
1997: l_new_status_name pa_project_statuses.project_status_name%TYPE;

Line 1994: l_old_sysstatus pa_project_statuses.project_system_status_code%TYPE;

1990: l_ci_comment_id NUMBER;
1991: l_ci_action_id NUMBER;
1992: l_rowid VARCHAR2(255);
1993: l_new_sysstatus pa_project_statuses.project_system_status_code%TYPE;
1994: l_old_sysstatus pa_project_statuses.project_system_status_code%TYPE;
1995: l_comment_text pa_ci_comments.comment_text%TYPE;
1996: l_obj_status_change_id NUMBER;
1997: l_new_status_name pa_project_statuses.project_status_name%TYPE;
1998: l_old_status_name pa_project_statuses.project_status_name%TYPE;

Line 1997: l_new_status_name pa_project_statuses.project_status_name%TYPE;

1993: l_new_sysstatus pa_project_statuses.project_system_status_code%TYPE;
1994: l_old_sysstatus pa_project_statuses.project_system_status_code%TYPE;
1995: l_comment_text pa_ci_comments.comment_text%TYPE;
1996: l_obj_status_change_id NUMBER;
1997: l_new_status_name pa_project_statuses.project_status_name%TYPE;
1998: l_old_status_name pa_project_statuses.project_status_name%TYPE;
1999:
2000: BEGIN
2001: x_return_status := fnd_api.g_ret_sts_success;

Line 1998: l_old_status_name pa_project_statuses.project_status_name%TYPE;

1994: l_old_sysstatus pa_project_statuses.project_system_status_code%TYPE;
1995: l_comment_text pa_ci_comments.comment_text%TYPE;
1996: l_obj_status_change_id NUMBER;
1997: l_new_status_name pa_project_statuses.project_status_name%TYPE;
1998: l_old_status_name pa_project_statuses.project_status_name%TYPE;
1999:
2000: BEGIN
2001: x_return_status := fnd_api.g_ret_sts_success;
2002: x_msg_data := 0;

Line 2144: select 'Y', wf_success_status_code from pa_project_statuses

2140: AND impact_type_code like 'FINPLAN%'
2141: );
2142:
2143: CURSOR c_submit_status(p_project_status_code varchar2) is
2144: select 'Y', wf_success_status_code from pa_project_statuses
2145: where project_status_code = p_project_status_code
2146: and enable_wf_flag = 'Y'
2147: and workflow_item_type is not null
2148: and workflow_process is not null