DBA Data[Home] [Help]

APPS.CSD_WIP_JOB_PVT dependencies on FND_GLOBAL

Line 117: l_job_header_rec.created_by := fnd_global.user_id;

113: -- Populate the row who columns
114:
115: l_job_header_rec.creation_date := SYSDATE;
116: l_job_header_rec.last_update_date := SYSDATE;
117: l_job_header_rec.created_by := fnd_global.user_id;
118: l_job_header_rec.last_updated_by := fnd_global.user_id;
119: l_job_header_rec.last_update_login := fnd_global.login_id;
120:
121:

Line 118: l_job_header_rec.last_updated_by := fnd_global.user_id;

114:
115: l_job_header_rec.creation_date := SYSDATE;
116: l_job_header_rec.last_update_date := SYSDATE;
117: l_job_header_rec.created_by := fnd_global.user_id;
118: l_job_header_rec.last_updated_by := fnd_global.user_id;
119: l_job_header_rec.last_update_login := fnd_global.login_id;
120:
121:
122: l_job_header_rec.job_name := p_job_bill_routing_rec.job_name;

Line 119: l_job_header_rec.last_update_login := fnd_global.login_id;

115: l_job_header_rec.creation_date := SYSDATE;
116: l_job_header_rec.last_update_date := SYSDATE;
117: l_job_header_rec.created_by := fnd_global.user_id;
118: l_job_header_rec.last_updated_by := fnd_global.user_id;
119: l_job_header_rec.last_update_login := fnd_global.login_id;
120:
121:
122: l_job_header_rec.job_name := p_job_bill_routing_rec.job_name;
123: l_job_header_rec.organization_id := p_job_header_rec.organization_id;

Line 320: l_job_header_rec.created_by := fnd_global.user_id;

316: -- Populate the row who columns
317:
318: l_job_header_rec.creation_date := SYSDATE;
319: l_job_header_rec.last_update_date := SYSDATE;
320: l_job_header_rec.created_by := fnd_global.user_id;
321: l_job_header_rec.last_updated_by := fnd_global.user_id;
322: l_job_header_rec.last_update_login := fnd_global.login_id;
323:
324:

Line 321: l_job_header_rec.last_updated_by := fnd_global.user_id;

317:
318: l_job_header_rec.creation_date := SYSDATE;
319: l_job_header_rec.last_update_date := SYSDATE;
320: l_job_header_rec.created_by := fnd_global.user_id;
321: l_job_header_rec.last_updated_by := fnd_global.user_id;
322: l_job_header_rec.last_update_login := fnd_global.login_id;
323:
324:
325: --insert into table wip_job_schedule_interface

Line 322: l_job_header_rec.last_update_login := fnd_global.login_id;

318: l_job_header_rec.creation_date := SYSDATE;
319: l_job_header_rec.last_update_date := SYSDATE;
320: l_job_header_rec.created_by := fnd_global.user_id;
321: l_job_header_rec.last_updated_by := fnd_global.user_id;
322: l_job_header_rec.last_update_login := fnd_global.login_id;
323:
324:
325: --insert into table wip_job_schedule_interface
326: BEGIN

Line 2216: L_user_id := fnd_global.user_id;

2212:
2213: -- call procedures to insert a row in csd_repair_job_xref
2214: -- and csd_repair_history tables for the job created.
2215:
2216: L_user_id := fnd_global.user_id;
2217:
2218: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2219: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
2220: lc_mod_name||'beforecallxrefwrite',

Line 2699: l_job_header_tbl(l_job_header_index).created_by := fnd_global.user_id;

2695: l_job_header_tbl(l_job_header_index).process_phase := 2;
2696: l_job_header_tbl(l_job_header_index).process_status := 1;
2697: l_job_header_tbl(l_job_header_index).creation_date := SYSDATE;
2698: l_job_header_tbl(l_job_header_index).last_update_date := SYSDATE;
2699: l_job_header_tbl(l_job_header_index).created_by := fnd_global.user_id;
2700: l_job_header_tbl(l_job_header_index).last_updated_by := fnd_global.user_id;
2701: l_job_header_tbl(l_job_header_index).last_update_login := fnd_global.login_id;
2702: l_job_header_tbl(l_job_header_index).primary_item_id := NVL(p_upgrade_to_item_id,p_inventory_item_ids(i));
2703: l_job_header_tbl(l_job_header_index).start_quantity := p_quantities(i);

Line 2700: l_job_header_tbl(l_job_header_index).last_updated_by := fnd_global.user_id;

2696: l_job_header_tbl(l_job_header_index).process_status := 1;
2697: l_job_header_tbl(l_job_header_index).creation_date := SYSDATE;
2698: l_job_header_tbl(l_job_header_index).last_update_date := SYSDATE;
2699: l_job_header_tbl(l_job_header_index).created_by := fnd_global.user_id;
2700: l_job_header_tbl(l_job_header_index).last_updated_by := fnd_global.user_id;
2701: l_job_header_tbl(l_job_header_index).last_update_login := fnd_global.login_id;
2702: l_job_header_tbl(l_job_header_index).primary_item_id := NVL(p_upgrade_to_item_id,p_inventory_item_ids(i));
2703: l_job_header_tbl(l_job_header_index).start_quantity := p_quantities(i);
2704: l_job_header_tbl(l_job_header_index).first_unit_start_date := p_start_date;

