1818: l_get_lock_failed BOOLEAN := false;
1819:
1820: CURSOR l_retry_cursor_1 IS
1821: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1822: FROM WF_PROCESS_ACTIVITIES PA,
1823: WF_ITEMS I,
1824: WF_ITEM_ACTIVITY_STATUSES IAS,
1825: WF_ITEM_ATTRIBUTE_VALUES WAT,
1826: WF_ACTIVITIES WA
1844: ORDER BY WAT.NUMBER_VALUE;
1845:
1846: CURSOR l_retry_cursor_2 IS
1847: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1848: FROM WF_PROCESS_ACTIVITIES PA,
1849: WF_ITEMS I,
1850: WF_ITEM_ACTIVITY_STATUSES IAS,
1851: WF_ITEM_ATTRIBUTE_VALUES WAT,
1852: WF_ACTIVITIES WA
1869: ORDER BY WAT.NUMBER_VALUE;
1870:
1871: CURSOR l_retry_cursor_3 IS
1872: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1873: FROM WF_PROCESS_ACTIVITIES PA,
1874: WF_ITEMS I,
1875: WF_ITEM_ACTIVITY_STATUSES IAS,
1876: WF_ITEM_ATTRIBUTE_VALUES WAT,
1877: WF_ACTIVITIES WA
1896: ORDER BY WAT.NUMBER_VALUE;
1897:
1898: CURSOR l_retry_cursor_4 IS
1899: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1900: FROM WF_PROCESS_ACTIVITIES PA,
1901: WF_ITEMS I,
1902: WF_ITEM_ACTIVITY_STATUSES IAS,
1903: WF_ITEM_ATTRIBUTE_VALUES WAT,
1904: WF_ACTIVITIES WA
1922: ORDER BY WAT.NUMBER_VALUE;
1923:
1924: CURSOR l_retry_cursor_5 IS
1925: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1926: FROM WF_PROCESS_ACTIVITIES PA,
1927: WF_ITEMS I,
1928: WF_ITEM_ACTIVITY_STATUSES IAS,
1929: WF_ITEM_ATTRIBUTE_VALUES WAT,
1930: WF_ACTIVITIES WA
1949: ORDER BY WAT.NUMBER_VALUE;
1950:
1951: CURSOR l_retry_cursor_6 IS
1952: SELECT IAS.ITEM_KEY, PA.INSTANCE_LABEL, PA.ACTIVITY_NAME, PA.PROCESS_NAME, IAS.PROCESS_ACTIVITY, I.USER_KEY, I.PARENT_ITEM_TYPE, I.PARENT_ITEM_KEY, PA.ACTIVITY_ITEM_TYPE, WAT.NUMBER_VALUE
1953: FROM WF_PROCESS_ACTIVITIES PA,
1954: WF_ITEMS I,
1955: WF_ITEM_ACTIVITY_STATUSES IAS,
1956: WF_ITEM_ATTRIBUTE_VALUES WAT,
1957: WF_ACTIVITIES WA
2494: IF p_activity_name is not null then
2495: SELECT DISPLAY_NAME into l_act_display_name FROM wf_activities_vl
2496: WHERE ROW_ID IN (SELECT MAX(ROWID) FROM WF_ACTIVITIES WA
2497: WHERE WA.TYPE NOT IN ('PROCESS','FOLDER')
2498: AND EXISTS (SELECT ACTIVITY_NAME FROM WF_PROCESS_ACTIVITIES WPA
2499: WHERE WA.NAME = WPA.ACTIVITY_NAME
2500: AND WPA.PROCESS_ITEM_TYPE = P_ITEM_TYPE
2501: AND WA.ITEM_TYPE=WPA.ACTIVITY_ITEM_TYPE)
2502: AND WA.VERSION = (SELECT MAX(WA2.VERSION) FROM WF_ACTIVITIES WA2