APPS.MTL_CCEOI_ACTION_PUB dependencies on MTL_CC_ENTRIES_INTERFACE

Line 26: from mtl_cc_entries_interface

22: -- note: we need to get rid of simulation mode because it breaks this rule
23: function find_iface_id return number is
24: cursor l_mcei_csr(p_cce_id NUMBER) is
25: select cc_entry_interface_id
26: from mtl_cc_entries_interface
27: where cycle_count_entry_id = p_cce_id and
28: (delete_flag <> 1 or delete_flag is null
29: OR not (status_flag in (0,1)));
30:

Line 54: update mtl_cc_entries_interface

50: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
51: BEGIN
52: x_return_status := fnd_api.g_ret_sts_success;
53:
54: update mtl_cc_entries_interface
55: set
56: lock_flag = 2
57: , last_update_date = sysdate
58: , last_updated_by = MTL_CCEOI_VAR_PVT.G_UserID

Line 451: -- into the mtl_cc_entries_interface table. If the interface record

447: --
448: -- Version: Current Version 0.9
449: -- Initial version 0.9
450: -- Notes : Attempts to insert and lock passed to it p_iface_rec
451: -- into the mtl_cc_entries_interface table. If the interface record
452: -- corresponds to an existing count request in mtl_cycle_count_entries
453: -- then the count entry will be marked as exported unless it was already
454: -- exported. If count entry is already exported that would mean that it
455: -- is exported by a different interface record in which case interface

Line 466: from mtl_cc_entries_interface

462: l_api_name VARCHAR2(30) := 'Initial_Insert';
463:
464: CURSOR l_mcei_csr(ccei_id in number) is
465: select *
466: from mtl_cc_entries_interface
467: where cc_entry_interface_id = ccei_id
468: for update of lock_flag;
469:
470: counter NUMBER := 0;

Line 613: SELECT MTL_CC_ENTRIES_INTERFACE_S1.nextval

609:
610: if (counter = 0) then
611: if (x_iface_rec.cc_entry_interface_id is null) then
612:
613: SELECT MTL_CC_ENTRIES_INTERFACE_S1.nextval
614: INTO x_iface_rec.cc_entry_interface_id
615: FROM dual;
616:
617: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID :=

Line 927: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE_ID'

923: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
924: p_cc_entry_interface_id =>
925: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,
926: p_error_column_name => 'ACTION_CODE'
927: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE_ID'
928: , p_message_name => 'INV_CCEOI_UNKNOWN_ACTION_CODE');
929:
930: x_return_status := FND_API.G_RET_STS_ERROR;
931:

Line 998: update mtl_cc_entries_interface

994: IF MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID is not null and
995: mtl_cceoi_var_pvt.g_cc_entry_interface_id is not null
996: THEN
997: begin
998: update mtl_cc_entries_interface
999: set inventory_item_id = MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,
1000: locator_id = MTL_CCEOI_VAR_PVT.G_LOCATOR_ID
1001: where cc_entry_interface_id = mtl_cceoi_var_pvt.g_cc_entry_interface_id
1002: and inventory_item_id is null;