DBA Data[Home] [Help]

PACKAGE: APPS.ZPB_DHMINTERFACE_GRP

Source


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;