36: CREATED_BY, CREATION_DATE,
37: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,ORG_ID)
38: VALUES
39: (X_value_id, X_name, X_dim_hierarchy_id, X_external_id,
40: fnd_global.user_id, sysdate,
41: fnd_global.user_id, sysdate, fnd_global.login_id,X_org_id);
42:
43: ELSE
44:
37: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,ORG_ID)
38: VALUES
39: (X_value_id, X_name, X_dim_hierarchy_id, X_external_id,
40: fnd_global.user_id, sysdate,
41: fnd_global.user_id, sysdate, fnd_global.login_id,X_org_id);
42:
43: ELSE
44:
45: SELECT value_id
70: (X_dim_hierarchy_id,
71: X_value_id,
72: X_parent_value_id,
73: x_hierarchy_api_id,
74: fnd_global.user_id,
75: sysdate,
76: fnd_global.login_id,
77: sysdate,
78: fnd_global.user_id,X_org_id);
72: X_parent_value_id,
73: x_hierarchy_api_id,
74: fnd_global.user_id,
75: sysdate,
76: fnd_global.login_id,
77: sysdate,
78: fnd_global.user_id,X_org_id);
79:
80: IF (X_parent_value_id IS NOT NULL) THEN
74: fnd_global.user_id,
75: sysdate,
76: fnd_global.login_id,
77: sysdate,
78: fnd_global.user_id,X_org_id);
79:
80: IF (X_parent_value_id IS NOT NULL) THEN
81:
82: DELETE cn_hierarchy_edges
118:
119: UPDATE cn_objects SET user_column_name = 'Y',
120: dimension_id = X_dimension_id,
121: primary_key = 'N',
122: last_updated_by = fnd_global.user_id,
123: last_update_date = sysdate,
124: last_update_login = fnd_global.login_id
125: WHERE object_id = X_user_column_name_id
126: --R12 MOAC Changes--Start
120: dimension_id = X_dimension_id,
121: primary_key = 'N',
122: last_updated_by = fnd_global.user_id,
123: last_update_date = sysdate,
124: last_update_login = fnd_global.login_id
125: WHERE object_id = X_user_column_name_id
126: --R12 MOAC Changes--Start
127: and org_id = X_org_id;
128: --R12 MOAC Changes--End
128: --R12 MOAC Changes--End
129:
130: UPDATE cn_objects SET primary_key = 'Y',
131: dimension_id = X_dimension_id,
132: last_updated_by = fnd_global.user_id,
133: last_update_date = sysdate,
134: last_update_login = fnd_global.login_id
135: WHERE object_id = X_primary_key_id
136: --R12 MOAC Changes--Start
130: UPDATE cn_objects SET primary_key = 'Y',
131: dimension_id = X_dimension_id,
132: last_updated_by = fnd_global.user_id,
133: last_update_date = sysdate,
134: last_update_login = fnd_global.login_id
135: WHERE object_id = X_primary_key_id
136: --R12 MOAC Changes--Start
137: and org_id = X_org_id;
138: --R12 MOAC Changes--End