APPS.WIP_TRANSACTIONS_PKG dependencies on MTL_TRANSACTIONS_INTERFACE

Line 449: from mtl_transactions_interface

445: l_bind3 := 90;
446: l_bind4 := NULL;
447: select count(*)
448: into completion_count1
449: from mtl_transactions_interface
450: where transaction_header_id = txn_hdr_id
451: and transaction_type_id in (l_bind1, l_bind2, l_bind3, l_bind4) ;
452: l_bind1 := 35;
453: l_bind2 := 43;

Line 458: from mtl_transactions_interface

454: l_bind3 := 38;
455: l_bind4 := 48;
456: select count(*)
457: into completion_count2
458: from mtl_transactions_interface
459: where transaction_header_id = txn_hdr_id
460: and transaction_type_id in (l_bind1, l_bind2, l_bind3, l_bind4) ;
461:
462: if ((completion_count1 = 0) and (completion_count2 > 0)) then

Line 467: mtl_transactions_interface

463:
464: delete from mtl_transaction_lots_interface
465: where transaction_interface_id in
466: ( select transaction_interface_id from
467: mtl_transactions_interface
468: where transaction_header_id = txn_hdr_id
469: and transaction_type_id in (35, 43, 38, 48)
470: ) ;
471:

Line 475: mtl_transactions_interface

471:
472: delete from mtl_serial_numbers_interface
473: where transaction_interface_id in
474: ( select transaction_interface_id from
475: mtl_transactions_interface
476: where transaction_header_id = txn_hdr_id
477: and transaction_type_id in (35, 43, 38, 48)
478: ) ;
479:

Line 480: delete from mtl_transactions_interface

476: where transaction_header_id = txn_hdr_id
477: and transaction_type_id in (35, 43, 38, 48)
478: ) ;
479:
480: delete from mtl_transactions_interface
481: where transaction_header_id = txn_hdr_id
482: and transaction_type_id in (35, 43, 38, 48) ;
483:
484: commit ;