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 121: FROM pa_wf_processes

117:
118: CURSOR get_last_workflow_info
119: IS
120: SELECT MAX(item_key)
121: FROM pa_wf_processes
122: WHERE item_type = p_item_type
123: AND description = p_process_name
124: AND entity_key2 = p_ci_id
125: AND entity_key1 = l_project_id

Line 1138: l_wf_type_code pa_wf_processes.wf_type_code%TYPE;

1134:
1135: l_item_key NUMBER;
1136: l_last_item_key VARCHAR2(200);
1137: l_project_id pa_projects_all.project_id%TYPE;
1138: l_wf_type_code pa_wf_processes.wf_type_code%TYPE;
1139: l_entity_key1 pa_wf_processes.entity_key1%TYPE;
1140: l_entity_key2 pa_wf_processes.entity_key2%TYPE;
1141:
1142: l_msg_count NUMBER := 0;

Line 1139: l_entity_key1 pa_wf_processes.entity_key1%TYPE;

1135: l_item_key NUMBER;
1136: l_last_item_key VARCHAR2(200);
1137: l_project_id pa_projects_all.project_id%TYPE;
1138: l_wf_type_code pa_wf_processes.wf_type_code%TYPE;
1139: l_entity_key1 pa_wf_processes.entity_key1%TYPE;
1140: l_entity_key2 pa_wf_processes.entity_key2%TYPE;
1141:
1142: l_msg_count NUMBER := 0;
1143: l_data VARCHAR2(2000);

Line 1140: l_entity_key2 pa_wf_processes.entity_key2%TYPE;

1136: l_last_item_key VARCHAR2(200);
1137: l_project_id pa_projects_all.project_id%TYPE;
1138: l_wf_type_code pa_wf_processes.wf_type_code%TYPE;
1139: l_entity_key1 pa_wf_processes.entity_key1%TYPE;
1140: l_entity_key2 pa_wf_processes.entity_key2%TYPE;
1141:
1142: l_msg_count NUMBER := 0;
1143: l_data VARCHAR2(2000);
1144: l_msg_data VARCHAR2(2000);

Line 2266: l_item_key pa_wf_processes.item_key%TYPE;

2262: l_action_status_code varchar2(100) := 'CI_ACTION_OPEN'; --ACTION_STATUS_CODE
2263:
2264:
2265: --bug 3297238
2266: l_item_key pa_wf_processes.item_key%TYPE;
2267:
2268: Cursor getRecordVersionNumber IS
2269: select record_version_number
2270: from pa_control_items

Line 2542: l_item_key pa_wf_processes.item_key%TYPE;

2538:
2539:
2540:
2541: --bug 3297238
2542: l_item_key pa_wf_processes.item_key%TYPE;
2543:
2544: Cursor getRecordVersionNumber IS
2545: select record_version_number
2546: from pa_control_items

Line 2680: from pa_wf_processes pwp,

2676: IS
2677: select wfi.notification_id,
2678: wfi.item_type,
2679: wfi.item_key
2680: from pa_wf_processes pwp,
2681: wf_item_activity_statuses_v wfi
2682: where pwp.entity_key2=p_action_id
2683: and pwp.item_type='PAWFCIAC'
2684: and wfi.item_type = pwp.item_type