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 271: -- the system table mtl_cycle_count_entries to the prior column.

267: -- TYPE : Private
268: -- Pre-reqs : None
269: -- FUNCTION :
270: -- this PROCEDURE SET the current VALUES of the open count request into
271: -- the system table mtl_cycle_count_entries to the prior column.
272: -- Parameters:
273: -- IN :
274: -- OUT :
275: -- Version: Current Version 0.9

Line 582: L_from_uom MTL_CYCLE_COUNT_ENTRIES.COUNT_UOM_CURRENT%type;

578: -- Notes : Note text
579: -- END OF comments
580: DECLARE
581: --
582: L_from_uom MTL_CYCLE_COUNT_ENTRIES.COUNT_UOM_CURRENT%type;
583: L_txn_uom MTL_CYCLE_COUNT_ENTRIES.COUNT_UOM_CURRENT%type;
584: L_txn_header_id NUMBER;
585: L_txn_temp_id NUMBER;
586: L_serial_prefix MTL_SYSTEM_ITEMS.auto_serial_alpha_prefix%type;

Line 583: L_txn_uom MTL_CYCLE_COUNT_ENTRIES.COUNT_UOM_CURRENT%type;

579: -- END OF comments
580: DECLARE
581: --
582: L_from_uom MTL_CYCLE_COUNT_ENTRIES.COUNT_UOM_CURRENT%type;
583: L_txn_uom MTL_CYCLE_COUNT_ENTRIES.COUNT_UOM_CURRENT%type;
584: L_txn_header_id NUMBER;
585: L_txn_temp_id NUMBER;
586: L_serial_prefix MTL_SYSTEM_ITEMS.auto_serial_alpha_prefix%type;
587: L_p_uom_qty NUMBER;

Line 590: L_org_id MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID%type;

586: L_serial_prefix MTL_SYSTEM_ITEMS.auto_serial_alpha_prefix%type;
587: L_p_uom_qty NUMBER;
588: L_number_of_counts NUMBER;
589: L_success_flag NUMBER;
590: L_org_id MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID%type;
591: l_txn_return_status NUMBER; -- 8712932
592: l_proc_msg VARCHAR2(3000);
593: l_business_flow_code NUMBER := 8 ;
594:

Line 1034: -- MTL_CYCLE_COUNT_ENTRIES_V.POSITIVE_MEASUREMENT_ERROR

1030: -- FUNCTION :
1031: -- Parameters:
1032: -- IN :
1033: -- p_pos_meas_err IN NUMBER (required)
1034: -- MTL_CYCLE_COUNT_ENTRIES_V.POSITIVE_MEASUREMENT_ERROR
1035: --
1036: -- p_neg_meas_err IN NUMBER (required)
1037: -- MTL_CYCLE_COUNT_ENTRIES_V.NEGATIVE_MEASUREMENT_ERROR
1038: --

Line 1037: -- MTL_CYCLE_COUNT_ENTRIES_V.NEGATIVE_MEASUREMENT_ERROR

1033: -- p_pos_meas_err IN NUMBER (required)
1034: -- MTL_CYCLE_COUNT_ENTRIES_V.POSITIVE_MEASUREMENT_ERROR
1035: --
1036: -- p_neg_meas_err IN NUMBER (required)
1037: -- MTL_CYCLE_COUNT_ENTRIES_V.NEGATIVE_MEASUREMENT_ERROR
1038: --
1039: -- p_app_tol_pos IN NUMBER (required)
1040: -- MTL_CYCLE_COUNT_ENTRIES_V.APP_TOL_POS
1041: --

Line 1040: -- MTL_CYCLE_COUNT_ENTRIES_V.APP_TOL_POS

1036: -- p_neg_meas_err IN NUMBER (required)
1037: -- MTL_CYCLE_COUNT_ENTRIES_V.NEGATIVE_MEASUREMENT_ERROR
1038: --
1039: -- p_app_tol_pos IN NUMBER (required)
1040: -- MTL_CYCLE_COUNT_ENTRIES_V.APP_TOL_POS
1041: --
1042: -- p_app_tol_neg IN NUMBER (required)
1043: -- MTL_CYCLE_COUNT_ENTRIES_V.APP_TOL_NEG
1044: --

Line 1043: -- MTL_CYCLE_COUNT_ENTRIES_V.APP_TOL_NEG

1039: -- p_app_tol_pos IN NUMBER (required)
1040: -- MTL_CYCLE_COUNT_ENTRIES_V.APP_TOL_POS
1041: --
1042: -- p_app_tol_neg IN NUMBER (required)
1043: -- MTL_CYCLE_COUNT_ENTRIES_V.APP_TOL_NEG
1044: --
1045: -- p_cost_tol_pos IN NUMBER (required)
1046: -- MTL_CYCLE_COUNT_ENTRIES_V.COST_TOL_POS
1047: --

Line 1046: -- MTL_CYCLE_COUNT_ENTRIES_V.COST_TOL_POS

1042: -- p_app_tol_neg IN NUMBER (required)
1043: -- MTL_CYCLE_COUNT_ENTRIES_V.APP_TOL_NEG
1044: --
1045: -- p_cost_tol_pos IN NUMBER (required)
1046: -- MTL_CYCLE_COUNT_ENTRIES_V.COST_TOL_POS
1047: --
1048: -- p_cost_tol_neg IN NUMBER (required)
1049: -- MTL_CYCLE_COUNT_ENTRIES_V.COST_TOL_NEG
1050: --

Line 1049: -- MTL_CYCLE_COUNT_ENTRIES_V.COST_TOL_NEG

1045: -- p_cost_tol_pos IN NUMBER (required)
1046: -- MTL_CYCLE_COUNT_ENTRIES_V.COST_TOL_POS
1047: --
1048: -- p_cost_tol_neg IN NUMBER (required)
1049: -- MTL_CYCLE_COUNT_ENTRIES_V.COST_TOL_NEG
1050: --
1051: -- p_adjustment_value IN NUMBER (required)
1052: -- MTL_CYCLE_COUNT_ENTRIES_V.ADJUSTMENT_AMOUNT
1053: --

Line 1052: -- MTL_CYCLE_COUNT_ENTRIES_V.ADJUSTMENT_AMOUNT

1048: -- p_cost_tol_neg IN NUMBER (required)
1049: -- MTL_CYCLE_COUNT_ENTRIES_V.COST_TOL_NEG
1050: --
1051: -- p_adjustment_value IN NUMBER (required)
1052: -- MTL_CYCLE_COUNT_ENTRIES_V.ADJUSTMENT_AMOUNT
1053: --
1054: -- p_adjustment_quantity IN NUMBER (required)
1055: -- get the value FROM the global variable
1056: -- MTL_CCEOI_VAR_PVT.G_ADJUSTMENT_QUANTITY

Line 1057: -- MTL_CYCLE_COUNT_ENTRIES.ADJUSTMENT_QUANTITY

1053: --
1054: -- p_adjustment_quantity IN NUMBER (required)
1055: -- get the value FROM the global variable
1056: -- MTL_CCEOI_VAR_PVT.G_ADJUSTMENT_QUANTITY
1057: -- MTL_CYCLE_COUNT_ENTRIES.ADJUSTMENT_QUANTITY
1058: --
1059: -- p_system_quantity IN NUMBER (required)
1060: -- gets the value FROM the global variable
1061: -- MTL_CCEOI_VAR_PVT.G_SYSTEM_QUANTITY

Line 1062: -- MTL_CYCLE_COUNT_ENTRIES.SYSTEM_QUANTITY_CURRENT

1058: --
1059: -- p_system_quantity IN NUMBER (required)
1060: -- gets the value FROM the global variable
1061: -- MTL_CCEOI_VAR_PVT.G_SYSTEM_QUANTITY
1062: -- MTL_CYCLE_COUNT_ENTRIES.SYSTEM_QUANTITY_CURRENT
1063: --
1064: -- p_approval_option_code IN NUMBER (required)
1065: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_OPTION_CODE
1066: --

Line 2191: -- MTL_CYCLE_COUNT_ENTRIES_V.APPROVAL_TOLERANCE_POSITIVE

2187: -- Parameters:
2188: -- IN :
2189: --
2190: -- p_item_app_tol_pos IN NUMBER (required)
2191: -- MTL_CYCLE_COUNT_ENTRIES_V.APPROVAL_TOLERANCE_POSITIVE
2192: --
2193: -- p_item_app_tol_neg IN NUMBER (required)
2194: -- MTL_CYCLE_COUNT_ENTRIES_V.APPROVAL_TOLERANCE_NEGATIVE
2195: --

Line 2194: -- MTL_CYCLE_COUNT_ENTRIES_V.APPROVAL_TOLERANCE_NEGATIVE

