[Home] [Help]
PACKAGE: APPS.MSC_M2A_PUSH
Source
1 PACKAGE MSC_M2A_PUSH AS -- specification
2 /* $Header: MSCPUSHS.pls 120.0 2005/05/25 19:27:59 appldev noship $ */
3
4 -- CONSTANTS --
5 SYS_YES CONSTANT INTEGER := 1;
6 SYS_NO CONSTANT INTEGER := 2;
7
8 G_SUCCESS CONSTANT NUMBER := 0;
9 G_WARNING CONSTANT NUMBER := 1;
10 G_ERROR CONSTANT NUMBER := 2;
11 G_MPS_IND CONSTANT NUMBER := 2;
12
13 G_APPS107 CONSTANT NUMBER := 1;
14 G_APPS110 CONSTANT NUMBER := 2;
15 G_APPS115 CONSTANT NUMBER := 3;
16
17
18 -- Misc --
19 NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
20
21 -- ================= Procedures ====================
22
23 PROCEDURE PUSH_PLAN_INFO(
24 ERRBUF OUT NOCOPY VARCHAR2,
25 RETCODE OUT NOCOPY NUMBER,
26 pINSTANCE_ID IN NUMBER,
27 pPLAN_TYPE IN VARCHAR2, -- dummy arg
28 pDESIGNATOR IN VARCHAR2 := NULL,
29 pBUY_ORDERS_ONLY IN NUMBER := SYS_YES,
30 pDEMAND IN NUMBER default 1,
31 pORGANIZATION_ID IN NUMBER,
32 pPLANNER IN VARCHAR2,
33 pCATEGORY_ID IN NUMBER,
34 pITEM_ID IN NUMBER,
35 pDUMMY2 IN NUMBER,
36 pSUPPLIER_ID IN NUMBER,
37 pDUMMY3 IN NUMBER,
38 pSUPPLIER_SITE_ID IN NUMBER,
39 pHORIZON_START_DATE IN VARCHAR2,
40 pHORIZON_END_DATE IN VARCHAR2); --for bug 3073566
41
42 END MSC_M2A_PUSH;