[Home] [Help]
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,
14: p_subinventory_code IN MTL_SECONDARY_INVENTORIES.secondary_inventory_name%TYPE,
15: p_locator_id IN MTL_ITEM_LOCATIONS.inventory_location_id%TYPE,
16: p_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
17: p_primary_quantity IN MTL_MATERIAL_TRANSACTIONS.primary_quantity%TYPE,
689: l_batch_id NUMBER := 0;
690: l_transaction_action_id NUMBER := inv_globals.G_Action_inv_lot_split;
691: l_transaction_source_type_id NUMBER := inv_globals.G_SourceType_Inventory;
692: l_acct_period_id org_acct_periods.acct_period_id%TYPE := 0;
693: l_dist_account_id mtl_parameters.distribution_account_id%TYPE := NULL;
694: l_wsm_enabled_flag mtl_parameters.wsm_enabled_flag%TYPE := 'N';
695: l_xfr_lpn_id NUMBER := NULL;
696: l_msg_count NUMBER := NULL;
697: l_msg_data VARCHAR2(2000) := NULL;
690: l_transaction_action_id NUMBER := inv_globals.G_Action_inv_lot_split;
691: l_transaction_source_type_id NUMBER := inv_globals.G_SourceType_Inventory;
692: l_acct_period_id org_acct_periods.acct_period_id%TYPE := 0;
693: l_dist_account_id mtl_parameters.distribution_account_id%TYPE := NULL;
694: l_wsm_enabled_flag mtl_parameters.wsm_enabled_flag%TYPE := 'N';
695: l_xfr_lpn_id NUMBER := NULL;
696: l_msg_count NUMBER := NULL;
697: l_msg_data VARCHAR2(2000) := NULL;
698: l_label_status VARCHAR2(300) := NULL;
762: SELECT distribution_account_id,
763: wsm_enabled_flag
764: INTO l_dist_account_id,
765: l_wsm_enabled_flag
766: FROM mtl_parameters
767: WHERE organization_id = tab_input(1).organization_id;
768:
769: IF (l_dist_account_id IS NULL AND l_wsm_enabled_flag = 'Y') THEN
770: IF (l_debug = 1) THEN
1143: END insert_mmtt;
1144: --
1145: PROCEDURE select_init_parameters(
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,
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,
1157: x_msg_data OUT NOCOPY VARCHAR2,
1158: x_msg_count OUT NOCOPY NUMBER,
1155: x_wsm_enabled_flag OUT NOCOPY VARCHAR2,
1156: x_return_status OUT NOCOPY VARCHAR2,
1157: x_msg_data OUT NOCOPY VARCHAR2,
1158: x_msg_count OUT NOCOPY NUMBER,
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;
1212: ,x_cost_group_id
1213: ,x_primary_cost_method
1214: ,x_wsm_enabled_flag
1215: , x_dist_account_id
1216: FROM mtl_parameters
1217: WHERE organization_id = p_organization_id;
1218:
1219: IF (x_dist_account_id IS NULL AND x_wsm_enabled_flag = 'Y') THEN
1220: IF (l_debug = 1) THEN