[Home] [Help]
PACKAGE: APPS.PJI_PJP_SUM_MAIN
Source
1 package PJI_PJP_SUM_MAIN AUTHID CURRENT_USER as
2 /* $Header: PJISP01S.pls 120.2.12010000.6 2010/05/13 23:11:41 rkuttiya ship $ */
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 p_project_status in varchar2 default null -- 12.1.3
36 );
37
38 procedure RUN_PROCESS (p_worker_id in number);
39
40 procedure WRAPUP_PROCESS (p_worker_id in number);
41
42 procedure WRAPUP_FAILURE (p_worker_id in number);
43
44 procedure SUMMARIZE
45 (
46 errbuf out nocopy varchar2,
47 retcode out nocopy varchar2,
48 p_run_mode in varchar2,
49 p_operating_unit in number default null, --new parameter
50 p_project_organization_id in number default null,
51 p_project_type in varchar2 default null,
52 /* These two parameter will be changed to p_from_project and p_to_project
53 p_from_project_id in number default null,
54 p_to_project_id in number default null,*/
55 p_from_project in varchar2 default null,
56 p_to_project in varchar2 default null,
57 p_plan_type_id in number default null,
58 p_rbs_header_id in number default null,
59 p_transaction_type in varchar2 default null, -- Bug#5099574 - New parameter for Partial Refresh
60 p_plan_versions in varchar2 default null, -- Bug#5099574 - New parameter for Partial Refresh
61 p_project_status in varchar2 default null,
62 p_only_pt_projects_flag in varchar2 default null
63 );
64
65 end PJI_PJP_SUM_MAIN;