eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_DIM_HIERARCHIES_PKG dependencies on CN_DIM_HIERARCHIES

Line 1: PACKAGE cn_dim_hierarchies_pkg AUTHID CURRENT_USER AS

1: PACKAGE cn_dim_hierarchies_pkg AUTHID CURRENT_USER AS
2: --$Header: cndidhs.pls 120.3 2005/12/14 00:26:34 hanaraya noship $
3:
4: -- Procedure Name
5: -- insert_row

Line 7: -- Insert row into cn_dim_hierarchies

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

Line 12: (x_header_dim_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,

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,

Line 13: x_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,

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);

Line 14: x_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,

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:

Line 15: x_root_node OUT NOCOPY CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,

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: --

Line 16: x_dim_hierarchy_id OUT NOCOPY CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,

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

Line 17: x_org_id IN CN_DIM_HIERARCHIES.ORG_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

Line 23: -- Update a row in cn_dim_hierarchies

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

Line 28: (x_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,

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,

Line 29: x_header_dim_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,

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,

Line 30: x_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,

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);

Line 31: x_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,

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:

Line 32: x_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,

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:

Line 33: x_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%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:

Line 34: x_org_id IN CN_DIM_HIERARCHIES.ORG_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:

Line 43: -- Delete a row from cn_dim_hierarchies

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

Line 48: (x_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE);

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;

Line 50: END CN_DIM_HIERARCHIES_PKG;

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;