DBA Data[Home] [Help]

PACKAGE: APPS.PJI_RM_SUM_MAIN

Source


1 package PJI_RM_SUM_MAIN AUTHID CURRENT_USER as
2 /* $Header: PJISR01S.pls 120.2 2005/12/07 21:54:47 appldev noship $ */
3 
4   g_process             varchar2(30) := 'PJI_PJI';
5   g_parallel_limit      number       := 8;
6   g_null                varchar2(8)  := 'PJI$NULL';
7   g_parameter_date_mask varchar2(21) := 'YYYY/MM/DD HH24:MI:SS';
8   g_date_mask           varchar2(21) := 'YYYY/MM/DD';
9   g_full_disp_name      varchar2(30) := 'PJI_PJI_SUMMARIZE_FULL';
10   g_incr_disp_name      varchar2(30) := 'PJI_PJI_SUMMARIZE_INCR';
11   g_prtl_disp_name      varchar2(30) := 'PJI_PJI_SUMMARIZE_PRTL';
12   g_helper_name         varchar2(30) := 'PJI_RM_HELPER_1';
13   g_parallel_processes  number       := 8;
14   g_process_delay       number       := 10;
15   g_commit_threshold    number       := 10000;
16 
17   g_min_date            date         := PJI_UTILS.GET_EXTRACTION_START_DATE;
18   g_max_date            date         := to_date('3000/01/01','YYYY/MM/DD');
19 
20   function PRIOR_ITERATION_SUCCESSFUL return boolean;
21 
22   procedure INIT_PROCESS
23   (
24     p_run_mode        in         varchar2,
25     p_prtl_schedule   in         varchar2 default null, -- RM
26     p_organization_id in         number   default null, -- RM parameter
27     p_include_sub_org in         varchar2 default 'N',  -- RM parameter
28     p_prtl_financial  in         varchar2 default null, -- FM
29     p_operating_unit  in         number   default null, -- FM parameter
30     p_from_project    in         varchar2 default null, -- FM parameter
31     p_to_project      in         varchar2 default null, -- FM parameter
32     p_plan_type       in         varchar2 default null  -- FM parameter
33   );
34 
35   function PROCESS_RUNNING (p_wait in varchar2) return boolean;
36 
37   procedure RUN_PROCESS;
38 
39   function MY_PAD (p_length in number,
40                    p_char   in varchar2) return varchar2;
41 
42   function GET_MISSING_TIME_HEADER return varchar2;
43 
44   function GET_MISSING_TIME_TEXT (p_calendar_name in varchar2,
45                                   p_period_type   in varchar2,
46                                   p_from_date     in date,
47                                   p_to_date       in date) return varchar2;
48 
49   procedure DANGLING_REPORT;
50 
51   procedure WRAPUP_PROCESS;
52 
53   procedure WRAPUP_FAILURE;
54 
55   procedure SHUTDOWN_PROCESS (errbuf  out nocopy varchar2,
56                               retcode out nocopy varchar2);
57 
58   procedure SUMMARIZE
59   (
60     errbuf            out nocopy varchar2,
61     retcode           out nocopy varchar2,
62     p_run_mode        in         varchar2,
63     p_prtl_schedule   in         varchar2 default null, -- RM
64     p_organization_id in         number   default null, -- RM parameter
65     p_include_sub_org in         varchar2 default 'N',  -- RM parameter
66     p_prtl_financial  in         varchar2 default null, -- FM
67     p_operating_unit  in         number   default null, -- FM parameter
68     p_from_project    in         varchar2 default null, -- FM parameter
69     p_to_project      in         varchar2 default null, -- FM parameter
70     p_plan_type       in         varchar2 default null  -- FM parameter
71   );
72 
73 end PJI_RM_SUM_MAIN;