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 248: ,pa_project_statuses ps

244:
245: Cursor C_SYS_CONTROL is
246: Select enabled_flag
247: from pa_project_status_controls sc
248: ,pa_project_statuses ps
249: where ps.project_status_code = l_status_code
250: and ps.project_system_status_code = sc.project_system_status_code
251: and sc.status_type = l_status_type
252: and sc.action_code = p_action_code;

Line 318: ,pa_project_statuses ps

314: ,cit.ci_type_class_code ci_type_class
315: ,cit.approval_required_flag approval_required_flag
316: from pa_control_items ci
317: ,pa_ci_types_b cit
318: ,pa_project_statuses ps
319: where ci.ci_id = p_ci_id
320: and ci.ci_type_id = cit.ci_type_id
321: and ci.status_code = ps.project_status_code;
322:

Line 326: from pa_project_statuses

322:
323: CI_REC C_CI%ROWTYPE;
324: Cursor C_NEXT_SYS_STAT is
325: Select project_system_status_code
326: from pa_project_statuses
327: where project_status_code = p_next_status;
328:
329: l_return_value boolean := false;
330: l_curr_sys_status PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;

Line 330: l_curr_sys_status PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;

326: from pa_project_statuses
327: where project_status_code = p_next_status;
328:
329: l_return_value boolean := false;
330: l_curr_sys_status PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
331: l_next_sys_status PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
332:
333: Begin
334: open C_CI;

Line 331: l_next_sys_status PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;

327: where project_status_code = p_next_status;
328:
329: l_return_value boolean := false;
330: l_curr_sys_status PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
331: l_next_sys_status PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
332:
333: Begin
334: open C_CI;
335: fetch C_CI into CI_REC;

Line 702: FROM pa_project_statuses

698:
699: CURSOR get_wf_info
700: IS
701: SELECT workflow_item_type, workflow_process, enable_wf_flag
702: FROM pa_project_statuses
703: WHERE status_type = 'CONTROL_ITEM'
704: AND project_status_code = p_status_code;
705:
706: l_wf_item_type VARCHAR2(30);

Line 774: from pa_wf_processes pwp, pa_project_statuses pps

770:
771:
772: CURSOR get_item_key IS
773: SELECT MAX(pwp.item_key), max(pwp.item_type)
774: from pa_wf_processes pwp, pa_project_statuses pps
775: where pwp.item_type = pps.WORKFLOW_ITEM_TYPE
776: and pps.status_type = 'CONTROL_ITEM'
777: and pps.project_status_code = 'CI_SUBMITTED'
778: AND entity_key2 = p_ci_id

Line 787: from wf_item_activity_statuses wias, pa_project_statuses pps

783: CURSOR get_wf_status IS
784: select 'Y' FROM dual
785: WHERE exists
786: (SELECT *
787: from wf_item_activity_statuses wias, pa_project_statuses pps
788: WHERE wias.item_type = pps.WORKFLOW_ITEM_TYPE
789: AND wias.item_key = l_item_key
790: AND wias.activity_status = 'ACTIVE'
791: AND pps.status_type = 'CONTROL_ITEM'

Line 900: select 'Y', wf_success_status_code from pa_project_statuses

896: AND impact_type_code = 'FINPLAN'
897: );
898:
899: CURSOR c_submit_status(p_project_status_code varchar2) is
900: select 'Y', wf_success_status_code from pa_project_statuses
901: where project_status_code = p_project_status_code
902: and enable_wf_flag = 'Y'
903: and workflow_item_type is not null
904: and workflow_process is not null

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

1374: -----------------------------------------------------------------------------*/
1375: FUNCTION getCISystemStatus ( p_CI_id IN NUMBER)
1376: return VARCHAR2
1377: is
1378: l_ci_system_status pa_project_statuses.project_system_status_code%TYPE := NULL ;
1379:
1380: BEGIN
1381: IF p_CI_id is not NULL then
1382: select ps.project_system_status_code

Line 1385: ,pa_project_statuses ps

1381: IF p_CI_id is not NULL then
1382: select ps.project_system_status_code
1383: into l_ci_system_status
1384: from pa_control_items ci
1385: ,pa_project_statuses ps
1386: where ci_id = p_ci_id
1387: and ps.project_status_code = nvl(ci.status_code,' ');
1388: END IF ;
1389:

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

1401: -----------------------------------------------------------------------------*/
1402: FUNCTION getSystemStatus ( p_status_code IN VARCHAR2)
1403: return VARCHAR2
1404: is
1405: l_ci_system_status pa_project_statuses.project_system_status_code%TYPE := NULL ;
1406:
1407: BEGIN
1408: IF p_status_code is not NULL then
1409: select ps.project_system_status_code

Line 1412: pa_project_statuses ps

1408: IF p_status_code is not NULL then
1409: select ps.project_system_status_code
1410: into l_ci_system_status
1411: from
1412: pa_project_statuses ps
1413: where ps.project_status_code = nvl(p_status_code,' ');
1414: END IF ;
1415:
1416: return l_ci_system_status;

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

1427: ,p_created_by_id IN NUMBER := NULL
1428: ,p_system_status IN VARCHAR2 := NULL)
1429: return VARCHAR2
1430: is
1431: l_system_status pa_project_statuses.project_system_status_code%TYPE := NULL ;
1432: BEGIN
1433: IF (p_system_status is not NULL AND p_system_status = 'CI_DRAFT') then
1434: return 'Y';
1435: END IF ;

Line 1535: ,pa_project_statuses

1531: cursor c_non_draft_ci is
1532: select
1533: ci_id
1534: from pa_control_items
1535: ,pa_project_statuses
1536: where pa_control_items.project_id = p_project_id
1537: and pa_control_items.status_code = pa_project_statuses.project_status_code
1538: and pa_project_statuses.project_system_status_code <> 'CI_DRAFT';
1539:

Line 1537: and pa_control_items.status_code = pa_project_statuses.project_status_code

1533: ci_id
1534: from pa_control_items
1535: ,pa_project_statuses
1536: where pa_control_items.project_id = p_project_id
1537: and pa_control_items.status_code = pa_project_statuses.project_status_code
1538: and pa_project_statuses.project_system_status_code <> 'CI_DRAFT';
1539:
1540: publishedCI c_non_draft_ci%rowtype;
1541: hasNonDraftCI VARCHAR2(1) := 'Y';

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

1534: from pa_control_items
1535: ,pa_project_statuses
1536: where pa_control_items.project_id = p_project_id
1537: and pa_control_items.status_code = pa_project_statuses.project_status_code
1538: and pa_project_statuses.project_system_status_code <> 'CI_DRAFT';
1539:
1540: publishedCI c_non_draft_ci%rowtype;
1541: hasNonDraftCI VARCHAR2(1) := 'Y';
1542:

Line 1820: from pa_project_statuses

1816: and pci.object_id = p_object_id
1817: and pci.ci_type_id = pctb.ci_type_id
1818: and pctb.ci_type_class_Code = p_item_type --'ISSUE'
1819: and pci.status_code not in (select project_status_code /* changes start for Bug 5050836 */
1820: from pa_project_statuses
1821: where status_type = 'CONTROL_ITEM'
1822: and project_system_status_code
1823: in ('CI_DRAFT','CI_CLOSED','CI_CANCELED')); /* changes end for Bug 5050836 */
1824:

Line 1835: from pa_project_statuses

1831: and pci.object_id = p_object_id
1832: and pci.ci_type_id = pctb.ci_type_id
1833: and pctb.ci_type_class_Code in ('CHANGE_ORDER','CHANGE_REQUEST')
1834: and pci.status_code not in (select project_status_code /* changes start for Bug 5050836 */
1835: from pa_project_statuses
1836: where status_type = 'CONTROL_ITEM'
1837: and project_system_status_code
1838: in ('CI_DRAFT','CI_CLOSED','CI_CANCELED')); /* changes end for Bug 5050836 */
1839:

Line 1850: -- from pa_project_statuses

1846: -- and pci.object_id = p_object_id
1847: -- and pci.ci_type_id = pctb.ci_type_id
1848: -- and pctb.ci_type_class_Code = 'CHANGE_ORDER'
1849: -- and pci.status_code not in (select project_status_code /* changes start for Bug 5050836 */
1850: -- from pa_project_statuses
1851: -- where status_type = 'CONTROL_ITEM'
1852: -- and project_system_status_code
1853: -- in ('CI_DRAFT','CI_CLOSED','CI_CANCELED')); /* changes end for Bug 5050836 */
1854:

Line 1865: -- from pa_project_statuses

1861: -- and pci.object_id = p_object_id
1862: -- and pci.ci_type_id = pctb.ci_type_id
1863: -- and pctb.ci_type_class_Code = 'CHANGE_REQUEST'
1864: -- and pci.status_code not in (select project_status_code /* changes start for Bug 5050836 */
1865: -- from pa_project_statuses
1866: -- where status_type = 'CONTROL_ITEM'
1867: -- and project_system_status_code
1868: -- in ('CI_DRAFT','CI_CLOSED','CI_CANCELED')); /* changes end for Bug 5050836 */
1869: /*code changes for bug 5611926 ends here*/

Line 1890: FROM pa_project_statuses ps,

1886:
1887: cursor c_wf_type is
1888: SELECT ps.workflow_item_type,
1889: ps.workflow_process
1890: FROM pa_project_statuses ps,
1891: pa_control_items ci
1892: WHERE ci.ci_id = p_ci_id
1893: and ci.status_code = ps.project_status_code
1894: and ps.enable_wf_flag = 'Y'

Line 1908: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;

1904: AND entity_key1 = p_project_id
1905: AND wf_type_code = 'Control Item';
1906:
1907: l_diagramUrl VARCHAR2(2000);
1908: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;
1909: l_wf_process pa_project_statuses.workflow_process%TYPE;
1910: l_item_key pa_wf_processes.item_key%TYPE;
1911:
1912: BEGIN

