APPS.EAM_MATERIALISSUE_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 68: l_rebuild_job_name mtl_transactions_interface.rebuild_job_name%type;

64: x_error_mssg1 Varchar2(200);
65: l_eam_one_step_mat_issue varchar2(1);
66: l_rebuild_item_id number := null;
67: l_rebuild_activity_id number := null;
68: l_rebuild_job_name mtl_transactions_interface.rebuild_job_name%type;
69: l_rebuild_job_temp Number;
70: l_prefix wip_eam_parameters.easy_work_order_prefix%type;
71: l_lot_number Varchar2(80);
72: l_fm_serial_number Varchar2(30);

Line 345: update mtl_transactions_interface

341: end if;
342: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
343: 'Inserting rebuild item id: '|| l_rebuild_item_id);
344: end if;
345: update mtl_transactions_interface
346: set rebuild_item_id=l_rebuild_item_id
347: where transaction_interface_id= x_tmp_id;
348: end;
349: end if;

Line 354: update mtl_transactions_interface

350:
351: if (p_rebuild_serial_number is not null) then
352: begin
353: --dbms_output.put_line('p_rebuild_serial_number ' || p_rebuild_serial_number);
354: update mtl_transactions_interface
355: set rebuild_serial_number=p_rebuild_serial_number
356: where transaction_interface_id= x_tmp_id;
357: end;
358: end if;

Line 373: update mtl_transactions_interface

369: end if;
370: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
371: 'Inserting rebuild activity id: '|| l_rebuild_activity_id);
372: end if;
373: update mtl_transactions_interface
374: set rebuild_activity_id=l_rebuild_activity_id
375: where transaction_interface_id= x_tmp_id;
376: end;
377: end if;

Line 398: update mtl_transactions_interface

394:
395: p_rebuild_job_name := l_rebuild_job_name;
396:
397: --dbms_output.put_line('p_rebuild_job_name ' || l_rebuild_job_name);
398: update mtl_transactions_interface
399: set rebuild_job_name=l_rebuild_job_name
400: where transaction_interface_id= x_tmp_id;
401:
402: if (p_reference is not null) then

Line 404: update mtl_transactions_interface

400: where transaction_interface_id= x_tmp_id;
401:
402: if (p_reference is not null) then
403: begin
404: update mtl_transactions_interface
405: set transaction_reference=p_reference
406: where transaction_interface_id= x_tmp_id;
407: end;
408: end if;

Line 413: update mtl_transactions_interface

409:
410: if (l_reason_id is not null) then
411: begin
412: --dbms_output.put_line('l_reason_id ' || l_reason_id);
413: update mtl_transactions_interface
414: set reason_id=l_reason_id
415: where transaction_interface_id= x_tmp_id;
416: end;
417: end if;

Line 420: from mtl_transactions_interface

416: end;
417: end if;
418:
419: select transaction_header_id into l_tx_hdr_id
420: from mtl_transactions_interface
421: where transaction_interface_id = x_tmp_id;
422:
423:
424: -- only call txn processor if online processing. 4(form level) is treated as 1.