PACKAGE: APPS.PJI_PJP_SUM_DENORM

Source

1 package PJI_PJP_SUM_DENORM as
2   /* $Header: PJISP03S.pls 120.0 2005/05/29 12:33:28 appldev noship $ */
3 
4 -- -----------------------------------------------------------------------
5 
6 
7 
8 -- -----------------------------------------------------------------------
9 
10 procedure POPULATE_XBS_DENORM(
11 	p_worker_id		in	number,
12 	p_denorm_type    	in 	varchar2,
13 	p_wbs_version_id 	in 	number,
14 	p_prg_group1     	in 	number,
15 	p_prg_group2     	in 	number
16 );
17 
18 procedure COPY_XBS_DENORM(
19 	p_worker_id		in	number,
20 	p_wbs_version_id_from 	in 	number,
21     p_wbs_version_id_to 	in 	number,
22     p_copy_mode             in varchar2 default null
23 );
24 -- -----------------------------------------------------------------------
25 
26 procedure POPULATE_RBS_DENORM(
27 	p_worker_id 		in 	number,
28 	p_denorm_type    	in 	varchar2,
29 	p_rbs_version_id 	in 	number
30 );
31 
32 
33 -- -----------------------------------------------------------------------
34 
35 procedure POPULATE_RBS_DENORM_UPGRADE(
36 	p_rbs_version_id	in  	   	number,
37 	x_return_status  	out nocopy 	varchar2,
38 	x_msg_count   	 	out nocopy 	number,
39 	x_msg_data       	out nocopy 	varchar2
40 );
41 
42 -- -----------------------------------------------------------------------
43 
44 procedure prg_denorm(
45 	p_worker_id 		in 	number,
46 	p_extraction_type 	in 	varchar2
47 );
48 
49 -- -----------------------------------------------------------------------
50 
51 procedure wbs_denorm(
52 	p_worker_id 		in 	number,
53 	p_extraction_type 	in 	varchar2,
54 	p_wbs_version_id	in 	number
55 );
56 
57 -- -----------------------------------------------------------------------
58 
59 procedure prg_denorm_online(
60 	p_worker_id 		in 	number,
61 	p_extraction_type 	in 	varchar2,
62 	p_prg_group_id		in 	number,
63 	p_wbs_version_id 	in 	number
64 );
65 
66 -- -----------------------------------------------------------------------
67 
68 procedure wbs_denorm_online(
69 	p_worker_id 		in 	number,
70 	p_extraction_type 	in 	varchar2,
71 	p_wbs_version_id 	in 	number
72 );
73 
74 -- -----------------------------------------------------------------------
75 
76 procedure rbs_denorm(
77 	p_worker_id 	  	in 	number,
78 	p_extraction_type 	in 	varchar2,
79 	p_rbs_version_id  	in 	number
80 );
81 
82 -- -----------------------------------------------------------------------
83 
84 procedure rbs_denorm_online(
85 	p_worker_id 	  	in 	number,
86 	p_extraction_type 	in 	varchar2,
87 	p_rbs_version_id  	in 	number
88 );
89 
90 -- -----------------------------------------------------------------------
91 
92 procedure merge_xbs_denorm(
93 	p_worker_id 		in 	number,
94 	p_extraction_type 	in 	varchar2
95 );
96 
97 -- -----------------------------------------------------------------------
98 
99 procedure merge_rbs_denorm(
100 	p_worker_id 		in 	number,
101 	p_extraction_type 	in 	varchar2
102 );
103 
104 -- -----------------------------------------------------------------------
105 
106 procedure cleanup_xbs_denorm(
107 	p_worker_id 		in 	number,
108 	p_extraction_type 	in 	varchar2
109 );
110 
111 -- -----------------------------------------------------------------------
112 
113 procedure cleanup_rbs_denorm(
114 	p_worker_id 		in 	number,
115 	p_extraction_type 	in 	varchar2
116 );
117 
118 -- -----------------------------------------------------------------------
119 
120 end PJI_PJP_SUM_DENORM;