[Home] [Help]
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 :=
620: x_iface_rec.cc_entry_interface_id;
621: MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM := FALSE;
1357: l_expl_tbl(v_index+1).cost_group_id := p_interface_rec.cost_group_id;
1358: END IF;
1359: -- 8712932 End
1360:
1361: -- Check if Unschedualed Entries are allowed.
1362: SELECT unscheduled_count_entry
1363: INTO l_unsched_allowed
1364: FROM mtl_cycle_count_headers
1365: WHERE cycle_count_header_id = p_interface_rec.cycle_count_header_id;
1388:
1389: --Check if record represents an item
1390: IF (l_expl_tbl(v_index).content_type = 1) THEN
1391: -- Check if item exist in cycle count entries table or in the cycle count items
1392: -- table if unschedualed entries are allowed.
1393: IF (l_debug = 1) THEN
1394: mdebug('org id: ' || TO_CHAR(l_expl_tbl(v_index).organization_id));
1395: mdebug('lpn id: ' || TO_CHAR(l_expl_tbl(v_index).parent_lpn_id));
1396: mdebug('item id: ' || TO_CHAR(l_expl_tbl(v_index).content_item_id));
1421: l_expl_tbl(v_index).content_item_id) )
1422: THEN
1423:
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
1529:
1530: -- Create subinventory transfer information
1531: SELECT mtl_material_transactions_s.nextval
1532: INTO L_txn_header_id
1533: FROM dual;
1534:
1535: -- Do a subinventory transfer
1536: L_success_flag := mtl_cc_transact_pkg.cc_transact(
1537: org_id=> p_interface_rec.organization_id