108: -- Populate the row who columns
109:
110: l_job_header_rec.creation_date := SYSDATE;
111: l_job_header_rec.last_update_date := SYSDATE;
112: l_job_header_rec.created_by := fnd_global.user_id;
113: l_job_header_rec.last_updated_by := fnd_global.user_id;
114: l_job_header_rec.last_update_login := fnd_global.login_id;
115:
116:
109:
110: l_job_header_rec.creation_date := SYSDATE;
111: l_job_header_rec.last_update_date := SYSDATE;
112: l_job_header_rec.created_by := fnd_global.user_id;
113: l_job_header_rec.last_updated_by := fnd_global.user_id;
114: l_job_header_rec.last_update_login := fnd_global.login_id;
115:
116:
117: l_job_header_rec.job_name := p_job_bill_routing_rec.job_name;
110: l_job_header_rec.creation_date := SYSDATE;
111: l_job_header_rec.last_update_date := SYSDATE;
112: l_job_header_rec.created_by := fnd_global.user_id;
113: l_job_header_rec.last_updated_by := fnd_global.user_id;
114: l_job_header_rec.last_update_login := fnd_global.login_id;
115:
116:
117: l_job_header_rec.job_name := p_job_bill_routing_rec.job_name;
118: l_job_header_rec.organization_id := p_job_header_rec.organization_id;
311: -- Populate the row who columns
312:
313: l_job_header_rec.creation_date := SYSDATE;
314: l_job_header_rec.last_update_date := SYSDATE;
315: l_job_header_rec.created_by := fnd_global.user_id;
316: l_job_header_rec.last_updated_by := fnd_global.user_id;
317: l_job_header_rec.last_update_login := fnd_global.login_id;
318:
319:
312:
313: l_job_header_rec.creation_date := SYSDATE;
314: l_job_header_rec.last_update_date := SYSDATE;
315: l_job_header_rec.created_by := fnd_global.user_id;
316: l_job_header_rec.last_updated_by := fnd_global.user_id;
317: l_job_header_rec.last_update_login := fnd_global.login_id;
318:
319:
320: --insert into table wip_job_schedule_interface
313: l_job_header_rec.creation_date := SYSDATE;
314: l_job_header_rec.last_update_date := SYSDATE;
315: l_job_header_rec.created_by := fnd_global.user_id;
316: l_job_header_rec.last_updated_by := fnd_global.user_id;
317: l_job_header_rec.last_update_login := fnd_global.login_id;
318:
319:
320: --insert into table wip_job_schedule_interface
321: BEGIN
2018: END IF;
2019: -- call procedures to insert a row in csd_repair_job_xref
2020: -- and csd_repair_history tables for the job created.
2021:
2022: L_user_id := fnd_global.user_id;
2023:
2024: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2025: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2026: lc_mod_name||'beforecallxrefwrite',