[Home] [Help]
PACKAGE: APPS.PJI_PJP_SUM_MAIN
Source
1 package PJI_PJP_SUM_MAIN as
2 /* $Header: PJISP01S.pls 120.2 2006/03/24 12:36:51 appldev noship $ */
3
4 g_parallel_processes number := 10;
5 g_process varchar2(30) := 'PJI_PJP';
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_PJP_SUMMARIZE_FULL';
10 g_incr_disp_name varchar2(30) := 'PJI_PJP_SUMMARIZE_INCR';
11 g_prtl_disp_name varchar2(30) := 'PJI_PJP_SUMMARIZE_PRTL';
12 g_rbs_disp_name varchar2(30) := 'PJI_PJP_SUMMARIZE_RBS';
13 g_retcode varchar2(255);
14
15 function WORKER_STATUS (p_worker_id in number,
16 p_mode in varchar2) return boolean;
17
18 procedure OUTPUT_FAILED_RUNS;
19
20 procedure INIT_PROCESS(
21 p_worker_id in out nocopy number,
22 p_run_mode in varchar2,
23 p_operating_unit in number default null,
24 p_project_type in varchar2 default null,
25 p_project_organization_id in number default null,
26 /* p_from_project_id in number default null,
27 p_to_project_id in number default null,*/
28 p_from_project in varchar2 default null,
29 p_to_project in varchar2 default null,
30 p_plan_type_id in number default null,
31 p_rbs_header_id in number default null,
32 p_only_pt_projects_flag in varchar2 default null,
33 p_transaction_type in varchar2 default null, -- Bug#5099574 - New parameter for Partial Refresh
34 p_plan_versions in varchar2 default null -- Bug#5099574 - New parameter for Partial Refresh
35 );
36
37 procedure RUN_PROCESS (p_worker_id in number);
38
39 procedure WRAPUP_PROCESS (p_worker_id in number);
40
41 procedure WRAPUP_FAILURE (p_worker_id in number);
42
43 procedure SUMMARIZE
44 (
45 errbuf out nocopy varchar2,
46 retcode out nocopy varchar2,
47 p_run_mode in varchar2,
48 p_operating_unit in number default null, --new parameter
49 p_project_organization_id in number default null,
50 p_project_type in varchar2 default null,
51 /* These two parameter will be changed to p_from_project and p_to_project
52 p_from_project_id in number default null,
53 p_to_project_id in number default null,*/
54 p_from_project in varchar2 default null,
55 p_to_project in varchar2 default null,
56 p_plan_type_id in number default null,
57 p_rbs_header_id in number default null,
58 p_transaction_type in varchar2 default null, -- Bug#5099574 - New parameter for Partial Refresh
59 p_plan_versions in varchar2 default null, -- Bug#5099574 - New parameter for Partial Refresh
60 p_only_pt_projects_flag in varchar2 default null
61 );
62
63 end PJI_PJP_SUM_MAIN;