PACKAGE: APPS.CN_DIM_HIERARCHIES_PKG

Source

1 PACKAGE cn_dim_hierarchies_pkg AS
2 --$Header: cndidhs.pls 120.3 2005/12/14 00:26:34 hanaraya noship $
3 
4 -- Procedure Name
5 --   insert_row
6 -- Purpose
7 --   Insert row into cn_dim_hierarchies
8 -- History
9 --   18-MAY-2001  mblum          Created
10 --
11 PROCEDURE insert_row
12   (x_header_dim_hierarchy_id   IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
13    x_start_date                IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
14    x_end_date                  IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
15    x_root_node                OUT NOCOPY CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,
16    x_dim_hierarchy_id         OUT NOCOPY CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
17    x_org_id                     IN CN_DIM_HIERARCHIES.ORG_ID%TYPE);
18 
19 --
20 -- Procedure Name
21 --   update_row
22 -- Purpose
23 --   Update a row in cn_dim_hierarchies
24 -- History
25 --   18-MAY-2001  mblum          Created
26 --
27 PROCEDURE update_row
28   (x_dim_hierarchy_id          IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
29    x_header_dim_hierarchy_id   IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
30    x_start_date                IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
31    x_end_date                  IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
32    x_root_node                 IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,
33    x_object_version_number     IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
34    x_org_id                     IN CN_DIM_HIERARCHIES.ORG_ID%TYPE);
35 
36 
37 
38 
39 --
40 -- Procedure Name
41 --   delete_row
42 -- Purpose
43 --   Delete a row from cn_dim_hierarchies
44 -- History
45 --   18-MAY-2001  mblum          Created
46 --
47 PROCEDURE delete_row
48   (x_dim_hierarchy_id          IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE);
49 
50 END CN_DIM_HIERARCHIES_PKG;