240: p_eam_wo_bills_tbl(i).offset_account_ccid, -- Offset/Clearance Account
241: p_eam_wo_bills_tbl(i).billed_amount, -- To credit Clearance A/C with this amount
242: l_merged_code,
243: l_merge_parent_id,
244: fnd_global.user_id,
245: sysdate,
246: fnd_global.user_id,
247: sysdate,
248: fnd_global.user_id);
242: l_merged_code,
243: l_merge_parent_id,
244: fnd_global.user_id,
245: sysdate,
246: fnd_global.user_id,
247: sysdate,
248: fnd_global.user_id);
249:
250:
244: fnd_global.user_id,
245: sysdate,
246: fnd_global.user_id,
247: sysdate,
248: fnd_global.user_id);
249:
250:
251: INSERT INTO eam_work_order_bills(
252: organization_id,
288: l_mass_addition_id,
289: sysdate,
290: p_eam_wo_bills_tbl(i).comments,
291: p_eam_wo_bills_tbl(i).offset_account_ccid,
292: fnd_global.user_id,
293: sysdate,
294: fnd_global.user_id,
295: sysdate,
296: fnd_global.user_id);
290: p_eam_wo_bills_tbl(i).comments,
291: p_eam_wo_bills_tbl(i).offset_account_ccid,
292: fnd_global.user_id,
293: sysdate,
294: fnd_global.user_id,
295: sysdate,
296: fnd_global.user_id);
297:
298: -- Added Bug 7678186
292: fnd_global.user_id,
293: sysdate,
294: fnd_global.user_id,
295: sysdate,
296: fnd_global.user_id);
297:
298: -- Added Bug 7678186
299:
300: IF i = p_eam_wo_bills_tbl.first AND l_add_to_asset = FALSE THEN