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 1466: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'

1462:
1463: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
1464: P_CC_ENTRY_INTERFACE_ID => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
1465: , P_ERROR_COLUMN_NAME => 'TRANSACTION_REASON_ID'
1466: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
1467: , p_message_name => 'INV_INT_REACODE'
1468: );
1469: GOTO end_VALIDATE;
1470:

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

1822: --
1823: -- p_validation_level IN NUMBER (optional)
1824: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
1825: --
1826: -- p_interface_rec MTL_CC_ENTRIES_INTERFACE%ROWTYPE (required)
1827: -- the interface RECORD
1828: --
1829: -- OUT :
1830: -- X_return_status OUT NUMBER

Line 1888: mtl_cc_entries_interface

1884: SELECT cc_entry_interface_id
1885: INTO
1886: L_dummy
1887: FROM
1888: mtl_cc_entries_interface
1889: WHERE
1890: cc_entry_interface_id =
1891: p_interface_rec.cc_entry_interface_id;
1892: --