APPS.WF_PLUG dependencies on WF_WORKLIST_COL_DEFINITIONS

Line 186: INSERT INTO WF_WORKLIST_COL_DEFINITIONS

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 ,
188: USERNAME ,
189: DEFINITION_NAME ,
190: COLUMN_NUMBER ,

Line 203: FROM WF_WORKLIST_COL_DEFINITIONS

199: 100
200: FROM SYS.DUAL
201: WHERE NOT EXISTS
202: (SELECT 1
203: FROM WF_WORKLIST_COL_DEFINITIONS
204: WHERE PLUG_ID = p_plug_id);
205:
206: COMMIT;
207:

Line 578: FROM WF_WORKLIST_COL_DEFINITIONS

574: USERNAME,
575: COLUMN_NUMBER,
576: COLUMN_NAME,
577: COLUMN_SIZE
578: FROM WF_WORKLIST_COL_DEFINITIONS
579: WHERE (PLUG_ID = c_plug_id and c_plug_id IS NOT NULL)
580: OR (USERNAME = c_username and c_username IS NOT NULL and c_plug_id IS NULL)
581: ORDER BY COLUMN_NUMBER;
582:

Line 1058: FROM WF_WORKLIST_COL_DEFINITIONS

1054: USERNAME,
1055: COLUMN_NUMBER,
1056: COLUMN_NAME,
1057: COLUMN_SIZE
1058: FROM WF_WORKLIST_COL_DEFINITIONS
1059: WHERE (PLUG_ID = c_plug_id and c_plug_id IS NOT NULL)
1060: OR (USERNAME = c_username and c_username IS NOT NULL and c_plug_id IS NULL)
1061: ORDER BY COLUMN_NUMBER;
1062:

Line 1510: DELETE FROM WF_WORKLIST_COL_DEFINITIONS

1506: ORDER_PRIMARY = l_orderkey
1507: WHERE PLUG_ID = TO_NUMBER(l_plug_id);
1508:
1509: -- Delete all the old column definitions
1510: DELETE FROM WF_WORKLIST_COL_DEFINITIONS
1511: WHERE PLUG_ID = TO_NUMBER(l_plug_id);
1512:
1513: END IF;
1514:

Line 1525: INSERT INTO WF_WORKLIST_COL_DEFINITIONS

1521: -- Since all the columns are already deleted you can just skip it
1522: -- here.
1523: IF (l_column_name <> 'NULL') THEN
1524:
1525: INSERT INTO WF_WORKLIST_COL_DEFINITIONS
1526: ( PLUG_ID ,
1527: USERNAME ,
1528: DEFINITION_NAME ,
1529: COLUMN_NUMBER ,

Line 1575: DELETE FROM WF_WORKLIST_COL_DEFINITIONS

1571:
1572: IF (p_delete = 'Y') THEN
1573:
1574: -- Delete all the old column 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