PACKAGE: APPS.MSC_X_CUST_FACING_RELEASE

Source

1 PACKAGE MSC_X_CUST_FACING_RELEASE AUTHID CURRENT_USER AS
2 /* $Header: MSCXRSOS.pls 120.1 2011/08/11 11:17:12 vjuluri ship $     */
3 
4 G_REPLENISHMENT        CONSTANT  NUMBER := 1;
5 G_PLANNER_OVERRIDE_ATP CONSTANT  NUMBER := 2;
6 G_CONSUMPTION_ADVICE   CONSTANT  NUMBER := 3;
7 
8 G_CONSIGNED_VMI        CONSTANT NUMBER := 1;
9 G_UNCONSIGNED_VMI      CONSTANT NUMBER := 2;
10 
11 G_REPLENISHMENT_ORDER        CONSTANT  NUMBER := 19;
12 
13 SYS_YES  CONSTANT NUMBER := 1;
14 SYS_NO   CONSTANT NUMBER := 2;
15 
16 G_UNRELEASED CONSTANT  NUMBER := 0;
17 G_RELEASED   CONSTANT  NUMBER := 1;
18 
19 G_CREATE CONSTANT NUMBER := 1;
20 G_UPDATE CONSTANT NUMBER := 2;
21 
22 G_OEM_ID CONSTANT NUMBER := 1;
23 
24 G_SUCCESS  CONSTANT NUMBER := 0;
25 G_WARNING  CONSTANT NUMBER := 1;
26 G_ERROR    CONSTANT NUMBER := 2;
27 
28 G_SUCCESSFUL  CONSTANT NUMBER := 1;
29 
30 PROCEDURE VMI_RELEASE
31   ( itemtype  in varchar2,
32     itemkey   in varchar2,
33     actid     in number,
34     funcmode  in varchar2,
35     resultout out nocopy varchar2
36   );
37 
38 PROCEDURE SCHEDULE_DATE_CHANGED
39   ( itemtype  in varchar2,
40     itemkey   in varchar2,
41     actid     in number,
42     funcmode  in varchar2,
43     resultout out nocopy varchar2
44   );
45 
46 PROCEDURE UPDATE_SO_ATP_OVERRIDE
47   ( itemtype  in varchar2,
48     itemkey   in varchar2,
49     actid     in number,
50     funcmode  in varchar2,
51     resultout out nocopy varchar2
52   );
53 
54 PROCEDURE DELETE_INTERFACE_RECORD
55   ( itemtype  in varchar2,
56     itemkey   in varchar2,
57     actid     in number,
58     funcmode  in varchar2,
59     resultout out nocopy varchar2
60   );
61 
62 PROCEDURE IS_CONSIGNED_VMI
63   ( itemtype  in varchar2,
64     itemkey   in varchar2,
65     actid     in number,
66     funcmode  in varchar2,
67     resultout out nocopy varchar2
68   );
69 
70 PROCEDURE CREATE_VMI_RELEASE( ERRBUF    OUT NOCOPY VARCHAR2,
71 			      RETCODE   OUT NOCOPY NUMBER,
72 			      pItem_name          in varchar2,
73 			      pCustomer_name      in varchar2,
74 			      pCustomer_site_name in varchar2,
75 			      itemtype            in varchar2,
76 			      itemkey             in varchar2,
77 			      pRelease_ID         in number,
78 			      pDestination        in number,
79           p_instance_id IN  NUMBER,
80           p_instance_code  IN  VARCHAR2,
81           p_a2m_dblink IN  VARCHAR2
82 			       );
83 
84 END MSC_X_CUST_FACING_RELEASE;