APPS.CN_DIM_HIERARCHIES_PKG dependencies on CN_DIM_HIERARCHIES_S

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