1 package ZPB_DHMInterface_GRP as
2 /* $Header: ZPBGDHMS.pls 120.0.12010.2 2005/12/23 06:00:56 appldev noship $ */
3
4 -- API name : Get_Business_Area_Info
5 -- Type : Group
6 -- Function : Returns the Business Area ID and Ledger ID for the
7 -- current user session
8 -- Pre-reqs : None.
9 -- Parameters :
10 --
11 -- OUT : x_business_area_id OUT NUMBER
12 -- x_ledger_id OUT NUMBER
13 --
14 procedure Get_Business_Area_Info
15 (x_business_area_id OUT NOCOPY ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type,
16 x_ledger_id OUT NOCOPY FEM_LEDGERS_B.LEDGER_ID%type,
17 x_snapshot_id OUT NOCOPY NUMBER);
18
19 -- API name : Export_Dimension
20 -- Type : Group
21 -- Function : Exports the metadata from the Personal AW to the FEM personal
22 -- tables for DHM use
23 -- Pre-reqs : None.
24 -- Parameters :
25 -- IN : p_api_version IN NUMBER Required
26 -- p_init_msg_list IN VARCHAR2 Optional Default = G_FALSE
27 -- p_commit IN VARCHAR2 Optional Default = G_FALSE
28 -- p_validation_level IN NUMBER Optional Default = G_VALID_LEVEL_FULL
29 -- p_dimension_id IN NUMBER The FEM dimension ID
30 -- p_user_id IN NUMBER The FND_USER user_id
31 -- p_attr_id IN VARCHAR2 The EPB attribute id (EPB-only)
32 --
33 -- OUT : x_return_status OUT VARCHAR2(1)
34 -- x_msg_count OUT NUMBER
35 -- x_msg_data OUT VARCHAR2(2000)
36 --
37 -- Version : Current version 1.0
38 -- Initial version 1.0
39 --
40 -- Notes : None
41 --
42 procedure Transfer_To_DHM
43 (p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
45 p_commit IN VARCHAR2 := FND_API.G_FALSE,
46 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 p_dimension_id IN NUMBER,
51 p_user_id IN NUMBER,
52 p_attr_id IN VARCHAR2 := NULL);
53
54 -- API name : Import_Dimension
55 -- Type : Group
56 -- Function : Imports the metadata from the FEM personal tables back into the
57 -- Personal AW
58 -- Pre-reqs : None.
59 -- Parameters :
60 -- IN : p_api_version IN NUMBER Required
61 -- p_init_msg_list IN VARCHAR2 Optional Default = G_FALSE
62 -- p_commit IN VARCHAR2 Optional Default = G_FALSE
63 -- p_validation_level IN NUMBER Optional Default = G_VALID_LEVEL_FULL
64 -- p_dimension_id IN NUMBER The FEM dimension ID
65 -- p_user_id IN NUMBER The FND_USER user_id
66 --
67 -- OUT : x_return_status OUT VARCHAR2(1)
68 -- x_msg_count OUT NUMBER
69 -- x_msg_data OUT VARCHAR2(2000)
70 --
71 -- Version : Current version 1.0
72 -- Initial version 1.0
73 --
74 -- Notes : None
75 --
76 procedure Transfer_To_EPB
77 (p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79 p_commit IN VARCHAR2 := FND_API.G_FALSE,
80 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_dimension_id IN NUMBER,
85 p_user_id IN NUMBER,
86 p_attr_id IN VARCHAR2 := NULL);
87
88 end ZPB_DHMInterface_GRP;