APPS.MTL_CCEOI_ACTION_PUB dependencies on MTL_CC_ENTRIES_INTERFACE

Line 27: from mtl_cc_entries_interface

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

Line 55: update mtl_cc_entries_interface

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

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

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

Line 467: from mtl_cc_entries_interface

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

Line 615: SELECT MTL_CC_ENTRIES_INTERFACE_S1.nextval

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

Line 929: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE_ID'

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

Line 1000: update mtl_cc_entries_interface

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