APPS.MTL_CCEOI_ACTION_PUB dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 79: p_cce_rec IN MTL_CYCLE_COUNT_ENTRIES%ROWTYPE )

75: -- pre: p_cce_rec is a copy of valid mtl_cycle_count_entry record
76: PROCEDURE derive_CCE_Info
77: (
78: x_iface_rec IN OUT NOCOPY MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE,
79: p_cce_rec IN MTL_CYCLE_COUNT_ENTRIES%ROWTYPE )
80: IS
81: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
82: BEGIN
83:

Line 209: -- open entry in mtl_cycle_count_entries then this entry is going

205: -- connected to cycle_count_enrty yet, and it makes sure that
206: -- either data in the interface correspond to an existing unexported
207: -- cycle count entry or that the data in the interface does not correspond
208: -- to any existing entries. If the interface record corresponds to some
209: -- open entry in mtl_cycle_count_entries then this entry is going
210: -- to be exported and interface record fields that can be derived from
211: -- cycle_count_entry will be overwritten by data from there.
212: PROCEDURE Enforce_SKU_CountEntry_Match
213: (p_api_version IN NUMBER,

Line 228: from mtl_cycle_count_entries

224: l_api_name VARCHAR2(30) := 'Enforce_SKU_CountEntry_Match';
225:
226: cursor l_mcce_csr(p_cce_id in number) is
227: select *
228: from mtl_cycle_count_entries
229: where cycle_count_entry_id = p_cce_id
230: for update of export_flag;
231:
232: counter number := 0;

Line 452: -- corresponds to an existing count request in mtl_cycle_count_entries

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
456: -- record is not inserted. If count entry os not exported then the SKU,

Line 538: -- if interface record is already linked to mtl_cycle_count_entries

534: x_errorcode := 207;
535: RAISE FND_API.G_EXC_ERROR;
536: end if;
537:
538: -- if interface record is already linked to mtl_cycle_count_entries
539: if (c_rec.cycle_count_entry_id is not null) then
540:
541: -- we may want to warn about updating only count info
542: x_iface_rec.cycle_count_entry_id := c_rec.cycle_count_entry_id;

Line 1307: FROM mtl_cycle_count_entries

1303:
1304: -- *** for testing purposes only. remove after testing!!!
1305: /* SELECT cost_group_id
1306: INTO l_expl_tbl(v_index).cost_group_id
1307: FROM mtl_cycle_count_entries
1308: WHERE organization_id = l_expl_tbl(v_index).organization_id
1309: AND inventory_item_id = l_expl_tbl(v_index).content_item_id
1310: AND parent_lpn_id = l_expl_tbl(v_index).parent_lpn_id
1311: AND cycle_count_header_id = p_interface_rec.cycle_count_header_id;*/

Line 1329: FROM mtl_cycle_count_entries

1325: IF l_in_cc_entries THEN
1326: -- Count List sequence number required for processing for schedualed entries
1327: SELECT count_list_sequence
1328: INTO l_item_rec.count_list_sequence
1329: FROM mtl_cycle_count_entries
1330: WHERE organization_id = l_expl_tbl(v_index).organization_id
1331: AND inventory_item_id = l_expl_tbl(v_index).content_item_id
1332: AND parent_lpn_id = l_expl_tbl(v_index).parent_lpn_id
1333: AND NVL(cost_group_id, -1) = NVL(l_expl_tbl(v_index).cost_group_id, -1)