DBA Data[Home] [Help]

PACKAGE: APPS.PA_PPR_SMART_SLICE_PVT

Source


1 package PA_ppr_smart_slice_PVT AUTHID CURRENT_USER as
2 /* $Header: PAPPR04S.pls 120.0.12020000.1 2013/03/08 02:01:01 sachandr noship $ * */
3 
4 G_LOG_LEVEL   number default 5;
5 
6 G_PACKAGE_NAME   varchar2(60) default  'PA_ppr_smart_slice_PVT' ;
7 G_DEBUG_MODE     varchar2(1)  default  'N';
8 
9 PROCEDURE maintain_smart_slice (
10 		  p_rbs_version_id      IN  NUMBER :=NULL,
11 		  p_plan_version_id_tbl IN  SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
12 		  p_wbs_element_id      IN  NUMBER   ,
13 		  p_rbs_element_id      IN  NUMBER    ,
14 		  p_prg_rollup_flag     IN  VARCHAR2    ,
15 		  p_curr_record_type_id IN  NUMBER,
16 		  p_calendar_type       IN  VARCHAR2,
17                   p_wbs_version_id      IN  NUMBER,
18                   p_commit              IN  VARCHAR2 := 'Y',
19 	          p_rbs_version_id_tbl IN  SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
20 		  x_msg_count           OUT NOCOPY  NUMBER,
21 		  x_msg_data            OUT NOCOPY  VARCHAR2,
22 		  x_return_status       OUT NOCOPY  VARCHAR2,
23 		   p_fact_slice           varchar2 default  'NULL');
24 
25 
26 	procedure ppr_log (
27     p_msg				IN	VARCHAR2  ,
28 	p_level      IN number default 0
29     );
30 
31     End PA_ppr_smart_slice_PVT;