APPS.WF_PLUG dependencies on WF_LOOKUPS

Line 261: from WF_LOOKUPS WL

257: lbeg_sent NUMBER;
258:
259: cursor lkcurs(lktype in varchar2) is
260: select WL.MEANING, WL.LOOKUP_CODE
261: from WF_LOOKUPS WL
262: where WL.LOOKUP_TYPE = lktype
263: order by WL.MEANING;
264:
265: -- Lookup for Item Type

Line 521: from WF_NOTIFICATIONS WN, WF_ITEM_TYPES_VL WIT, WF_LOOKUPS WL

517: WN.END_DATE,
518: WL.MEANING display_status,
519: WN.STATUS,
520: WN.LANGUAGE
521: from WF_NOTIFICATIONS WN, WF_ITEM_TYPES_VL WIT, WF_LOOKUPS WL
522: where WN.MESSAGE_TYPE = decode(Worklist.littype, '*', WN.MESSAGE_TYPE,
523: Worklist.littype)
524: and WN.MESSAGE_TYPE = WIT.NAME
525: and WL.LOOKUP_TYPE = 'WF_NOTIFICATION_STATUS'

Line 654: ** filling in the p_wf_lookups_tbl

650: OPEN c_fetch_col_def (TO_NUMBER(plug_id), username);
651:
652: /*
653: ** Loop through all the lookup_code rows for the given lookup_type
654: ** filling in the p_wf_lookups_tbl
655: */
656: l_record_num := 0;
657:
658: LOOP

Line 679: ** filling in the p_wf_lookups_tbl

675: OPEN c_fetch_col_def (-1, '-1');
676:
677: /*
678: ** Loop through all the lookup_code rows for the given lookup_type
679: ** filling in the p_wf_lookups_tbl
680: */
681: LOOP
682:
683: l_record_num := l_record_num + 1;

Line 1037: FROM WF_LOOKUPS WL

1033:
1034:
1035: CURSOR lkcurs(lktype in varchar2) IS
1036: SELECT WL.MEANING, WL.LOOKUP_CODE
1037: FROM WF_LOOKUPS WL
1038: WHERE WL.LOOKUP_TYPE = lktype
1039: AND WL.LOOKUP_CODE IN ('SUBJECT', 'DUE_DATE', 'BEGIN_DATE', 'MESSAGE_TYPE')
1040: ORDER BY WL.MEANING;
1041:

Line 1044: FROM WF_LOOKUPS WL

1040: ORDER BY WL.MEANING;
1041:
1042: CURSOR lkcurs_order(lktype in varchar2) IS
1043: SELECT WL.MEANING, WL.LOOKUP_CODE
1044: FROM WF_LOOKUPS WL
1045: WHERE WL.LOOKUP_TYPE = lktype
1046: AND WL.LOOKUP_CODE IN ('SUBJECT', 'DUE_DATE', 'BEGIN_DATE', 'MESSAGE_TYPE', 'PRIORITY')
1047: ORDER BY WL.MEANING;
1048:

Line 1121: ** filling in the p_wf_lookups_tbl

1117: l_worklist_definition.username);
1118:
1119: /*
1120: ** Loop through all the lookup_code rows for the given lookup_type
1121: ** filling in the p_wf_lookups_tbl
1122: */
1123: LOOP
1124:
1125: l_record_num := l_record_num + 1;