2253: wms_cartnzn_pub.g_wms_pack_hist_seq,
2254: pack_level,
2255: l_item_id,
2256: Sysdate,
2257: fnd_global.user_id,
2258: Sysdate,
2259: fnd_global.user_id,
2260: fnd_global.login_id,
2261: l_rev,
2255: l_item_id,
2256: Sysdate,
2257: fnd_global.user_id,
2258: Sysdate,
2259: fnd_global.user_id,
2260: fnd_global.login_id,
2261: l_rev,
2262: lot_table(counter),
2263: serial_table(counter),
2256: Sysdate,
2257: fnd_global.user_id,
2258: Sysdate,
2259: fnd_global.user_id,
2260: fnd_global.login_id,
2261: l_rev,
2262: lot_table(counter),
2263: serial_table(counter),
2264: serial_table(counter),
2330: wms_cartnzn_pub.g_wms_pack_hist_seq,
2331: pack_level,
2332: NULL,
2333: Sysdate,
2334: fnd_global.user_id,
2335: Sysdate,
2336: fnd_global.user_id,
2337: fnd_global.login_id,
2338: null,
2332: NULL,
2333: Sysdate,
2334: fnd_global.user_id,
2335: Sysdate,
2336: fnd_global.user_id,
2337: fnd_global.login_id,
2338: null,
2339: null,
2340: null,
2333: Sysdate,
2334: fnd_global.user_id,
2335: Sysdate,
2336: fnd_global.user_id,
2337: fnd_global.login_id,
2338: null,
2339: null,
2340: null,
2341: NULL,
2408: wms_cartnzn_pub.g_wms_pack_hist_seq,
2409: pack_level,
2410: l_cont_item_id,
2411: Sysdate,
2412: fnd_global.user_id,
2413: Sysdate,
2414: fnd_global.user_id,
2415: fnd_global.login_id,
2416: null,
2410: l_cont_item_id,
2411: Sysdate,
2412: fnd_global.user_id,
2413: Sysdate,
2414: fnd_global.user_id,
2415: fnd_global.login_id,
2416: null,
2417: null,
2418: null,
2411: Sysdate,
2412: fnd_global.user_id,
2413: Sysdate,
2414: fnd_global.user_id,
2415: fnd_global.login_id,
2416: null,
2417: null,
2418: null,
2419: NULL,
5077: cartonization_id = l_LPN,
5078: container_item_id = p_container_item_id,
5079: parent_line_id = par_line_id,
5080: last_update_date = Sysdate,
5081: last_updated_by = fnd_global.user_id
5082: WHERE
5083: transaction_temp_id = p_transaction_temp_id;
5084: ELSE
5085: UPDATE mtl_material_transactions_temp SET
5086: cartonization_id = l_LPN,
5087: container_item_id = p_container_item_id,
5088: parent_line_id = par_line_id,
5089: last_update_date = Sysdate,
5090: last_updated_by = fnd_global.user_id
5091: WHERE
5092: transaction_temp_id = p_transaction_temp_id;
5093: END IF;
5094:
5117: cartonization_id = l_LPN,
5118: parent_line_id = par_line_id,
5119: container_item_id = p_container_item_id,
5120: last_update_date = Sysdate,
5121: last_updated_by = fnd_global.user_id
5122: WHERE
5123: transaction_temp_id = p_transaction_temp_id;
5124: ELSE
5125: UPDATE wms_cartonization_temp SET
5126: cartonization_id = l_LPN,
5127: parent_line_id = par_line_id,
5128: container_item_id = p_container_item_id,
5129: last_update_date = Sysdate,
5130: last_updated_by = fnd_global.user_id
5131: WHERE
5132: transaction_temp_id = p_transaction_temp_id;
5133: END IF;
5134:
5208: v1.secondary_transaction_quantity := p_secondary_quantity; --invconv kkillams
5209: v1.cartonization_id := l_LPN;
5210: v1.container_item_id := p_container_item_id;
5211: v1.last_update_date := Sysdate;
5212: v1.last_updated_by := fnd_global.user_id;
5213: v1.creation_date := Sysdate;
5214: v1.created_by := fnd_global.user_id;
5215:
5216:
5210: v1.container_item_id := p_container_item_id;
5211: v1.last_update_date := Sysdate;
5212: v1.last_updated_by := fnd_global.user_id;
5213: v1.creation_date := Sysdate;
5214: v1.created_by := fnd_global.user_id;
5215:
5216:
5217: IF p_new_txn_hdr_id IS NOT NULL THEN
5218: v1.transaction_header_id := p_new_txn_hdr_id;
5453: p_mmtt_row.allocated_lpn_id,
5454: p_mmtt_row.cartonization_id,
5455: p_mmtt_row.transaction_quantity,
5456: Sysdate,
5457: FND_GLOBAL.USER_ID);
5458:
5459:
5460: --insert another line for drop
5461: INSERT INTO wms_device_requests (request_id,
5495: p_mmtt_row.allocated_lpn_id,
5496: p_mmtt_row.cartonization_id,
5497: p_mmtt_row.transaction_quantity,
5498: Sysdate,
5499: FND_GLOBAL.USER_ID);
5500:
5501: wdrdata.request_id := WMS_Device_Integration_PVT.wms_pkrel_dev_req_id;
5502: wdrData.organization_id := p_mmtt_row.organization_id;
5503: wdrData.subinventory_code := p_mmtt_row.subinventory_code ;