2190: -- p_item_app_tol_pos IN NUMBER (required)
2191: -- MTL_CYCLE_COUNT_ENTRIES_V.APPROVAL_TOLERANCE_POSITIVE
2192: --
2193: -- p_item_app_tol_neg IN NUMBER (required)
2194: -- MTL_CYCLE_COUNT_ENTRIES_V.APPROVAL_TOLERANCE_NEGATIVE
2195: --
2196: -- p_class_app_tol_pos IN NUMBER (required)
2197: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_APP_TOL_POS
2198: --

Line 2197: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_APP_TOL_POS

2193: -- p_item_app_tol_neg IN NUMBER (required)
2194: -- MTL_CYCLE_COUNT_ENTRIES_V.APPROVAL_TOLERANCE_NEGATIVE
2195: --
2196: -- p_class_app_tol_pos IN NUMBER (required)
2197: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_APP_TOL_POS
2198: --
2199: -- p_class_app_tol_neg IN NUMBER (required)
2200: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_APP_TOL_NEG
2201: --

Line 2200: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_APP_TOL_NEG

2196: -- p_class_app_tol_pos IN NUMBER (required)
2197: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_APP_TOL_POS
2198: --
2199: -- p_class_app_tol_neg IN NUMBER (required)
2200: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_APP_TOL_NEG
2201: --
2202: -- p_class_cost_tol_pos IN NUMBER (required)
2203: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_COST_TOL_POS
2204: --

Line 2203: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_COST_TOL_POS

2199: -- p_class_app_tol_neg IN NUMBER (required)
2200: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_APP_TOL_NEG
2201: --
2202: -- p_class_cost_tol_pos IN NUMBER (required)
2203: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_COST_TOL_POS
2204: --
2205: -- p_class_cost_tol_neg IN NUMBER (required)
2206: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_COST_TOL_NEG
2207: --

Line 2206: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_COST_TOL_NEG

2202: -- p_class_cost_tol_pos IN NUMBER (required)
2203: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_COST_TOL_POS
2204: --
2205: -- p_class_cost_tol_neg IN NUMBER (required)
2206: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_COST_TOL_NEG
2207: --
2208: -- p_head_app_tol_pos IN NUMBER (required)
2209: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_TOLERANCE_POSITIVE
2210: --

Line 2437: -- inserts the RECORD INTO MTL_CYCLE_COUNT_ENTRIES TABLE

2433: -- API name : Insert_CCEntry
2434: -- TYPE : Public
2435: -- Pre-reqs : None
2436: -- FUNCTION :
2437: -- inserts the RECORD INTO MTL_CYCLE_COUNT_ENTRIES TABLE
2438: -- Parameters:
2439: -- IN :
2440: -- p_interface_rec IN CCEOI_Rec_Type (required)
2441: -- complete interface RECORD

Line 2449: MTL_CYCLE_COUNT_ENTRIES_S.nextval

2445: l_count_due_date DATE;
2446:
2447: BEGIN
2448: SELECT
2449: MTL_CYCLE_COUNT_ENTRIES_S.nextval
2450: INTO
2451: L_CCEntryId
2452: FROM
2453: dual;

Line 2481: INSERT INTO MTL_CYCLE_COUNT_ENTRIES

