DBA Data[Home] [Help]

APPS.EAM_REQUEST_UTILITY_PVT dependencies on FND_GLOBAL

Line 36: last_updated_by = FND_GLOBAL.user_id,

32: SET
33: wip_entity_id = p_eam_request_rec.wip_entity_id,
34: work_request_status_id = 4,
35: last_update_date = sysdate,
36: last_updated_by = FND_GLOBAL.user_id,
37: last_update_login = fnd_global.login_id
38: WHERE work_request_id = p_eam_request_rec.request_id
39: AND organization_id = p_eam_request_rec.organization_id;
40:

Line 37: last_update_login = fnd_global.login_id

33: wip_entity_id = p_eam_request_rec.wip_entity_id,
34: work_request_status_id = 4,
35: last_update_date = sysdate,
36: last_updated_by = FND_GLOBAL.user_id,
37: last_update_login = fnd_global.login_id
38: WHERE work_request_id = p_eam_request_rec.request_id
39: AND organization_id = p_eam_request_rec.organization_id;
40:
41: END IF;

Line 79: FND_GLOBAL.USER_ID,

75: p_eam_request_rec.organization_id,
76: p_eam_request_rec.wip_entity_id,
77: p_eam_request_rec.request_id,
78: sysdate,
79: FND_GLOBAL.USER_ID,
80: FND_GLOBAL.LOGIN_ID,
81: null,--fnd_global.conc_program_id,
82: null,
83: null,

Line 80: FND_GLOBAL.LOGIN_ID,

76: p_eam_request_rec.wip_entity_id,
77: p_eam_request_rec.request_id,
78: sysdate,
79: FND_GLOBAL.USER_ID,
80: FND_GLOBAL.LOGIN_ID,
81: null,--fnd_global.conc_program_id,
82: null,
83: null,
84: null,

Line 81: null,--fnd_global.conc_program_id,

77: p_eam_request_rec.request_id,
78: sysdate,
79: FND_GLOBAL.USER_ID,
80: FND_GLOBAL.LOGIN_ID,
81: null,--fnd_global.conc_program_id,
82: null,
83: null,
84: null,
85: null,

Line 98: fnd_global.user_id,

94: null,
95: null,
96: null,
97: null,
98: fnd_global.user_id,
99: sysdate,
100: 'Y'); -- Fix for 3773450
101: END IF;
102:

Line 125: last_updated_by = FND_GLOBAL.user_id

121: UPDATE WIP_EAM_WORK_REQUESTS
122: SET wip_entity_id = null,
123: work_request_status_id = 3,
124: last_update_date = sysdate,
125: last_updated_by = FND_GLOBAL.user_id
126: WHERE work_request_id = p_eam_request_rec.request_id
127: AND organization_id = p_eam_request_rec.organization_id;
128: END IF;
129:

Line 135: last_updated_by = FND_GLOBAL.user_id,

131:
132: UPDATE EAM_WO_SERVICE_ASSOCIATION -- Fix for 3773450
133: SET enable_flag = 'N',
134: last_update_date = sysdate,
135: last_updated_by = FND_GLOBAL.user_id,
136: last_update_login = FND_GLOBAL.login_id
137: WHERE service_request_id = p_eam_request_rec.request_id
138: AND wip_entity_id = p_eam_request_rec.wip_entity_id
139: AND maintenance_organization_id = p_eam_request_rec.organization_id

Line 136: last_update_login = FND_GLOBAL.login_id

132: UPDATE EAM_WO_SERVICE_ASSOCIATION -- Fix for 3773450
133: SET enable_flag = 'N',
134: last_update_date = sysdate,
135: last_updated_by = FND_GLOBAL.user_id,
136: last_update_login = FND_GLOBAL.login_id
137: WHERE service_request_id = p_eam_request_rec.request_id
138: AND wip_entity_id = p_eam_request_rec.wip_entity_id
139: AND maintenance_organization_id = p_eam_request_rec.organization_id
140: AND (enable_flag IS NULL or enable_flag = 'Y');

Line 191: X_created_by => FND_GLOBAL.USER_ID,

187: X_to_pk2_value => to_char(p_eam_request_rec.wip_entity_id),
188: X_to_pk3_value => '',
189: X_to_pk4_value => '',
190: X_to_pk5_value => '',
191: X_created_by => FND_GLOBAL.USER_ID,
192: X_last_update_login => '',
193: X_program_application_id=> '',
194: X_program_id => '',
195: X_request_id => ''