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_PROJECT_STATUSES

Line 35: from pa_project_statuses

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
36: where status_type = 'CONTROL_ITEM') s
37: WHERE ci.ci_id = c_Ci_Id
38: AND ci.ci_type_id = cib.ci_type_id
39: AND ci.status_code = s.project_status_code;

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 1612: pa_project_statuses pstat

1608: from
1609: pa_obj_status_lists obj,
1610: pa_status_lists list,
1611: pa_status_list_items item,
1612: pa_project_statuses pstat
1613: where obj.object_id = p_ci_type_id
1614: and obj.status_list_id = list.status_list_id
1615: and list.status_type = 'CONTROL_ITEM'
1616: and sysdate between list.start_date_active and nvl(list.end_date_active,sysdate)

Line 1629: pa_project_statuses pstat

1625: from
1626: pa_obj_status_lists obj,
1627: pa_status_lists list,
1628: pa_status_list_items item,
1629: pa_project_statuses pstat
1630: where obj.object_id = p_ci_type_id
1631: and obj.status_list_id = list.status_list_id
1632: and list.status_type = 'CONTROL_ITEM'
1633: and sysdate between list.start_date_active and nvl(list.end_date_active,sysdate)

Line 1651: from pa_project_statuses

1647:
1648: cursor validate_progress_sts_code(p_progress_status_code varchar2)
1649: is
1650: select project_status_code
1651: from pa_project_statuses
1652: where
1653: (trunc(sysdate) between nvl(start_date_active, trunc(sysdate)) and nvl(end_date_active, trunc(sysdate)))
1654: and status_type = 'PROGRESS'
1655: and project_status_code = p_progress_status_code;

Line 1751: l_status_code pa_project_statuses.project_status_code%type;

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:
1755: l_ci_number_char PA_CONTROL_ITEMS.ci_number%type := NULL;

Line 1752: l_status_name pa_project_statuses.project_status_name%type;

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:
1755: l_ci_number_char PA_CONTROL_ITEMS.ci_number%type := NULL;
1756: l_ci_number_num NUMBER(15) := NULL;

Line 1753: l_system_status_code pa_project_statuses.project_system_status_code%type;

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:
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;

Line 1761: l_progress_status_code pa_project_statuses.project_status_code%type;

1757: l_system_number_id NUMBER(15) := NULL;
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;

Line 1846: from pa_project_statuses

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
1846: from pa_project_statuses
1847: where project_status_code = l_status_code
1848: and status_type = 'CONTROL_ITEM';
1849:
1850: elsif(p_status_code is null and p_status is not null) then

Line 1853: unique index on pa_project_statuses table We derive p_status_code from */

1849:
1850: elsif(p_status_code is null and p_status is not null) then
1851:
1852: /* the below cursor query will give only one record as status_type and project_status_name forms a
1853: unique index on pa_project_statuses table We derive p_status_code from */
1854: open get_strtng_sts_frm_sts_nme(p_ci_type_id , p_status);
1855: fetch get_strtng_sts_frm_sts_nme into get_strtng_sts_frm_sts_nme_rec;
1856: if (get_strtng_sts_frm_sts_nme%notfound) then
1857: PA_UTILS.Add_message ( p_app_short_name => 'PA'

Line 2771: from pa_project_statuses

2767:
2768: cursor chk_action_status_code(p_action_status VARCHAR2)
2769: is
2770: select project_status_code
2771: from pa_project_statuses
2772: where status_type = 'CI_ACTION'
2773: and project_status_name = p_action_status;
2774:
2775: cursor act_sts_allw_for_ci_sts(p_ci_id NUMBER)

Line 2778: from pa_project_statuses pps,

2774:
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;

Line 2797: l_action_status_code pa_project_statuses.project_status_code%type;

2793: l_module_name VARCHAR2(200);
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;