eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_CCEOI_ACTION_PVT dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 167: -- MTL_CYCLE_COUNT_ENTRIES

163: -- Pre-reqs : None
164: -- FUNCTION :
165: -- INSERT the interface RECORD INTO the MTL_CC_ENTRIES_INTERFACE
166: -- TABLE AND locks the original RECORD IN the TABLE
167: -- MTL_CYCLE_COUNT_ENTRIES
168: -- Parameters:
169: -- IN : p_api_version IN NUMBER (required)
170: -- API Version of this procedure
171: -- p_init_msg_level IN VARCHAR2 (optional)

Line 233: -- Set EXPORT FLAG= 1 in MTL_CYCLE_COUNT_ENTRIES

229: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
230: p_interface_rec=> p_interface_rec,
231: x_return_status => L_return_status);
232: --
233: -- Set EXPORT FLAG= 1 in MTL_CYCLE_COUNT_ENTRIES
234: MTL_CCEOI_PROCESS_PVT.Set_CCExport(
235: p_api_version => 0.9,
236: X_return_status=> L_return_status,
237: x_msg_count => L_msg_count,

Line 315: -- mtl_cycle_count_entries only IF unscheduled request

311: -- TYPE : Private
312: -- Pre-reqs : None
313: -- FUNCTION :
314: -- This PROCEDURE creates COUNT requests INTO TABLE
315: -- mtl_cycle_count_entries only IF unscheduled request
316: -- are allowed.
317: -- Parameters:
318: -- IN :
319: -- p_api_version IN NUMBER (required)

Line 335: -- create record in mtl_cycle_count_entries

331: --
332: -- p_simulate IN VARCHAR2 (optional)
333: -- determines whether to do do actual processing or just simulate it
334: -- DEFAULT = FND_API.G_FALSE
335: -- create record in mtl_cycle_count_entries
336: -- FND_API.G_TRUE
337: -- do not insert records into mtl_cycle_count_entries
338: --
339: --

Line 337: -- do not insert records into mtl_cycle_count_entries

333: -- determines whether to do do actual processing or just simulate it
334: -- DEFAULT = FND_API.G_FALSE
335: -- create record in mtl_cycle_count_entries
336: -- FND_API.G_TRUE
337: -- do not insert records into mtl_cycle_count_entries
338: --
339: --
340: -- p_interface_rec MTL_CC_ENTRIES_INTERFACE%ROWTYPE (required)
341: -- the interface RECORD

Line 445: p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES',

441: p_api_version => 0.9,
442: p_interface_rec => p_interface_rec,
443: p_message_name => 'INV_CCEOI_COUNT_REQ_EXISTS',
444: p_error_column_name => 'CYCLE_COUNT_ENTRY_ID',
445: p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES',
446: p_flags => '1$2$',
447: x_return_status => x_return_status,
448: x_msg_count => x_msg_count,
449: x_msg_data => x_msg_data);

Line 469: -- insert count request into mtl_cycle_count_entries

465: -- create count request if not in simulation mode
466: IF (p_simulate = FND_API.G_FALSE) THEN
467:
468:
469: -- insert count request into mtl_cycle_count_entries
470: MTL_CCEOI_PROCESS_PVT.Insert_CCEntry(
471: p_interface_rec=> p_interface_rec);
472:
473: declare

Line 632: -- - update processed info in mtl_cycle_count_entries (and any

628: --
629: -- p_simulate IN VARCHAR2 (optional)
630: -- determines whether to do do actual processing or just simulate it
631: -- DEFAULT = FND_API.G_FALSE
632: -- - update processed info in mtl_cycle_count_entries (and any
633: -- other table necessary)
634: -- FND_API.G_TRUE
635: -- - do not insert record into mtl_cycle_count_entries
636: --

Line 635: -- - do not insert record into mtl_cycle_count_entries

631: -- DEFAULT = FND_API.G_FALSE
632: -- - update processed info in mtl_cycle_count_entries (and any
633: -- other table necessary)
634: -- FND_API.G_TRUE
635: -- - do not insert record into mtl_cycle_count_entries
636: --
637: -- OUT :
638: -- X_return_status OUT NUMBER
639: -- Result of all the operations

Line 995: L_subinventory MTL_CYCLE_COUNT_ENTRIES.SUBINVENTORY%TYPE;

991: DECLARE
992: L_inventory_rec MTL_CCEOI_VAR_PVT.Inv_Item_rec_type;
993: L_sku_rec MTL_CCEOI_VAR_PVT.INV_SKU_REC_TYPE;
994: L_locator_rec MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE;
995: L_subinventory MTL_CYCLE_COUNT_ENTRIES.SUBINVENTORY%TYPE;
996: l_derivable_item_sku BOOLEAN := TRUE;
997: L_errorcode NUMBER := 0;
998: L_return_status VARCHAR2(30);
999: --

Line 1153: from mtl_cycle_count_entries

1149: while (l_same_seq_not_closed_entries <> 0) loop
1150: MTL_CCEOI_VAR_PVT.G_Seq_No := MTL_CCEOI_VAR_PVT.G_Seq_No + 1;
1151: select count(*)
1152: into l_same_seq_not_closed_entries
1153: from mtl_cycle_count_entries
1154: where count_list_sequence = MTL_CCEOI_VAR_PVT.G_Seq_No
1155: and cycle_count_header_id = MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID
1156: and entry_status_code not in (4, 5);
1157: IF (l_debug = 1) THEN