[Home] [Help]
PACKAGE: APPS.PJI_FM_PLAN_MAINT
Source
1 PACKAGE PJI_FM_PLAN_MAINT AS
2 /* $Header: PJIPP01S.pls 120.4 2005/09/10 19:19:43 appldev noship $ */
3
4 -- This line is could be deleted, for reference only: pji_empty_num_tbl is a sql type of nested table of numbers. Source: $PA_TOP/.../par1tt20.sql
5
6 pji_empty_num_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7 pji_empty_varchar2_30_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8
9
10 ------------------------------------------------------------------
11 ------------------------------------------------------------------
12 -- Public Apis Declaration --
13 ------------------------------------------------------------------
14 ------------------------------------------------------------------
15
16 PROCEDURE MAP_RESOURCE_LIST (
17 p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
18 , p_context IN VARCHAR2 := 'BULK');
19
20
21 ------------------------------------------------------------------
22 ------------------------------------------------------------------
23 -- Private Apis Declaration --
24 ------------------------------------------------------------------
25 ------------------------------------------------------------------
26
27 PROCEDURE CREATE_PRIMARY_UPGRD_PVT
28 ( p_context IN VARCHAR2 := 'FPM_UPGRADE' -- Valid values: 'FPM_UPGRADE' and 'TRUNCATE'
29 ) ;
30
31 PROCEDURE CREATE_PRIMARY_PVT(
32 p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
33 , p_is_primary_rbs IN VARCHAR2 -- Valid values are T/F
34 , p_commit IN VARCHAR2 := 'F'
35 , p_fp_src_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
36 ,p_copy_mode IN VARCHAR2 :=NULL
37 );
38
39
40 PROCEDURE DELETE_ALL_PVT (
41 p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
42 , p_commit IN VARCHAR2 := 'F');
43
44
45 PROCEDURE CREATE_SECONDARY_PVT(
46 p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
47 , p_commit IN VARCHAR2 := 'F'
48 , p_process_all IN VARCHAR2 := 'F');
49
50
51 PROCEDURE CREATE_SECONDARY_T_PVT(
52 p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
53 , p_commit IN VARCHAR2 := 'F'
54 , p_process_all IN VARCHAR2 := 'F');
55
56
57 PROCEDURE UPDATE_PRIMARY_PVT(
58 p_plan_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
59 , p_commit IN VARCHAR2 := 'F');
60
61
62 PROCEDURE UPDATE_PRIMARY_PVT_ACT_ETC (
63 p_commit IN VARCHAR2 := 'F'
64 , p_plan_version_id IN NUMBER := NULL
65 , p_prev_pub_version_id IN NUMBER := NULL
66 , x_return_status OUT NOCOPY VARCHAR2
67 , x_processing_code OUT NOCOPY VARCHAR2);
68
69
70 PROCEDURE POPULATE_FIN8(
71 p_worker_id IN NUMBER
72 , p_extraction_type IN VARCHAR2
73 , x_return_status OUT NOCOPY VARCHAR2
74 , x_msg_data OUT NOCOPY VARCHAR2 );
75
76
77 ----------------------------------------------
78 ----- Partial refresh of plan data... -----
79 ----------------------------------------------
80
81 PROCEDURE PULL_PLANS_FOR_PR (
82 p_rbs_version_id IN NUMBER
83 , p_plan_type_id IN NUMBER
84 , p_context IN VARCHAR2 -- Valid values are 'RBS' or 'PLANTYPE'.
85 , x_return_status OUT NOCOPY VARCHAR2
86 , x_msg_code OUT NOCOPY VARCHAR2 ) ;
87
88
89 ---------------------------------------------------------
90 ----- Full and Incr summarization of actuals ... -----
91 ---------------------------------------------------------
92
93 PROCEDURE GET_ACTUALS_SUMM (
94 p_extr_type IN VARCHAR2 -- Valid values are 'FULL' and 'INCR'.
95 , x_return_status OUT NOCOPY VARCHAR2
96 , x_msg_code OUT NOCOPY VARCHAR2 ) ;
97
98
99 ----------------------------------------------
100 ----- Misc apis... -----
101 ----------------------------------------------
102
103 FUNCTION CHECK_VER3_NOT_EMPTY ( p_online IN VARCHAR2 := 'T') -- Valid values T/F
104 RETURN VARCHAR2;
105
106
107 END PJI_FM_PLAN_MAINT;