DBA Data[Home] [Help]

APPS.LOT_SPLIT_DATA_INSERT dependencies on MTL_TRANSACTION_TYPES

Line 9: p_transaction_type_id IN MTL_TRANSACTION_TYPES.transaction_type_id%TYPE,

5:
6:
7:
8: PROCEDURE set_table (
9: p_transaction_type_id IN MTL_TRANSACTION_TYPES.transaction_type_id%TYPE,
10: p_transaction_lot IN VARCHAR2,
11: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
12: p_revision IN MTL_ITEM_REVISIONS.revision%TYPE,
13: p_organization_id IN MTL_PARAMETERS.organization_id%TYPE,

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

1146: p_organization_id IN MTL_ORGANIZATIONS.organization_id%TYPE,
1147: x_stock_locator_code OUT NOCOPY MTL_parameters.stock_locator_control_code%TYPE,
1148: x_wmsinstall OUT NOCOPY VARCHAR2,
1149: x_wmsorg OUT NOCOPY VARCHAR2,
1150: x_split_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,
1151: x_merge_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,
1152: x_translate_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,
1153: x_cost_group_id OUT NOCOPY CST_COST_GROUPS.cost_group_id%TYPE,
1154: x_primary_cost_method OUT NOCOPY MTL_PARAMETERS.primary_cost_method%TYPE,

Line 1151: x_merge_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,

1147: x_stock_locator_code OUT NOCOPY MTL_parameters.stock_locator_control_code%TYPE,
1148: x_wmsinstall OUT NOCOPY VARCHAR2,
1149: x_wmsorg OUT NOCOPY VARCHAR2,
1150: x_split_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,
1151: x_merge_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,
1152: x_translate_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,
1153: x_cost_group_id OUT NOCOPY CST_COST_GROUPS.cost_group_id%TYPE,
1154: x_primary_cost_method OUT NOCOPY MTL_PARAMETERS.primary_cost_method%TYPE,
1155: x_wsm_enabled_flag OUT NOCOPY VARCHAR2,

Line 1152: x_translate_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,

1148: x_wmsinstall OUT NOCOPY VARCHAR2,
1149: x_wmsorg OUT NOCOPY VARCHAR2,
1150: x_split_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,
1151: x_merge_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,
1152: x_translate_txnname OUT NOCOPY MTL_TRANSACTION_TYPES.transaction_type_name%TYPE,
1153: x_cost_group_id OUT NOCOPY CST_COST_GROUPS.cost_group_id%TYPE,
1154: x_primary_cost_method OUT NOCOPY MTL_PARAMETERS.primary_cost_method%TYPE,
1155: x_wsm_enabled_flag OUT NOCOPY VARCHAR2,
1156: x_return_status OUT NOCOPY VARCHAR2,

Line 1163: l_transaction_type_id MTL_TRANSACTION_TYPES.transaction_type_id%TYPE;

1159: x_dist_account_id OUT NOCOPY mtl_parameters.distribution_account_id%TYPE
1160: )
1161:
1162: IS
1163: l_transaction_type_id MTL_TRANSACTION_TYPES.transaction_type_id%TYPE;
1164: CURSOR cur_trx_types IS
1165: SELECT transaction_type_name , transaction_type_id
1166: FROM mtl_transaction_types
1167: WHERE transaction_type_id IN ( INV_Globals.G_type_inv_lot_split,

Line 1166: FROM mtl_transaction_types

1162: IS
1163: l_transaction_type_id MTL_TRANSACTION_TYPES.transaction_type_id%TYPE;
1164: CURSOR cur_trx_types IS
1165: SELECT transaction_type_name , transaction_type_id
1166: FROM mtl_transaction_types
1167: WHERE transaction_type_id IN ( INV_Globals.G_type_inv_lot_split,
1168: INV_Globals.G_type_inv_lot_merge,
1169: INV_Globals.G_type_inv_lot_translate);
1170: -- (82, 83, 84);