DBA Data[Home] [Help]

APPS.WF_PLUG dependencies on WF_PLUG

Line 1: package body WF_PLUG as

1: package body WF_PLUG as
2: /* $Header: wfplugb.pls 120.2 2005/10/04 23:26:39 rtodi ship $ */
3:
4:
5: --

Line 52: replace(error_stack,wf_plug.chr_newline,'
'));

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;

Line 87: wf_core.context('Wf_plug', 'GetPlugSession');

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:

Line 100: p_worklist_definition OUT NOCOPY wf_plug.wf_worklist_definition_record

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';

Line 221: wf_core.context('Wf_Plug', 'get_plug_definition');

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:

Line 222: wf_plug.Error;

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: /*===========================================================================

Line 451: Wf_Core.Context('wf_plug', 'find_criteria');

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:

Line 452: wf_plug.Error;

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:

Line 583: l_worklist_definition wf_plug.wf_worklist_definition_record;

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;

Line 584: l_worklist_col_definition wf_plug.wf_worklist_col_def_table;

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:

Line 778: owa_util.get_owa_service_path||'wf_plug.edit_worklist_definition?'||

774: htp.p('');
775: IF (display_name IS NULL) THEN
776:
777: icx_plug_utilities.plugbanner(wf_core.translate('WFA_WTITLE'),
778: owa_util.get_owa_service_path||'wf_plug.edit_worklist_definition?'||
779: 'p_plug_id='||plug_id, 'FNDALERT.gif');
780:
781: ELSE
782:

Line 784: owa_util.get_owa_service_path||'wf_plug.edit_worklist_definition?'||

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('');

Line 814: owa_util.get_owa_service_path||'wf_plug.edit_worklist_definition?'||

810: htp.p('');
811: IF (display_name IS NULL) THEN
812:
813: icx_plug_utilities.plugbanner(wf_core.translate('WFA_WTITLE'),
814: owa_util.get_owa_service_path||'wf_plug.edit_worklist_definition?'||
815: 'p_plug_id='||plug_id, 'FNDALERT.gif');
816:
817: ELSE
818:

Line 820: owa_util.get_owa_service_path||'wf_plug.edit_worklist_definition?'||

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('');

Line 990: wf_core.context('Wf_Plug','WorkList');

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:

Line 991: wf_plug.Error;

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: /*===========================================================================

Line 1031: l_worklist_definition wf_plug.wf_worklist_definition_record;

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

Line 1032: l_worklist_col_definition wf_plug.wf_worklist_col_def_table;

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

Line 1142: Wf_Core.Context('wf_plug', 'edit_worklist_definition',

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:

Line 1144: wf_plug.Error;

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:

Line 1190: htp.p('
');

1186: htp.p('');
1187:
1188: -- wf_dsk.submit_dsk is the url(procedure) to which the contents
1189: -- of this form is sent
1190: htp.p('');
1191:
1192: htp.formHidden(cname=>'plug_id', cvalue=>p_plug_id);
1193: htp.formHidden(cname=>'username', cvalue=>p_username);
1194: htp.formHidden(cname=>'definition_name', cvalue=>null);

Line 1389: Wf_Core.Context('wf_plug', 'edit_worklist_definition',

1385: htp.htmlClose;
1386:
1387: exception
1388: when others then
1389: Wf_Core.Context('wf_plug', 'edit_worklist_definition',
1390: p_plug_id, p_username);
1391: wf_plug.Error;
1392:
1393: END edit_worklist_definition;

Line 1391: wf_plug.Error;

1387: exception
1388: when others then
1389: Wf_Core.Context('wf_plug', 'edit_worklist_definition',
1390: p_plug_id, p_username);
1391: wf_plug.Error;
1392:
1393: END edit_worklist_definition;
1394:
1395: /*===========================================================================

Line 1551: Wf_Core.Context('wf_plug', 'submit_worklist_definition',

1547: icx_plug_utilities.gotomainmenu;
1548:
1549: exception
1550: when others then
1551: Wf_Core.Context('wf_plug', 'submit_worklist_definition',
1552: plug_id, username);
1553: wf_plug.Error;
1554:
1555: END submit_worklist_definition;

Line 1553: wf_plug.Error;

1549: exception
1550: when others then
1551: Wf_Core.Context('wf_plug', 'submit_worklist_definition',
1552: plug_id, username);
1553: wf_plug.Error;
1554:
1555: END submit_worklist_definition;
1556:
1557: /*===========================================================================

Line 1585: wf_plug.worklist (plug_id=>p_plug_id, session_id=>p_session_id,

1581:
1582:
1583: ELSE
1584:
1585: wf_plug.worklist (plug_id=>p_plug_id, session_id=>p_session_id,
1586: display_name=>p_display_name);
1587:
1588: END IF;
1589:

Line 1594: Wf_Core.Context('wf_plug', 'worklist_plug',

1590: COMMIT;
1591:
1592: exception
1593: when others then
1594: Wf_Core.Context('wf_plug', 'worklist_plug',
1595: p_session_id,p_plug_id,p_delete);
1596: wf_plug.Error;
1597:
1598: END worklist_plug;

Line 1596: wf_plug.Error;

1592: exception
1593: when others then
1594: Wf_Core.Context('wf_plug', 'worklist_plug',
1595: p_session_id,p_plug_id,p_delete);
1596: wf_plug.Error;
1597:
1598: END worklist_plug;
1599:
1600: end WF_PLUG;

Line 1600: end WF_PLUG;

1596: wf_plug.Error;
1597:
1598: END worklist_plug;
1599:
1600: end WF_PLUG;