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 64: FROM MTL_CC_ENTRIES_INTERFACE

60: END IF;
61: BEGIN
62: SELECT Nvl(count_date,SYSDATE)
63: INTO l_transaction_date
64: FROM MTL_CC_ENTRIES_INTERFACE
65: WHERE cc_entry_interface_id = MTL_CCEOI_VAR_PVT.G_cc_entry_interface_id;
66: EXCEPTION
67: WHEN NO_DATA_FOUND THEN
68: l_transaction_date := sysdate;

Line 1067: -- p_interface_rec IN MTL_CC_ENTRIES_INTERFACE%rowtype

1063: --
1064: -- p_approval_option_code IN NUMBER (required)
1065: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_OPTION_CODE
1066: --
1067: -- p_interface_rec IN MTL_CC_ENTRIES_INTERFACE%rowtype
1068: --
1069: -- p_simulate IN varchar2 (default)
1070: -- default = FND_API.G_FALSE - may modify data in other tables
1071: -- FND_API.G_TRUE modify data only in the interface tables

Line 2372: delete from mtl_cc_entries_interface

2368: --
2369: BEGIN
2370: --
2371: begin
2372: delete from mtl_cc_entries_interface
2373: where cc_entry_interface_id = p_cc_entry_interface_id;
2374: exception when others then
2375: null;
2376: end;

Line 2689: -- Insert the given record into MTL_CC_ENTRIES_INTERFACE

2685: raise fnd_api.g_exc_unexpected_error;
2686: END;
2687: END;
2688: --
2689: -- Insert the given record into MTL_CC_ENTRIES_INTERFACE
2690: PROCEDURE Insert_CCIEntry(
2691: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,
2692: x_return_status OUT NOCOPY VARCHAR2 )
2693: IS

Line 2723: MTL_CC_ENTRIES_INTERFACE_S1.nextval

2719:
2720: IF p_interface_rec.cc_entry_interface_id IS NULL THEN
2721: BEGIN
2722: SELECT
2723: MTL_CC_ENTRIES_INTERFACE_S1.nextval
2724: INTO
2725: L_CCEOIId
2726: FROM
2727: dual;

Line 2745: INSERT INTO MTL_CC_ENTRIES_INTERFACE

2741: --
2742: IF (l_debug = 1) THEN
2743: mdebug('Insert_CCIEntry: ' || L_CCEOIId);
2744: END IF;
2745: INSERT INTO MTL_CC_ENTRIES_INTERFACE
2746: ( cost_group_name
2747: , cost_group_id
2748: , parent_lpn_id
2749: , outermost_lpn_id

Line 3478: -- mtl_cc_entries_interface

3474: -- TYPE : Private
3475: -- Pre-reqs : None
3476: -- FUNCTION :
3477: -- SET all the flags IN the interface TABLE
3478: -- mtl_cc_entries_interface
3479: -- Parameters:
3480: -- IN :
3481: -- p_api_version IN NUMBER (required)
3482: -- API Version of this procedure

Line 3558: UPDATE mtl_cc_entries_interface

3554: IF (l_debug = 1) THEN
3555: MDEBUG( 'Process:Setsflag-Delete '||p_flags);
3556: END IF;
3557:
3558: UPDATE mtl_cc_entries_interface
3559: SET
3560: last_update_date = sysdate
3561: , last_updated_by = MTL_CCEOI_VAR_PVT.G_UserID
3562: , last_update_login = MTL_CCEOI_VAR_PVT.G_LoginID

Line 4569: FROM MTL_CC_ENTRIES_INTERFACE

4565: MDEBUG( 'Before call Validate_Serial-2');
4566: END IF;
4567: --Begin changes 3904722
4568: SELECT COUNT_QUANTITY INTO l_serial_quantity
4569: FROM MTL_CC_ENTRIES_INTERFACE
4570: WHERE CC_ENTRY_INTERFACE_ID = MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID;
4571: --End changes 3904722
4572: -- Validate Serial
4573: /* Validate API Implementation for Serial validation */

Line 5144: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'

5140: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5141: p_cc_entry_interface_id =>
5142: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5143: , p_error_column_name => 'COUNT_QUANTITY'
5144: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
5145: , p_message_name => 'INV_SERIAL_QTY_MUST_BE_1');
5146:
5147: RAISE FND_API.G_EXC_ERROR;
5148: ELSIF x_errorcode = 61 THEN

Line 5154: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'

5150: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5151: p_cc_entry_interface_id =>
5152: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5153: , p_error_column_name => 'COUNT_QUANTITY'
5154: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
5155: , p_message_name => 'INV_GREATER_EQUAL_ZERO');
5156:
5157: RAISE FND_API.G_EXC_ERROR;
5158:

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

5736: -- p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE
5737: -- G_TRUE - skip any updates/inserts to any non-cc-interface tables
5738: -- G_FALSE - update any tables necessary
5739: --
5740: -- p_interface_rec MTL_CC_ENTRIES_INTERFACE%rowtype (required)
5741: -- interface RECORD parameter
5742: --
5743: -- OUT :
5744: -- X_return_status OUT NUMBER

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

6056: -- that the RECORD IS exported, THEN only the unexported columns
6057: -- can be updated.
6058: -- Parameters:
6059: -- IN :
6060: -- p_interface_rec MTL_CC_ENTRIES_INTERFACE%ROWTYPE (required)
6061: -- the interface RECORD
6062: --
6063: -- OUT :
6064: -- X_return_status OUT NUMBER

Line 6089: UPDATE MTL_CC_ENTRIES_INTERFACE

6085: END IF;
6086: IF p_interface_rec.cycle_count_entry_id IS NOT NULL THEN
6087: --
6088: --
6089: UPDATE MTL_CC_ENTRIES_INTERFACE
6090: SET
6091: last_update_date = sysdate
6092: , last_updated_by = MTL_CCEOI_VAR_PVT.G_UserID
6093: , last_update_login = MTL_CCEOI_VAR_PVT.G_LoginID

Line 6126: UPDATE MTL_CC_ENTRIES_INTERFACE

6122: cc_entry_interface_id = p_interface_rec.cc_entry_interface_id;
6123: --
6124: ELSE
6125: --
6126: UPDATE MTL_CC_ENTRIES_INTERFACE
6127: SET cost_group_name = p_interface_rec.cost_group_name
6128: , cost_group_id = p_interface_rec.cost_group_id
6129: , parent_lpn_id = p_interface_rec.parent_lpn_id
6130: , outermost_lpn_id = p_interface_rec.outermost_lpn_id

Line 6684: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'

6680: -- Write INTO interface error TABLE
6681: mtl_cceoi_process_pvt.insert_cceoierror
6682: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6683: , p_error_column_name => 'SECONDARY_COUNT_QUANTITY'
6684: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
6685: , p_message_name => 'INV_NO_CONVERSION_ERR');
6686: RAISE fnd_api.g_exc_error;
6687: ELSIF x_errorcode = 51 THEN
6688: -- Write INTO interface error TABLE

Line 6692: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'

6688: -- Write INTO interface error TABLE
6689: mtl_cceoi_process_pvt.insert_cceoierror
6690: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6691: , p_error_column_name => 'SECONDARY_COUNT_QUANTITY'
6692: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
6693: , p_message_name => 'INV_DEVIATION_CHECK_ERR');
6694: RAISE fnd_api.g_exc_error;
6695: ELSIF x_errorcode = 52 THEN
6696: -- Write INTO interface error TABLE

Line 6700: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'

6696: -- Write INTO interface error TABLE
6697: mtl_cceoi_process_pvt.insert_cceoierror
6698: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6699: , p_error_column_name => 'SECONDARY_COUNT_QUANTITY'
6700: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
6701: , p_message_name => 'INV_CCEOI_NEG_QTY');
6702: RAISE fnd_api.g_exc_error;
6703: END IF;
6704: