APPS.CN_DIHY_TWO_API_PKG dependencies on FND_GLOBAL

Line 40: fnd_global.user_id, sysdate,

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:

Line 41: fnd_global.user_id, sysdate, fnd_global.login_id,X_org_id);

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

Line 74: fnd_global.user_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);

Line 76: fnd_global.login_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

Line 78: fnd_global.user_id,X_org_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
81:
82: DELETE cn_hierarchy_edges

Line 122: last_updated_by = fnd_global.user_id,

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

Line 124: last_update_login = fnd_global.login_id

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

Line 132: last_updated_by = fnd_global.user_id,

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

Line 134: last_update_login = fnd_global.login_id

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