[Home] [Help]
PACKAGE: APPS.MSC_LAUNCH_PLAN_PK
Source
1 PACKAGE MSC_LAUNCH_PLAN_PK AUTHID CURRENT_USER AS
2 /* $Header: MSCPLAPS.pls 120.7.12020000.3 2012/11/07 11:02:11 snilagir ship $ */
3 -- Modification for bug 1863615
4 PROCEDURE msc_launch_plan (
5 errbuf OUT NOCOPY VARCHAR2,
6 retcode OUT NOCOPY NUMBER,
7 arg_designator IN VARCHAR2,
8 arg_plan_id IN NUMBER,
9 arg_launch_snapshot IN NUMBER,
10 arg_launch_planner IN NUMBER,
11 arg_netchange_mode IN NUMBER,
12 arg_anchor_date IN VARCHAR2,
13 p_archive_flag IN number default 2,
14 p_plan_type_dummy IN VARCHAR2 default null,
15 p_24x7atp IN NUMBER default 2,
16 p_reschedule_dummy IN VARCHAR2 default null,
17 arg_release_reschedules IN NUMBER default 2 ,
18 p_snap_static_entities IN NUMBER default 1 ,
19 p_generate_worksheet IN NUMBER default NULL ,
20 p_snapshot_dummy IN NUMBER default NULL ,
21 p_snapshot_source IN NUMBER default NULL,
22 p_calculate_liability_dummy IN varchar2 default null ,
23 p_calculate_liabilty IN number default 2,
24 p_generate_fcst IN number default 2,
25 p_compute_ss_eoq IN number default 2 ,
26 p_pub_cap_cmro IN number default 2
27
28 );
29
30 /*-----------------+
31 | Define constants |
32 +-----------------*/
33
34 SYS_YES CONSTANT INTEGER := 1;
35 SYS_NO CONSTANT INTEGER := 2;
36 DP_SCN_ONLY_SNAPSHOT CONSTANT INTEGER := 3; /* SNOP Change */
37 /* Changes for DS Exception only mode */
38
39 DS_EXP_ONLY CONSTANT INTEGER := 3;
40 DS_OLS_ONLY CONSTANT INTEGER := 4;
41 DP_SCN_ONLY_SNP_MODE CONSTANT INTEGER := 5; /* SNOP Change */ /* New mode for SOP */
42 VERSION CONSTANT CHAR(80) :=
43 '$Header: MSCPLAPS.pls 120.7.12020000.3 2012/11/07 11:02:11 snilagir ship $';
44 PROCEDURE msc_switch_24_7_atp_plans(
45 errbuf OUT NOCOPY VARCHAR2,
46 retcode OUT NOCOPY NUMBER,
47 P_Org_plan_id IN NUMBER,
48 P_temp_plan_id IN NUMBER);
49
50 /* SNOP Change Start*/
51 PROCEDURE MSC_CHECK_PLAN_COMPLETION(
52 launch_plan_request_id IN NUMBER,
53 plan_id IN NUMBER,
54 completion_code OUT NOCOPY NUMBER);
55
56 PROCEDURE MSC_WAIT_FOR_REQUEST(
57 p_request_id IN NUMBER,
58 p_timeout IN NUMBER,
59 o_retcode OUT NOCOPY NUMBER);
60
61 /* constants */
62
63 ---- Completion codes -----
64 SUCCESS CONSTANT NUMBER := 1;
65 SNAPSHOT_FAILURE CONSTANT NUMBER := 2;
66 PLANNER_FAILURE CONSTANT NUMBER := 3;
67
68 FAILURE_OR_TIMEOUT CONSTANT NUMBER := 2;
69
70 --- NULL VALUE -------
71 NULL_VALUE CONSTANT NUMBER := -23453;
72
73 /* SNOP Change End*/
74
75 PROCEDURE msc_launch_schedule ( errbuf OUT NOCOPY VARCHAR2
76 , retcode OUT NOCOPY NUMBER
77 , arg_plan_id IN NUMBER
78 , arg_launch_snapshot IN NUMBER
79 , arg_launch_scheduler IN NUMBER
80 , arg_ols_horizon_days IN NUMBER default null
81 , arg_frozen_horizon_days IN NUMBER default null);
82 Procedure purge_user_notes_data(p_plan_id number);
83
84 PROCEDURE msc_launch_rp_plan (
85 errbuf OUT NOCOPY VARCHAR2,
86 retcode OUT NOCOPY NUMBER,
87 arg_plan_id IN NUMBER,
88 arg_calc_lateness IN NUMBER,
89 arg_save_option IN NUMBER
90 );
91
92
93 END MSC_LAUNCH_PLAN_PK;