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_WORKFLOW dependencies on PA_WF_PROCESSES

Line 97: FROM pa_wf_processes

93:
94: CURSOR get_last_workflow_info
95: IS
96: SELECT MAX(item_key)
97: FROM pa_wf_processes
98: WHERE item_type = p_item_type
99: AND description = p_process_name
100: AND entity_key2 = p_ci_id
101: AND entity_key1 = l_project_id

Line 1038: l_wf_type_code pa_wf_processes.wf_type_code%TYPE;

1034:
1035: l_item_key NUMBER;
1036: l_last_item_key VARCHAR2(200);
1037: l_project_id pa_projects_all.project_id%TYPE;
1038: l_wf_type_code pa_wf_processes.wf_type_code%TYPE;
1039: l_entity_key1 pa_wf_processes.entity_key1%TYPE;
1040: l_entity_key2 pa_wf_processes.entity_key2%TYPE;
1041:
1042: l_msg_count NUMBER := 0;

Line 1039: l_entity_key1 pa_wf_processes.entity_key1%TYPE;

1035: l_item_key NUMBER;
1036: l_last_item_key VARCHAR2(200);
1037: l_project_id pa_projects_all.project_id%TYPE;
1038: l_wf_type_code pa_wf_processes.wf_type_code%TYPE;
1039: l_entity_key1 pa_wf_processes.entity_key1%TYPE;
1040: l_entity_key2 pa_wf_processes.entity_key2%TYPE;
1041:
1042: l_msg_count NUMBER := 0;
1043: l_data VARCHAR2(2000);

Line 1040: l_entity_key2 pa_wf_processes.entity_key2%TYPE;

1036: l_last_item_key VARCHAR2(200);
1037: l_project_id pa_projects_all.project_id%TYPE;
1038: l_wf_type_code pa_wf_processes.wf_type_code%TYPE;
1039: l_entity_key1 pa_wf_processes.entity_key1%TYPE;
1040: l_entity_key2 pa_wf_processes.entity_key2%TYPE;
1041:
1042: l_msg_count NUMBER := 0;
1043: l_data VARCHAR2(2000);
1044: l_msg_data VARCHAR2(2000);

Line 2063: l_item_key pa_wf_processes.item_key%TYPE;

2059:
2060:
2061:
2062: --bug 3297238
2063: l_item_key pa_wf_processes.item_key%TYPE;
2064:
2065: Cursor getRecordVersionNumber IS
2066: select record_version_number
2067: from pa_control_items

Line 2299: l_item_key pa_wf_processes.item_key%TYPE;

2295:
2296:
2297:
2298: --bug 3297238
2299: l_item_key pa_wf_processes.item_key%TYPE;
2300:
2301: Cursor getRecordVersionNumber IS
2302: select record_version_number
2303: from pa_control_items

Line 2437: from pa_wf_processes pwp,

2433: IS
2434: select wfi.notification_id,
2435: wfi.item_type,
2436: wfi.item_key
2437: from pa_wf_processes pwp,
2438: wf_item_activity_statuses_v wfi
2439: where pwp.entity_key2=p_action_id
2440: and pwp.item_type='PAWFCIAC'
2441: and wfi.item_type = pwp.item_type