2477: mdebug('std oper id:'||l_user_tt_id);
2478: end if;
2479:
2480:
2481: INSERT INTO MTL_CYCLE_COUNT_ENTRIES
2482: ( COST_GROUP_ID
2483: , PARENT_LPN_ID
2484: , OUTERMOST_LPN_ID
2485: , CYCLE_COUNT_ENTRY_ID

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

3290: --
3291: END;
3292: END;
3293: --
3294: -- Set the export flag in the table MTL_CYCLE_COUNT_ENTRIES
3295: PROCEDURE Set_CCExport(
3296: p_api_version IN NUMBER ,
3297: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3298: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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

3309: -- API name : Set_CCExport
3310: -- TYPE : Private
3311: -- Pre-reqs : None
3312: -- FUNCTION :
3313: -- SET export flag to orginal RECORD IN the MTL_CYCLE_COUNT_ENTRIES TABLE
3314: -- Parameters:
3315: -- IN :
3316: -- p_api_version IN NUMBER (required)
3317: -- API Version of this procedure

Line 3386: UPDATE mtl_cycle_count_entries

3382: IF (l_debug = 1) THEN
3383: MDEBUG( 'SetCCExport : Before Update CCEId '||to_char(p_cycle_count_entry_id) ||' to '|| to_char(p_export_flag));
3384: END IF;
3385:
3386: UPDATE mtl_cycle_count_entries
3387: SET
3388: export_flag = p_export_flag
3389: , last_update_date = sysdate
3390: , last_updated_by = MTL_CCEOI_VAR_PVT.G_UserID

Line 4105: FROM mtl_cycle_count_entries

4101: org IN NUMBER, header IN NUMBER, loc IN NUMBER, rev IN VARCHAR2,
4102: ser IN VARCHAR2, lot IN VARCHAR2, cost IN NUMBER)
4103: IS SELECT
4104: *
4105: FROM mtl_cycle_count_entries
4106: WHERE
4107: cycle_count_header_id = header
4108: AND organization_id = org
4109: AND inventory_item_id = itemid

Line 4683: FROM MTL_CYCLE_COUNT_ENTRIES

4679:
4680: -- Bug : 8300310 Start
4681: SELECT COUNT(1)
4682: INTO l_count
4683: FROM MTL_CYCLE_COUNT_ENTRIES
4684: WHERE organization_id = p_organization_id
4685: AND subinventory = p_subinventory
4686: AND locator_id = MTL_CCEOI_VAR_PVT.G_LOCATOR_ID
4687: AND inventory_item_id = p_inventory_item_rec.inventory_item_id

Line 4758: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

4754: -- Write INTO interface error TABLE
4755: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4756: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4757: , p_error_column_name => '*'
4758: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'
4759: , p_message_name => 'INV_CCEOI_NO_CCENTRY'
4760: );
4761: RAISE FND_API.G_EXC_ERROR;
4762: ELSIF

Line 4779: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

4775: -- Write INTO interface error TABLE
4776: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4777: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4778: , p_error_column_name => '*'
4779: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'
4780: , p_message_name => 'INV_CCEOI_MULT_REQUESTS'
4781: );
4782: RAISE FND_API.G_EXC_ERROR;
4783: END IF;

Line 5035: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

5031: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5032: p_cc_entry_interface_id =>
5033: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5034: , p_error_column_name => 'COUNT_QUANTITY'
5035: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'
5036: , p_message_name => 'INV_CCEOI_NEG_QTY');
5037: RAISE FND_API.G_EXC_ERROR;
5038:
5039: ELSIF x_errorcode = 60 THEN

Line 5044: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

5040: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5041: p_cc_entry_interface_id =>
5042: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5043: , p_error_column_name => 'COUNT_QUANTITY'
5044: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'
5045: , p_message_name => 'INV_SERIAL_QTY_MUST_BE_1');
5046: RAISE FND_API.G_EXC_ERROR;
5047:
5048: ELSIF x_errorcode = 61 THEN

Line 5053: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

5049: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5050: p_cc_entry_interface_id =>
5051: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5052: , p_error_column_name => 'COUNT_QUANTITY'
5053: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'
5054: , p_message_name => 'INV_GREATER_EQUAL_ZERO');
5055: RAISE FND_API.G_EXC_ERROR;
5056:
5057: --

Line 5134: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

5130: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5131: p_cc_entry_interface_id =>
5132: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5133: , p_error_column_name => 'COUNT_QUANTITY'
5134: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'
5135: , p_message_name => 'INV_CCEOI_NEG_QTY');
5136:
5137: RAISE FND_API.G_EXC_ERROR;
5138: ELSIF x_errorcode = 60 THEN

Line 5562: UPDATE MTL_CYCLE_COUNT_ENTRIES

5558: nvl(MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.COUNT_DUE_DATE,
5559: nvl(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.COUNT_DUE_DATE,
5560: sysdate)); -- Bug16031205 removed validation as its not existing in forms/mobile code
5561:
5562: UPDATE MTL_CYCLE_COUNT_ENTRIES
5563: SET
5564: last_update_date =
5565: sysdate
5566: , last_updated_by =

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

5691: END;
5692:
5693: -- Processed the interface record
5694: -- This function will prepare record for being updated into
5695: -- mtl_cycle_count_entries and will also perform a transaction
5696: -- if necessary
5697: -- The logic which handles serial numbers is copied from INVATCEN.pld
5698: -- and will need further review/rewrite
5699: PROCEDURE Process_Data(