Line 2701: l_job_header_tbl(l_job_header_index).last_update_login := fnd_global.login_id;

2697: l_job_header_tbl(l_job_header_index).creation_date := SYSDATE;
2698: l_job_header_tbl(l_job_header_index).last_update_date := SYSDATE;
2699: l_job_header_tbl(l_job_header_index).created_by := fnd_global.user_id;
2700: l_job_header_tbl(l_job_header_index).last_updated_by := fnd_global.user_id;
2701: l_job_header_tbl(l_job_header_index).last_update_login := fnd_global.login_id;
2702: l_job_header_tbl(l_job_header_index).primary_item_id := NVL(p_upgrade_to_item_id,p_inventory_item_ids(i));
2703: l_job_header_tbl(l_job_header_index).start_quantity := p_quantities(i);
2704: l_job_header_tbl(l_job_header_index).first_unit_start_date := p_start_date;
2705: l_job_header_tbl(l_job_header_index).last_unit_completion_date := p_end_date;

Line 2760: l_job_header_tbl(l_job_header_index).created_by := fnd_global.user_id;

2756: l_job_header_tbl(l_job_header_index).process_phase := 2;
2757: l_job_header_tbl(l_job_header_index).process_status := 1;
2758: l_job_header_tbl(l_job_header_index).creation_date := SYSDATE;
2759: l_job_header_tbl(l_job_header_index).last_update_date := SYSDATE;
2760: l_job_header_tbl(l_job_header_index).created_by := fnd_global.user_id;
2761: l_job_header_tbl(l_job_header_index).last_updated_by := fnd_global.user_id;
2762: l_job_header_tbl(l_job_header_index).last_update_login := fnd_global.login_id;
2763: l_job_header_tbl(l_job_header_index).primary_item_id := NVL(p_upgrade_to_item_id,p_inventory_item_ids(i));
2764: l_job_header_tbl(l_job_header_index).start_quantity := p_quantities(i);

Line 2761: l_job_header_tbl(l_job_header_index).last_updated_by := fnd_global.user_id;

2757: l_job_header_tbl(l_job_header_index).process_status := 1;
2758: l_job_header_tbl(l_job_header_index).creation_date := SYSDATE;
2759: l_job_header_tbl(l_job_header_index).last_update_date := SYSDATE;
2760: l_job_header_tbl(l_job_header_index).created_by := fnd_global.user_id;
2761: l_job_header_tbl(l_job_header_index).last_updated_by := fnd_global.user_id;
2762: l_job_header_tbl(l_job_header_index).last_update_login := fnd_global.login_id;
2763: l_job_header_tbl(l_job_header_index).primary_item_id := NVL(p_upgrade_to_item_id,p_inventory_item_ids(i));
2764: l_job_header_tbl(l_job_header_index).start_quantity := p_quantities(i);
2765: l_job_header_tbl(l_job_header_index).first_unit_start_date := p_start_date;

Line 2762: l_job_header_tbl(l_job_header_index).last_update_login := fnd_global.login_id;

2758: l_job_header_tbl(l_job_header_index).creation_date := SYSDATE;
2759: l_job_header_tbl(l_job_header_index).last_update_date := SYSDATE;
2760: l_job_header_tbl(l_job_header_index).created_by := fnd_global.user_id;
2761: l_job_header_tbl(l_job_header_index).last_updated_by := fnd_global.user_id;
2762: l_job_header_tbl(l_job_header_index).last_update_login := fnd_global.login_id;
2763: l_job_header_tbl(l_job_header_index).primary_item_id := NVL(p_upgrade_to_item_id,p_inventory_item_ids(i));
2764: l_job_header_tbl(l_job_header_index).start_quantity := p_quantities(i);
2765: l_job_header_tbl(l_job_header_index).first_unit_start_date := p_start_date;
2766: l_job_header_tbl(l_job_header_index).last_unit_completion_date := p_end_date;

Line 2841: fnd_global.user_id,

2837: OBJECT_VERSION_NUMBER
2838: )
2839: VALUES
2840: (CSD_REPAIR_JOB_XREF_S1.nextval,
2841: fnd_global.user_id,
2842: sysdate,
2843: fnd_global.user_id,
2844: sysdate,
2845: fnd_global.login_id,

Line 2843: fnd_global.user_id,

2839: VALUES
2840: (CSD_REPAIR_JOB_XREF_S1.nextval,
2841: fnd_global.user_id,
2842: sysdate,
2843: fnd_global.user_id,
2844: sysdate,
2845: fnd_global.login_id,
2846: l_job_header_tbl(k).source_line_id,
2847: NULL,

Line 2845: fnd_global.login_id,

2841: fnd_global.user_id,
2842: sysdate,
2843: fnd_global.user_id,
2844: sysdate,
2845: fnd_global.login_id,
2846: l_job_header_tbl(k).source_line_id,
2847: NULL,
2848: l_group_id,
2849: l_job_header_tbl(k).organization_id,