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

1591: from
1592: pa_obj_status_lists obj,
1593: pa_status_lists list,
1594: pa_status_list_items item,
1595: pa_project_statuses pstat
1596: where obj.object_id = p_ci_type_id
1597: and obj.status_list_id = list.status_list_id
1598: and list.status_type = 'CONTROL_ITEM'
1599: and sysdate between list.start_date_active and nvl(list.end_date_active,sysdate)

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 1634: from pa_project_statuses

1630:
1631: cursor validate_progress_sts_code(p_progress_status_code varchar2)
1632: is
1633: select project_status_code
1634: from pa_project_statuses
1635: where
1636: (trunc(sysdate) between nvl(start_date_active, trunc(sysdate)) and nvl(end_date_active, trunc(sysdate)))
1637: and status_type = 'PROGRESS'
1638: and project_status_code = p_progress_status_code;

Line 1734: l_status_code pa_project_statuses.project_status_code%type;

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

Line 1735: l_status_name pa_project_statuses.project_status_name%type;

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

Line 1736: l_system_status_code pa_project_statuses.project_system_status_code%type;

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

Line 1744: l_progress_status_code pa_project_statuses.project_status_code%type;

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

Line 1829: from pa_project_statuses

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
1829: from pa_project_statuses
1830: where project_status_code = l_status_code
1831: and status_type = 'CONTROL_ITEM';
1832:
1833: elsif(p_status_code is null and p_status is not null) then

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

1832:
1833: elsif(p_status_code is null and p_status is not null) then
1834:
1835: /* the below cursor query will give only one record as status_type and project_status_name forms a
1836: unique index on pa_project_statuses table We derive p_status_code from */
1837: open get_strtng_sts_frm_sts_nme(p_ci_type_id , p_status);
1838: fetch get_strtng_sts_frm_sts_nme into get_strtng_sts_frm_sts_nme_rec;
1839: if (get_strtng_sts_frm_sts_nme%notfound) then
1840: PA_UTILS.Add_message ( p_app_short_name => 'PA'

Line 2754: from pa_project_statuses

2750:
2751: cursor chk_action_status_code(p_action_status VARCHAR2)
2752: is
2753: select project_status_code
2754: from pa_project_statuses
2755: where status_type = 'CI_ACTION'
2756: and project_status_name = p_action_status;
2757:
2758: cursor act_sts_allw_for_ci_sts(p_ci_id NUMBER)

Line 2761: from pa_project_statuses pps,

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

Line 2780: l_action_status_code pa_project_statuses.project_status_code%type;

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