1: package body WF_PLUG as
2: /* $Header: wfplugb.pls 120.2 2005/10/04 23:26:39 rtodi ship $ */
3:
4:
5: --
48: htp.hr;
49: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
50: htp.br;
51: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
52: replace(error_stack,wf_plug.chr_newline,'
'));
53:
54: wfa_sec.Footer;
55: htp.htmlClose;
56: end Error;
83: user_name := l_user_name;
84:
85: exception
86: when others then
87: wf_core.context('Wf_plug', 'GetPlugSession');
88: raise;
89: end GetPlugSession;
90:
91:
96:
97: ============================================================================*/
98: PROCEDURE get_plug_definition (
99: p_plug_id IN NUMBER,
100: p_worklist_definition OUT NOCOPY wf_plug.wf_worklist_definition_record
101: ) IS
102:
103: ii NUMBER := 0;
104: l_definition_exists VARCHAR2(1) := 'Y';
217:
218: exception
219: when others then
220: rollback;
221: wf_core.context('Wf_Plug', 'get_plug_definition');
222: wf_plug.Error;
223: end get_plug_definition;
224:
225:
218: exception
219: when others then
220: rollback;
221: wf_core.context('Wf_Plug', 'get_plug_definition');
222: wf_plug.Error;
223: end get_plug_definition;
224:
225:
226: /*===========================================================================
447:
448:
449: exception
450: when others then
451: Wf_Core.Context('wf_plug', 'find_criteria');
452: wf_plug.Error;
453:
454: END find_criteria;
455:
448:
449: exception
450: when others then
451: Wf_Core.Context('wf_plug', 'find_criteria');
452: wf_plug.Error;
453:
454: END find_criteria;
455:
456:
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:
583: l_worklist_definition wf_plug.wf_worklist_definition_record;
584: l_worklist_col_definition wf_plug.wf_worklist_col_def_table;
585:
586: notrec wl_cursor%ROWTYPE;
587: result attrs%rowtype;
580: OR (USERNAME = c_username and c_username IS NOT NULL and c_plug_id IS NULL)
581: ORDER BY COLUMN_NUMBER;
582:
583: l_worklist_definition wf_plug.wf_worklist_definition_record;
584: l_worklist_col_definition wf_plug.wf_worklist_col_def_table;
585:
586: notrec wl_cursor%ROWTYPE;
587: result attrs%rowtype;
588:
774: htp.p('
780:
781: ELSE
782:
783: icx_plug_utilities.plugbanner(display_name,
784: owa_util.get_owa_service_path||'wf_plug.edit_worklist_definition?'||
785: 'p_plug_id='||plug_id, 'FNDALERT.gif');
786:
787: END IF;
788: htp.p('
810: htp.p('
816:
817: ELSE
818:
819: icx_plug_utilities.plugbanner(display_name,
820: owa_util.get_owa_service_path||'wf_plug.edit_worklist_definition?'||
821: 'p_plug_id='||plug_id, 'FNDALERT.gif');
822: end if;
823:
824: htp.p('
986: end if;
987: if (attrs%isopen) then
988: close attrs;
989: end if;
990: wf_core.context('Wf_Plug','WorkList');
991: wf_plug.Error;
992: end Worklist;
993:
994:
987: if (attrs%isopen) then
988: close attrs;
989: end if;
990: wf_core.context('Wf_Plug','WorkList');
991: wf_plug.Error;
992: end Worklist;
993:
994:
995: /*===========================================================================
1027: s0 varchar2(2000);
1028: lang_codeset varchar2(50); -- Language Codeset from environment
1029: -- (e.g. WE8ISO8859P1)
1030:
1031: l_worklist_definition wf_plug.wf_worklist_definition_record;
1032: l_worklist_col_definition wf_plug.wf_worklist_col_def_table;
1033:
1034:
1035: CURSOR lkcurs(lktype in varchar2) IS
1028: lang_codeset varchar2(50); -- Language Codeset from environment
1029: -- (e.g. WE8ISO8859P1)
1030:
1031: l_worklist_definition wf_plug.wf_worklist_definition_record;
1032: l_worklist_col_definition wf_plug.wf_worklist_col_def_table;
1033:
1034:
1035: CURSOR lkcurs(lktype in varchar2) IS
1036: SELECT WL.MEANING, WL.LOOKUP_CODE
1138: -- Must have either a plug_id or username passed in otherwise show an error
1139: ELSE
1140:
1141: l_no_parameters_passed := TRUE;
1142: Wf_Core.Context('wf_plug', 'edit_worklist_definition',
1143: 'missing parameter values');
1144: wf_plug.Error;
1145: return;
1146:
1140:
1141: l_no_parameters_passed := TRUE;
1142: Wf_Core.Context('wf_plug', 'edit_worklist_definition',
1143: 'missing parameter values');
1144: wf_plug.Error;
1145: return;
1146:
1147: END IF;
1148: