117: l_deb_rec.task_assignment_id := p_record.task_assignment_id;
118: l_deb_rec.debrief_header_id := l_debrief_header_id;
119: l_deb_rec.debrief_status_id := NULL;
120: l_deb_rec.last_update_date := l_date;
121: l_deb_rec.last_updated_by := NVL(p_record.last_updated_by,FND_GLOBAL.USER_ID); --12.1
122: l_deb_rec.creation_date := l_date;
123: l_deb_rec.created_by := NVL(p_record.created_by,FND_GLOBAL.USER_ID); --12.1
124: l_deb_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
125:
119: l_deb_rec.debrief_status_id := NULL;
120: l_deb_rec.last_update_date := l_date;
121: l_deb_rec.last_updated_by := NVL(p_record.last_updated_by,FND_GLOBAL.USER_ID); --12.1
122: l_deb_rec.creation_date := l_date;
123: l_deb_rec.created_by := NVL(p_record.created_by,FND_GLOBAL.USER_ID); --12.1
124: l_deb_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
125:
126:
127: if l_debrief_header_id is null
120: l_deb_rec.last_update_date := l_date;
121: l_deb_rec.last_updated_by := NVL(p_record.last_updated_by,FND_GLOBAL.USER_ID); --12.1
122: l_deb_rec.creation_date := l_date;
123: l_deb_rec.created_by := NVL(p_record.created_by,FND_GLOBAL.USER_ID); --12.1
124: l_deb_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
125:
126:
127: if l_debrief_header_id is null
128: then
167:
168: l_line_rec.issuing_inventory_org_id := l_issuing_inventory_org_id;
169: l_line_rec.receiving_inventory_org_id := l_receiving_inventory_org_id;
170: l_line_rec.last_update_date := l_date;
171: l_line_rec.last_updated_by := NVL(p_record.last_updated_by,FND_GLOBAL.USER_ID); --12.1
172: l_line_rec.creation_date := l_date;
173: l_line_rec.created_by := NVL(p_record.created_by,FND_GLOBAL.USER_ID); --12.1
174: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
175: l_line_rec.inventory_item_id := p_record.inventory_item_id;
169: l_line_rec.receiving_inventory_org_id := l_receiving_inventory_org_id;
170: l_line_rec.last_update_date := l_date;
171: l_line_rec.last_updated_by := NVL(p_record.last_updated_by,FND_GLOBAL.USER_ID); --12.1
172: l_line_rec.creation_date := l_date;
173: l_line_rec.created_by := NVL(p_record.created_by,FND_GLOBAL.USER_ID); --12.1
174: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
175: l_line_rec.inventory_item_id := p_record.inventory_item_id;
176: l_line_rec.txn_billing_type_id := p_record.txn_billing_type_id;
177: l_line_rec.service_date := p_record.service_date;
170: l_line_rec.last_update_date := l_date;
171: l_line_rec.last_updated_by := NVL(p_record.last_updated_by,FND_GLOBAL.USER_ID); --12.1
172: l_line_rec.creation_date := l_date;
173: l_line_rec.created_by := NVL(p_record.created_by,FND_GLOBAL.USER_ID); --12.1
174: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
175: l_line_rec.inventory_item_id := p_record.inventory_item_id;
176: l_line_rec.txn_billing_type_id := p_record.txn_billing_type_id;
177: l_line_rec.service_date := p_record.service_date;
178: --l_line_rec.debrief_line_number := To_Char( p_record.debrief_line_id );
323: l_line_rec.issuing_inventory_org_id := r_cdl.issuing_inventory_org_id;
324: l_line_rec.debrief_line_id := p_record.debrief_line_id;
325: l_line_rec.debrief_header_id := l_debrief_header_id;
326: l_line_rec.last_update_date := l_date;
327: l_line_rec.last_updated_by := NVL(p_record.last_updated_by,FND_GLOBAL.USER_ID); --12.1
328: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
329: l_line_rec.inventory_item_id := p_record.inventory_item_id;
330: l_line_rec.txn_billing_type_id := p_record.txn_billing_type_id;
331: l_line_rec.service_date := p_record.service_date;
324: l_line_rec.debrief_line_id := p_record.debrief_line_id;
325: l_line_rec.debrief_header_id := l_debrief_header_id;
326: l_line_rec.last_update_date := l_date;
327: l_line_rec.last_updated_by := NVL(p_record.last_updated_by,FND_GLOBAL.USER_ID); --12.1
328: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
329: l_line_rec.inventory_item_id := p_record.inventory_item_id;
330: l_line_rec.txn_billing_type_id := p_record.txn_billing_type_id;
331: l_line_rec.service_date := p_record.service_date;
332: --l_line_rec.debrief_line_number := To_Char( p_record.debrief_line_id );