DBA Data[Home] [Help]

PACKAGE: APPS.PJI_LAUNCH_UPP_MAIN

Source


1 package PJI_LAUNCH_UPP_MAIN AUTHID CURRENT_USER as
2  /* $Header: PJILN01S.pls 120.4.12020000.2 2013/04/18 12:46:12 krkondur ship $ */
3 
4   g_full_disp_name      varchar2(30) := 'PJI_PJP_SUMMARIZE_FULL';
5   g_incr_disp_name      varchar2(30) := 'PJI_PJP_SUMMARIZE_INCR';
6   g_prtl_disp_name      varchar2(30) := 'PJI_PJP_SUMMARIZE_PRTL';
7   g_rbs_disp_name       varchar2(30) := 'PJI_PJP_SUMMARIZE_RBS';
8   g_retcode             varchar2(255);
9   g_stat_count          number := 0;   /* Added for bug 8416116 */
10 
11   PROCEDURE LAUNCH_UPP_PROCESS
12   (
13     errbuf                    out  NOCOPY  varchar2,
14     retcode                   out  NOCOPY  varchar2,
15     p_num_of_projects            in     number ,
16     p_temp_table_size           in     number ,
17     p_num_parallel_runs         in     number ,
18     p_num_of_batches            in     number ,
19     p_wait_time_seconds         in     number ,
20     p_regenerate_batches        in     varchar2 ,  -- Sridhar added this new parameter
21     p_incremental_mode          in     varchar2 default 'Y',   -- Sridhar Carlson added this new parameter
22     P_OPERATING_UNIT            in     number,
23     p_submit_uppd_during_lppd   in varchar2 default 'Y',
24     P_LAUNCH_TYPE               in     varchar2  default  'UPPD',   -- sridhar_phase_1
25     p_project_status            in     varchar2 );--rkuttiya added new parameter for 12.1.3
26 
27   PROCEDURE CREATE_UPP_BATCHES
28   (
29     p_wbs_temp_table_size           in   number ,
30     p_num_of_projects               in   number ,
31     p_incremental_mode          in     varchar2,   -- Sridhar Carlson added this new parameter
32     p_regenerate_batches            in   varchar2,  --Goodman
33     P_OPERATING_UNIT            in     number,
34     p_project_status            in     varchar2 ) -- new parameter for 12.1.3
35     ;
36 
37   PROCEDURE CREATE_INCR_PROJECT_LIST
38   (
39     p_operating_unit            in   number
40   ) ;
41 
42   PROCEDURE UPDATE_BATCH_CONC_STATUS
43   (
44     p_first_time_flag   in  varchar2,
45     x_count_batches     out NOCOPY  number,
46     x_count_running     out  NOCOPY number,
47     x_count_errored     out  NOCOPY number,
48     x_count_completed   out  NOCOPY number,
49     x_count_pending     out  NOCOPY number
50   );
51 
52 end PJI_LAUNCH_UPP_MAIN;