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 BODY cn_dim_hierarchies_pkg AS

1: PACKAGE BODY cn_dim_hierarchies_pkg AS
2: --$Header: cndidhb.pls 120.4 2005/12/14 00:26:17 hanaraya ship $
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) IS

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) IS
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) IS
18:
19: BEGIN

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) IS
18:
19: BEGIN
20: -- get the next pk from sequence

Line 17: x_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE) IS

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) IS
18:
19: BEGIN
20: -- get the next pk from sequence
21: SELECT cn_dim_hierarchies_s.nextval

Line 21: SELECT cn_dim_hierarchies_s.nextval

17: x_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE) IS
18:
19: BEGIN
20: -- get the next pk from sequence
21: SELECT cn_dim_hierarchies_s.nextval
22: INTO x_dim_hierarchy_id
23: FROM dual;
24:
25: SELECT cn_hierarchy_nodes_s.nextval

Line 32: INSERT into cn_dim_hierarchies

28:
29:
30:
31: -- create hierarchy
32: INSERT into cn_dim_hierarchies
33: (dim_hierarchy_id,
34: org_id, --MOAC
35: start_date,
36: end_date,

Line 80: Update cn_dim_hierarchies

76: X_external_id => null,
77: X_hierarchy_api_id => NULL, -- not used
78: x_org_id => x_org_id);
79:
80: Update cn_dim_hierarchies
81: Set root_node = x_root_node
82: Where dim_hierarchy_id = x_dim_hierarchy_id;
83:
84:

Line 91: -- Update a row in cn_dim_hierarchies

87: --
88: -- Procedure Name
89: -- update_row
90: -- Purpose
91: -- Update a row in cn_dim_hierarchies
92: -- History
93: -- 18-MAY-2001 mblum Created
94: --
95: PROCEDURE update_row

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

92: -- History
93: -- 18-MAY-2001 mblum Created
94: --
95: PROCEDURE update_row
96: (x_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
97: x_header_dim_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
98: x_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
99: x_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
100: x_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,

Line 97: x_header_dim_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,

93: -- 18-MAY-2001 mblum Created
94: --
95: PROCEDURE update_row
96: (x_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
97: x_header_dim_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
98: x_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
99: x_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
100: x_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,
101: x_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,

Line 98: x_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,

94: --
95: PROCEDURE update_row
96: (x_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
97: x_header_dim_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
98: x_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
99: x_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
100: x_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,
101: x_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
102: x_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE) IS

Line 99: x_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,

95: PROCEDURE update_row
96: (x_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
97: x_header_dim_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
98: x_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
99: x_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
100: x_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,
101: x_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
102: x_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE) IS
103: BEGIN

Line 100: x_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,

96: (x_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
97: x_header_dim_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
98: x_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
99: x_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
100: x_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,
101: x_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
102: x_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE) IS
103: BEGIN
104: x_object_version_number := x_object_version_number + 1;

Line 101: x_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,

97: x_header_dim_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
98: x_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
99: x_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
100: x_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,
101: x_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
102: x_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE) IS
103: BEGIN
104: x_object_version_number := x_object_version_number + 1;
105: update cn_dim_hierarchies set

Line 102: x_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE) IS

98: x_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
99: x_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
100: x_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,
101: x_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
102: x_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE) IS
103: BEGIN
104: x_object_version_number := x_object_version_number + 1;
105: update cn_dim_hierarchies set
106: start_date = x_start_date,

Line 105: update cn_dim_hierarchies set

101: x_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
102: x_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE) IS
103: BEGIN
104: x_object_version_number := x_object_version_number + 1;
105: update cn_dim_hierarchies set
106: start_date = x_start_date,
107: end_date = x_end_date,
108: root_node = x_root_node,
109: header_dim_hierarchy_id = x_header_dim_hierarchy_id,

Line 122: -- Delete a row from cn_dim_hierarchies

118: --
119: -- Procedure Name
120: -- delete_row
121: -- Purpose
122: -- Delete a row from cn_dim_hierarchies
123: -- History
124: -- 18-MAY-2001 mblum Created
125: --
126: PROCEDURE delete_row

Line 127: (x_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE) IS

123: -- History
124: -- 18-MAY-2001 mblum Created
125: --
126: PROCEDURE delete_row
127: (x_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE) IS
128: BEGIN
129: DELETE from cn_dim_hierarchies
130: WHERE dim_hierarchy_id = x_dim_hierarchy_id;
131: if (sql%notfound) then

Line 129: DELETE from cn_dim_hierarchies

125: --
126: PROCEDURE delete_row
127: (x_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE) IS
128: BEGIN
129: DELETE from cn_dim_hierarchies
130: WHERE dim_hierarchy_id = x_dim_hierarchy_id;
131: if (sql%notfound) then
132: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
133: fnd_msg_pub.add;

Line 146: END CN_DIM_HIERARCHIES_PKG;

142:
143: END Delete_Row;
144:
145:
146: END CN_DIM_HIERARCHIES_PKG;