DBA Data[Home] [Help]

APPS.EAM_WO_COMP_UTILITY_PVT dependencies on FND_GLOBAL

Line 129: FND_GLOBAL.user_id,

125: p_eam_wo_comp_rec.qa_collection_id,
126: p_eam_wo_comp_rec.actual_start_date,
127: p_eam_wo_comp_rec.actual_end_date,
128: p_eam_wo_comp_rec.actual_duration,
129: FND_GLOBAL.user_id,
130: sysdate,
131: FND_GLOBAL.user_id,
132: sysdate,
133: FND_GLOBAL.login_id,

Line 131: FND_GLOBAL.user_id,

127: p_eam_wo_comp_rec.actual_end_date,
128: p_eam_wo_comp_rec.actual_duration,
129: FND_GLOBAL.user_id,
130: sysdate,
131: FND_GLOBAL.user_id,
132: sysdate,
133: FND_GLOBAL.login_id,
134: p_eam_wo_comp_rec.request_id,
135: p_eam_wo_comp_rec.program_application_id,

Line 133: FND_GLOBAL.login_id,

129: FND_GLOBAL.user_id,
130: sysdate,
131: FND_GLOBAL.user_id,
132: sysdate,
133: FND_GLOBAL.login_id,
134: p_eam_wo_comp_rec.request_id,
135: p_eam_wo_comp_rec.program_application_id,
136: p_eam_wo_comp_rec.program_id,
137: p_eam_wo_comp_rec.program_update_date,

Line 207: , last_updated_by = FND_GLOBAL.user_id

203: -- Enhancement Bug 3852846
204: UPDATE eam_asset_status_history
205: SET enable_flag = 'N'
206: , last_update_date = SYSDATE
207: , last_updated_by = FND_GLOBAL.user_id
208: , last_update_login = FND_GLOBAL.login_id
209: WHERE organization_id = s_organization_id
210: AND wip_entity_id = s_wip_entity_id
211: AND operation_seq_num IS NULL

Line 208: , last_update_login = FND_GLOBAL.login_id

204: UPDATE eam_asset_status_history
205: SET enable_flag = 'N'
206: , last_update_date = SYSDATE
207: , last_updated_by = FND_GLOBAL.user_id
208: , last_update_login = FND_GLOBAL.login_id
209: WHERE organization_id = s_organization_id
210: AND wip_entity_id = s_wip_entity_id
211: AND operation_seq_num IS NULL
212: AND (enable_flag is NULL OR enable_flag = 'Y')

Line 715: s_user_id => fnd_global.user_id,

711: s_wip_entity_id => p_eam_wo_comp_rec.wip_entity_id,
712: s_qa_collection_id => p_eam_wo_comp_rec.qa_collection_id,
713: s_rebuild_item_id => i_rebuild_item_id,
714: s_acct_period_id => i_acct_period_id,
715: s_user_id => fnd_global.user_id,
716: s_transaction_type => l_txn_type,
717: s_project_id => i_project_id,
718: s_task_id => i_task_id,
719: s_commit => x_commit,

Line 794: s_user_id => fnd_global.user_id,

790: s_wip_entity_id => p_eam_wo_comp_rec.wip_entity_id,
791: s_qa_collection_id => p_eam_wo_comp_rec.qa_collection_id,
792: s_rebuild_item_id => i_rebuild_item_id,
793: s_acct_period_id => i_acct_period_id,
794: s_user_id => fnd_global.user_id,
795: s_transaction_type => l_txn_type,
796: s_project_id => i_project_id,
797: s_task_id => i_task_id,
798: s_commit => x_commit,

Line 902: s_user_id => fnd_global.user_id,

898: s_organization_id => p_eam_wo_comp_rec.organization_id,
899: s_asset_number => l_asset_number,
900: s_start_date => p_eam_wo_comp_rec.shutdown_start_date,
901: s_end_date => p_eam_wo_comp_rec.shutdown_end_date,
902: s_user_id => fnd_global.user_id,
903: s_maintenance_object_type => i_maintenance_object_type, -- Fix for Bug 3448770
904: s_maintenance_object_id => i_maintenance_object_id,
905: s_wip_entity_id => p_eam_wo_comp_rec.wip_entity_id
906: );

Line 914: last_updated_by = FND_GLOBAL.user_id,

910:
911:
912: UPDATE WIP_DISCRETE_JOBS
913: SET last_update_date = sysdate,
914: last_updated_by = FND_GLOBAL.user_id,
915: last_update_login = FND_GLOBAL.login_id,
916: status_type = i_status_type,
917: date_completed = i_completion_date,
918: request_id = p_eam_wo_comp_rec.request_id,

Line 915: last_update_login = FND_GLOBAL.login_id,

911:
912: UPDATE WIP_DISCRETE_JOBS
913: SET last_update_date = sysdate,
914: last_updated_by = FND_GLOBAL.user_id,
915: last_update_login = FND_GLOBAL.login_id,
916: status_type = i_status_type,
917: date_completed = i_completion_date,
918: request_id = p_eam_wo_comp_rec.request_id,
919: program_application_id = p_eam_wo_comp_rec.program_application_id,

Line 934: last_updated_by = fnd_global.user_id,

930: -- Update wip_eam_work_requests table
931: UPDATE WIP_EAM_WORK_REQUESTS
932: SET work_request_status_id = i_work_request_status,
933: last_update_date = sysdate,
934: last_updated_by = fnd_global.user_id,
935: last_update_login = fnd_global.login_id
936: WHERE wip_entity_id = p_eam_wo_comp_rec.wip_entity_id;
937:
938:

Line 935: last_update_login = fnd_global.login_id

931: UPDATE WIP_EAM_WORK_REQUESTS
932: SET work_request_status_id = i_work_request_status,
933: last_update_date = sysdate,
934: last_updated_by = fnd_global.user_id,
935: last_update_login = fnd_global.login_id
936: WHERE wip_entity_id = p_eam_wo_comp_rec.wip_entity_id;
937:
938:
939: