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_PROCESS_PVT dependencies on MTL_CC_ENTRIES_INTERFACE

Line 970: -- p_interface_rec IN MTL_CC_ENTRIES_INTERFACE%rowtype

966: --
967: -- p_approval_option_code IN NUMBER (required)
968: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_OPTION_CODE
969: --
970: -- p_interface_rec IN MTL_CC_ENTRIES_INTERFACE%rowtype
971: --
972: -- p_simulate IN varchar2 (default)
973: -- default = FND_API.G_FALSE - may modify data in other tables
974: -- FND_API.G_TRUE modify data only in the interface tables

Line 2254: delete from mtl_cc_entries_interface

2250: --
2251: BEGIN
2252: --
2253: begin
2254: delete from mtl_cc_entries_interface
2255: where cc_entry_interface_id = p_cc_entry_interface_id;
2256: exception when others then
2257: null;
2258: end;

Line 2551: -- Insert the given record into MTL_CC_ENTRIES_INTERFACE

2547: raise fnd_api.g_exc_unexpected_error;
2548: END;
2549: END;
2550: --
2551: -- Insert the given record into MTL_CC_ENTRIES_INTERFACE
2552: PROCEDURE Insert_CCIEntry(
2553: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,
2554: x_return_status OUT NOCOPY VARCHAR2 )
2555: IS

Line 2585: MTL_CC_ENTRIES_INTERFACE_S1.nextval

2581:
2582: IF p_interface_rec.cc_entry_interface_id IS NULL THEN
2583: BEGIN
2584: SELECT
2585: MTL_CC_ENTRIES_INTERFACE_S1.nextval
2586: INTO
2587: L_CCEOIId
2588: FROM
2589: dual;

Line 2607: INSERT INTO MTL_CC_ENTRIES_INTERFACE

2603: --
2604: IF (l_debug = 1) THEN
2605: mdebug('Insert_CCIEntry: ' || L_CCEOIId);
2606: END IF;
2607: INSERT INTO MTL_CC_ENTRIES_INTERFACE
2608: ( cost_group_name
2609: , cost_group_id
2610: , parent_lpn_id
2611: , outermost_lpn_id

Line 3337: -- mtl_cc_entries_interface

3333: -- TYPE : Private
3334: -- Pre-reqs : None
3335: -- FUNCTION :
3336: -- SET all the flags IN the interface TABLE
3337: -- mtl_cc_entries_interface
3338: -- Parameters:
3339: -- IN :
3340: -- p_api_version IN NUMBER (required)
3341: -- API Version of this procedure

Line 3417: UPDATE mtl_cc_entries_interface

3413: IF (l_debug = 1) THEN
3414: MDEBUG( 'Process:Setsflag-Delete '||p_flags);
3415: END IF;
3416:
3417: UPDATE mtl_cc_entries_interface
3418: SET
3419: last_update_date = sysdate
3420: , last_updated_by = MTL_CCEOI_VAR_PVT.G_UserID
3421: , last_update_login = MTL_CCEOI_VAR_PVT.G_LoginID

Line 4427: FROM MTL_CC_ENTRIES_INTERFACE

4423: MDEBUG( 'Before call Validate_Serial-2');
4424: END IF;
4425: --Begin changes 3904722
4426: SELECT COUNT_QUANTITY INTO l_serial_quantity
4427: FROM MTL_CC_ENTRIES_INTERFACE
4428: WHERE CC_ENTRY_INTERFACE_ID = MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID;
4429: --End changes 3904722
4430: -- Validate Serial
4431: /* Validate API Implementation for Serial validation */

Line 4973: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'

4969: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4970: p_cc_entry_interface_id =>
4971: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4972: , p_error_column_name => 'COUNT_QUANTITY'
4973: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
4974: , p_message_name => 'INV_SERIAL_QTY_MUST_BE_1');
4975:
4976: RAISE FND_API.G_EXC_ERROR;
4977: ELSIF x_errorcode = 61 THEN

Line 4983: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'

4979: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4980: p_cc_entry_interface_id =>
4981: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4982: , p_error_column_name => 'COUNT_QUANTITY'
4983: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
4984: , p_message_name => 'INV_GREATER_EQUAL_ZERO');
4985:
4986: RAISE FND_API.G_EXC_ERROR;
4987:

Line 5565: -- p_interface_rec MTL_CC_ENTRIES_INTERFACE%rowtype (required)

5561: -- p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE
5562: -- G_TRUE - skip any updates/inserts to any non-cc-interface tables
5563: -- G_FALSE - update any tables necessary
5564: --
5565: -- p_interface_rec MTL_CC_ENTRIES_INTERFACE%rowtype (required)
5566: -- interface RECORD parameter
5567: --
5568: -- OUT :
5569: -- X_return_status OUT NUMBER

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

5881: -- that the RECORD IS exported, THEN only the unexported columns
5882: -- can be updated.
5883: -- Parameters:
5884: -- IN :
5885: -- p_interface_rec MTL_CC_ENTRIES_INTERFACE%ROWTYPE (required)
5886: -- the interface RECORD
5887: --
5888: -- OUT :
5889: -- X_return_status OUT NUMBER

Line 5914: UPDATE MTL_CC_ENTRIES_INTERFACE

5910: END IF;
5911: IF p_interface_rec.cycle_count_entry_id IS NOT NULL THEN
5912: --
5913: --
5914: UPDATE MTL_CC_ENTRIES_INTERFACE
5915: SET
5916: last_update_date = sysdate
5917: , last_updated_by = MTL_CCEOI_VAR_PVT.G_UserID
5918: , last_update_login = MTL_CCEOI_VAR_PVT.G_LoginID

Line 5951: UPDATE MTL_CC_ENTRIES_INTERFACE

5947: cc_entry_interface_id = p_interface_rec.cc_entry_interface_id;
5948: --
5949: ELSE
5950: --
5951: UPDATE MTL_CC_ENTRIES_INTERFACE
5952: SET cost_group_name = p_interface_rec.cost_group_name
5953: , cost_group_id = p_interface_rec.cost_group_id
5954: , parent_lpn_id = p_interface_rec.parent_lpn_id
5955: , outermost_lpn_id = p_interface_rec.outermost_lpn_id

Line 6509: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'

6505: -- Write INTO interface error TABLE
6506: mtl_cceoi_process_pvt.insert_cceoierror
6507: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6508: , p_error_column_name => 'SECONDARY_COUNT_QUANTITY'
6509: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
6510: , p_message_name => 'INV_NO_CONVERSION_ERR');
6511: RAISE fnd_api.g_exc_error;
6512: ELSIF x_errorcode = 51 THEN
6513: -- Write INTO interface error TABLE

Line 6517: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'

6513: -- Write INTO interface error TABLE
6514: mtl_cceoi_process_pvt.insert_cceoierror
6515: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6516: , p_error_column_name => 'SECONDARY_COUNT_QUANTITY'
6517: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
6518: , p_message_name => 'INV_DEVIATION_CHECK_ERR');
6519: RAISE fnd_api.g_exc_error;
6520: ELSIF x_errorcode = 52 THEN
6521: -- Write INTO interface error TABLE

Line 6525: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'

6521: -- Write INTO interface error TABLE
6522: mtl_cceoi_process_pvt.insert_cceoierror
6523: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6524: , p_error_column_name => 'SECONDARY_COUNT_QUANTITY'
6525: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
6526: , p_message_name => 'INV_CCEOI_NEG_QTY');
6527: RAISE fnd_api.g_exc_error;
6528: END IF;
6529: