APPS.PA_CONTROL_ITEMS_UTILS dependencies on PA_WF_PROCESSES

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 936: l_item_key pa_wf_processes.item_key%TYPE; -- Bug#14267314 end.

932: l_ci_action_id pa_ci_actions.ci_action_id%type; -- Bug#14267314 start.
933: l_ci_action_number pa_ci_actions.ci_action_number%type;
934: l_sign_off pa_ci_actions.sign_off_required_flag%type;
935: l_process_name VARCHAR2(30);
936: l_item_key pa_wf_processes.item_key%TYPE; -- Bug#14267314 end.
937:
938: BEGIN
939:
940: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 1900: FROM pa_wf_processes

1896: and ps.wf_failure_status_code is NOT NULL;
1897:
1898: CURSOR get_last_workflow_info(p_wf_item_type IN VARCHAR2, p_wf_process IN VARCHAR2) IS
1899: SELECT MAX(item_key)
1900: FROM pa_wf_processes
1901: WHERE item_type = p_wf_item_type
1902: AND description = p_wf_process
1903: AND entity_key2 = p_ci_id
1904: AND entity_key1 = p_project_id

Line 1910: l_item_key pa_wf_processes.item_key%TYPE;

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:
1914: OPEN c_wf_type;

Line 1961: FROM pa_wf_processes

1957: and ps.wf_failure_status_code is NOT NULL;
1958:
1959: CURSOR get_last_workflow_info(p_wf_item_type IN VARCHAR2, p_wf_process IN VARCHAR2) IS
1960: SELECT MAX(item_key)
1961: FROM pa_wf_processes
1962: WHERE item_type = p_wf_item_type
1963: AND description = p_wf_process
1964: AND entity_key2 = p_ci_id
1965: AND entity_key1 = p_project_id

Line 1982: l_item_key pa_wf_processes.item_key%TYPE;

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