APPS.MTL_CCEOI_ACTION_PVT dependencies on MTL_CC_ENTRIES_INTERFACE

Line 165: -- INSERT the interface RECORD INTO the MTL_CC_ENTRIES_INTERFACE

161: -- API name : Export_CountRequest
162: -- TYPE : Private
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)

Line 228: -- INSERT the RECORD INTO the TABLE MTL_CC_ENTRIES_INTERFACE

224: -- Delete all error records first
225: MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(
226: p_interface_rec.cc_entry_interface_id);
227: --
228: -- INSERT the RECORD INTO the TABLE MTL_CC_ENTRIES_INTERFACE
229: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
230: p_interface_rec=> p_interface_rec,
231: x_return_status => L_return_status);
232: --

Line 340: -- p_interface_rec MTL_CC_ENTRIES_INTERFACE%ROWTYPE (required)

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
342: --
343: -- OUT :
344: -- X_return_status OUT NUMBER

Line 508: update mtl_cc_entries_interface

504: IF (l_debug = 1) THEN
505: mdebug('updating ccei_id='||l_interface_rec.cc_entry_interface_id||' with cce_id='|| l_cycle_count_entry_id);
506: END IF;
507: -- make additional changes to interface rec sku impossible
508: update mtl_cc_entries_interface
509: set
510: cycle_count_entry_id =
511: l_cycle_count_entry_id
512: where cc_entry_interface_id =

Line 854: p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE',

850: p_api_version => 0.9,
851: p_interface_rec => p_interface_rec,
852: p_message_name => 'INV_SERIAL_UNAVAILABLE',
853: p_error_column_name => 'SERIAL_NUMBER',
854: p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE',
855: p_flags => '1$2$',
856: x_return_status => x_return_status,
857: x_msg_count => x_msg_count,
858: x_msg_data => x_msg_data);

Line 868: p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE',

864: p_api_version => 0.9,
865: p_interface_rec => p_interface_rec,
866: p_message_name => 'UNEXPECTED ERROR',
867: p_error_column_name => 'UNEXPECTED ERROR',
868: p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE',
869: p_flags => '1$2$',
870: x_return_status => x_return_status,
871: x_msg_count => x_msg_count,
872: x_msg_data => x_msg_data);

Line 971: -- p_interface_rec IN MTL_CC_ENTRIES_INTERFACE%ROWTYPE (required)

967: -- 0 = FND_API.G_VALID_LEVEL_NONE (no processing),
968: -- 1 = Validate FOR processing
969: --
970: --
971: -- p_interface_rec IN MTL_CC_ENTRIES_INTERFACE%ROWTYPE (required)
972: -- Cycle COUNT entries interface RECORD
973: --
974: -- OUT :
975: -- X_return_status OUT NUMBER

Line 1777: -- p_interface_rec MTL_CC_ENTRIES_INTERFACE%ROWTYPE (required)

1773: --
1774: -- p_validation_level IN NUMBER (optional)
1775: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
1776: --
1777: -- p_interface_rec MTL_CC_ENTRIES_INTERFACE%ROWTYPE (required)
1778: -- the interface RECORD
1779: --
1780: -- OUT :
1781: -- X_return_status OUT NUMBER

Line 1839: mtl_cc_entries_interface

1835: SELECT cc_entry_interface_id
1836: INTO
1837: L_dummy
1838: FROM
1839: mtl_cc_entries_interface
1840: WHERE
1841: cc_entry_interface_id =
1842: p_interface_rec.cc_entry_interface_id;
1843: --