DBA Data[Home] [Help]

APPS.AZW_PROC dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 1944: FROM wf_items wfi, wf_item_attribute_values wiav

1940: -- get count of tasks for this process
1941: BEGIN
1942: SELECT count(*)
1943: INTO v_count
1944: FROM wf_items wfi, wf_item_attribute_values wiav
1945: WHERE wfi.item_type = p_type
1946: AND wfi.root_activity = p_name
1947: AND wiav.item_type = p_type
1948: AND wiav.item_key = wfi.item_key

Line 1957: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_count from wf_items,wf_item_attribute_values');

1953: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1954: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1955: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1956: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1957: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_count from wf_items,wf_item_attribute_values');
1958: APP_EXCEPTION.RAISE_EXCEPTION;
1959: END;
1960:
1961: IF (value <> 'N') THEN

Line 2576: FROM az_processes ap,wf_items wfi, wf_item_attribute_values wiav

2572: PROCEDURE populate_process_status IS
2573:
2574: CURSOR az_process_active_cursor IS
2575: SELECT ap.item_type, ap.process_name, ap.context_id
2576: FROM az_processes ap,wf_items wfi, wf_item_attribute_values wiav
2577: WHERE wfi.item_type = ap.item_type
2578: AND wfi.root_activity = ap.process_name
2579: AND wiav.item_type = wfi.item_type
2580: AND wiav.item_key = wfi.item_key