DBA Data[Home] [Help]

APPS.ZPB_WFMNT dependencies on ZPB_WFMNT

Line 1: PACKAGE BODY ZPB_WFMNT AS

1: PACKAGE BODY ZPB_WFMNT AS
2: /* $Header: zpbwkfmnt.plb 120.0.12010.2 2006/08/03 18:48:48 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZPB_WFMNT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZPB_WFMNT';

1: PACKAGE BODY ZPB_WFMNT AS
2: /* $Header: zpbwkfmnt.plb 120.0.12010.2 2006/08/03 18:48:48 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZPB_WFMNT';
5:
6: -- Wrapper to call DeleteWorkflow and clean zpb_excp* tables for a BAID
7: Procedure PurgeWF_BusinessArea (p_business_area_id in number)
8: is

Line 36: ZPB_WFMNT.purge_Workflows (errbuf, retcode, l_thisACID, 'A');

32: -- for each ACID within each BA abort and delete the EPBCYCLE and ZPBSCHED workflows
33: for v_acid in c_acids loop
34:
35: l_thisACID := v_acid.ANALYSIS_CYCLE_ID;
36: ZPB_WFMNT.purge_Workflows (errbuf, retcode, l_thisACID, 'A');
37:
38: -- Delete task rows from zpb_excp_results, zpb_exp_explanations by instance
39: for v_instance in c_instances loop
40: l_thisInst := v_instance.instance_ac_id;

Line 152: end ZPB_WFMNT;

148: end purge_Workflows;
149:
150:
151:
152: end ZPB_WFMNT;
153: