49: x_end_date,
50: null,
51: x_header_dim_hierarchy_id,
52: sysdate,
53: fnd_global.user_id,
54: fnd_global.login_id,
55: sysdate,
56: fnd_global.user_id,
57: 1);
50: null,
51: x_header_dim_hierarchy_id,
52: sysdate,
53: fnd_global.user_id,
54: fnd_global.login_id,
55: sysdate,
56: fnd_global.user_id,
57: 1);
58:
52: sysdate,
53: fnd_global.user_id,
54: fnd_global.login_id,
55: sysdate,
56: fnd_global.user_id,
57: 1);
58:
59: -- create new root node
60: INSERT INTO cn_hierarchy_nodes
63: last_updated_by, last_update_date, last_update_login)
64: VALUES
65: (X_dim_hierarchy_id,x_org_id, X_root_node, -- MOAC Change
66: fnd_message.get_string('CN', 'CN_BASE_NODE'),
67: fnd_global.user_id, sysdate,
68: fnd_global.user_id, sysdate, fnd_global.login_id);
69:
70: -- create base node
71: CN_DIHY_TWO_API_PKG.Insert_Edge
64: VALUES
65: (X_dim_hierarchy_id,x_org_id, X_root_node, -- MOAC Change
66: fnd_message.get_string('CN', 'CN_BASE_NODE'),
67: fnd_global.user_id, sysdate,
68: fnd_global.user_id, sysdate, fnd_global.login_id);
69:
70: -- create base node
71: CN_DIHY_TWO_API_PKG.Insert_Edge
72: (X_name => fnd_message.get_string('CN', 'CN_BASE_NODE'),
107: end_date = x_end_date,
108: root_node = x_root_node,
109: header_dim_hierarchy_id = x_header_dim_hierarchy_id,
110: last_update_date = sysdate,
111: last_updated_by = fnd_global.user_id,
112: last_update_login = fnd_global.login_id,
113: object_version_number = x_object_version_number
114: where dim_hierarchy_id = x_dim_hierarchy_id;
115: END Update_Row;
108: root_node = x_root_node,
109: header_dim_hierarchy_id = x_header_dim_hierarchy_id,
110: last_update_date = sysdate,
111: last_updated_by = fnd_global.user_id,
112: last_update_login = fnd_global.login_id,
113: object_version_number = x_object_version_number
114: where dim_hierarchy_id = x_dim_hierarchy_id;
115: END Update_Row;
116: