PACKAGE: APPS.ZPB_SC_REASSIGN

Source

1 PACKAGE ZPB_SC_REASSIGN AS
2 /* $Header: zpbscreassign.pls 120.0.12010.2 2005/12/23 08:57:38 appldev noship $  */
3 
4 MAX_LENGTH CONSTANT NUMBER := 1000;
5 
6 PROCEDURE reassign_all_objects (
7   p_owner_id           IN zpb_analysis_cycles.owner_id%TYPE,
8   p_new_owner_id           IN zpb_analysis_cycles.owner_id%TYPE,
9   p_business_area_id       IN zpb_analysis_cycles.business_area_id%TYPE);
10 
11 
12 PROCEDURE reassign_bus_proc_objs (
13   p_owner_id               IN zpb_analysis_cycles.owner_id%TYPE,
14   p_new_owner_id           IN zpb_analysis_cycles.owner_id%TYPE,
15   p_business_area_id       IN zpb_analysis_cycles.business_area_id%TYPE);
16 
17 FUNCTION get_active_business_procs (
18   p_owner_id           IN zpb_analysis_cycles.owner_id%TYPE,
19   p_business_area_id   IN zpb_analysis_cycles.business_area_id%TYPE)
20   return varchar2;
21 
22 FUNCTION get_worksheets (
23   p_owner_id           IN zpb_analysis_cycles.owner_id%TYPE,
24   p_business_area_id   IN zpb_analysis_cycles.business_area_id%TYPE)
25   return varchar2;
26 
27 PROCEDURE reassign_exception_objs (
28   p_owner_id              IN zpb_analysis_cycles.owner_id%TYPE,
29   p_new_owner_id              IN zpb_analysis_cycles.owner_id%TYPE,
30   p_business_area_id          IN zpb_analysis_cycles.business_area_id%TYPE);
31 
32 END ZPB_SC_REASSIGN;