1 PACKAGE PJI_FM_SUM_BKLG AUTHID CURRENT_USER AS
2 /* $Header: PJISF12S.pls 120.2 2005/11/10 20:22:04 appldev noship $ */
3
4 --Name: Init_Drmt_Bklg
5 --Type: Procedure
6 --
7 --Description:
8 -- The procedure initiates the calculation for following project-related
9 -- 1) Revenue at Risk
10 -- 2) Dormant Backlog
11 -- 3) Not Started Backlog
12 -- 4) Lost Backlog
13 -- 5) Active Backlog
14 --
15 -- This procedure is called by PJI Summarization Process
16 --
17 -- At the start of this procedure, this procedure retrieves selected
18 -- enterprise calendar ITD numbersand stores them in a persistent table
19 -- for subsequent insert processing.
20 --
21 -- This procedure inserts project day records to the
22 -- PJI_FM_AGGR_ACT partitioned tmp table. The insert
23 -- generates most of the required numbers.
24 --
25 -- Subsequently, the tmp table rows are merged back into the
26 -- PJI_AC_PROJ_F fact table.
27 --
28 --NOTE:
29 --
30 --
31 --Called subprograms:
32 --
33 --
34 --History:
35 -- 25-JUL-2002 vgautam Created
36 --
37
38 procedure ROWID_ACTIVITY_DATES_FIN (p_worker_id in number);
39
40 procedure UPDATE_ACTIVITY_DATES_FIN (p_worker_id in number);
41
42 procedure ROWID_ACTIVITY_DATES_ACT (p_worker_id in number);
43
44 procedure UPDATE_ACTIVITY_DATES_ACT (p_worker_id in number);
45
46 procedure SCOPE_PROJECTS_BKLG (p_worker_id in number);
47
48 procedure CLEANUP_INT_TABLE (p_worker_id in number);
49
50 procedure PROCESS_DRMT_BKLG (p_worker_id in number);
51
52 end PJI_FM_SUM_BKLG;