APPS.MTL_CCEOI_ACTION_PUB dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 80: p_cce_rec IN MTL_CYCLE_COUNT_ENTRIES%ROWTYPE )

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

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

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

Line 229: from mtl_cycle_count_entries

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

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

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

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

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

Line 1406: FROM mtl_cycle_count_entries

1402:
1403: -- *** for testing purposes only. remove after testing!!!
1404: /* SELECT cost_group_id
1405: INTO l_expl_tbl(v_index).cost_group_id
1406: FROM mtl_cycle_count_entries
1407: WHERE organization_id = l_expl_tbl(v_index).organization_id
1408: AND inventory_item_id = l_expl_tbl(v_index).content_item_id
1409: AND parent_lpn_id = l_expl_tbl(v_index).parent_lpn_id
1410: AND cycle_count_header_id = p_interface_rec.cycle_count_header_id;*/

Line 1428: FROM mtl_cycle_count_entries

1424: IF l_in_cc_entries THEN
1425: -- Count List sequence number required for processing for schedualed entries
1426: SELECT count_list_sequence
1427: INTO l_item_rec.count_list_sequence
1428: FROM mtl_cycle_count_entries
1429: WHERE organization_id = l_expl_tbl(v_index).organization_id
1430: AND inventory_item_id = l_expl_tbl(v_index).content_item_id
1431: AND parent_lpn_id = l_expl_tbl(v_index).parent_lpn_id
1432: AND NVL(cost_group_id, -1) = NVL(l_expl_tbl(v_index).cost_group_id, -1)