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_CYCLE_COUNT_ENTRIES

Line 212: -- the system table mtl_cycle_count_entries to the prior column.

208: -- TYPE : Private
209: -- Pre-reqs : None
210: -- FUNCTION :
211: -- this PROCEDURE SET the current VALUES of the open count request into
212: -- the system table mtl_cycle_count_entries to the prior column.
213: -- Parameters:
214: -- IN :
215: -- OUT :
216: -- Version: Current Version 0.9

Line 523: L_from_uom MTL_CYCLE_COUNT_ENTRIES.COUNT_UOM_CURRENT%type;

519: -- Notes : Note text
520: -- END OF comments
521: DECLARE
522: --
523: L_from_uom MTL_CYCLE_COUNT_ENTRIES.COUNT_UOM_CURRENT%type;
524: L_txn_uom MTL_CYCLE_COUNT_ENTRIES.COUNT_UOM_CURRENT%type;
525: L_txn_header_id NUMBER;
526: L_txn_temp_id NUMBER;
527: L_serial_prefix MTL_SYSTEM_ITEMS.auto_serial_alpha_prefix%type;

Line 524: L_txn_uom MTL_CYCLE_COUNT_ENTRIES.COUNT_UOM_CURRENT%type;

520: -- END OF comments
521: DECLARE
522: --
523: L_from_uom MTL_CYCLE_COUNT_ENTRIES.COUNT_UOM_CURRENT%type;
524: L_txn_uom MTL_CYCLE_COUNT_ENTRIES.COUNT_UOM_CURRENT%type;
525: L_txn_header_id NUMBER;
526: L_txn_temp_id NUMBER;
527: L_serial_prefix MTL_SYSTEM_ITEMS.auto_serial_alpha_prefix%type;
528: L_p_uom_qty NUMBER;

Line 937: -- MTL_CYCLE_COUNT_ENTRIES_V.POSITIVE_MEASUREMENT_ERROR

933: -- FUNCTION :
934: -- Parameters:
935: -- IN :
936: -- p_pos_meas_err IN NUMBER (required)
937: -- MTL_CYCLE_COUNT_ENTRIES_V.POSITIVE_MEASUREMENT_ERROR
938: --
939: -- p_neg_meas_err IN NUMBER (required)
940: -- MTL_CYCLE_COUNT_ENTRIES_V.NEGATIVE_MEASUREMENT_ERROR
941: --

Line 940: -- MTL_CYCLE_COUNT_ENTRIES_V.NEGATIVE_MEASUREMENT_ERROR

936: -- p_pos_meas_err IN NUMBER (required)
937: -- MTL_CYCLE_COUNT_ENTRIES_V.POSITIVE_MEASUREMENT_ERROR
938: --
939: -- p_neg_meas_err IN NUMBER (required)
940: -- MTL_CYCLE_COUNT_ENTRIES_V.NEGATIVE_MEASUREMENT_ERROR
941: --
942: -- p_app_tol_pos IN NUMBER (required)
943: -- MTL_CYCLE_COUNT_ENTRIES_V.APP_TOL_POS
944: --

Line 943: -- MTL_CYCLE_COUNT_ENTRIES_V.APP_TOL_POS

939: -- p_neg_meas_err IN NUMBER (required)
940: -- MTL_CYCLE_COUNT_ENTRIES_V.NEGATIVE_MEASUREMENT_ERROR
941: --
942: -- p_app_tol_pos IN NUMBER (required)
943: -- MTL_CYCLE_COUNT_ENTRIES_V.APP_TOL_POS
944: --
945: -- p_app_tol_neg IN NUMBER (required)
946: -- MTL_CYCLE_COUNT_ENTRIES_V.APP_TOL_NEG
947: --

Line 946: -- MTL_CYCLE_COUNT_ENTRIES_V.APP_TOL_NEG

942: -- p_app_tol_pos IN NUMBER (required)
943: -- MTL_CYCLE_COUNT_ENTRIES_V.APP_TOL_POS
944: --
945: -- p_app_tol_neg IN NUMBER (required)
946: -- MTL_CYCLE_COUNT_ENTRIES_V.APP_TOL_NEG
947: --
948: -- p_cost_tol_pos IN NUMBER (required)
949: -- MTL_CYCLE_COUNT_ENTRIES_V.COST_TOL_POS
950: --

