DBA Data[Home] [Help]

APPS.LOT_SPLIT_DATA_INSERT dependencies on MTL_PARAMETERS

Line 8: organization_id MTL_PARAMETERS.organization_id%TYPE,

4: transaction_type_id MTL_TRANSACTION_TYPES.transaction_type_id%TYPE,
5: transaction_lot VARCHAR2(1),
6: inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
7: revision MTL_ITEM_REVISIONS.revision%TYPE,
8: organization_id MTL_PARAMETERS.organization_id%TYPE,
9: subinventory_code MTL_SECONDARY_INVENTORIES.secondary_inventory_name%TYPE,
10: locator_id MTL_ITEM_LOCATIONS.inventory_location_id%TYPE,
11: transaction_quantity MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
12: secondary_transaction_quantity MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE, -- Bug #4093379 INVCONV

Line 136: p_organization_id IN MTL_PARAMETERS.organization_id%TYPE,

132: p_transaction_type_id IN MTL_TRANSACTION_TYPES.transaction_type_id%TYPE,
133: p_transaction_lot IN VARCHAR2,
134: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
135: p_revision IN MTL_ITEM_REVISIONS.revision%TYPE,
136: p_organization_id IN MTL_PARAMETERS.organization_id%TYPE,
137: p_subinventory_code IN MTL_SECONDARY_INVENTORIES.secondary_inventory_name%TYPE,
138: p_locator_id IN MTL_ITEM_LOCATIONS.inventory_location_id%TYPE,
139: p_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
140: p_primary_quantity IN MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,

Line 250: x_stock_locator_code OUT NOCOPY MTL_parameters.stock_locator_control_code%TYPE,

246: --
247: /* This procedure is called from the lotsplitmergepage (parent page) to get the initial values */
248: PROCEDURE select_init_parameters(
249: p_organization_id IN MTL_ORGANIZATIONS.organization_id%TYPE,
250: x_stock_locator_code OUT NOCOPY MTL_parameters.stock_locator_control_code%TYPE,
251: x_wmsinstall OUT NOCOPY VARCHAR2,
252: x_wmsorg OUT NOCOPY VARCHAR2,
253: x_split_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,
254: x_merge_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,

Line 257: x_primary_cost_method OUT NOCOPY MTL_PARAMETERS.primary_cost_method%TYPE,

253: x_split_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,
254: x_merge_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,
255: x_translate_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,
256: x_cost_group_id OUT NOCOPY CST_COST_GROUPS.cost_group_id%TYPE,
257: x_primary_cost_method OUT NOCOPY MTL_PARAMETERS.primary_cost_method%TYPE,
258: x_wsm_enabled_flag OUT NOCOPY VARCHAR2,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_data OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,

Line 262: x_dist_account_id OUT NOCOPY mtl_parameters.distribution_account_id%TYPE

258: x_wsm_enabled_flag OUT NOCOPY VARCHAR2,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_data OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,
262: x_dist_account_id OUT NOCOPY mtl_parameters.distribution_account_id%TYPE
263: );
264: END lot_split_data_insert;