DBA Data[Home] [Help]

APPS.LOT_SPLIT_DATA_INSERT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 112: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

108: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
109: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
110: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
111: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
112: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
113: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
114: p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
115: p_hold_date IN MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
116: p_reason_id IN MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE DEFAULT NULL -- Bug #4093379 INVCONV

Line 113: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

109: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
110: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
111: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
112: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
113: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
114: p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
115: p_hold_date IN MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
116: p_reason_id IN MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE DEFAULT NULL -- Bug #4093379 INVCONV
117: )

Line 114: p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

110: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
111: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
112: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
113: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
114: p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
115: p_hold_date IN MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
116: p_reason_id IN MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE DEFAULT NULL -- Bug #4093379 INVCONV
117: )
118: IS

Line 115: p_hold_date IN MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

111: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
112: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
113: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
114: p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
115: p_hold_date IN MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
116: p_reason_id IN MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE DEFAULT NULL -- Bug #4093379 INVCONV
117: )
118: IS
119: ind INTEGER := 0;

Line 116: p_reason_id IN MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE DEFAULT NULL -- Bug #4093379 INVCONV

112: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
113: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
114: p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
115: p_hold_date IN MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
116: p_reason_id IN MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE DEFAULT NULL -- Bug #4093379 INVCONV
117: )
118: IS
119: ind INTEGER := 0;
120: l_dir VARCHAR2(1000) := NULL;

Line 470: l_msg_data := 'mtl_transaction_lots_temp ';

466:
467: IF (l_debug = 1) THEN
468: INV_TRX_UTIL_PUB.trace('inserting mtlt ' || p_ind,g_pkg_name,9);
469: END IF;
470: l_msg_data := 'mtl_transaction_lots_temp ';
471:
472: INSERT INTO
473: mtl_transaction_lots_temp
474: (transaction_temp_id

Line 473: mtl_transaction_lots_temp

469: END IF;
470: l_msg_data := 'mtl_transaction_lots_temp ';
471:
472: INSERT INTO
473: mtl_transaction_lots_temp
474: (transaction_temp_id
475: ,last_update_date
476: ,last_updated_by
477: ,creation_date