Line 949: -- MTL_CYCLE_COUNT_ENTRIES_V.COST_TOL_POS

945: -- p_app_tol_neg IN NUMBER (required)
946: -- MTL_CYCLE_COUNT_ENTRIES_V.APP_TOL_NEG
947: --
948: -- p_cost_tol_pos IN NUMBER (required)
949: -- MTL_CYCLE_COUNT_ENTRIES_V.COST_TOL_POS
950: --
951: -- p_cost_tol_neg IN NUMBER (required)
952: -- MTL_CYCLE_COUNT_ENTRIES_V.COST_TOL_NEG
953: --

Line 952: -- MTL_CYCLE_COUNT_ENTRIES_V.COST_TOL_NEG

948: -- p_cost_tol_pos IN NUMBER (required)
949: -- MTL_CYCLE_COUNT_ENTRIES_V.COST_TOL_POS
950: --
951: -- p_cost_tol_neg IN NUMBER (required)
952: -- MTL_CYCLE_COUNT_ENTRIES_V.COST_TOL_NEG
953: --
954: -- p_adjustment_value IN NUMBER (required)
955: -- MTL_CYCLE_COUNT_ENTRIES_V.ADJUSTMENT_AMOUNT
956: --

Line 955: -- MTL_CYCLE_COUNT_ENTRIES_V.ADJUSTMENT_AMOUNT

951: -- p_cost_tol_neg IN NUMBER (required)
952: -- MTL_CYCLE_COUNT_ENTRIES_V.COST_TOL_NEG
953: --
954: -- p_adjustment_value IN NUMBER (required)
955: -- MTL_CYCLE_COUNT_ENTRIES_V.ADJUSTMENT_AMOUNT
956: --
957: -- p_adjustment_quantity IN NUMBER (required)
958: -- get the value FROM the global variable
959: -- MTL_CCEOI_VAR_PVT.G_ADJUSTMENT_QUANTITY

Line 960: -- MTL_CYCLE_COUNT_ENTRIES.ADJUSTMENT_QUANTITY

956: --
957: -- p_adjustment_quantity IN NUMBER (required)
958: -- get the value FROM the global variable
959: -- MTL_CCEOI_VAR_PVT.G_ADJUSTMENT_QUANTITY
960: -- MTL_CYCLE_COUNT_ENTRIES.ADJUSTMENT_QUANTITY
961: --
962: -- p_system_quantity IN NUMBER (required)
963: -- gets the value FROM the global variable
964: -- MTL_CCEOI_VAR_PVT.G_SYSTEM_QUANTITY

Line 965: -- MTL_CYCLE_COUNT_ENTRIES.SYSTEM_QUANTITY_CURRENT

961: --
962: -- p_system_quantity IN NUMBER (required)
963: -- gets the value FROM the global variable
964: -- MTL_CCEOI_VAR_PVT.G_SYSTEM_QUANTITY
965: -- MTL_CYCLE_COUNT_ENTRIES.SYSTEM_QUANTITY_CURRENT
966: --
967: -- p_approval_option_code IN NUMBER (required)
968: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_OPTION_CODE
969: --

Line 2073: -- MTL_CYCLE_COUNT_ENTRIES_V.APPROVAL_TOLERANCE_POSITIVE

2069: -- Parameters:
2070: -- IN :
2071: --
2072: -- p_item_app_tol_pos IN NUMBER (required)
2073: -- MTL_CYCLE_COUNT_ENTRIES_V.APPROVAL_TOLERANCE_POSITIVE
2074: --
2075: -- p_item_app_tol_neg IN NUMBER (required)
2076: -- MTL_CYCLE_COUNT_ENTRIES_V.APPROVAL_TOLERANCE_NEGATIVE
2077: --

Line 2076: -- MTL_CYCLE_COUNT_ENTRIES_V.APPROVAL_TOLERANCE_NEGATIVE

2072: -- p_item_app_tol_pos IN NUMBER (required)
2073: -- MTL_CYCLE_COUNT_ENTRIES_V.APPROVAL_TOLERANCE_POSITIVE
2074: --
2075: -- p_item_app_tol_neg IN NUMBER (required)
2076: -- MTL_CYCLE_COUNT_ENTRIES_V.APPROVAL_TOLERANCE_NEGATIVE
2077: --
2078: -- p_class_app_tol_pos IN NUMBER (required)
2079: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_APP_TOL_POS
2080: --

Line 2079: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_APP_TOL_POS

2075: -- p_item_app_tol_neg IN NUMBER (required)
2076: -- MTL_CYCLE_COUNT_ENTRIES_V.APPROVAL_TOLERANCE_NEGATIVE
2077: --
2078: -- p_class_app_tol_pos IN NUMBER (required)
2079: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_APP_TOL_POS
2080: --
2081: -- p_class_app_tol_neg IN NUMBER (required)
2082: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_APP_TOL_NEG
2083: --

Line 2082: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_APP_TOL_NEG

2078: -- p_class_app_tol_pos IN NUMBER (required)
2079: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_APP_TOL_POS
2080: --
2081: -- p_class_app_tol_neg IN NUMBER (required)
2082: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_APP_TOL_NEG
2083: --
2084: -- p_class_cost_tol_pos IN NUMBER (required)
2085: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_COST_TOL_POS
2086: --

Line 2085: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_COST_TOL_POS

2081: -- p_class_app_tol_neg IN NUMBER (required)
2082: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_APP_TOL_NEG
2083: --
2084: -- p_class_cost_tol_pos IN NUMBER (required)
2085: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_COST_TOL_POS
2086: --
2087: -- p_class_cost_tol_neg IN NUMBER (required)
2088: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_COST_TOL_NEG
2089: --

Line 2088: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_COST_TOL_NEG

2084: -- p_class_cost_tol_pos IN NUMBER (required)
2085: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_COST_TOL_POS
2086: --
2087: -- p_class_cost_tol_neg IN NUMBER (required)
2088: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_COST_TOL_NEG
2089: --
2090: -- p_head_app_tol_pos IN NUMBER (required)
2091: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_TOLERANCE_POSITIVE
2092: --

Line 2318: -- inserts the RECORD INTO MTL_CYCLE_COUNT_ENTRIES TABLE

2314: -- API name : Insert_CCEntry
2315: -- TYPE : Public
2316: -- Pre-reqs : None
2317: -- FUNCTION :
2318: -- inserts the RECORD INTO MTL_CYCLE_COUNT_ENTRIES TABLE
2319: -- Parameters:
2320: -- IN :
2321: -- p_interface_rec IN CCEOI_Rec_Type (required)
2322: -- complete interface RECORD

Line 2330: MTL_CYCLE_COUNT_ENTRIES_S.nextval

2326: l_count_due_date DATE;
2327:
2328: BEGIN
2329: SELECT
2330: MTL_CYCLE_COUNT_ENTRIES_S.nextval
2331: INTO
2332: L_CCEntryId
2333: FROM
2334: dual;

Line 2346: INSERT INTO MTL_CYCLE_COUNT_ENTRIES

