1 PACKAGE MSC_WS_SNO_PUBLISH AUTHID CURRENT_USER AS
2 /* $Header: MSCWSPBS.pls 120.8 2009/08/10 15:54:03 saskrish ship $ */
3 PROCEDURE LOG_MESSAGE (p_message varchar2);
4 PROCEDURE SET_UP_SYSTEM_ITEMS(
5 Status OUT NOCOPY VARCHAR2,
6 PlanIdVar IN NUMBER
7 );
8 PROCEDURE SET_ASCP_PLAN_BUCKETS(
9 Status OUT NOCOPY VARCHAR2,
10 PlanIdVar IN NUMBER
11 );
12 PROCEDURE SET_ASCP_DEMANDS(
13 Status OUT NOCOPY VARCHAR2,
14 PlanIdVar IN NUMBER
15 );
16 PROCEDURE SET_ASCP_SUPPLIES(
17 Status OUT NOCOPY VARCHAR2,
18 PlanIdVar IN NUMBER
19 );
20 PROCEDURE SET_ASCP_SAFETY_STOCKS(
21 Status OUT NOCOPY VARCHAR2,
22 PlanIdVar IN NUMBER
23 );
24 PROCEDURE SET_ASCP_ALERTS(
25 Status OUT NOCOPY VARCHAR2,
26 PlanIdVar IN NUMBER
27 );
28 PROCEDURE SET_APCC_FACILITY_COST(
29 Status OUT NOCOPY VARCHAR2,
30 PlanIdVar IN NUMBER
31 );
32 PROCEDURE SET_ASCP_DEPARTMENT_RESOURCES(
33 Status OUT NOCOPY VARCHAR2,
34 PlanIdVar IN NUMBER
35 );
36 PROCEDURE SET_ASCP_RES_SUMMARY(
37 Status OUT NOCOPY VARCHAR2,
38 PlanIdVar IN NUMBER,
39 ScenarioNameVar OUT NOCOPY VARCHAR2
40 );
41 PROCEDURE SET_ASCP_BIS_INV_DETAIL(
42 Status OUT NOCOPY VARCHAR2,
43 PlanIdVar IN NUMBER
44 );
45 PROCEDURE SET_ASCP_SRC_RECOMMEND_DETAIL(
46 Status OUT NOCOPY VARCHAR2,
47 PlanIdVar IN NUMBER,
48 AssignmentSetOutIdVar IN NUMBER
49 );
50
51 -- =============================================================
52 --
53 -- Helper functions used defined in MSC_WS_COMMON package ( copies here ).
54 -- =============================================================
55
56 -- get plan name from plan Id
57 FUNCTION GET_PLAN_NAME_BY_PLAN_ID(
58 Status OUT NOCOPY VARCHAR2,
59 PlanId IN NUMBER
60 ) RETURN BOOLEAN ;
61 -- validate userId
62 PROCEDURE VALIDATE_USER_RESP( VRETURN OUT NOCOPY VARCHAR2,
63 USERID IN NUMBER,
64 RESPID IN NUMBER);
65
66 -- ===========================================================
67 PROCEDURE PUBLISH_SNO_RESULTS( processId OUT NOCOPY Number,
68 status OUT NOCOPY Varchar2,
69 planIdVar IN Number,
70 assignmentSetOutIdVar IN Number);
71
72 PROCEDURE VALIDATE_FOR_PUBLISH_SNO_RES( processId OUT NOCOPY Number,
73 status OUT NOCOPY Varchar2,
74 userId IN Number,
75 responsibilityId IN Number,
76 planIdVar IN Number);
77
78 PROCEDURE PUBLISH_SNO_RESULTS_WITH_VAL( processId OUT NOCOPY Number,
79 status OUT NOCOPY Varchar2,
80 userId IN Number,
81 responsibilityId IN Number,
82 planIdVar IN Number,
83 assignmentSetOutIdVar IN Number);
84
85 PROCEDURE PUBLISH_SNO_RESULTS_SOP(processId OUT NOCOPY Number,
86 status OUT NOCOPY Varchar2,
87 planIdVar IN Number );
88
89 END MSC_WS_SNO_PUBLISH;