[Home] [Help]
PACKAGE: APPS.MSC_LAUNCH_PLAN_PK
Source
1 PACKAGE MSC_LAUNCH_PLAN_PK AS
2 /* $Header: MSCPLAPS.pls 120.3.12010000.1 2008/05/02 19:06:12 appldev 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_calculate_liability_dummy IN varchar2 default null ,
20 p_calculate_liabilty IN number default 2,
21 p_generate_fcst IN number default 2
22 );
23
24 /*-----------------+
25 | Define constants |
26 +-----------------*/
27
28 SYS_YES CONSTANT INTEGER := 1;
29 SYS_NO CONSTANT INTEGER := 2;
30 DP_SCN_ONLY_SNAPSHOT CONSTANT INTEGER := 3; /* SNOP Change */
31 /* Changes for DS Exception only mode */
32
33 DS_EXP_ONLY CONSTANT INTEGER := 3;
34 DS_OLS_ONLY CONSTANT INTEGER := 4;
35 DP_SCN_ONLY_SNP_MODE CONSTANT INTEGER := 5; /* SNOP Change */ /* New mode for SOP */
36 VERSION CONSTANT CHAR(80) :=
37 '$Header: MSCPLAPS.pls 120.3.12010000.1 2008/05/02 19:06:12 appldev ship $';
38 PROCEDURE msc_switch_24_7_atp_plans(
39 errbuf OUT NOCOPY VARCHAR2,
40 retcode OUT NOCOPY NUMBER,
41 P_Org_plan_id IN NUMBER,
42 P_temp_plan_id IN NUMBER);
43
44 /* SNOP Change Start*/
45 PROCEDURE MSC_CHECK_PLAN_COMPLETION(
46 launch_plan_request_id IN NUMBER,
47 plan_id IN NUMBER,
48 completion_code OUT NOCOPY NUMBER);
49
50 PROCEDURE MSC_WAIT_FOR_REQUEST(
51 p_request_id IN NUMBER,
52 p_timeout IN NUMBER,
53 o_retcode OUT NOCOPY NUMBER);
54
55 /* constants */
56
57 ---- Completion codes -----
58 SUCCESS CONSTANT NUMBER := 1;
59 SNAPSHOT_FAILURE CONSTANT NUMBER := 2;
60 PLANNER_FAILURE CONSTANT NUMBER := 3;
61
62 FAILURE_OR_TIMEOUT CONSTANT NUMBER := 2;
63
64 --- NULL VALUE -------
65 NULL_VALUE CONSTANT NUMBER := -23453;
66
67 /* SNOP Change End*/
68
69 PROCEDURE msc_launch_schedule ( errbuf OUT NOCOPY VARCHAR2
70 , retcode OUT NOCOPY NUMBER
71 , arg_plan_id IN NUMBER
72 , arg_launch_snapshot IN NUMBER
73 , arg_launch_scheduler IN NUMBER
74 , arg_ols_horizon_days IN NUMBER default null
75 , arg_frozen_horizon_days IN NUMBER default null);
76 Procedure purge_user_notes_data(p_plan_id number);
77 END MSC_LAUNCH_PLAN_PK;