[Home] [Help]
PACKAGE: APPS.MSC_E1APS_UTIL
Source
1 PACKAGE MSC_E1APS_UTIL AUTHID CURRENT_USER AS
2 --# $Header: MSCE1ULS.pls 120.5 2011/02/18 12:45:23 sravinoo noship $
3
4 /* Contants */
5
6 COL_PLAN_DATA CONSTANT NUMBER := 1;
7 PUB_PLAN_RES CONSTANT NUMBER := 2;
8 COL_SALES_HST CONSTANT NUMBER := 3;
9 COL_PRC_UOM CONSTANT NUMBER := 4;
10 PUB_FCST CONSTANT NUMBER := 5;
11 COL_PTP_DATA CONSTANT NUMBER := 6;
12 PUB_PTP_RES CONSTANT NUMBER := 7;
13 COL_DSM_DATA CONSTANT NUMBER := 8;
14 PUB_DSM_RES CONSTANT NUMBER := 9;
15
16 /*Consants for Demantra workflow*/
17
18 DEM_SUCCESS CONSTANT NUMBER := 0;
19 DEM_WARNING CONSTANT NUMBER := 1;
20 DEM_FAILURE CONSTANT NUMBER := 2;
21
22
23 FUNCTION MSC_E1APS_ODIScenarioExecute ( ScenarioName IN VARCHAR2,
24 ScenarioVersion IN VARCHAR2,
25 ScenarioParam IN VARCHAR2,
26 WsUrl IN VARCHAR2 )
27 RETURN VARCHAR2;
28 FUNCTION MSC_E1APS_ODIInitialize ( WsUrl IN VARCHAR2,
29 BaseDate INTEGER )
30 RETURN VARCHAR2;
31 FUNCTION MSC_E1APS_ODIScenExecute10g ( ScenarioName IN VARCHAR2,
32 ScenarioVersion IN VARCHAR2,
33 ScenarioParam IN VARCHAR2,
34 WsUrl IN VARCHAR2 )
35 RETURN VARCHAR2;
36
37 FUNCTION MSC_E1APS_ODIInitialize10g ( WsUrl IN VARCHAR2,
38 BaseDate INTEGER )
39 RETURN VARCHAR2;
40 PROCEDURE DEM_WORKFLOW(errbuf OUT NOCOPY VARCHAR2 ,
41 retcode OUT NOCOPY VARCHAR2 ,
42 l_wf_lookup_code IN VARCHAR2 ,
43 process_id OUT NOCOPY VARCHAR2 ,
44 p_user_id IN NUMBER);
45 FUNCTION PUBLISH_DEM_WORKFLOW(ERRBUF OUT NOCOPY VARCHAR2 ,
46 RETCODE OUT NOCOPY VARCHAR2 ,
47 p_instance_id IN NUMBER ,
48 l_wf_lookup_code IN VARCHAR2 ,
49 scenario_name IN VARCHAR2 ,
50 p_user_id IN NUMBER)
51 RETURN NUMBER;
52 FUNCTION OdiSessionStatus(scenario_name IN VARCHAR2 )
53 RETURN Boolean;
54
55 PROCEDURE UPDATE_TP_SITE_CODE(errbuf OUT NOCOPY VARCHAR2,
56 retcode OUT NOCOPY VARCHAR2,
57 parInstanceID IN VARCHAR2,
58 updateFlag IN NUMBER );
59 FUNCTION GetODIErrorMessage (Session_no IN VARCHAR2)
60 RETURN VARCHAR2;
61 END MSC_E1APS_UTIL;