Line 1909: l_wf_process pa_project_statuses.workflow_process%TYPE;

1905: AND wf_type_code = 'Control Item';
1906:
1907: l_diagramUrl VARCHAR2(2000);
1908: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;
1909: l_wf_process pa_project_statuses.workflow_process%TYPE;
1910: l_item_key pa_wf_processes.item_key%TYPE;
1911:
1912: BEGIN
1913:

Line 1951: FROM pa_project_statuses ps,

1947: IS
1948: cursor c_wf_type is
1949: SELECT ps.workflow_item_type,
1950: ps.workflow_process
1951: FROM pa_project_statuses ps,
1952: pa_control_items ci
1953: WHERE ci.ci_id = p_ci_id
1954: and ci.status_code = ps.project_status_code
1955: and ps.enable_wf_flag = 'Y'

Line 1980: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;

1976: order by obj_status_change_id desc) a
1977: where rownum = 1;
1978:
1979: l_diagramUrl VARCHAR2(2000);
1980: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;
1981: l_wf_process pa_project_statuses.workflow_process%TYPE;
1982: l_item_key pa_wf_processes.item_key%TYPE;
1983: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;
1984: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;

Line 1981: l_wf_process pa_project_statuses.workflow_process%TYPE;

1977: where rownum = 1;
1978:
1979: l_diagramUrl VARCHAR2(2000);
1980: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;
1981: l_wf_process pa_project_statuses.workflow_process%TYPE;
1982: l_item_key pa_wf_processes.item_key%TYPE;
1983: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;
1984: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;
1985: l_comment pa_ci_comments.comment_text%TYPE;

Line 2081: from pa_project_statuses

2077: IS
2078:
2079: cursor c_status_name(p_status VARCHAR2) is
2080: select project_status_name
2081: from pa_project_statuses
2082: where status_type = 'CONTROL_ITEM'
2083: and project_status_code = p_status;
2084:
2085: l_error_msg_code varchar2(30);

Line 2089: l_new_sysstatus pa_project_statuses.project_system_status_code%TYPE;

2085: l_error_msg_code varchar2(30);
2086: l_ci_comment_id NUMBER;
2087: l_ci_action_id NUMBER;
2088: l_rowid VARCHAR2(255);
2089: l_new_sysstatus pa_project_statuses.project_system_status_code%TYPE;
2090: l_old_sysstatus pa_project_statuses.project_system_status_code%TYPE;
2091: l_comment_text pa_ci_comments.comment_text%TYPE;
2092: l_obj_status_change_id NUMBER;
2093: l_new_status_name pa_project_statuses.project_status_name%TYPE;

Line 2090: l_old_sysstatus pa_project_statuses.project_system_status_code%TYPE;

2086: l_ci_comment_id NUMBER;
2087: l_ci_action_id NUMBER;
2088: l_rowid VARCHAR2(255);
2089: l_new_sysstatus pa_project_statuses.project_system_status_code%TYPE;
2090: l_old_sysstatus pa_project_statuses.project_system_status_code%TYPE;
2091: l_comment_text pa_ci_comments.comment_text%TYPE;
2092: l_obj_status_change_id NUMBER;
2093: l_new_status_name pa_project_statuses.project_status_name%TYPE;
2094: l_old_status_name pa_project_statuses.project_status_name%TYPE;

Line 2093: l_new_status_name pa_project_statuses.project_status_name%TYPE;

2089: l_new_sysstatus pa_project_statuses.project_system_status_code%TYPE;
2090: l_old_sysstatus pa_project_statuses.project_system_status_code%TYPE;
2091: l_comment_text pa_ci_comments.comment_text%TYPE;
2092: l_obj_status_change_id NUMBER;
2093: l_new_status_name pa_project_statuses.project_status_name%TYPE;
2094: l_old_status_name pa_project_statuses.project_status_name%TYPE;
2095:
2096: BEGIN
2097: x_return_status := fnd_api.g_ret_sts_success;

Line 2094: l_old_status_name pa_project_statuses.project_status_name%TYPE;

2090: l_old_sysstatus pa_project_statuses.project_system_status_code%TYPE;
2091: l_comment_text pa_ci_comments.comment_text%TYPE;
2092: l_obj_status_change_id NUMBER;
2093: l_new_status_name pa_project_statuses.project_status_name%TYPE;
2094: l_old_status_name pa_project_statuses.project_status_name%TYPE;
2095:
2096: BEGIN
2097: x_return_status := fnd_api.g_ret_sts_success;
2098: x_msg_data := 0;

Line 2240: select 'Y', wf_success_status_code from pa_project_statuses

2236: AND impact_type_code like 'FINPLAN%'
2237: );
2238:
2239: CURSOR c_submit_status(p_project_status_code varchar2) is
2240: select 'Y', wf_success_status_code from pa_project_statuses
2241: where project_status_code = p_project_status_code
2242: and enable_wf_flag = 'Y'
2243: and workflow_item_type is not null
2244: and workflow_process is not null