1 PACKAGE MSC_POST_PRO
2 /* $Header: MSCPOSTS.pls 120.1 2007/12/12 10:36:55 sbnaik ship $ */
3 AUTHID CURRENT_USER AS
4
5 G_SUCCESS CONSTANT NUMBER := 0;
6 G_WARNING CONSTANT NUMBER := 1;
7 G_ERROR CONSTANT NUMBER := 2;
8
9 -- For summary enhancement
10 G_SF_SUMMARY_NOT_RUN CONSTANT NUMBER := 1; -- Summary / pre-allocation was never run.
11 G_SF_PREALLOC_RUNNING CONSTANT NUMBER := 2; -- Pre-allocation is running.
12 G_SF_PREALLOC_COMPLETED CONSTANT NUMBER := 3; -- Pre-allocation is completed and is ready for use.
13 G_SF_SYNC_NOT_RUN CONSTANT NUMBER := 4; -- 24X7 synch did not run.
14 G_SF_SYNC_RUNNING CONSTANT NUMBER := 5; -- 24X7 synch is running.
15 G_SF_SYNC_SUCCESS CONSTANT NUMBER := 6; -- 24X7 synch completed successfully.
16 G_SF_SYNC_ERROR CONSTANT NUMBER := 7; -- Error occurred in 24X7 synch.
17 G_SF_SYNC_DOWNTIME CONSTANT NUMBER := 8; -- 24X7 synch plan down time.
18 G_SF_FULL_SUMMARY_RUNNING CONSTANT NUMBER := 9; -- Full summation is running.
19 G_SF_NET_SUMMARY_RUNNING CONSTANT NUMBER := 10; -- Incremental summation is running.
20 G_SF_SUMMARY_COMPLETED CONSTANT NUMBER := 11; -- Summary is completed.
21 G_SF_ATPPEG_RUNNING CONSTANT NUMBER := 12; -- ATP Pegging generation running.
22 G_SF_ATPPEG_COMPLETED CONSTANT NUMBER := 13; -- ATP Pegging generation completed.
23
24
25 PROCEDURE LOAD_SUPPLY_DEMAND ( ERRBUF OUT NoCopy VARCHAR2,
26 RETCODE OUT NoCopy NUMBER,
27 P_INSTANCE_ID IN NUMBER,
28 P_COLLECT_TYPE IN NUMBER);
29
30 PROCEDURE CREATE_PARTITIONS(ERRBUF OUT NoCopy VARCHAR2,
31 RETCODE OUT NoCopy NUMBER);
32
33 PROCEDURE LOAD_PLAN_SD ( ERRBUF OUT NoCopy VARCHAR2,
34 RETCODE OUT NoCopy NUMBER,
35 p_plan_id IN NUMBER,
36 p_calling_module IN NUMBER := 1); /* Bug 3478888 Added input parameter
37 to identify how ATP Post Plan Processing
38 has been launched */
39
40 PROCEDURE CLEAN_TABLES(p_applsys_schema IN varchar2
41 );
42
43 PROCEDURE INSERT_SUPPLIER_DATA(p_plan_id IN NUMBER,
44 p_share_partition IN varchar2,
45 p_applsys_schema IN varchar2,
46 p_full_refresh IN NUMBER, -- 1:Yes, 2:No <-- for sumary enhancement
47 p_sys_date IN DATE, -- For summary enhancement
48 p_last_refresh_number IN NUMBER DEFAULT NULL, -- for sumary enhancement
49 p_new_refresh_number IN NUMBER DEFAULT NULL); -- for sumary enhancement
50
51 FUNCTION get_tolerance_defined( p_plan_id IN NUMBER,
52 p_instance_id IN NUMBER,
53 p_organization_id IN NUMBER,
54 p_inventory_item_id IN NUMBER,
55 p_supplier_id IN NUMBER,
56 p_supplier_site_id IN NUMBER)
57 RETURN NUMBER;
58
59 PROCEDURE LOAD_RESOURCES (p_plan_id IN NUMBER,
60 p_share_partition IN varchar2,
61 p_applsys_schema IN varchar2,
62 p_full_refresh IN NUMBER, -- 1:Yes, 2:No -- for sumary enhancement
63 p_plan_start_date IN DATE, -- for summary enhancement
64 p_sys_date IN DATE, -- for summary enhancement
65 p_last_refresh_number IN NUMBER DEFAULT NULL, -- for sumary enhancement
66 p_new_refresh_number IN NUMBER DEFAULT NULL); -- for sumary enhancement
67
68 Procedure Clean_Plan_Tables( p_applsys_schema IN varchar2 );
69
70 PROCEDURE CREATE_PLAN_PARTITIONS( p_plan_id IN NUMBER,
71 p_applsys_schema IN VARCHAR2,
72 p_share_partition IN VARCHAR2,
73 p_owner IN VARCHAR2,
74 p_ret_code OUT NoCopy NUMBER,
75 p_err_msg OUT NoCopy VARCHAR2);
76
77 PROCEDURE LOAD_NET_SO (
78 ERRBUF OUT NoCopy VARCHAR2,
79 RETCODE OUT NoCopy NUMBER,
80 P_INSTANCE_ID IN NUMBER
81 );
82
83 PROCEDURE LOAD_NET_SD (
84 ERRBUF OUT NoCopy VARCHAR2,
85 RETCODE OUT NoCopy NUMBER,
86 P_INSTANCE_ID IN NUMBER
87 );
88
89 PROCEDURE CREATE_INST_PARTITIONS(p_instance_id IN NUMBER,
90 p_applsys_schema IN VARCHAR2,
91 p_owner IN VARCHAR2,
92 p_ret_code OUT NoCopy NUMBER,
93 p_err_msg OUT NoCopy VARCHAR2);
94
95 PROCEDURE LAUNCH_CONC_PROG(ERRBUF IN OUT NoCopy VARCHAR2,
96 RETCODE IN OUT NoCopy NUMBER,
97 P_INSTANCE_ID IN NUMBER,
98 P_COLLECT_TYPE IN NUMBER,
99 REFRESH_SO IN NUMBER,
100 REFRESH_SD IN NUMBER);
101
102
103 -- 2/14/2002 ngoel, added this procedure for pre-allocating demands and supplies using
104 -- pegging from the plan in case allocation method profile is set to "Use Planning Output".
105
106 PROCEDURE post_plan_allocation(
107 ERRBUF OUT NoCopy VARCHAR2,
108 RETCODE OUT NoCopy NUMBER,
109 p_plan_id IN NUMBER);
110
111
112 -- ngoel 5/7/2002, added new API to be called from planning process to launch concurrent program
113 -- for post-plan process for summary/ pre-allocation process.
114
115 procedure atp_post_plan_proc(
116 p_plan_id IN NUMBER,
117 p_alloc_mode IN NUMBER DEFAULT 0,
118 p_summary_mode IN NUMBER DEFAULT 0,
119 x_retcode OUT NoCopy NUMBER,
120 x_errbuf OUT NoCopy VARCHAR2);
121
122
123 PROCEDURE ATP_Purge_MRP_Temp(
124 ERRBUF OUT NoCopy VARCHAR2,
125 RETCODE OUT NoCopy NUMBER,
126 p_hours IN NUMBER
127 );
128
129
130 -- For summary enhancement - Entry point for Incremental PDS Summary
131 PROCEDURE Load_Net_Plan(
132 ERRBUF OUT NoCopy VARCHAR2,
133 RETCODE OUT NoCopy NUMBER,
134 p_plan_id IN NUMBER);
135
136 /* For time_phased_atp
137 Made this a public procedure*/
138 -- Added input parameters to drop newly added temp table MSC_ALLOC_TEMP_ as well for forecast at PF
139 PROCEDURE clean_temp_tables(
140 p_applsys_schema IN varchar2,
141 p_plan_id IN NUMBER,
142 p_plan_id2 IN NUMBER,
143 p_demand_priority IN VARCHAR2);
144
145 /*------------------------------------------------------------|
146 |New Procedure added for collection enhancement --bug3049003 |
147 |-------------------------------------------------------------*/
148 PROCEDURE atp_snapshot_hook(
149 p_plan_id IN NUMBER
150 );
151
152 -- NGOEL 1/15/2004, API to delete CTO BOM and OSS data from ATP temp tables for standalone and post 24x7 plan run plan purging
153 -- This API will be called by "Purge Plan" conc program.
154
155 Procedure Delete_CTO_BOM_OSS(
156 p_plan_id IN NUMBER);
157
158
159 END MSC_POST_PRO;