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