PACKAGE: APPS.MSD_DEM_SOP

Source

1 PACKAGE MSD_DEM_SOP AUTHID CURRENT_USER AS
2 /* $Header: msddemsops.pls 120.2.12000000.2 2007/09/24 11:25:19 nallkuma noship $ */
3 
4 
5    /*** GLOBAL VARIABLES ***/
6    G_YES 		NUMBER	:= MSD_DEM_COMMON_UTILITIES.C_YES;
7    G_NO			NUMBER	:= MSD_DEM_COMMON_UTILITIES.C_NO;
8    G_SCI_BACKLOG 	NUMBER 	:= 1;
9    G_SCI_OTHER   	NUMBER 	:= 2;
10    /* MSD DEM Debug Profile Value */
11    C_MSD_DEM_DEBUG   		VARCHAR2(1)   := nvl( fnd_profile.value( 'MSD_DEM_DEBUG_MODE'), 'N');
12    C_MSD_DEM_PUSH_TIME		VARCHAR2(1)   := 'Y';
13    /* ASCP Series Ids */
14    C_MSD_DEM_SOP_ITEM_COST      NUMBER := 111;
15 
16 
17 
18    /*** PROCEDURES ***
19     * SET_PLAN_ATTRIBUTES
20     * LOAD_PLAN_DATA
21     * LOAD_PLAN_MEMBERS
22     * POST_DOWNLOAD_HOOK
23     * LOAD_ITEM_COST
24     * WAIT_UNTIL_DOWNLOAD_COMPLETE
25     * COLLECT_SCI_DATA
26     * LAUNCH_SCI_DATA_LOADS
27     */
28 
29 
30       /*
31        *
32        */
33       PROCEDURE SET_PLAN_ATTRIBUTES (
34       			p_member_id			IN	   NUMBER );
35 
36 
37       /*
38        *
39        */
40       PROCEDURE LOAD_PLAN_DATA (
41       			p_member_id			IN	   NUMBER );
42 
43 
44       /*
45        *
46        */
47       PROCEDURE LOAD_PLAN_MEMBERS;
48 
49 
50       /*
51        *
52        */
53       PROCEDURE POST_DOWNLOAD_HOOK (
54       			p_member_id			IN	   NUMBER );
55 
56 
57       /*
58        * This procedure loads item cost information from planning server ODS
59        * for all DM enabled organizations into the import integration
60        * staging table - BIIO_ITEM_COST
61        */
62       PROCEDURE LOAD_ITEM_COST;
63 
64 
65       /*
66        * This procedure is called by the Wait step of the Download Plan Scenario Data workflow.
67        *
68        */
69       PROCEDURE WAIT_UNTIL_DOWNLOAD_COMPLETE;
70 
71 
72       /*
73        *
74        */
75       PROCEDURE COLLECT_SCI_DATA (
76       			errbuf				OUT NOCOPY VARCHAR2,
77       			retcode				OUT NOCOPY VARCHAR2,
78       			p_sr_instance_id		IN	   NUMBER,
79       			p_collection_group      	IN         VARCHAR2 DEFAULT '-999',
80       			p_collection_method     	IN         NUMBER,
81       			p_hidden_param1			IN	   VARCHAR2,
82       			p_date_range_type		IN	   NUMBER,
83       			p_collection_window		IN	   NUMBER,
84       			p_from_date			IN	   VARCHAR2,
85       			p_to_date			IN	   VARCHAR2 );
86 
87 
88       /*
89        *
90        */
91       PROCEDURE LAUNCH_SCI_DATA_LOADS (
92       			errbuf				OUT NOCOPY VARCHAR2,
93       			retcode				OUT NOCOPY VARCHAR2,
94       			p_sr_instance_id		IN	   NUMBER,
95       			p_collection_group      	IN         VARCHAR2 DEFAULT '-999',
96       			p_collection_method     	IN         NUMBER,
97       			p_date_range_type		IN	   NUMBER,
98       			p_collection_window		IN	   NUMBER,
99       			p_from_date			IN	   VARCHAR2,
100       			p_to_date			IN	   VARCHAR2,
101       			p_entity                        IN         NUMBER );
102 
103 END MSD_DEM_SOP;