[Home] [Help]
PACKAGE: APPS.PJI_FM_SUM_MAIN
Source
1 package PJI_FM_SUM_MAIN AUTHID CURRENT_USER as
2 /* $Header: PJISF01S.pls 120.4 2006/07/22 02:41:02 svermett noship $ */
3
4 g_process varchar2(30) := 'PJI_EXTR';
5 g_null varchar2(8) := 'PJI$NULL';
6 g_parameter_date_mask varchar2(21) := 'YYYY/MM/DD HH24:MI:SS';
7 g_date_mask varchar2(21) := 'YYYY/MM/DD';
8 g_full_disp_name varchar2(30) := 'PJI_FM_SUMMARIZE_FULL';
9 g_incr_disp_name varchar2(30) := 'PJI_FM_SUMMARIZE_INCR';
10 g_prtl_disp_name varchar2(30) := 'PJI_FM_SUMMARIZE_PRTL';
11 g_helper_name varchar2(30) := 'PJI_FM_HELPER_1';
12 g_parallel_processes number := 8;
13 g_process_delay number := 10;
14 g_commit_threshold number := 10000;
15
16 procedure RUN_SETUP;
17
18 function PRIOR_ITERATION_SUCCESSFUL return boolean;
19
20 procedure INIT_PROCESS
21 (
22 p_run_mode in varchar2,
23 p_extract_commitments in varchar2 default 'N',
24 p_organization_id in number default null,
25 p_include_sub_org in varchar2 default null,
26 p_operating_unit in number default null,
27 p_from_project in varchar2 default null,
28 p_to_project in varchar2 default null,
29 p_plan_type in varchar2 default null,
30 p_cmt_operating_unit in number default null,
31 p_cmt_from_project in varchar2 default null,
32 p_cmt_to_project in varchar2 default null
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_SETUP;
52
53 procedure WRAPUP_PROCESS;
54
55 procedure WRAPUP_FAILURE;
56
57 procedure SUMMARIZE
58 (
59 errbuf out nocopy varchar2,
60 retcode out nocopy varchar2,
61 p_run_mode in varchar2,
62 p_extract_commitments in varchar2 default 'N',
63 p_organization_id in number default null,
64 p_include_sub_org in varchar2 default null,
65 p_operating_unit in number default null,
66 p_from_project in varchar2 default null,
67 p_to_project in varchar2 default null,
68 p_plan_type in varchar2 default null,
69 p_cmt_operating_unit in number default null,
70 p_cmt_from_project in varchar2 default null,
71 p_cmt_to_project in varchar2 default null
72 );
73
74 end PJI_FM_SUM_MAIN;