DBA Data[Home] [Help]

APPS.JTS_CONFIG_VERSION_FLOW_PVT dependencies on FND_GLOBAL

Line 70: last_updated_by = FND_GLOBAL.user_id,

66:
67: --propagate the changes up the root for last update fields
68: UPDATE jts_config_version_flows
69: SET complete_flag = p_complete_flag,
70: last_updated_by = FND_GLOBAL.user_id,
71: last_update_login = FND_GLOBAL.user_id,
72: last_update_date = sysdate
73: WHERE version_id = p_version_id
74: AND flow_id = p_flow_id;

Line 71: last_update_login = FND_GLOBAL.user_id,

67: --propagate the changes up the root for last update fields
68: UPDATE jts_config_version_flows
69: SET complete_flag = p_complete_flag,
70: last_updated_by = FND_GLOBAL.user_id,
71: last_update_login = FND_GLOBAL.user_id,
72: last_update_date = sysdate
73: WHERE version_id = p_version_id
74: AND flow_id = p_flow_id;
75:

Line 83: SET last_updated_by = FND_GLOBAL.user_id,

79: WHILE (l_flow_id IS NOT NULL) LOOP
80: l_parent_id := JTS_SETUP_FLOW_PVT.GET_PARENT_FLOW_ID(l_flow_id);
81: IF (l_parent_id IS NOT NULL) THEN --not at root level yet
82: UPDATE jts_config_version_flows
83: SET last_updated_by = FND_GLOBAL.user_id,
84: last_update_login = FND_GLOBAL.user_id,
85: last_update_date = sysdate
86: WHERE version_id = p_version_id
87: AND flow_id = l_flow_id;

Line 84: last_update_login = FND_GLOBAL.user_id,

80: l_parent_id := JTS_SETUP_FLOW_PVT.GET_PARENT_FLOW_ID(l_flow_id);
81: IF (l_parent_id IS NOT NULL) THEN --not at root level yet
82: UPDATE jts_config_version_flows
83: SET last_updated_by = FND_GLOBAL.user_id,
84: last_update_login = FND_GLOBAL.user_id,
85: last_update_date = sysdate
86: WHERE version_id = p_version_id
87: AND flow_id = l_flow_id;
88: END IF;

Line 135: FND_GLOBAL.user_id, --created_by

131: p_flow_hiearchy(I).flow_id,
132: 'N',
133: 1,
134: sysdate,
135: FND_GLOBAL.user_id, --created_by
136: sysdate,
137: FND_GLOBAL.user_id,
138: FND_GLOBAL.user_id
139: );

Line 137: FND_GLOBAL.user_id,

133: 1,
134: sysdate,
135: FND_GLOBAL.user_id, --created_by
136: sysdate,
137: FND_GLOBAL.user_id,
138: FND_GLOBAL.user_id
139: );
140: END LOOP;
141:

Line 138: FND_GLOBAL.user_id

134: sysdate,
135: FND_GLOBAL.user_id, --created_by
136: sysdate,
137: FND_GLOBAL.user_id,
138: FND_GLOBAL.user_id
139: );
140: END LOOP;
141:
142: EXCEPTION