[Home] [Help]
PACKAGE: APPS.MSD_COLLECT_LEVEL_VALUES
Source
1 PACKAGE MSD_COLLECT_LEVEL_VALUES AUTHID CURRENT_USER AS
2 /* $Header: msdclvls.pls 120.0 2005/05/25 20:31:05 appldev noship $ */
3
4 -- C_SOP CONSTANT NUMBER := 1; --jarorad
5 -- C_DP CONSTANT NUMBER := 2; --jarorad
6
7 C_MSC_DEBUG VARCHAR2(1) := nvl(FND_PROFILE.Value('MRP_DEBUG'),'N');
8
9 procedure collect_data(
10 errbuf OUT NOCOPY VARCHAR2,
11 retcode OUT NOCOPY VARCHAR2,
12 p_instance_id IN NUMBER,
13 p_collection_type IN VARCHAR2,
14 p_collection_var IN VARCHAR2);
15 -- ,p_launched_from IN NUMBER DEFAULT NULL); --jarorad
16
17 procedure collect_level_parent_data(
18 errbuf OUT NOCOPY VARCHAR2,
19 retcode OUT NOCOPY VARCHAR2,
20 p_instance_id IN NUMBER,
21 p_level_id IN NUMBER,
22 p_parent_level_id IN NUMBER,
23 p_update_lvl_table IN NUMBER);
24
25 procedure collect_level_data(
26 errbuf OUT NOCOPY VARCHAR2,
27 retcode OUT NOCOPY VARCHAR2,
28 p_instance_id IN NUMBER,
29 p_level_id IN NUMBER);
30
31 procedure collect_hierarchy_data(
32 errbuf OUT NOCOPY VARCHAR2,
33 retcode OUT NOCOPY VARCHAR2,
34 p_instance_id IN NUMBER,
35 p_hierarchy_id IN NUMBER);
36
37 procedure collect_dimension_data(
38 errbuf OUT NOCOPY VARCHAR2,
39 retcode OUT NOCOPY VARCHAR2,
40 p_instance_id IN NUMBER,
41 p_dimension_code IN VARCHAR2);
42
43 procedure collect_dp_dimension_data(
44 errbuf OUT NOCOPY VARCHAR2,
45 retcode OUT NOCOPY VARCHAR2,
46 p_instance_id IN NUMBER,
47 p_demand_plan_id IN NUMBER,
48 p_dimension_code IN VARCHAR2);
49
50 procedure collect_demand_plan_data(
51 errbuf OUT NOCOPY VARCHAR2,
52 retcode OUT NOCOPY VARCHAR2,
53 p_instance_id IN NUMBER,
54 p_demand_plan_id IN NUMBER);
55
56 procedure collect_all_data(
57 errbuf OUT NOCOPY VARCHAR2,
58 retcode OUT NOCOPY VARCHAR2,
59 p_instance_id IN NUMBER);
60
61
62 procedure fix_orphans(p_instance_id in number,
63 p_level_id in number,
64 p_dest_table in varchar2,
65 p_dest_ass_table in varchar2,
66 p_hierarchy_id in number);
67
68 Procedure Delete_duplicate_lvl_assoc( errbuf OUT NOCOPY VARCHAR2,
69 retcode OUT NOCOPY VARCHAR2,
70 p_instance_id in number);
71
72 FUNCTION get_dest_table return varchar2;
73 FUNCTION get_assoc_table return varchar2;
74
75 END MSD_COLLECT_LEVEL_VALUES ;