DBA Data[Home] [Help]

APPS.LOT_SPLIT_DATA_INSERT dependencies on MTL_TRANSACTION_TYPES

Line 4: transaction_type_id MTL_TRANSACTION_TYPES.transaction_type_id%TYPE,

1: PACKAGE lot_split_data_insert AUTHID CURRENT_USER AS
2: /* $Header: INVLSPLS.pls 120.0 2005/05/25 05:31:08 appldev noship $ */
3: TYPE inputrec IS RECORD (
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,

Line 132: p_transaction_type_id IN MTL_TRANSACTION_TYPES.transaction_type_id%TYPE,

128: and all others will be the starting lot records
129: */
130: --
131: PROCEDURE set_table (
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,

Line 253: x_split_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,

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,
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,

Line 254: x_merge_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%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,
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,

Line 255: x_translate_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%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,
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,