2342: IF (l_debug = 1) THEN
2343: mdebug('date due:'||to_char(l_count_due_date));
2344: END IF;
2345:
2346: INSERT INTO MTL_CYCLE_COUNT_ENTRIES
2347: ( COST_GROUP_ID
2348: , PARENT_LPN_ID
2349: , OUTERMOST_LPN_ID
2350: , CYCLE_COUNT_ENTRY_ID

Line 3156: -- Set the export flag in the table MTL_CYCLE_COUNT_ENTRIES

3152: --
3153: END;
3154: END;
3155: --
3156: -- Set the export flag in the table MTL_CYCLE_COUNT_ENTRIES
3157: PROCEDURE Set_CCExport(
3158: p_api_version IN NUMBER ,
3159: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3160: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 3175: -- SET export flag to orginal RECORD IN the MTL_CYCLE_COUNT_ENTRIES TABLE

3171: -- API name : Set_CCExport
3172: -- TYPE : Private
3173: -- Pre-reqs : None
3174: -- FUNCTION :
3175: -- SET export flag to orginal RECORD IN the MTL_CYCLE_COUNT_ENTRIES TABLE
3176: -- Parameters:
3177: -- IN :
3178: -- p_api_version IN NUMBER (required)
3179: -- API Version of this procedure

Line 3248: UPDATE mtl_cycle_count_entries

3244: IF (l_debug = 1) THEN
3245: MDEBUG( 'SetCCExport : Before Update CCEId '||to_char(p_cycle_count_entry_id) ||' to '|| to_char(p_export_flag));
3246: END IF;
3247:
3248: UPDATE mtl_cycle_count_entries
3249: SET
3250: export_flag = p_export_flag
3251: , last_update_date = sysdate
3252: , last_updated_by = MTL_CCEOI_VAR_PVT.G_UserID

Line 3963: FROM mtl_cycle_count_entries

3959: org IN NUMBER, header IN NUMBER, loc IN NUMBER, rev IN VARCHAR2,
3960: ser IN VARCHAR2, lot IN VARCHAR2, cost IN NUMBER)
3961: IS SELECT
3962: *
3963: FROM mtl_cycle_count_entries
3964: WHERE
3965: cycle_count_header_id = header
3966: AND organization_id = org
3967: AND inventory_item_id = itemid

Line 4587: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

4583: -- Write INTO interface error TABLE
4584: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4585: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4586: , p_error_column_name => '*'
4587: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'
4588: , p_message_name => 'INV_CCEOI_NO_CCENTRY'
4589: );
4590: RAISE FND_API.G_EXC_ERROR;
4591: ELSIF

Line 4608: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

4604: -- Write INTO interface error TABLE
4605: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4606: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4607: , p_error_column_name => '*'
4608: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'
4609: , p_message_name => 'INV_CCEOI_MULT_REQUESTS'
4610: );
4611: RAISE FND_API.G_EXC_ERROR;
4612: END IF;

Line 4864: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

4860: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4861: p_cc_entry_interface_id =>
4862: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4863: , p_error_column_name => 'COUNT_QUANTITY'
4864: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'
4865: , p_message_name => 'INV_CCEOI_NEG_QTY');
4866: RAISE FND_API.G_EXC_ERROR;
4867:
4868: ELSIF x_errorcode = 60 THEN

Line 4873: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

4869: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4870: p_cc_entry_interface_id =>
4871: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4872: , p_error_column_name => 'COUNT_QUANTITY'
4873: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'
4874: , p_message_name => 'INV_SERIAL_QTY_MUST_BE_1');
4875: RAISE FND_API.G_EXC_ERROR;
4876:
4877: ELSIF x_errorcode = 61 THEN

Line 4882: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

4878: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4879: p_cc_entry_interface_id =>
4880: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4881: , p_error_column_name => 'COUNT_QUANTITY'
4882: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'
4883: , p_message_name => 'INV_GREATER_EQUAL_ZERO');
4884: RAISE FND_API.G_EXC_ERROR;
4885:
4886: --

Line 4963: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

4959: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4960: p_cc_entry_interface_id =>
4961: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4962: , p_error_column_name => 'COUNT_QUANTITY'
4963: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'
4964: , p_message_name => 'INV_CCEOI_NEG_QTY');
4965:
4966: RAISE FND_API.G_EXC_ERROR;
4967: ELSIF x_errorcode = 60 THEN

Line 5387: UPDATE MTL_CYCLE_COUNT_ENTRIES

5383: nvl(MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.COUNT_DUE_DATE,
5384: nvl(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.COUNT_DUE_DATE,
5385: compute_count_due_date(sysdate)));
5386:
5387: UPDATE MTL_CYCLE_COUNT_ENTRIES
5388: SET
5389: last_update_date =
5390: sysdate
5391: , last_updated_by =

Line 5520: -- mtl_cycle_count_entries and will also perform a transaction

5516: END;
5517:
5518: -- Processed the interface record
5519: -- This function will prepare record for being updated into
5520: -- mtl_cycle_count_entries and will also perform a transaction
5521: -- if necessary
5522: -- The logic which handles serial numbers is copied from INVATCEN.pld
5523: -- and will need further review/rewrite
5524: PROCEDURE Process_Data(