DBA Data[Home] [Help]

APPS.CN_DIM_HIERARCHIES_PKG dependencies on FND_GLOBAL

Line 53: fnd_global.user_id,

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);

Line 54: fnd_global.login_id,

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:

Line 56: fnd_global.user_id,

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

Line 67: fnd_global.user_id, sysdate,

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

Line 68: fnd_global.user_id, sysdate, fnd_global.login_id);

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

Line 111: last_updated_by = fnd_global.user_id,

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;

Line 112: last_update_login = fnd_global.login_id,

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: