APPS.WF_PLUG dependencies on WF_WORKLIST_DEFINITIONS

Line 132: FROM WF_WORKLIST_DEFINITIONS

128: WHERE_NOTIF_DEL_BY_ME,
129: ORDER_PRIMARY,
130: ORDER_ASC_DESC
131: INTO p_worklist_definition
132: FROM WF_WORKLIST_DEFINITIONS
133: WHERE PLUG_ID = p_plug_id;
134:
135: EXCEPTION
136: WHEN NO_DATA_FOUND THEN

Line 146: INSERT INTO WF_WORKLIST_DEFINITIONS

142: -- If this definition does not exist then copy the definition
143: -- from the default
144: IF (l_definition_exists = 'N' AND p_plug_id IS NOT NULL) THEN
145:
146: INSERT INTO WF_WORKLIST_DEFINITIONS
147: ( PLUG_ID,
148: USERNAME,
149: DEFINITION_NAME,
150: WHERE_STATUS,

Line 183: FROM WF_WORKLIST_DEFINITIONS

179: null
180: FROM SYS.DUAL
181: WHERE NOT EXISTS
182: (SELECT 1
183: FROM WF_WORKLIST_DEFINITIONS
184: WHERE PLUG_ID = p_plug_id);
185:
186: INSERT INTO WF_WORKLIST_COL_DEFINITIONS
187: ( PLUG_ID ,

Line 1102: FROM WF_WORKLIST_DEFINITIONS

1098: WHERE_NOTIF_DEL_BY_ME,
1099: ORDER_PRIMARY,
1100: ORDER_ASC_DESC
1101: INTO l_worklist_definition
1102: FROM WF_WORKLIST_DEFINITIONS
1103: WHERE (PLUG_ID = p_plug_id AND p_plug_id IS NOT NULL)
1104: OR (USERNAME = p_username AND p_username IS NOT NULL and p_plug_id IS NULL);
1105:
1106: EXCEPTION

Line 1458: INSERT INTO WF_WORKLIST_DEFINITIONS

1454:
1455:
1456: IF (definition_exists = 'N') THEN
1457:
1458: INSERT INTO WF_WORKLIST_DEFINITIONS
1459: ( PLUG_ID ,
1460: USERNAME ,
1461: DEFINITION_NAME ,
1462: WHERE_STATUS ,

Line 1494: UPDATE WF_WORKLIST_DEFINITIONS

1490: );
1491:
1492: ELSE
1493:
1494: UPDATE WF_WORKLIST_DEFINITIONS
1495: SET DEFINITION_NAME = l_definition_name,
1496: WHERE_STATUS = l_status,
1497: WHERE_FROM = l_fromuser,
1498: WHERE_ITEM_TYPE = l_ittype,

Line 1579: DELETE FROM WF_WORKLIST_DEFINITIONS

1575: DELETE FROM WF_WORKLIST_COL_DEFINITIONS
1576: WHERE PLUG_ID = TO_NUMBER(p_plug_id) ;
1577:
1578: -- Delete all the old plug definition
1579: DELETE FROM WF_WORKLIST_DEFINITIONS
1580: WHERE PLUG_ID = TO_NUMBER(p_plug_id) ;
1581:
1582:
1583: ELSE