1 PACKAGE MSC_WS_SNO_PUBLISH AS
2 /* $Header: MSCWSPBS.pls 120.6.12010000.1 2008/05/02 19:09:23 appldev 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_ASCP_DEPARTMENT_RESOURCES(
29 Status OUT NOCOPY VARCHAR2,
30 PlanIdVar IN NUMBER
31 );
32 PROCEDURE SET_ASCP_RES_SUMMARY(
33 Status OUT NOCOPY VARCHAR2,
34 PlanIdVar IN NUMBER,
35 ScenarioNameVar OUT NOCOPY VARCHAR2
36 );
37 PROCEDURE SET_ASCP_BIS_INV_DETAIL(
38 Status OUT NOCOPY VARCHAR2,
39 PlanIdVar IN NUMBER
40 );
41 PROCEDURE SET_ASCP_SRC_RECOMMEND_DETAIL(
42 Status OUT NOCOPY VARCHAR2,
43 PlanIdVar IN NUMBER,
44 AssignmentSetOutIdVar IN NUMBER
45 );
46
47 -- =============================================================
48 --
49 -- Helper functions used defined in MSC_WS_COMMON package ( copies here ).
50 -- =============================================================
51
52 -- get plan name from plan Id
53 FUNCTION GET_PLAN_NAME_BY_PLAN_ID(
54 Status OUT NOCOPY VARCHAR2,
55 PlanId IN NUMBER
56 ) RETURN BOOLEAN ;
57 -- validate userId
58 PROCEDURE VALIDATE_USER_RESP( VRETURN OUT NOCOPY VARCHAR2,
59 USERID IN NUMBER,
60 RESPID IN NUMBER);
61
62 -- ===========================================================
63 PROCEDURE PUBLISH_SNO_RESULTS( processId OUT NOCOPY Number,
64 status OUT NOCOPY Varchar2,
65 planIdVar IN Number,
66 assignmentSetOutIdVar IN Number);
67
68 PROCEDURE VALIDATE_FOR_PUBLISH_SNO_RES( processId OUT NOCOPY Number,
69 status OUT NOCOPY Varchar2,
70 userId IN Number,
71 responsibilityId IN Number,
72 planIdVar IN Number);
73 PROCEDURE PUBLISH_SNO_RESULTS_WITH_VAL( processId OUT NOCOPY Number,
74 status OUT NOCOPY Varchar2,
75 userId IN Number,
76 responsibilityId IN Number,
77 planIdVar IN Number,
78 assignmentSetOutIdVar IN Number);
79
80 END MSC_WS_SNO_PUBLISH;