APPS.OE_ERROR_WF dependencies on WF_ACTIVITIES

Line 1185: FROM WF_Activities_VL

1181: oe_debug_pub.add('Entering Get_Activity_Display_Name');
1182: END IF;
1183: SELECT display_name
1184: INTO l_activity_display_name
1185: FROM WF_Activities_VL
1186: WHERE Name = p_activity_name
1187: AND Item_Type = p_activity_item_type
1188: AND Version = (SELECT max(version)
1189: FROM WF_Activities_VL

Line 1189: FROM WF_Activities_VL

1185: FROM WF_Activities_VL
1186: WHERE Name = p_activity_name
1187: AND Item_Type = p_activity_item_type
1188: AND Version = (SELECT max(version)
1189: FROM WF_Activities_VL
1190: WHERE Name = p_activity_name
1191: AND Item_Type = p_activity_item_type);
1192: IF l_debug_level > 0 THEN
1193: oe_debug_pub.add('Exiting Get_Activity_Display_Name with result: ' ||l_activity_display_name);

Line 1826: WF_ACTIVITIES WA

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
1827: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
1828: AND IAS.ITEM_KEY = I.ITEM_KEY
1829: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
1830: AND IAS.ITEM_TYPE = OE_GLOBALS.G_WFI_LIN

Line 1852: WF_ACTIVITIES WA

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
1853: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
1854: AND IAS.ITEM_KEY = I.ITEM_KEY
1855: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
1856: AND IAS.ITEM_TYPE = OE_GLOBALS.G_WFI_HDR

Line 1877: WF_ACTIVITIES WA

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
1878: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
1879: AND IAS.ITEM_KEY = I.ITEM_KEY
1880: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
1881: AND IAS.ITEM_TYPE = p_item_type

Line 1904: WF_ACTIVITIES WA

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
1905: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
1906: AND IAS.ITEM_KEY = I.ITEM_KEY
1907: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
1908: AND IAS.ITEM_TYPE = p_item_type

Line 1930: WF_ACTIVITIES WA

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
1931: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
1932: AND IAS.ITEM_KEY = I.ITEM_KEY
1933: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
1934: AND IAS.ITEM_TYPE = p_item_type

Line 1957: WF_ACTIVITIES WA

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
1958: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
1959: AND IAS.ITEM_KEY = I.ITEM_KEY
1960: AND IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
1961: AND IAS.ITEM_TYPE = p_item_type

Line 2495: SELECT DISPLAY_NAME into l_act_display_name FROM wf_activities_vl

2491: AND ENABLED_FLAG='Y'
2492: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE) AND NVL(END_DATE_ACTIVE,SYSDATE);
2493:
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

Line 2496: WHERE ROW_ID IN (SELECT MAX(ROWID) FROM WF_ACTIVITIES WA

2492: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE,SYSDATE) AND NVL(END_DATE_ACTIVE,SYSDATE);
2493:
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

Line 2502: AND WA.VERSION = (SELECT MAX(WA2.VERSION) FROM WF_ACTIVITIES WA2

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
2503: WHERE WA2.ITEM_TYPE = WA.ITEM_TYPE
2504: AND WA2.NAME=WA.NAME)
2505: GROUP BY WA.NAME)
2506: AND NAME = p_activity_name;